PREVIEW / futures_1hour / 2022-08-15
file: by_date/futures_1hour/2022/2022-08-15.parquet size: 67 KB rows: 2,036
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-08-15 00:00:00 | ES | Futures | 4839.69 | 4841.68 | 4839.41 | 4840.26 | 2038.0 |
| 2022-08-15 01:00:00 | ES | Futures | 4840.26 | 4842.53 | 4836.58 | 4840.54 | 4970.0 |
| 2022-08-15 02:00:00 | ES | Futures | 4840.26 | 4842.81 | 4838.56 | 4838.84 | 5073.0 |
| 2022-08-15 03:00:00 | ES | Futures | 4838.84 | 4839.98 | 4825.53 | 4826.38 | 17637.0 |
| 2022-08-15 04:00:00 | ES | Futures | 4826.66 | 4834.03 | 4826.38 | 4828.36 | 10901.0 |
| 2022-08-15 05:00:00 | ES | Futures | 4828.36 | 4830.63 | 4822.13 | 4827.51 | 13340.0 |
| 2022-08-15 06:00:00 | ES | Futures | 4827.51 | 4830.35 | 4822.41 | 4829.21 | 16976.0 |
| 2022-08-15 07:00:00 | ES | Futures | 4829.5 | 4830.91 | 4820.15 | 4824.11 | 17430.0 |
| 2022-08-15 08:00:00 | ES | Futures | 4824.11 | 4828.93 | 4814.48 | 4814.77 | 31708.0 |
| 2022-08-15 09:00:00 | ES | Futures | 4815.05 | 4854.14 | 4814.48 | 4849.61 | 197051.0 |
| 2022-08-15 10:00:00 | ES | Futures | 4849.61 | 4849.89 | 4834.03 | 4836.29 | 199436.0 |
| 2022-08-15 11:00:00 | ES | Futures | 4836.29 | 4864.34 | 4832.33 | 4861.51 | 186340.0 |
| 2022-08-15 12:00:00 | ES | Futures | 4861.79 | 4872.27 | 4858.39 | 4870.85 | 118415.0 |
| 2022-08-15 13:00:00 | ES | Futures | 4871.14 | 4873.97 | 4862.92 | 4868.02 | 88239.0 |
| 2022-08-15 14:00:00 | ES | Futures | 4868.02 | 4873.4 | 4862.64 | 4872.27 | 95312.0 |
| 2022-08-15 15:00:00 | ES | Futures | 4872.55 | 4877.65 | 4868.02 | 4871.14 | 185686.0 |
| 2022-08-15 16:00:00 | ES | Futures | 4870.85 | 4871.99 | 4865.19 | 4866.04 | 45824.0 |
| 2022-08-15 18:00:00 | ES | Futures | 4866.04 | 4866.89 | 4863.49 | 4864.62 | 3618.0 |
| 2022-08-15 19:00:00 | ES | Futures | 4864.34 | 4868.59 | 4863.77 | 4866.32 | 3808.0 |
| 2022-08-15 20:00:00 | ES | Futures | 4866.32 | 4866.32 | 4860.94 | 4862.92 | 7552.0 |
| 2022-08-15 21:00:00 | ES | Futures | 4862.64 | 4864.9 | 4857.54 | 4864.62 | 9390.0 |
| 2022-08-15 22:00:00 | ES | Futures | 4864.34 | 4872.55 | 4863.49 | 4870.0 | 7197.0 |
| 2022-08-15 23:00:00 | ES | Futures | 4870.0 | 4870.29 | 4864.05 | 4864.9 | 4468.0 |
| 2022-08-15 00:00:00 | NQ | Futures | 15671.55 | 15675.6 | 15665.48 | 15673.0 | 1070.0 |
| 2022-08-15 01:00:00 | NQ | Futures | 15672.71 | 15680.81 | 15660.56 | 15670.39 | 1800.0 |
| 2022-08-15 02:00:00 | NQ | Futures | 15671.55 | 15685.72 | 15665.19 | 15669.53 | 2404.0 |
| 2022-08-15 03:00:00 | NQ | Futures | 15668.66 | 15673.29 | 15620.64 | 15629.32 | 8110.0 |
| 2022-08-15 04:00:00 | NQ | Futures | 15629.32 | 15656.22 | 15627.59 | 15638.0 | 4907.0 |
| 2022-08-15 05:00:00 | NQ | Futures | 15637.13 | 15646.39 | 15613.41 | 15644.36 | 5548.0 |
| 2022-08-15 06:00:00 | NQ | Futures | 15643.49 | 15675.31 | 15638.29 | 15674.73 | 7481.0 |
| 2022-08-15 07:00:00 | NQ | Futures | 15675.31 | 15678.49 | 15635.4 | 15648.99 | 6941.0 |
| 2022-08-15 08:00:00 | NQ | Futures | 15648.12 | 15677.05 | 15620.64 | 15625.85 | 12453.0 |
| 2022-08-15 09:00:00 | NQ | Futures | 15626.14 | 15774.52 | 15623.83 | 15754.85 | 73621.0 |
| 2022-08-15 10:00:00 | NQ | Futures | 15755.14 | 15757.74 | 15664.32 | 15685.43 | 75685.0 |
| 2022-08-15 11:00:00 | NQ | Futures | 15686.01 | 15806.62 | 15666.34 | 15798.82 | 67049.0 |
| 2022-08-15 12:00:00 | NQ | Futures | 15798.82 | 15816.17 | 15775.97 | 15810.67 | 41673.0 |
| 2022-08-15 13:00:00 | NQ | Futures | 15810.96 | 15824.56 | 15784.64 | 15805.18 | 30389.0 |
| 2022-08-15 14:00:00 | NQ | Futures | 15805.47 | 15831.21 | 15782.04 | 15826.87 | 31796.0 |
| 2022-08-15 15:00:00 | NQ | Futures | 15826.58 | 15857.24 | 15818.48 | 15833.23 | 56306.0 |
| 2022-08-15 16:00:00 | NQ | Futures | 15832.95 | 15834.1 | 15813.57 | 15825.71 | 12116.0 |
| 2022-08-15 18:00:00 | NQ | Futures | 15821.09 | 15824.56 | 15810.67 | 15817.62 | 1676.0 |
| 2022-08-15 19:00:00 | NQ | Futures | 15817.62 | 15834.1 | 15814.72 | 15828.9 | 1652.0 |
| 2022-08-15 20:00:00 | NQ | Futures | 15828.03 | 15828.32 | 15801.42 | 15805.47 | 2998.0 |
| 2022-08-15 21:00:00 | NQ | Futures | 15804.31 | 15813.28 | 15787.82 | 15805.76 | 3351.0 |
| 2022-08-15 22:00:00 | NQ | Futures | 15805.76 | 15829.19 | 15803.15 | 15821.38 | 2950.0 |
| 2022-08-15 23:00:00 | NQ | Futures | 15822.82 | 15823.11 | 15802.86 | 15808.36 | 1680.0 |
| 2022-08-15 00:00:00 | YM | Futures | 37972.1 | 37977.8 | 37965.4 | 37969.9 | 418.0 |
| 2022-08-15 01:00:00 | YM | Futures | 37968.8 | 37983.4 | 37945.1 | 37966.5 | 860.0 |
| 2022-08-15 02:00:00 | YM | Futures | 37967.6 | 37982.3 | 37958.6 | 37960.9 | 1281.0 |
| 2022-08-15 03:00:00 | YM | Futures | 37960.9 | 37969.9 | 37876.2 | 37878.5 | 4483.0 |
> showing 50 of 2,036 rows — these rows as CSV