PREVIEW / futures_1hour / 2024-10-15
file: by_date/futures_1hour/2024/2024-10-15.parquet size: 67 KB rows: 2,083
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-10-15 00:00:00 | ES | Futures | 6139.55 | 6139.55 | 6137.99 | 6138.77 | 1230.0 |
| 2024-10-15 01:00:00 | ES | Futures | 6138.51 | 6139.03 | 6134.35 | 6134.61 | 4229.0 |
| 2024-10-15 02:00:00 | ES | Futures | 6134.87 | 6136.43 | 6133.32 | 6133.58 | 5463.0 |
| 2024-10-15 03:00:00 | ES | Futures | 6133.58 | 6136.95 | 6132.28 | 6134.61 | 9364.0 |
| 2024-10-15 04:00:00 | ES | Futures | 6134.61 | 6134.61 | 6127.35 | 6129.68 | 13736.0 |
| 2024-10-15 05:00:00 | ES | Futures | 6129.68 | 6132.02 | 6127.09 | 6128.9 | 9352.0 |
| 2024-10-15 06:00:00 | ES | Futures | 6129.16 | 6135.65 | 6127.09 | 6133.84 | 13008.0 |
| 2024-10-15 07:00:00 | ES | Futures | 6133.84 | 6135.65 | 6130.98 | 6133.58 | 12840.0 |
| 2024-10-15 08:00:00 | ES | Futures | 6133.58 | 6136.43 | 6130.98 | 6135.39 | 18036.0 |
| 2024-10-15 09:00:00 | ES | Futures | 6135.65 | 6139.29 | 6130.98 | 6132.28 | 111391.0 |
| 2024-10-15 10:00:00 | ES | Futures | 6132.28 | 6136.69 | 6101.65 | 6108.92 | 281206.0 |
| 2024-10-15 11:00:00 | ES | Futures | 6108.92 | 6117.75 | 6101.4 | 6102.95 | 148025.0 |
| 2024-10-15 12:00:00 | ES | Futures | 6103.21 | 6115.15 | 6102.17 | 6107.1 | 94870.0 |
| 2024-10-15 13:00:00 | ES | Futures | 6107.36 | 6108.92 | 6096.72 | 6098.54 | 98942.0 |
| 2024-10-15 14:00:00 | ES | Futures | 6098.54 | 6102.95 | 6087.9 | 6089.46 | 99195.0 |
| 2024-10-15 15:00:00 | ES | Futures | 6089.46 | 6090.5 | 6072.85 | 6086.34 | 276899.0 |
| 2024-10-15 16:00:00 | ES | Futures | 6086.34 | 6088.16 | 6081.41 | 6084.01 | 49704.0 |
| 2024-10-15 18:00:00 | ES | Futures | 6084.27 | 6086.86 | 6076.74 | 6086.34 | 5188.0 |
| 2024-10-15 19:00:00 | ES | Futures | 6086.34 | 6089.2 | 6085.82 | 6086.34 | 3897.0 |
| 2024-10-15 20:00:00 | ES | Futures | 6086.6 | 6089.98 | 6084.79 | 6087.12 | 5968.0 |
| 2024-10-15 21:00:00 | ES | Futures | 6086.86 | 6090.75 | 6084.01 | 6088.94 | 6595.0 |
| 2024-10-15 22:00:00 | ES | Futures | 6088.94 | 6091.01 | 6087.9 | 6089.98 | 4045.0 |
| 2024-10-15 23:00:00 | ES | Futures | 6089.72 | 6092.57 | 6088.94 | 6091.79 | 2930.0 |
| 2024-10-15 00:00:00 | NQ | Futures | 21534.14 | 21534.4 | 21525.01 | 21529.96 | 831.0 |
| 2024-10-15 01:00:00 | NQ | Futures | 21529.44 | 21531.01 | 21505.44 | 21507.0 | 1897.0 |
| 2024-10-15 02:00:00 | NQ | Futures | 21508.05 | 21512.74 | 21489.78 | 21490.3 | 2912.0 |
| 2024-10-15 03:00:00 | NQ | Futures | 21490.3 | 21513.53 | 21485.87 | 21501.52 | 4356.0 |
| 2024-10-15 04:00:00 | NQ | Futures | 21501.26 | 21508.57 | 21461.08 | 21479.35 | 7212.0 |
| 2024-10-15 05:00:00 | NQ | Futures | 21480.13 | 21490.04 | 21465.52 | 21483.26 | 4438.0 |
| 2024-10-15 06:00:00 | NQ | Futures | 21483.26 | 21522.14 | 21477.0 | 21507.79 | 5984.0 |
| 2024-10-15 07:00:00 | NQ | Futures | 21508.05 | 21520.83 | 21492.91 | 21512.74 | 5382.0 |
| 2024-10-15 08:00:00 | NQ | Futures | 21512.74 | 21531.27 | 21503.35 | 21524.48 | 8016.0 |
| 2024-10-15 09:00:00 | NQ | Futures | 21524.74 | 21561.01 | 21505.18 | 21529.96 | 57010.0 |
| 2024-10-15 10:00:00 | NQ | Futures | 21529.44 | 21549.53 | 21218.69 | 21289.92 | 133462.0 |
| 2024-10-15 11:00:00 | NQ | Futures | 21290.45 | 21340.54 | 21233.57 | 21238.78 | 66549.0 |
| 2024-10-15 12:00:00 | NQ | Futures | 21238.78 | 21307.67 | 21225.48 | 21265.92 | 38725.0 |
| 2024-10-15 13:00:00 | NQ | Futures | 21265.4 | 21279.23 | 21221.83 | 21247.39 | 36735.0 |
| 2024-10-15 14:00:00 | NQ | Futures | 21247.92 | 21278.97 | 21210.35 | 21217.65 | 31981.0 |
| 2024-10-15 15:00:00 | NQ | Futures | 21217.65 | 21238.78 | 21138.07 | 21231.48 | 75278.0 |
| 2024-10-15 16:00:00 | NQ | Futures | 21231.48 | 21244.0 | 21207.74 | 21220.78 | 12070.0 |
| 2024-10-15 18:00:00 | NQ | Futures | 21222.09 | 21240.35 | 21192.34 | 21238.78 | 2625.0 |
| 2024-10-15 19:00:00 | NQ | Futures | 21238.78 | 21254.7 | 21235.39 | 21240.09 | 2974.0 |
| 2024-10-15 20:00:00 | NQ | Futures | 21240.35 | 21262.79 | 21233.04 | 21245.05 | 3797.0 |
| 2024-10-15 21:00:00 | NQ | Futures | 21244.52 | 21265.66 | 21228.35 | 21255.74 | 3440.0 |
| 2024-10-15 22:00:00 | NQ | Futures | 21255.74 | 21273.49 | 21249.22 | 21267.22 | 3331.0 |
| 2024-10-15 23:00:00 | NQ | Futures | 21267.75 | 21282.62 | 21259.92 | 21277.66 | 2367.0 |
| 2024-10-15 00:00:00 | YM | Futures | 45189.5 | 45193.6 | 45185.3 | 45187.4 | 97.0 |
| 2024-10-15 01:00:00 | YM | Futures | 45185.3 | 45187.4 | 45157.2 | 45161.4 | 701.0 |
| 2024-10-15 02:00:00 | YM | Futures | 45163.4 | 45190.5 | 45158.2 | 45188.4 | 935.0 |
| 2024-10-15 03:00:00 | YM | Futures | 45188.4 | 45215.5 | 45165.5 | 45198.8 | 1119.0 |
> showing 50 of 2,083 rows — these rows as CSV