PREVIEW / futures_1hour / 2022-05-05
file: by_date/futures_1hour/2022/2022-05-05.parquet size: 73 KB rows: 2,110
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-05 00:00:00 | ES | Futures | 4866.1 | 4872.05 | 4865.25 | 4872.05 | 3164.0 |
| 2022-05-05 01:00:00 | ES | Futures | 4871.77 | 4876.02 | 4868.37 | 4873.75 | 7066.0 |
| 2022-05-05 02:00:00 | ES | Futures | 4873.75 | 4874.89 | 4854.48 | 4855.33 | 14422.0 |
| 2022-05-05 03:00:00 | ES | Futures | 4855.61 | 4858.45 | 4839.17 | 4848.81 | 30504.0 |
| 2022-05-05 04:00:00 | ES | Futures | 4848.53 | 4851.08 | 4830.1 | 4835.49 | 20521.0 |
| 2022-05-05 05:00:00 | ES | Futures | 4835.21 | 4842.58 | 4832.66 | 4839.46 | 16074.0 |
| 2022-05-05 06:00:00 | ES | Futures | 4839.46 | 4846.54 | 4833.51 | 4834.07 | 14344.0 |
| 2022-05-05 07:00:00 | ES | Futures | 4834.36 | 4847.39 | 4833.51 | 4838.61 | 19699.0 |
| 2022-05-05 08:00:00 | ES | Futures | 4838.32 | 4845.41 | 4833.79 | 4834.07 | 27156.0 |
| 2022-05-05 09:00:00 | ES | Futures | 4834.07 | 4834.92 | 4780.22 | 4785.6 | 220750.0 |
| 2022-05-05 10:00:00 | ES | Futures | 4785.89 | 4786.45 | 4713.33 | 4730.9 | 397555.0 |
| 2022-05-05 11:00:00 | ES | Futures | 4731.18 | 4735.15 | 4679.88 | 4680.73 | 320258.0 |
| 2022-05-05 12:00:00 | ES | Futures | 4680.45 | 4710.21 | 4665.14 | 4705.39 | 263971.0 |
| 2022-05-05 13:00:00 | ES | Futures | 4705.11 | 4726.65 | 4686.12 | 4693.49 | 187706.0 |
| 2022-05-05 14:00:00 | ES | Futures | 4693.49 | 4713.04 | 4672.23 | 4685.83 | 198406.0 |
| 2022-05-05 15:00:00 | ES | Futures | 4685.55 | 4703.97 | 4647.57 | 4698.87 | 457510.0 |
| 2022-05-05 16:00:00 | ES | Futures | 4698.87 | 4713.04 | 4694.34 | 4706.24 | 84986.0 |
| 2022-05-05 18:00:00 | ES | Futures | 4701.14 | 4701.71 | 4690.37 | 4698.87 | 9199.0 |
| 2022-05-05 19:00:00 | ES | Futures | 4698.87 | 4703.97 | 4695.19 | 4702.56 | 6286.0 |
| 2022-05-05 20:00:00 | ES | Futures | 4702.56 | 4704.54 | 4681.3 | 4683.57 | 15206.0 |
| 2022-05-05 21:00:00 | ES | Futures | 4683.57 | 4687.25 | 4676.2 | 4683.0 | 15585.0 |
| 2022-05-05 22:00:00 | ES | Futures | 4683.0 | 4690.65 | 4678.75 | 4689.23 | 9437.0 |
| 2022-05-05 23:00:00 | ES | Futures | 4688.95 | 4701.99 | 4686.4 | 4700.01 | 7634.0 |
| 2022-05-05 00:00:00 | NQ | Futures | 15684.17 | 15705.92 | 15680.69 | 15705.05 | 1448.0 |
| 2022-05-05 01:00:00 | NQ | Futures | 15704.47 | 15714.33 | 15687.07 | 15707.08 | 3065.0 |
| 2022-05-05 02:00:00 | NQ | Futures | 15707.95 | 15709.69 | 15622.12 | 15625.02 | 7076.0 |
| 2022-05-05 03:00:00 | NQ | Futures | 15625.89 | 15636.61 | 15567.6 | 15602.4 | 12893.0 |
| 2022-05-05 04:00:00 | NQ | Futures | 15601.82 | 15607.04 | 15517.14 | 15547.01 | 11692.0 |
| 2022-05-05 05:00:00 | NQ | Futures | 15546.43 | 15590.22 | 15542.37 | 15566.73 | 8705.0 |
| 2022-05-05 06:00:00 | NQ | Futures | 15566.15 | 15600.08 | 15555.42 | 15556.58 | 7272.0 |
| 2022-05-05 07:00:00 | NQ | Futures | 15557.16 | 15603.56 | 15549.04 | 15566.73 | 9831.0 |
| 2022-05-05 08:00:00 | NQ | Futures | 15565.57 | 15604.43 | 15536.57 | 15543.53 | 12532.0 |
| 2022-05-05 09:00:00 | NQ | Futures | 15543.24 | 15545.85 | 15258.2 | 15280.24 | 97446.0 |
| 2022-05-05 10:00:00 | NQ | Futures | 15281.39 | 15283.13 | 14992.87 | 15058.4 | 148593.0 |
| 2022-05-05 11:00:00 | NQ | Futures | 15058.69 | 15065.36 | 14890.8 | 14895.15 | 111272.0 |
| 2022-05-05 12:00:00 | NQ | Futures | 14894.57 | 15006.79 | 14842.66 | 14969.09 | 95983.0 |
| 2022-05-05 13:00:00 | NQ | Futures | 14968.51 | 15039.27 | 14866.15 | 14887.61 | 76486.0 |
| 2022-05-05 14:00:00 | NQ | Futures | 14886.74 | 14958.94 | 14825.55 | 14869.34 | 72971.0 |
| 2022-05-05 15:00:00 | NQ | Futures | 14868.76 | 14938.06 | 14736.82 | 14914.87 | 135868.0 |
| 2022-05-05 16:00:00 | NQ | Futures | 14914.58 | 14988.52 | 14905.88 | 14959.23 | 33031.0 |
| 2022-05-05 18:00:00 | NQ | Futures | 14943.28 | 14948.79 | 14901.24 | 14924.15 | 4591.0 |
| 2022-05-05 19:00:00 | NQ | Futures | 14924.15 | 14950.53 | 14911.39 | 14944.73 | 3081.0 |
| 2022-05-05 20:00:00 | NQ | Futures | 14945.02 | 14950.53 | 14869.92 | 14874.56 | 6773.0 |
| 2022-05-05 21:00:00 | NQ | Futures | 14873.69 | 14887.32 | 14825.55 | 14854.26 | 7272.0 |
| 2022-05-05 22:00:00 | NQ | Futures | 14855.13 | 14888.48 | 14842.08 | 14878.04 | 3752.0 |
| 2022-05-05 23:00:00 | NQ | Futures | 14879.2 | 14937.19 | 14865.57 | 14929.66 | 3901.0 |
| 2022-05-05 00:00:00 | YM | Futures | 38275.1 | 38318.0 | 38271.8 | 38316.8 | 535.0 |
| 2022-05-05 01:00:00 | YM | Futures | 38319.1 | 38351.8 | 38292.0 | 38334.9 | 1253.0 |
| 2022-05-05 02:00:00 | YM | Futures | 38334.9 | 38341.6 | 38223.3 | 38227.8 | 2422.0 |
| 2022-05-05 03:00:00 | YM | Futures | 38230.0 | 38253.7 | 38120.7 | 38187.2 | 5054.0 |
> showing 50 of 2,110 rows — these rows as CSV