PREVIEW / futures_1hour / 2024-09-20
file: by_date/futures_1hour/2024/2024-09-20.parquet size: 57 KB rows: 1,676
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-09-20 00:00:00 | ES | Futures | 5990.84 | 5992.91 | 5989.02 | 5991.88 | 2532.0 |
| 2024-09-20 01:00:00 | ES | Futures | 5991.88 | 5992.14 | 5985.91 | 5989.8 | 4093.0 |
| 2024-09-20 02:00:00 | ES | Futures | 5989.54 | 5991.62 | 5986.17 | 5986.43 | 6262.0 |
| 2024-09-20 03:00:00 | ES | Futures | 5986.43 | 5992.91 | 5985.13 | 5990.58 | 14263.0 |
| 2024-09-20 04:00:00 | ES | Futures | 5991.1 | 5991.88 | 5982.53 | 5985.13 | 15220.0 |
| 2024-09-20 05:00:00 | ES | Futures | 5984.87 | 5989.02 | 5982.79 | 5984.35 | 10778.0 |
| 2024-09-20 06:00:00 | ES | Futures | 5984.35 | 5987.46 | 5979.94 | 5981.24 | 13725.0 |
| 2024-09-20 07:00:00 | ES | Futures | 5981.5 | 5983.83 | 5978.38 | 5983.31 | 14813.0 |
| 2024-09-20 08:00:00 | ES | Futures | 5983.57 | 5993.43 | 5983.05 | 5991.88 | 43750.0 |
| 2024-09-20 09:00:00 | ES | Futures | 5991.88 | 5992.14 | 5970.34 | 5972.41 | 195092.0 |
| 2024-09-20 10:00:00 | ES | Futures | 5972.67 | 5979.16 | 5963.33 | 5964.89 | 201229.0 |
| 2024-09-20 11:00:00 | ES | Futures | 5964.89 | 5975.27 | 5951.91 | 5970.6 | 224201.0 |
| 2024-09-20 12:00:00 | ES | Futures | 5970.6 | 5986.95 | 5968.26 | 5983.31 | 100085.0 |
| 2024-09-20 13:00:00 | ES | Futures | 5983.05 | 5988.76 | 5980.2 | 5982.53 | 87279.0 |
| 2024-09-20 14:00:00 | ES | Futures | 5982.79 | 5983.05 | 5961.25 | 5976.05 | 133005.0 |
| 2024-09-20 15:00:00 | ES | Futures | 5976.05 | 5994.99 | 5971.89 | 5982.53 | 257219.0 |
| 2024-09-20 16:00:00 | ES | Futures | 5982.27 | 5983.05 | 5973.19 | 5977.6 | 73529.0 |
| 2024-09-20 00:00:00 | NQ | Futures | 20926.73 | 20939.26 | 20917.08 | 20933.26 | 2230.0 |
| 2024-09-20 01:00:00 | NQ | Futures | 20932.73 | 20932.73 | 20902.47 | 20922.04 | 2452.0 |
| 2024-09-20 02:00:00 | NQ | Futures | 20922.3 | 20930.13 | 20901.16 | 20905.6 | 3864.0 |
| 2024-09-20 03:00:00 | NQ | Futures | 20906.12 | 20945.78 | 20897.77 | 20934.04 | 6742.0 |
| 2024-09-20 04:00:00 | NQ | Futures | 20934.56 | 20939.52 | 20880.55 | 20895.69 | 7719.0 |
| 2024-09-20 05:00:00 | NQ | Futures | 20895.69 | 20915.78 | 20881.33 | 20885.51 | 4694.0 |
| 2024-09-20 06:00:00 | NQ | Futures | 20885.77 | 20895.42 | 20853.16 | 20864.9 | 7312.0 |
| 2024-09-20 07:00:00 | NQ | Futures | 20864.9 | 20894.12 | 20854.46 | 20891.77 | 6627.0 |
| 2024-09-20 08:00:00 | NQ | Futures | 20892.29 | 20951.26 | 20887.86 | 20939.78 | 15206.0 |
| 2024-09-20 09:00:00 | NQ | Futures | 20939.26 | 20959.09 | 20863.85 | 20874.81 | 68278.0 |
| 2024-09-20 10:00:00 | NQ | Futures | 20874.03 | 20900.12 | 20803.32 | 20812.71 | 69105.0 |
| 2024-09-20 11:00:00 | NQ | Futures | 20812.45 | 20860.46 | 20726.87 | 20845.59 | 74923.0 |
| 2024-09-20 12:00:00 | NQ | Futures | 20846.11 | 20910.82 | 20839.33 | 20892.55 | 36228.0 |
| 2024-09-20 13:00:00 | NQ | Futures | 20892.81 | 20904.82 | 20860.98 | 20868.03 | 29692.0 |
| 2024-09-20 14:00:00 | NQ | Futures | 20867.77 | 20877.16 | 20804.37 | 20871.16 | 37065.0 |
| 2024-09-20 15:00:00 | NQ | Futures | 20870.64 | 20960.65 | 20853.68 | 20907.43 | 62066.0 |
| 2024-09-20 16:00:00 | NQ | Futures | 20907.17 | 20911.86 | 20868.29 | 20889.16 | 14844.0 |
| 2024-09-20 00:00:00 | YM | Futures | 44166.4 | 44177.9 | 44160.2 | 44172.6 | 320.0 |
| 2024-09-20 01:00:00 | YM | Futures | 44173.7 | 44173.7 | 44142.5 | 44159.1 | 508.0 |
| 2024-09-20 02:00:00 | YM | Futures | 44158.1 | 44173.7 | 44143.5 | 44144.5 | 883.0 |
| 2024-09-20 03:00:00 | YM | Futures | 44143.5 | 44175.8 | 44123.7 | 44164.3 | 1397.0 |
| 2024-09-20 04:00:00 | YM | Futures | 44165.4 | 44176.8 | 44143.5 | 44160.2 | 1717.0 |
| 2024-09-20 05:00:00 | YM | Futures | 44159.1 | 44181.0 | 44152.9 | 44174.7 | 1342.0 |
| 2024-09-20 06:00:00 | YM | Futures | 44175.8 | 44217.4 | 44162.2 | 44195.5 | 2110.0 |
| 2024-09-20 07:00:00 | YM | Futures | 44195.5 | 44196.6 | 44143.5 | 44160.2 | 1789.0 |
| 2024-09-20 08:00:00 | YM | Futures | 44163.3 | 44204.9 | 44162.2 | 44199.7 | 2553.0 |
| 2024-09-20 09:00:00 | YM | Futures | 44200.8 | 44200.8 | 44016.5 | 44041.5 | 19232.0 |
| 2024-09-20 10:00:00 | YM | Futures | 44039.4 | 44123.7 | 43970.7 | 44063.4 | 16466.0 |
| 2024-09-20 11:00:00 | YM | Futures | 44063.4 | 44107.1 | 43995.7 | 44067.5 | 13420.0 |
| 2024-09-20 12:00:00 | YM | Futures | 44068.6 | 44229.9 | 44044.6 | 44201.8 | 8361.0 |
| 2024-09-20 13:00:00 | YM | Futures | 44199.7 | 44270.5 | 44189.3 | 44216.4 | 7071.0 |
| 2024-09-20 14:00:00 | YM | Futures | 44216.4 | 44218.4 | 44031.1 | 44115.4 | 11100.0 |
| 2024-09-20 15:00:00 | YM | Futures | 44113.3 | 44247.6 | 44070.7 | 44175.8 | 15668.0 |
> showing 50 of 1,676 rows — these rows as CSV