PREVIEW / futures_1hour / 2021-02-22
file: by_date/futures_1hour/2021/2021-02-22.parquet size: 64 KB rows: 1,937
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-22 00:00:00 | ES | Futures | 4373.9 | 4376.71 | 4368.85 | 4368.85 | 10149.0 |
| 2021-02-22 01:00:00 | ES | Futures | 4369.13 | 4373.9 | 4366.89 | 4372.22 | 7888.0 |
| 2021-02-22 02:00:00 | ES | Futures | 4371.94 | 4373.06 | 4347.24 | 4352.57 | 39408.0 |
| 2021-02-22 03:00:00 | ES | Futures | 4352.29 | 4354.26 | 4334.89 | 4340.22 | 59269.0 |
| 2021-02-22 04:00:00 | ES | Futures | 4340.22 | 4350.61 | 4338.82 | 4349.49 | 33415.0 |
| 2021-02-22 05:00:00 | ES | Futures | 4349.21 | 4354.82 | 4348.64 | 4349.21 | 19584.0 |
| 2021-02-22 06:00:00 | ES | Futures | 4349.21 | 4352.85 | 4344.15 | 4348.64 | 25740.0 |
| 2021-02-22 07:00:00 | ES | Futures | 4348.64 | 4352.57 | 4340.51 | 4346.4 | 27402.0 |
| 2021-02-22 08:00:00 | ES | Futures | 4346.4 | 4355.94 | 4341.63 | 4352.29 | 34952.0 |
| 2021-02-22 09:00:00 | ES | Futures | 4352.57 | 4362.4 | 4342.19 | 4359.31 | 201972.0 |
| 2021-02-22 10:00:00 | ES | Futures | 4359.59 | 4365.77 | 4347.52 | 4350.89 | 215238.0 |
| 2021-02-22 11:00:00 | ES | Futures | 4350.89 | 4362.4 | 4346.96 | 4359.87 | 127120.0 |
| 2021-02-22 12:00:00 | ES | Futures | 4360.15 | 4369.13 | 4354.26 | 4368.01 | 94802.0 |
| 2021-02-22 13:00:00 | ES | Futures | 4368.01 | 4377.55 | 4365.2 | 4375.03 | 73540.0 |
| 2021-02-22 14:00:00 | ES | Futures | 4375.03 | 4376.15 | 4367.73 | 4369.69 | 81764.0 |
| 2021-02-22 15:00:00 | ES | Futures | 4369.69 | 4369.98 | 4346.96 | 4349.77 | 270139.0 |
| 2021-02-22 16:00:00 | ES | Futures | 4350.05 | 4354.54 | 4348.36 | 4353.14 | 52400.0 |
| 2021-02-22 18:00:00 | ES | Futures | 4353.7 | 4359.87 | 4352.85 | 4354.26 | 9997.0 |
| 2021-02-22 19:00:00 | ES | Futures | 4353.98 | 4355.38 | 4342.75 | 4345.84 | 18220.0 |
| 2021-02-22 20:00:00 | ES | Futures | 4345.84 | 4359.87 | 4345.0 | 4358.19 | 18304.0 |
| 2021-02-22 21:00:00 | ES | Futures | 4358.19 | 4365.2 | 4356.22 | 4363.8 | 10431.0 |
| 2021-02-22 22:00:00 | ES | Futures | 4363.52 | 4364.08 | 4354.54 | 4363.52 | 9898.0 |
| 2021-02-22 23:00:00 | ES | Futures | 4363.52 | 4372.22 | 4362.12 | 4371.94 | 7750.0 |
| 2021-02-22 00:00:00 | NQ | Futures | 15676.89 | 15683.55 | 15654.31 | 15656.63 | 5780.0 |
| 2021-02-22 01:00:00 | NQ | Futures | 15656.92 | 15672.84 | 15635.79 | 15664.44 | 5388.0 |
| 2021-02-22 02:00:00 | NQ | Futures | 15664.44 | 15669.94 | 15525.52 | 15552.43 | 20299.0 |
| 2021-02-22 03:00:00 | NQ | Futures | 15552.72 | 15557.35 | 15472.55 | 15492.52 | 19179.0 |
| 2021-02-22 04:00:00 | NQ | Futures | 15492.23 | 15539.41 | 15473.42 | 15533.33 | 15004.0 |
| 2021-02-22 05:00:00 | NQ | Futures | 15532.75 | 15553.3 | 15521.75 | 15523.78 | 6397.0 |
| 2021-02-22 06:00:00 | NQ | Futures | 15524.07 | 15535.65 | 15477.47 | 15509.6 | 12062.0 |
| 2021-02-22 07:00:00 | NQ | Futures | 15510.18 | 15528.7 | 15473.13 | 15504.39 | 12152.0 |
| 2021-02-22 08:00:00 | NQ | Futures | 15504.39 | 15544.62 | 15479.5 | 15529.86 | 15304.0 |
| 2021-02-22 09:00:00 | NQ | Futures | 15529.86 | 15558.8 | 15465.6 | 15546.06 | 75138.0 |
| 2021-02-22 10:00:00 | NQ | Futures | 15545.78 | 15566.9 | 15385.14 | 15398.16 | 106502.0 |
| 2021-02-22 11:00:00 | NQ | Futures | 15398.16 | 15460.1 | 15376.75 | 15423.63 | 70044.0 |
| 2021-02-22 12:00:00 | NQ | Futures | 15424.21 | 15445.92 | 15375.59 | 15441.0 | 48996.0 |
| 2021-02-22 13:00:00 | NQ | Futures | 15441.29 | 15497.15 | 15421.61 | 15476.31 | 34615.0 |
| 2021-02-22 14:00:00 | NQ | Futures | 15476.89 | 15483.26 | 15423.34 | 15433.76 | 32649.0 |
| 2021-02-22 15:00:00 | NQ | Futures | 15433.48 | 15435.5 | 15303.52 | 15313.36 | 93251.0 |
| 2021-02-22 16:00:00 | NQ | Futures | 15313.36 | 15332.46 | 15299.47 | 15306.41 | 15475.0 |
| 2021-02-22 18:00:00 | NQ | Futures | 15313.36 | 15346.93 | 15307.28 | 15315.1 | 6245.0 |
| 2021-02-22 19:00:00 | NQ | Futures | 15314.81 | 15320.31 | 15275.73 | 15291.65 | 8683.0 |
| 2021-02-22 20:00:00 | NQ | Futures | 15290.78 | 15380.8 | 15288.47 | 15374.72 | 15512.0 |
| 2021-02-22 21:00:00 | NQ | Futures | 15374.72 | 15405.98 | 15361.7 | 15399.32 | 6779.0 |
| 2021-02-22 22:00:00 | NQ | Futures | 15399.61 | 15403.66 | 15364.59 | 15395.27 | 5550.0 |
| 2021-02-22 23:00:00 | NQ | Futures | 15395.27 | 15431.45 | 15389.48 | 15430.0 | 4181.0 |
| 2021-02-22 00:00:00 | YM | Futures | 34835.4 | 34857.6 | 34805.4 | 34808.8 | 2185.0 |
| 2021-02-22 01:00:00 | YM | Futures | 34811.0 | 34842.0 | 34794.3 | 34823.2 | 1775.0 |
| 2021-02-22 02:00:00 | YM | Futures | 34824.3 | 34832.1 | 34681.2 | 34716.7 | 8081.0 |
| 2021-02-22 03:00:00 | YM | Futures | 34715.6 | 34728.9 | 34595.8 | 34634.6 | 12387.0 |
> showing 50 of 1,937 rows — these rows as CSV