PREVIEW / futures_1hour / 2024-11-10
file: by_date/futures_1hour/2024/2024-11-10.parquet size: 20 KB rows: 453
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-11-10 18:00:00 | ES | Futures | 6259.7 | 6268.53 | 6259.19 | 6267.49 | 12982.0 |
| 2024-11-10 19:00:00 | ES | Futures | 6267.49 | 6268.27 | 6262.04 | 6262.56 | 7163.0 |
| 2024-11-10 20:00:00 | ES | Futures | 6262.56 | 6265.93 | 6261.0 | 6265.15 | 6335.0 |
| 2024-11-10 21:00:00 | ES | Futures | 6265.15 | 6265.67 | 6262.04 | 6263.08 | 4406.0 |
| 2024-11-10 22:00:00 | ES | Futures | 6262.82 | 6264.64 | 6262.3 | 6264.12 | 2418.0 |
| 2024-11-10 23:00:00 | ES | Futures | 6264.12 | 6266.45 | 6264.12 | 6266.45 | 3789.0 |
| 2024-11-10 18:00:00 | NQ | Futures | 22177.29 | 22250.6 | 22176.5 | 22234.43 | 6424.0 |
| 2024-11-10 19:00:00 | NQ | Futures | 22233.9 | 22240.95 | 22201.29 | 22204.16 | 4766.0 |
| 2024-11-10 20:00:00 | NQ | Futures | 22203.12 | 22218.51 | 22185.9 | 22212.25 | 5882.0 |
| 2024-11-10 21:00:00 | NQ | Futures | 22211.47 | 22212.51 | 22190.59 | 22198.42 | 3602.0 |
| 2024-11-10 22:00:00 | NQ | Futures | 22197.64 | 22206.77 | 22193.98 | 22202.07 | 2159.0 |
| 2024-11-10 23:00:00 | NQ | Futures | 22203.12 | 22217.99 | 22203.12 | 22216.94 | 2187.0 |
| 2024-11-10 18:00:00 | YM | Futures | 45951.3 | 45995.0 | 45940.9 | 45994.0 | 2228.0 |
| 2024-11-10 19:00:00 | YM | Futures | 45992.9 | 45998.1 | 45962.7 | 45964.8 | 1642.0 |
| 2024-11-10 20:00:00 | YM | Futures | 45962.7 | 45975.2 | 45949.2 | 45966.9 | 1163.0 |
| 2024-11-10 21:00:00 | YM | Futures | 45967.9 | 45983.6 | 45957.5 | 45960.7 | 1007.0 |
| 2024-11-10 22:00:00 | YM | Futures | 45960.7 | 45969.0 | 45952.3 | 45966.9 | 709.0 |
| 2024-11-10 23:00:00 | YM | Futures | 45966.9 | 45975.2 | 45962.7 | 45970.0 | 634.0 |
| 2024-11-10 18:00:00 | CL | Futures | 63.58 | 63.73 | 63.43 | 63.57 | 2398.0 |
| 2024-11-10 19:00:00 | CL | Futures | 63.57 | 63.65 | 63.56 | 63.6 | 766.0 |
| 2024-11-10 20:00:00 | CL | Futures | 63.6 | 63.6 | 63.32 | 63.46 | 3045.0 |
| 2024-11-10 21:00:00 | CL | Futures | 63.46 | 63.51 | 63.32 | 63.51 | 1454.0 |
| 2024-11-10 22:00:00 | CL | Futures | 63.5 | 63.51 | 63.33 | 63.41 | 1098.0 |
| 2024-11-10 23:00:00 | CL | Futures | 63.41 | 63.41 | 63.28 | 63.32 | 821.0 |
| 2024-11-10 18:00:00 | GC | Futures | 2834.7 | 2836.0 | 2828.9 | 2835.2 | 2442.0 |
| 2024-11-10 19:00:00 | GC | Futures | 2835.4 | 2836.1 | 2832.2 | 2833.7 | 1906.0 |
| 2024-11-10 20:00:00 | GC | Futures | 2833.6 | 2834.7 | 2820.4 | 2821.8 | 7945.0 |
| 2024-11-10 21:00:00 | GC | Futures | 2821.6 | 2824.1 | 2814.7 | 2820.7 | 6134.0 |
| 2024-11-10 22:00:00 | GC | Futures | 2820.6 | 2820.7 | 2816.6 | 2819.0 | 2636.0 |
| 2024-11-10 23:00:00 | GC | Futures | 2818.8 | 2821.3 | 2817.3 | 2821.1 | 2595.0 |
| 2024-11-10 18:00:00 | ZN | Futures | 110.388854 | 110.420156 | 110.294946 | 110.310597 | 19253.0 |
| 2024-11-10 19:00:00 | ZN | Futures | 110.310597 | 110.326248 | 110.23234 | 110.23234 | 16730.0 |
| 2024-11-10 20:00:00 | ZN | Futures | 110.23234 | 110.263643 | 110.23234 | 110.247992 | 7389.0 |
| 2024-11-10 21:00:00 | ZN | Futures | 110.23234 | 110.263643 | 110.216689 | 110.247992 | 9369.0 |
| 2024-11-10 22:00:00 | ZN | Futures | 110.23234 | 110.247992 | 110.185386 | 110.216689 | 8334.0 |
| 2024-11-10 23:00:00 | ZN | Futures | 110.201038 | 110.23234 | 110.185386 | 110.201038 | 10232.0 |
> showing 36 of 453 rows — these rows as CSV