PREVIEW / futures_1hour / 2024-03-15
file: by_date/futures_1hour/2024/2024-03-15.parquet size: 55 KB rows: 1,648
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-15 00:00:00 | ES | Futures | 5535.93 | 5535.93 | 5530.88 | 5532.21 | 4288.0 |
| 2024-03-15 01:00:00 | ES | Futures | 5531.95 | 5533.54 | 5528.76 | 5531.15 | 5352.0 |
| 2024-03-15 02:00:00 | ES | Futures | 5530.88 | 5533.27 | 5529.03 | 5530.62 | 4625.0 |
| 2024-03-15 03:00:00 | ES | Futures | 5530.62 | 5536.99 | 5529.56 | 5530.62 | 7628.0 |
| 2024-03-15 04:00:00 | ES | Futures | 5530.62 | 5538.58 | 5530.35 | 5537.52 | 15650.0 |
| 2024-03-15 05:00:00 | ES | Futures | 5537.78 | 5546.54 | 5537.52 | 5544.41 | 16843.0 |
| 2024-03-15 06:00:00 | ES | Futures | 5544.68 | 5550.78 | 5544.41 | 5548.39 | 15195.0 |
| 2024-03-15 07:00:00 | ES | Futures | 5548.13 | 5550.52 | 5543.62 | 5544.68 | 18954.0 |
| 2024-03-15 08:00:00 | ES | Futures | 5544.95 | 5545.21 | 5534.86 | 5539.64 | 44155.0 |
| 2024-03-15 09:00:00 | ES | Futures | 5539.37 | 5540.7 | 5497.19 | 5499.85 | 300640.0 |
| 2024-03-15 10:00:00 | ES | Futures | 5499.31 | 5520.01 | 5489.23 | 5513.38 | 281073.0 |
| 2024-03-15 11:00:00 | ES | Futures | 5513.64 | 5514.7 | 5496.66 | 5498.25 | 174270.0 |
| 2024-03-15 12:00:00 | ES | Futures | 5498.52 | 5500.38 | 5483.93 | 5484.99 | 171497.0 |
| 2024-03-15 13:00:00 | ES | Futures | 5484.99 | 5501.44 | 5484.72 | 5501.17 | 130755.0 |
| 2024-03-15 14:00:00 | ES | Futures | 5501.17 | 5508.07 | 5493.21 | 5504.09 | 147589.0 |
| 2024-03-15 15:00:00 | ES | Futures | 5503.82 | 5508.07 | 5494.27 | 5499.85 | 273086.0 |
| 2024-03-15 16:00:00 | ES | Futures | 5500.11 | 5504.89 | 5497.99 | 5500.38 | 101913.0 |
| 2024-03-15 00:00:00 | NQ | Futures | 19521.91 | 19522.44 | 19495.96 | 19500.78 | 2367.0 |
| 2024-03-15 01:00:00 | NQ | Futures | 19501.04 | 19508.27 | 19480.18 | 19492.22 | 3476.0 |
| 2024-03-15 02:00:00 | NQ | Futures | 19491.15 | 19499.44 | 19483.92 | 19494.09 | 2934.0 |
| 2024-03-15 03:00:00 | NQ | Futures | 19495.69 | 19520.04 | 19483.12 | 19486.06 | 5436.0 |
| 2024-03-15 04:00:00 | NQ | Futures | 19484.99 | 19543.84 | 19484.46 | 19537.69 | 8789.0 |
| 2024-03-15 05:00:00 | NQ | Futures | 19537.69 | 19583.7 | 19532.07 | 19570.06 | 8516.0 |
| 2024-03-15 06:00:00 | NQ | Futures | 19570.06 | 19605.64 | 19570.06 | 19589.86 | 8268.0 |
| 2024-03-15 07:00:00 | NQ | Futures | 19589.59 | 19591.73 | 19553.47 | 19561.5 | 10173.0 |
| 2024-03-15 08:00:00 | NQ | Futures | 19562.03 | 19563.64 | 19509.07 | 19531.27 | 23146.0 |
| 2024-03-15 09:00:00 | NQ | Futures | 19530.47 | 19533.68 | 19335.19 | 19360.87 | 133428.0 |
| 2024-03-15 10:00:00 | NQ | Futures | 19360.07 | 19444.33 | 19291.32 | 19392.7 | 120914.0 |
| 2024-03-15 11:00:00 | NQ | Futures | 19393.51 | 19398.05 | 19313.79 | 19327.97 | 69988.0 |
| 2024-03-15 12:00:00 | NQ | Futures | 19328.24 | 19340.81 | 19266.98 | 19272.6 | 63890.0 |
| 2024-03-15 13:00:00 | NQ | Futures | 19271.79 | 19351.24 | 19269.12 | 19346.96 | 50466.0 |
| 2024-03-15 14:00:00 | NQ | Futures | 19347.5 | 19368.63 | 19304.43 | 19349.64 | 48628.0 |
| 2024-03-15 15:00:00 | NQ | Futures | 19349.37 | 19374.51 | 19307.37 | 19322.89 | 73323.0 |
| 2024-03-15 16:00:00 | NQ | Futures | 19322.62 | 19346.69 | 19320.21 | 19328.24 | 18561.0 |
| 2024-03-15 00:00:00 | YM | Futures | 41767.4 | 41768.4 | 41741.9 | 41748.3 | 417.0 |
| 2024-03-15 01:00:00 | YM | Futures | 41747.2 | 41754.6 | 41732.3 | 41745.1 | 654.0 |
| 2024-03-15 02:00:00 | YM | Futures | 41745.1 | 41762.1 | 41727.0 | 41736.6 | 1050.0 |
| 2024-03-15 03:00:00 | YM | Futures | 41736.6 | 41788.6 | 41731.3 | 41741.9 | 1703.0 |
| 2024-03-15 04:00:00 | YM | Futures | 41743.0 | 41803.5 | 41741.9 | 41780.1 | 2996.0 |
| 2024-03-15 05:00:00 | YM | Futures | 41781.2 | 41839.6 | 41781.2 | 41828.9 | 2608.0 |
| 2024-03-15 06:00:00 | YM | Futures | 41828.9 | 41841.7 | 41812.0 | 41821.5 | 2103.0 |
| 2024-03-15 07:00:00 | YM | Futures | 41823.6 | 41858.7 | 41820.5 | 41840.6 | 2655.0 |
| 2024-03-15 08:00:00 | YM | Futures | 41841.7 | 41858.7 | 41807.7 | 41830.0 | 4771.0 |
| 2024-03-15 09:00:00 | YM | Futures | 41831.1 | 41837.4 | 41585.8 | 41615.5 | 35576.0 |
| 2024-03-15 10:00:00 | YM | Futures | 41613.4 | 41740.8 | 41573.1 | 41711.1 | 22980.0 |
| 2024-03-15 11:00:00 | YM | Futures | 41712.2 | 41732.3 | 41595.4 | 41610.2 | 14772.0 |
| 2024-03-15 12:00:00 | YM | Futures | 41610.2 | 41624.0 | 41457.4 | 41469.0 | 16236.0 |
| 2024-03-15 13:00:00 | YM | Futures | 41465.8 | 41574.1 | 41461.6 | 41569.9 | 12187.0 |
| 2024-03-15 14:00:00 | YM | Futures | 41571.0 | 41631.5 | 41521.1 | 41587.9 | 12331.0 |
| 2024-03-15 15:00:00 | YM | Futures | 41584.8 | 41613.4 | 41520.0 | 41569.9 | 18054.0 |
> showing 50 of 1,648 rows — these rows as CSV