PREVIEW / futures_1hour / 2022-06-28
file: by_date/futures_1hour/2022/2022-06-28.parquet size: 68 KB rows: 2,030
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-06-28 00:00:00 | ES | Futures | 4418.75 | 4423.57 | 4414.22 | 4418.75 | 5927.0 |
| 2022-06-28 01:00:00 | ES | Futures | 4418.47 | 4428.38 | 4418.19 | 4425.83 | 8131.0 |
| 2022-06-28 02:00:00 | ES | Futures | 4426.4 | 4449.63 | 4425.83 | 4442.26 | 16483.0 |
| 2022-06-28 03:00:00 | ES | Futures | 4442.26 | 4461.81 | 4428.1 | 4438.3 | 25056.0 |
| 2022-06-28 04:00:00 | ES | Futures | 4438.3 | 4450.48 | 4437.16 | 4449.63 | 12644.0 |
| 2022-06-28 05:00:00 | ES | Futures | 4449.35 | 4454.44 | 4441.7 | 4443.11 | 11416.0 |
| 2022-06-28 06:00:00 | ES | Futures | 4442.83 | 4450.48 | 4440.85 | 4449.35 | 11372.0 |
| 2022-06-28 07:00:00 | ES | Futures | 4449.06 | 4452.74 | 4445.38 | 4449.35 | 11330.0 |
| 2022-06-28 08:00:00 | ES | Futures | 4449.35 | 4450.76 | 4430.65 | 4441.41 | 37469.0 |
| 2022-06-28 09:00:00 | ES | Futures | 4441.13 | 4475.69 | 4440.56 | 4461.53 | 183760.0 |
| 2022-06-28 10:00:00 | ES | Futures | 4461.53 | 4466.06 | 4413.37 | 4425.83 | 246949.0 |
| 2022-06-28 11:00:00 | ES | Futures | 4425.55 | 4428.38 | 4369.75 | 4372.3 | 226037.0 |
| 2022-06-28 12:00:00 | ES | Futures | 4372.3 | 4386.74 | 4363.8 | 4377.39 | 174539.0 |
| 2022-06-28 13:00:00 | ES | Futures | 4377.11 | 4377.68 | 4354.45 | 4360.68 | 166422.0 |
| 2022-06-28 14:00:00 | ES | Futures | 4360.96 | 4368.9 | 4334.05 | 4342.55 | 169664.0 |
| 2022-06-28 15:00:00 | ES | Futures | 4342.55 | 4347.37 | 4331.79 | 4334.34 | 308932.0 |
| 2022-06-28 16:00:00 | ES | Futures | 4334.34 | 4338.87 | 4330.37 | 4337.45 | 61220.0 |
| 2022-06-28 18:00:00 | ES | Futures | 4337.74 | 4341.7 | 4335.75 | 4341.7 | 4176.0 |
| 2022-06-28 19:00:00 | ES | Futures | 4341.42 | 4341.99 | 4334.62 | 4339.15 | 6873.0 |
| 2022-06-28 20:00:00 | ES | Futures | 4338.87 | 4344.53 | 4330.09 | 4331.5 | 15976.0 |
| 2022-06-28 21:00:00 | ES | Futures | 4331.79 | 4343.4 | 4330.65 | 4337.74 | 10639.0 |
| 2022-06-28 22:00:00 | ES | Futures | 4337.74 | 4344.82 | 4334.05 | 4342.27 | 11289.0 |
| 2022-06-28 23:00:00 | ES | Futures | 4342.27 | 4343.4 | 4337.45 | 4340.85 | 8563.0 |
| 2022-06-28 00:00:00 | NQ | Futures | 13910.08 | 13927.15 | 13893.02 | 13911.53 | 3027.0 |
| 2022-06-28 01:00:00 | NQ | Futures | 13910.66 | 13950.58 | 13908.06 | 13943.06 | 5371.0 |
| 2022-06-28 02:00:00 | NQ | Futures | 13945.37 | 14028.96 | 13942.19 | 13998.88 | 10016.0 |
| 2022-06-28 03:00:00 | NQ | Futures | 13999.75 | 14072.93 | 13938.14 | 13972.27 | 13437.0 |
| 2022-06-28 04:00:00 | NQ | Futures | 13970.82 | 14017.68 | 13968.8 | 14010.74 | 7170.0 |
| 2022-06-28 05:00:00 | NQ | Futures | 14010.16 | 14029.54 | 13978.34 | 13982.97 | 6826.0 |
| 2022-06-28 06:00:00 | NQ | Futures | 13984.71 | 14009.29 | 13971.4 | 14003.8 | 5256.0 |
| 2022-06-28 07:00:00 | NQ | Futures | 14003.51 | 14024.33 | 13986.44 | 13999.17 | 7663.0 |
| 2022-06-28 08:00:00 | NQ | Futures | 13998.88 | 14008.43 | 13932.93 | 13965.04 | 14203.0 |
| 2022-06-28 09:00:00 | NQ | Futures | 13965.04 | 14085.07 | 13938.14 | 14003.51 | 78419.0 |
| 2022-06-28 10:00:00 | NQ | Futures | 14002.35 | 14027.52 | 13807.69 | 13848.19 | 97335.0 |
| 2022-06-28 11:00:00 | NQ | Futures | 13847.32 | 13862.65 | 13632.7 | 13641.67 | 92808.0 |
| 2022-06-28 12:00:00 | NQ | Futures | 13642.25 | 13695.76 | 13601.76 | 13672.33 | 64675.0 |
| 2022-06-28 13:00:00 | NQ | Futures | 13672.62 | 13672.91 | 13580.93 | 13602.33 | 48812.0 |
| 2022-06-28 14:00:00 | NQ | Futures | 13602.33 | 13635.02 | 13523.66 | 13555.48 | 53925.0 |
| 2022-06-28 15:00:00 | NQ | Futures | 13555.48 | 13572.54 | 13498.79 | 13506.31 | 76294.0 |
| 2022-06-28 16:00:00 | NQ | Futures | 13505.73 | 13518.17 | 13491.84 | 13513.83 | 14225.0 |
| 2022-06-28 18:00:00 | NQ | Futures | 13513.83 | 13534.07 | 13507.75 | 13533.5 | 2922.0 |
| 2022-06-28 19:00:00 | NQ | Futures | 13533.21 | 13533.78 | 13506.02 | 13523.08 | 3558.0 |
| 2022-06-28 20:00:00 | NQ | Futures | 13520.19 | 13543.62 | 13487.51 | 13496.18 | 6653.0 |
| 2022-06-28 21:00:00 | NQ | Futures | 13497.05 | 13539.86 | 13491.56 | 13516.14 | 5121.0 |
| 2022-06-28 22:00:00 | NQ | Futures | 13517.01 | 13547.38 | 13502.84 | 13536.1 | 4829.0 |
| 2022-06-28 23:00:00 | NQ | Futures | 13534.94 | 13539.57 | 13513.83 | 13528.29 | 3412.0 |
| 2022-06-28 00:00:00 | YM | Futures | 35436.8 | 35474.0 | 35411.9 | 35436.8 | 737.0 |
| 2022-06-28 01:00:00 | YM | Futures | 35436.8 | 35499.9 | 35436.8 | 35479.6 | 1057.0 |
| 2022-06-28 02:00:00 | YM | Futures | 35481.9 | 35644.4 | 35479.6 | 35597.0 | 2712.0 |
| 2022-06-28 03:00:00 | YM | Futures | 35598.1 | 35743.7 | 35505.6 | 35586.8 | 5850.0 |
> showing 50 of 2,030 rows — these rows as CSV