bitfinex | Bitcoin trading scripts written in Python | Cryptocurrency library

I try to set up external tables for BigQuery, the source is BigTable. I can create a table but while executing a sql statment i get this error:

Error while reading data, error message: Error detected while parsing row starting at position: 6. Error: Data between close double quote (") and field separator.

Most likely the table definition file is wrong. I spend the last day tinkering, but i don't find the problem. Can somebody point out the mistake i'm making?

thanks

my workflow:

• create definition file
• use command: bq mk --external_table_definition=gs://realtimecrypto-ostabprj/def.json test.test1
• in bigquery: SELECT * FROM ostabprj.test.test1 LIMIT 1000

my table definition file:

I also tried different variations of it.

I'm trying to write a program that will read a JSON file and take the information I need from it. In my JSON file there is a parameter: 'exchangeId' which outputs the exchange number. I would like to make sure that only those exchanges that I set, or rather their 'exchangeId', are recorded in my dictionary, and if coin don't have any 'exchangeId' at the list this coin don't wanna save as JSON file. How can I do this?

My code:

I'm trying to send this information as a message with using telegram bot. But, when I tryed to send message I had a eror: card = f'{hbold("ExchangeName: ")}{(item.get("exchange_name"))}\n'
AttributeError: 'str' object has no attribute 'get'. How I can fix it?

I want to iterate through a dictionary array like the following to only copy the 'symbol' and 'product_progress' keys and their corresponding values to new dictionary array.

I am working on a indicator which shows the aggregated trading volume of multiple BTC markets.

The indicator works for the most part but for some reason unchecking inputs does not work. Even when everything is unchecked the indicator still plots the aggregated volume of all markets.

It is probably a simple fix but I have no background in coding. I got to this point by looking at other indicators and a bit of trial and error.

I would be very grateful if someone can help me.

I am also thinking it would be very interesting to be able to see what volume came from every single market by plotting the histogram in multiple colors, but I do not think I can pull that off or if it is even possible.

This is the entire code:

I have built a model that analyses crypto currency performance, based on raw data downloaded from a web portal. To automate this process, I developed some VBA code that recognizes the downloaded file by going to my "Downloads" directory and selecting the most recent file that has the word "BITFINEX" in its name. My challenge is that some of the cryptos I am interested in do not have that particular keyword included in the filename. Some, for example, use "COINBASE" instead and others may use something else. Bottom line is that I need my macro to choose the most recent of multiple file that include BITFINEX, COINBASE and, say, 5 other names that are not yet defined (for these, there could just be place markers saying, AAA, BBB, CCC, DDD, EEE). I am guessing that there is some version of the "Or" function that is required, but that is unfortunately beyond my coding skills at this point. The code I have attached is for my existing model and works perfectly. Any assistance would be most appreciated.

I have two tables with >4million records i need to make a select query with where two columns match bring both tables value on this match and then i will insert that into a 3rth table:

This is table A: (bitfinex)

This is table B: (Kraken)

I need to do a SELECT where timestamp and exchange_pair matches, as you can see in this image from table B the same timestamp can have multiple exchange_pair, what i need to do is match those with the other table columns and bring both table content

this was the query i used at once but when analyzing the results i had some mismatch values on the joins ( i did not found the relation, it was not either timestamp or the exchange pair) i wonder if my query syntax is right for the result im looking for.

I'm trying to call this API response using a custom function where I can change the parameters. This is my code:

I have an API response that I'm trying to place in my spreadsheet.

I managed to figure out how to call it using the following code but it all goes to the first cell. How do I make each value go to a different cell?