PREVIEW / futures_1hour / 2023-05-10
file: by_date/futures_1hour/2023/2023-05-10.parquet size: 67 KB rows: 2,041
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-10 00:00:00 | ES | Futures | 4590.2 | 4592.14 | 4588.53 | 4591.31 | 2775.0 |
| 2023-05-10 01:00:00 | ES | Futures | 4591.31 | 4591.86 | 4586.59 | 4588.81 | 3852.0 |
| 2023-05-10 02:00:00 | ES | Futures | 4588.81 | 4593.8 | 4588.81 | 4592.97 | 5107.0 |
| 2023-05-10 03:00:00 | ES | Futures | 4592.97 | 4595.75 | 4576.61 | 4577.44 | 19601.0 |
| 2023-05-10 04:00:00 | ES | Futures | 4577.44 | 4582.43 | 4571.34 | 4580.49 | 20538.0 |
| 2023-05-10 05:00:00 | ES | Futures | 4580.49 | 4582.99 | 4577.72 | 4580.77 | 9854.0 |
| 2023-05-10 06:00:00 | ES | Futures | 4580.49 | 4581.05 | 4577.44 | 4579.38 | 11879.0 |
| 2023-05-10 07:00:00 | ES | Futures | 4579.66 | 4582.99 | 4578.0 | 4580.77 | 15705.0 |
| 2023-05-10 08:00:00 | ES | Futures | 4580.49 | 4625.15 | 4578.55 | 4622.09 | 164884.0 |
| 2023-05-10 09:00:00 | ES | Futures | 4622.09 | 4629.86 | 4591.31 | 4602.4 | 293969.0 |
| 2023-05-10 10:00:00 | ES | Futures | 4602.4 | 4616.82 | 4576.89 | 4584.93 | 314650.0 |
| 2023-05-10 11:00:00 | ES | Futures | 4584.93 | 4601.85 | 4584.1 | 4593.53 | 144341.0 |
| 2023-05-10 12:00:00 | ES | Futures | 4593.53 | 4594.08 | 4579.38 | 4582.16 | 109039.0 |
| 2023-05-10 13:00:00 | ES | Futures | 4582.16 | 4582.99 | 4562.19 | 4576.05 | 187094.0 |
| 2023-05-10 14:00:00 | ES | Futures | 4575.78 | 4599.63 | 4575.78 | 4597.41 | 156159.0 |
| 2023-05-10 15:00:00 | ES | Futures | 4597.41 | 4617.93 | 4595.19 | 4606.84 | 282125.0 |
| 2023-05-10 16:00:00 | ES | Futures | 4606.84 | 4611.55 | 4606.01 | 4607.12 | 59627.0 |
| 2023-05-10 18:00:00 | ES | Futures | 4607.12 | 4609.89 | 4605.73 | 4609.34 | 4311.0 |
| 2023-05-10 19:00:00 | ES | Futures | 4609.06 | 4614.05 | 4607.95 | 4611.83 | 4800.0 |
| 2023-05-10 20:00:00 | ES | Futures | 4612.11 | 4619.04 | 4612.11 | 4617.1 | 10892.0 |
| 2023-05-10 21:00:00 | ES | Futures | 4617.1 | 4620.15 | 4614.05 | 4614.61 | 8220.0 |
| 2023-05-10 22:00:00 | ES | Futures | 4614.33 | 4616.55 | 4613.5 | 4615.44 | 4635.0 |
| 2023-05-10 23:00:00 | ES | Futures | 4615.44 | 4617.38 | 4614.88 | 4615.99 | 4709.0 |
| 2023-05-10 00:00:00 | NQ | Futures | 14946.8 | 14952.72 | 14940.33 | 14949.9 | 1534.0 |
| 2023-05-10 01:00:00 | NQ | Futures | 14949.34 | 14951.31 | 14932.16 | 14940.05 | 2230.0 |
| 2023-05-10 02:00:00 | NQ | Futures | 14940.61 | 14960.04 | 14940.61 | 14958.35 | 3022.0 |
| 2023-05-10 03:00:00 | NQ | Futures | 14958.07 | 14962.57 | 14891.62 | 14895.28 | 10411.0 |
| 2023-05-10 04:00:00 | NQ | Futures | 14895.56 | 14912.17 | 14869.1 | 14903.45 | 10027.0 |
| 2023-05-10 05:00:00 | NQ | Futures | 14903.16 | 14917.81 | 14894.44 | 14907.39 | 4597.0 |
| 2023-05-10 06:00:00 | NQ | Futures | 14907.11 | 14918.65 | 14896.41 | 14916.4 | 4358.0 |
| 2023-05-10 07:00:00 | NQ | Futures | 14916.68 | 14941.46 | 14911.05 | 14935.54 | 7804.0 |
| 2023-05-10 08:00:00 | NQ | Futures | 14935.54 | 15083.08 | 14926.25 | 15072.94 | 57853.0 |
| 2023-05-10 09:00:00 | NQ | Futures | 15072.94 | 15110.39 | 15002.55 | 15064.21 | 127404.0 |
| 2023-05-10 10:00:00 | NQ | Futures | 15064.49 | 15129.25 | 14976.65 | 15002.55 | 167765.0 |
| 2023-05-10 11:00:00 | NQ | Futures | 15002.55 | 15083.36 | 15001.14 | 15055.2 | 73614.0 |
| 2023-05-10 12:00:00 | NQ | Futures | 15055.2 | 15056.61 | 15004.8 | 15015.22 | 57824.0 |
| 2023-05-10 13:00:00 | NQ | Futures | 15015.5 | 15028.46 | 14936.11 | 14989.88 | 79179.0 |
| 2023-05-10 14:00:00 | NQ | Futures | 14989.88 | 15086.46 | 14988.19 | 15085.05 | 84856.0 |
| 2023-05-10 15:00:00 | NQ | Futures | 15084.77 | 15143.89 | 15074.63 | 15103.07 | 110663.0 |
| 2023-05-10 16:00:00 | NQ | Futures | 15103.07 | 15116.86 | 15095.75 | 15101.1 | 16722.0 |
| 2023-05-10 18:00:00 | NQ | Futures | 15102.5 | 15108.13 | 15095.18 | 15103.63 | 2344.0 |
| 2023-05-10 19:00:00 | NQ | Futures | 15103.63 | 15121.65 | 15097.72 | 15116.02 | 2868.0 |
| 2023-05-10 20:00:00 | NQ | Futures | 15116.3 | 15137.98 | 15116.02 | 15129.81 | 4698.0 |
| 2023-05-10 21:00:00 | NQ | Futures | 15129.53 | 15145.02 | 15124.18 | 15125.31 | 4624.0 |
| 2023-05-10 22:00:00 | NQ | Futures | 15125.87 | 15135.45 | 15122.49 | 15128.69 | 2211.0 |
| 2023-05-10 23:00:00 | NQ | Futures | 15127.84 | 15135.16 | 15125.59 | 15128.41 | 1987.0 |
| 2023-05-10 00:00:00 | YM | Futures | 37196.9 | 37210.2 | 37187.0 | 37205.8 | 591.0 |
| 2023-05-10 01:00:00 | YM | Futures | 37205.8 | 37210.2 | 37168.2 | 37182.6 | 730.0 |
| 2023-05-10 02:00:00 | YM | Futures | 37181.5 | 37221.3 | 37181.5 | 37212.4 | 896.0 |
| 2023-05-10 03:00:00 | YM | Futures | 37212.4 | 37248.9 | 37104.1 | 37112.9 | 4134.0 |
> showing 50 of 2,041 rows — these rows as CSV