PREVIEW / futures_1hour / 2024-03-12
file: by_date/futures_1hour/2024/2024-03-12.parquet size: 63 KB rows: 1,997
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-03-12 00:00:00 | ES | Futures | 5520.07 | 5523.57 | 5519.27 | 5523.03 | 1513.0 |
| 2024-03-12 01:00:00 | ES | Futures | 5523.03 | 5528.13 | 5522.76 | 5527.59 | 2541.0 |
| 2024-03-12 02:00:00 | ES | Futures | 5527.86 | 5527.86 | 5522.22 | 5525.18 | 2679.0 |
| 2024-03-12 03:00:00 | ES | Futures | 5524.91 | 5527.33 | 5523.3 | 5525.71 | 3225.0 |
| 2024-03-12 04:00:00 | ES | Futures | 5525.71 | 5528.94 | 5512.82 | 5515.78 | 8685.0 |
| 2024-03-12 05:00:00 | ES | Futures | 5515.78 | 5518.46 | 5512.55 | 5512.82 | 3792.0 |
| 2024-03-12 06:00:00 | ES | Futures | 5512.82 | 5520.88 | 5512.55 | 5518.46 | 4512.0 |
| 2024-03-12 07:00:00 | ES | Futures | 5517.93 | 5518.19 | 5512.55 | 5515.78 | 6240.0 |
| 2024-03-12 08:00:00 | ES | Futures | 5515.51 | 5541.83 | 5492.95 | 5527.86 | 55219.0 |
| 2024-03-12 09:00:00 | ES | Futures | 5527.86 | 5530.28 | 5498.32 | 5525.98 | 83162.0 |
| 2024-03-12 10:00:00 | ES | Futures | 5525.98 | 5559.29 | 5521.15 | 5553.38 | 79240.0 |
| 2024-03-12 11:00:00 | ES | Futures | 5553.38 | 5559.83 | 5544.78 | 5552.57 | 47084.0 |
| 2024-03-12 12:00:00 | ES | Futures | 5552.3 | 5553.38 | 5527.33 | 5536.46 | 38567.0 |
| 2024-03-12 13:00:00 | ES | Futures | 5536.46 | 5551.5 | 5527.59 | 5549.35 | 25834.0 |
| 2024-03-12 14:00:00 | ES | Futures | 5549.62 | 5566.81 | 5548.28 | 5561.97 | 36237.0 |
| 2024-03-12 15:00:00 | ES | Futures | 5561.97 | 5568.42 | 5557.95 | 5562.24 | 55452.0 |
| 2024-03-12 16:00:00 | ES | Futures | 5562.24 | 5565.73 | 5559.56 | 5559.83 | 15111.0 |
| 2024-03-12 18:00:00 | ES | Futures | 5560.9 | 5564.93 | 5559.02 | 5563.32 | 1277.0 |
| 2024-03-12 19:00:00 | ES | Futures | 5563.59 | 5566.54 | 5562.24 | 5564.66 | 1270.0 |
| 2024-03-12 20:00:00 | ES | Futures | 5564.66 | 5565.47 | 5560.09 | 5561.17 | 2997.0 |
| 2024-03-12 21:00:00 | ES | Futures | 5561.17 | 5561.17 | 5559.29 | 5559.83 | 2076.0 |
| 2024-03-12 22:00:00 | ES | Futures | 5560.09 | 5561.17 | 5557.14 | 5557.41 | 1174.0 |
| 2024-03-12 23:00:00 | ES | Futures | 5557.68 | 5559.56 | 5555.53 | 5559.29 | 1098.0 |
| 2024-03-12 00:00:00 | NQ | Futures | 19584.57 | 19606.27 | 19583.49 | 19604.37 | 761.0 |
| 2024-03-12 01:00:00 | NQ | Futures | 19604.64 | 19629.86 | 19604.64 | 19627.69 | 1857.0 |
| 2024-03-12 02:00:00 | NQ | Futures | 19627.96 | 19629.86 | 19600.03 | 19612.78 | 1861.0 |
| 2024-03-12 03:00:00 | NQ | Futures | 19614.13 | 19622.27 | 19605.73 | 19613.59 | 1438.0 |
| 2024-03-12 04:00:00 | NQ | Futures | 19614.67 | 19632.57 | 19559.62 | 19571.01 | 4555.0 |
| 2024-03-12 05:00:00 | NQ | Futures | 19571.28 | 19585.66 | 19562.06 | 19562.87 | 2274.0 |
| 2024-03-12 06:00:00 | NQ | Futures | 19563.15 | 19595.15 | 19561.52 | 19580.77 | 2380.0 |
| 2024-03-12 07:00:00 | NQ | Futures | 19580.5 | 19593.25 | 19562.06 | 19581.05 | 2990.0 |
| 2024-03-12 08:00:00 | NQ | Futures | 19580.23 | 19670.27 | 19477.99 | 19600.57 | 24982.0 |
| 2024-03-12 09:00:00 | NQ | Futures | 19601.66 | 19628.24 | 19450.87 | 19578.6 | 38077.0 |
| 2024-03-12 10:00:00 | NQ | Futures | 19578.6 | 19741.33 | 19558.26 | 19712.58 | 29099.0 |
| 2024-03-12 11:00:00 | NQ | Futures | 19713.94 | 19752.72 | 19680.85 | 19714.21 | 15244.0 |
| 2024-03-12 12:00:00 | NQ | Futures | 19713.94 | 19718.82 | 19610.06 | 19645.05 | 15166.0 |
| 2024-03-12 13:00:00 | NQ | Futures | 19645.32 | 19701.46 | 19610.88 | 19693.32 | 11312.0 |
| 2024-03-12 14:00:00 | NQ | Futures | 19694.41 | 19764.38 | 19687.63 | 19750.28 | 10856.0 |
| 2024-03-12 15:00:00 | NQ | Futures | 19750.82 | 19789.06 | 19729.12 | 19772.79 | 14694.0 |
| 2024-03-12 16:00:00 | NQ | Futures | 19772.52 | 19780.38 | 19760.04 | 19768.45 | 3984.0 |
| 2024-03-12 18:00:00 | NQ | Futures | 19763.3 | 19776.86 | 19760.04 | 19771.97 | 540.0 |
| 2024-03-12 19:00:00 | NQ | Futures | 19773.06 | 19786.08 | 19767.91 | 19778.48 | 512.0 |
| 2024-03-12 20:00:00 | NQ | Futures | 19776.04 | 19779.3 | 19754.62 | 19760.04 | 548.0 |
| 2024-03-12 21:00:00 | NQ | Futures | 19759.23 | 19760.85 | 19749.74 | 19757.87 | 723.0 |
| 2024-03-12 22:00:00 | NQ | Futures | 19757.06 | 19760.04 | 19747.29 | 19748.38 | 391.0 |
| 2024-03-12 23:00:00 | NQ | Futures | 19748.65 | 19754.89 | 19740.51 | 19752.99 | 611.0 |
| 2024-03-12 00:00:00 | YM | Futures | 41699.4 | 41710.0 | 41692.0 | 41705.8 | 319.0 |
| 2024-03-12 01:00:00 | YM | Futures | 41704.7 | 41731.3 | 41704.7 | 41728.1 | 781.0 |
| 2024-03-12 02:00:00 | YM | Futures | 41728.1 | 41729.1 | 41701.5 | 41715.3 | 897.0 |
| 2024-03-12 03:00:00 | YM | Futures | 41714.3 | 41727.0 | 41702.6 | 41713.2 | 1412.0 |
> showing 50 of 1,997 rows — these rows as CSV