PREVIEW / futures_1hour / 2022-04-28
file: by_date/futures_1hour/2022/2022-04-28.parquet size: 70 KB rows: 2,084
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-04-28 00:00:00 | ES | Futures | 4772.57 | 4778.24 | 4770.58 | 4777.95 | 3593.0 |
| 2022-04-28 01:00:00 | ES | Futures | 4777.67 | 4784.47 | 4773.13 | 4780.5 | 8112.0 |
| 2022-04-28 02:00:00 | ES | Futures | 4780.5 | 4794.96 | 4778.52 | 4793.54 | 11622.0 |
| 2022-04-28 03:00:00 | ES | Futures | 4793.54 | 4815.93 | 4789.29 | 4805.16 | 33550.0 |
| 2022-04-28 04:00:00 | ES | Futures | 4805.16 | 4826.42 | 4805.16 | 4825.85 | 27893.0 |
| 2022-04-28 05:00:00 | ES | Futures | 4825.57 | 4828.4 | 4810.55 | 4813.67 | 20537.0 |
| 2022-04-28 06:00:00 | ES | Futures | 4813.67 | 4815.37 | 4800.63 | 4805.45 | 16492.0 |
| 2022-04-28 07:00:00 | ES | Futures | 4805.73 | 4817.63 | 4802.33 | 4805.16 | 18690.0 |
| 2022-04-28 08:00:00 | ES | Futures | 4805.16 | 4808.0 | 4785.32 | 4790.99 | 55215.0 |
| 2022-04-28 09:00:00 | ES | Futures | 4790.71 | 4804.88 | 4764.35 | 4774.55 | 205013.0 |
| 2022-04-28 10:00:00 | ES | Futures | 4774.27 | 4777.1 | 4741.95 | 4761.23 | 240242.0 |
| 2022-04-28 11:00:00 | ES | Futures | 4761.51 | 4784.47 | 4758.68 | 4775.4 | 170363.0 |
| 2022-04-28 12:00:00 | ES | Futures | 4775.4 | 4835.49 | 4769.45 | 4833.22 | 176549.0 |
| 2022-04-28 13:00:00 | ES | Futures | 4833.22 | 4856.46 | 4828.97 | 4851.08 | 181966.0 |
| 2022-04-28 14:00:00 | ES | Futures | 4851.08 | 4874.32 | 4845.98 | 4867.8 | 133789.0 |
| 2022-04-28 15:00:00 | ES | Futures | 4867.8 | 4879.14 | 4842.01 | 4858.45 | 280825.0 |
| 2022-04-28 16:00:00 | ES | Futures | 4858.17 | 4862.42 | 4822.74 | 4830.1 | 122842.0 |
| 2022-04-28 18:00:00 | ES | Futures | 4811.68 | 4823.3 | 4802.04 | 4813.67 | 17183.0 |
| 2022-04-28 19:00:00 | ES | Futures | 4813.95 | 4818.48 | 4810.55 | 4813.38 | 5313.0 |
| 2022-04-28 20:00:00 | ES | Futures | 4813.67 | 4829.25 | 4813.38 | 4826.7 | 8112.0 |
| 2022-04-28 21:00:00 | ES | Futures | 4826.99 | 4844.56 | 4825.29 | 4839.17 | 12639.0 |
| 2022-04-28 22:00:00 | ES | Futures | 4839.46 | 4842.29 | 4830.39 | 4835.49 | 7602.0 |
| 2022-04-28 23:00:00 | ES | Futures | 4835.21 | 4839.46 | 4831.24 | 4836.91 | 7466.0 |
| 2022-04-28 00:00:00 | NQ | Futures | 15286.61 | 15308.65 | 15275.31 | 15306.91 | 2653.0 |
| 2022-04-28 01:00:00 | NQ | Futures | 15306.62 | 15319.96 | 15271.54 | 15297.92 | 5285.0 |
| 2022-04-28 02:00:00 | NQ | Futures | 15297.92 | 15362.59 | 15288.93 | 15354.18 | 7879.0 |
| 2022-04-28 03:00:00 | NQ | Futures | 15354.18 | 15465.53 | 15334.75 | 15413.62 | 17456.0 |
| 2022-04-28 04:00:00 | NQ | Futures | 15413.91 | 15473.07 | 15398.83 | 15471.33 | 13143.0 |
| 2022-04-28 05:00:00 | NQ | Futures | 15471.04 | 15481.48 | 15396.23 | 15410.43 | 9535.0 |
| 2022-04-28 06:00:00 | NQ | Futures | 15409.85 | 15418.84 | 15367.81 | 15391.01 | 7923.0 |
| 2022-04-28 07:00:00 | NQ | Futures | 15391.88 | 15444.94 | 15375.06 | 15385.79 | 10734.0 |
| 2022-04-28 08:00:00 | NQ | Futures | 15386.37 | 15388.11 | 15273.57 | 15305.17 | 28824.0 |
| 2022-04-28 09:00:00 | NQ | Futures | 15305.17 | 15404.34 | 15189.76 | 15235.87 | 103041.0 |
| 2022-04-28 10:00:00 | NQ | Futures | 15235.58 | 15294.73 | 15116.98 | 15200.78 | 106604.0 |
| 2022-04-28 11:00:00 | NQ | Futures | 15201.07 | 15325.18 | 15183.67 | 15237.32 | 73119.0 |
| 2022-04-28 12:00:00 | NQ | Futures | 15238.19 | 15510.19 | 15211.8 | 15492.5 | 70701.0 |
| 2022-04-28 13:00:00 | NQ | Futures | 15492.79 | 15602.98 | 15475.68 | 15597.18 | 68592.0 |
| 2022-04-28 14:00:00 | NQ | Futures | 15597.47 | 15688.23 | 15569.34 | 15652.85 | 59512.0 |
| 2022-04-28 15:00:00 | NQ | Futures | 15653.14 | 15707.37 | 15555.71 | 15615.74 | 77133.0 |
| 2022-04-28 16:00:00 | NQ | Futures | 15614.0 | 15626.76 | 15393.04 | 15435.95 | 61058.0 |
| 2022-04-28 18:00:00 | NQ | Futures | 15333.3 | 15409.27 | 15284.87 | 15371.29 | 10689.0 |
| 2022-04-28 19:00:00 | NQ | Futures | 15371.87 | 15397.96 | 15353.02 | 15366.94 | 3690.0 |
| 2022-04-28 20:00:00 | NQ | Futures | 15364.62 | 15414.2 | 15361.72 | 15410.43 | 3916.0 |
| 2022-04-28 21:00:00 | NQ | Futures | 15410.14 | 15481.19 | 15398.25 | 15452.48 | 6358.0 |
| 2022-04-28 22:00:00 | NQ | Futures | 15453.35 | 15466.69 | 15411.01 | 15431.31 | 4672.0 |
| 2022-04-28 23:00:00 | NQ | Futures | 15432.76 | 15467.27 | 15407.53 | 15465.53 | 5624.0 |
| 2022-04-28 00:00:00 | YM | Futures | 37505.2 | 37549.1 | 37496.1 | 37549.1 | 799.0 |
| 2022-04-28 01:00:00 | YM | Futures | 37543.5 | 37604.4 | 37527.7 | 37585.2 | 2077.0 |
| 2022-04-28 02:00:00 | YM | Futures | 37587.5 | 37688.9 | 37571.7 | 37678.8 | 2869.0 |
| 2022-04-28 03:00:00 | YM | Futures | 37679.9 | 37818.6 | 37646.1 | 37754.3 | 7460.0 |
> showing 50 of 2,084 rows — these rows as CSV