PREVIEW / futures_1hour / 2022-05-13
file: by_date/futures_1hour/2022/2022-05-13.parquet size: 58 KB rows: 1,643
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-13 00:00:00 | ES | Futures | 4497.35 | 4499.05 | 4489.69 | 4497.06 | 6537.0 |
| 2022-05-13 01:00:00 | ES | Futures | 4497.06 | 4502.16 | 4492.24 | 4497.06 | 8786.0 |
| 2022-05-13 02:00:00 | ES | Futures | 4497.06 | 4498.48 | 4482.89 | 4491.68 | 15711.0 |
| 2022-05-13 03:00:00 | ES | Futures | 4491.68 | 4506.7 | 4479.49 | 4496.21 | 31097.0 |
| 2022-05-13 04:00:00 | ES | Futures | 4496.21 | 4506.7 | 4493.94 | 4499.9 | 19651.0 |
| 2022-05-13 05:00:00 | ES | Futures | 4500.18 | 4508.68 | 4491.96 | 4494.79 | 19820.0 |
| 2022-05-13 06:00:00 | ES | Futures | 4494.79 | 4505.0 | 4491.11 | 4503.58 | 11417.0 |
| 2022-05-13 07:00:00 | ES | Futures | 4503.3 | 4521.44 | 4498.48 | 4518.32 | 28267.0 |
| 2022-05-13 08:00:00 | ES | Futures | 4518.6 | 4520.87 | 4511.23 | 4513.79 | 32728.0 |
| 2022-05-13 09:00:00 | ES | Futures | 4513.5 | 4528.81 | 4489.13 | 4523.71 | 232521.0 |
| 2022-05-13 10:00:00 | ES | Futures | 4523.42 | 4556.58 | 4521.44 | 4549.78 | 263821.0 |
| 2022-05-13 11:00:00 | ES | Futures | 4549.78 | 4559.99 | 4542.41 | 4557.44 | 158549.0 |
| 2022-05-13 12:00:00 | ES | Futures | 4557.44 | 4575.86 | 4547.51 | 4559.99 | 153464.0 |
| 2022-05-13 13:00:00 | ES | Futures | 4559.99 | 4564.52 | 4529.66 | 4531.93 | 143272.0 |
| 2022-05-13 14:00:00 | ES | Futures | 4532.21 | 4546.38 | 4507.55 | 4545.81 | 221735.0 |
| 2022-05-13 15:00:00 | ES | Futures | 4545.81 | 4568.49 | 4537.88 | 4558.0 | 309537.0 |
| 2022-05-13 16:00:00 | ES | Futures | 4558.0 | 4558.85 | 4546.66 | 4550.92 | 60352.0 |
| 2022-05-13 00:00:00 | NQ | Futures | 14050.16 | 14070.75 | 14025.51 | 14060.02 | 4307.0 |
| 2022-05-13 01:00:00 | NQ | Futures | 14060.31 | 14082.06 | 14034.21 | 14056.25 | 5756.0 |
| 2022-05-13 02:00:00 | NQ | Futures | 14057.7 | 14062.34 | 13998.26 | 14051.61 | 8786.0 |
| 2022-05-13 03:00:00 | NQ | Futures | 14051.03 | 14127.87 | 13998.55 | 14080.61 | 15439.0 |
| 2022-05-13 04:00:00 | NQ | Futures | 14080.61 | 14121.78 | 14064.95 | 14089.31 | 10522.0 |
| 2022-05-13 05:00:00 | NQ | Futures | 14089.6 | 14121.2 | 14059.15 | 14079.16 | 10335.0 |
| 2022-05-13 06:00:00 | NQ | Futures | 14078.29 | 14107.29 | 14050.45 | 14099.17 | 6563.0 |
| 2022-05-13 07:00:00 | NQ | Futures | 14098.3 | 14159.48 | 14076.55 | 14149.62 | 12772.0 |
| 2022-05-13 08:00:00 | NQ | Futures | 14149.91 | 14158.61 | 14118.88 | 14121.49 | 15119.0 |
| 2022-05-13 09:00:00 | NQ | Futures | 14122.07 | 14242.12 | 13993.91 | 14200.95 | 93785.0 |
| 2022-05-13 10:00:00 | NQ | Futures | 14200.37 | 14318.1 | 14193.41 | 14295.48 | 87394.0 |
| 2022-05-13 11:00:00 | NQ | Futures | 14295.77 | 14345.94 | 14251.98 | 14336.66 | 59353.0 |
| 2022-05-13 12:00:00 | NQ | Futures | 14336.08 | 14418.14 | 14316.94 | 14364.49 | 60247.0 |
| 2022-05-13 13:00:00 | NQ | Futures | 14364.49 | 14379.28 | 14256.62 | 14270.54 | 49237.0 |
| 2022-05-13 14:00:00 | NQ | Futures | 14270.83 | 14328.25 | 14172.24 | 14323.61 | 69047.0 |
| 2022-05-13 15:00:00 | NQ | Futures | 14324.19 | 14419.88 | 14285.33 | 14364.78 | 90526.0 |
| 2022-05-13 16:00:00 | NQ | Futures | 14364.2 | 14371.16 | 14327.67 | 14341.01 | 17613.0 |
| 2022-05-13 00:00:00 | YM | Futures | 35973.1 | 35979.9 | 35922.4 | 35966.4 | 1322.0 |
| 2022-05-13 01:00:00 | YM | Futures | 35969.7 | 36004.7 | 35946.1 | 35969.7 | 1549.0 |
| 2022-05-13 02:00:00 | YM | Futures | 35965.2 | 35987.8 | 35860.4 | 35906.6 | 2905.0 |
| 2022-05-13 03:00:00 | YM | Futures | 35907.7 | 36009.2 | 35826.6 | 35929.2 | 6021.0 |
| 2022-05-13 04:00:00 | YM | Futures | 35922.4 | 35994.5 | 35908.9 | 35957.3 | 2493.0 |
| 2022-05-13 05:00:00 | YM | Futures | 35957.3 | 36003.6 | 35884.1 | 35898.7 | 3087.0 |
| 2022-05-13 06:00:00 | YM | Futures | 35896.5 | 35970.9 | 35885.2 | 35963.0 | 1969.0 |
| 2022-05-13 07:00:00 | YM | Futures | 35961.9 | 36072.3 | 35926.9 | 36061.1 | 3678.0 |
| 2022-05-13 08:00:00 | YM | Futures | 36063.3 | 36087.0 | 36016.0 | 36044.1 | 4940.0 |
| 2022-05-13 09:00:00 | YM | Futures | 36043.0 | 36050.9 | 35881.8 | 36010.3 | 25415.0 |
| 2022-05-13 10:00:00 | YM | Futures | 36016.0 | 36268.5 | 35997.9 | 36199.7 | 24827.0 |
| 2022-05-13 11:00:00 | YM | Futures | 36200.8 | 36264.0 | 36152.4 | 36202.0 | 11304.0 |
| 2022-05-13 12:00:00 | YM | Futures | 36204.2 | 36301.2 | 36079.1 | 36163.6 | 12572.0 |
| 2022-05-13 13:00:00 | YM | Futures | 36164.8 | 36196.3 | 35958.5 | 35986.7 | 12115.0 |
| 2022-05-13 14:00:00 | YM | Futures | 35984.4 | 36098.3 | 35824.3 | 36097.1 | 17102.0 |
| 2022-05-13 15:00:00 | YM | Futures | 36098.3 | 36266.2 | 36080.2 | 36213.2 | 23188.0 |
> showing 50 of 1,643 rows — these rows as CSV