PREVIEW / futures_1hour / 2021-07-28
file: by_date/futures_1hour/2021/2021-07-28.parquet size: 64 KB rows: 1,990
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-07-28 00:00:00 | ES | Futures | 4943.74 | 4944.3 | 4939.23 | 4939.8 | 4606.0 |
| 2021-07-28 01:00:00 | ES | Futures | 4939.8 | 4950.22 | 4935.29 | 4949.93 | 12283.0 |
| 2021-07-28 02:00:00 | ES | Futures | 4949.65 | 4950.78 | 4941.77 | 4945.15 | 12666.0 |
| 2021-07-28 03:00:00 | ES | Futures | 4945.15 | 4949.65 | 4939.8 | 4949.37 | 19643.0 |
| 2021-07-28 04:00:00 | ES | Futures | 4949.37 | 4960.92 | 4946.84 | 4960.35 | 18145.0 |
| 2021-07-28 05:00:00 | ES | Futures | 4960.35 | 4960.63 | 4956.41 | 4958.66 | 11876.0 |
| 2021-07-28 06:00:00 | ES | Futures | 4958.66 | 4959.79 | 4947.68 | 4951.9 | 17870.0 |
| 2021-07-28 07:00:00 | ES | Futures | 4951.9 | 4956.41 | 4948.53 | 4951.34 | 21528.0 |
| 2021-07-28 08:00:00 | ES | Futures | 4951.06 | 4956.69 | 4949.09 | 4954.16 | 21396.0 |
| 2021-07-28 09:00:00 | ES | Futures | 4954.16 | 4959.23 | 4939.52 | 4945.43 | 153689.0 |
| 2021-07-28 10:00:00 | ES | Futures | 4945.43 | 4956.41 | 4940.08 | 4953.59 | 177191.0 |
| 2021-07-28 11:00:00 | ES | Futures | 4953.31 | 4955.57 | 4948.53 | 4952.75 | 97206.0 |
| 2021-07-28 12:00:00 | ES | Futures | 4953.03 | 4953.88 | 4943.18 | 4945.71 | 66591.0 |
| 2021-07-28 13:00:00 | ES | Futures | 4945.43 | 4946.84 | 4937.54 | 4940.92 | 82208.0 |
| 2021-07-28 14:00:00 | ES | Futures | 4940.92 | 4964.58 | 4930.5 | 4957.82 | 199165.0 |
| 2021-07-28 15:00:00 | ES | Futures | 4957.82 | 4960.92 | 4946.84 | 4947.68 | 166174.0 |
| 2021-07-28 16:00:00 | ES | Futures | 4947.4 | 4949.09 | 4944.3 | 4946.84 | 50373.0 |
| 2021-07-28 18:00:00 | ES | Futures | 4948.81 | 4949.93 | 4946.27 | 4948.81 | 5509.0 |
| 2021-07-28 19:00:00 | ES | Futures | 4948.81 | 4949.65 | 4945.15 | 4949.65 | 5312.0 |
| 2021-07-28 20:00:00 | ES | Futures | 4949.65 | 4949.65 | 4941.77 | 4945.71 | 8811.0 |
| 2021-07-28 21:00:00 | ES | Futures | 4945.71 | 4945.71 | 4933.88 | 4935.01 | 13923.0 |
| 2021-07-28 22:00:00 | ES | Futures | 4935.29 | 4941.77 | 4933.88 | 4941.2 | 8047.0 |
| 2021-07-28 23:00:00 | ES | Futures | 4941.2 | 4944.02 | 4940.36 | 4940.92 | 4310.0 |
| 2021-07-28 00:00:00 | NQ | Futures | 17291.94 | 17293.97 | 17269.06 | 17271.09 | 2984.0 |
| 2021-07-28 01:00:00 | NQ | Futures | 17270.8 | 17314.25 | 17257.18 | 17313.38 | 6564.0 |
| 2021-07-28 02:00:00 | NQ | Futures | 17313.09 | 17315.99 | 17289.92 | 17295.42 | 5980.0 |
| 2021-07-28 03:00:00 | NQ | Futures | 17293.97 | 17313.09 | 17290.49 | 17304.69 | 6097.0 |
| 2021-07-28 04:00:00 | NQ | Futures | 17304.4 | 17379.14 | 17302.08 | 17376.53 | 9298.0 |
| 2021-07-28 05:00:00 | NQ | Futures | 17376.53 | 17379.14 | 17358.28 | 17364.94 | 5521.0 |
| 2021-07-28 06:00:00 | NQ | Futures | 17364.36 | 17368.13 | 17327.28 | 17349.01 | 7411.0 |
| 2021-07-28 07:00:00 | NQ | Futures | 17348.14 | 17380.01 | 17339.45 | 17366.39 | 8634.0 |
| 2021-07-28 08:00:00 | NQ | Futures | 17365.52 | 17403.18 | 17363.49 | 17384.93 | 11816.0 |
| 2021-07-28 09:00:00 | NQ | Futures | 17384.35 | 17406.66 | 17266.74 | 17356.25 | 89297.0 |
| 2021-07-28 10:00:00 | NQ | Futures | 17355.96 | 17467.2 | 17350.46 | 17425.49 | 105489.0 |
| 2021-07-28 11:00:00 | NQ | Futures | 17425.78 | 17451.56 | 17364.07 | 17392.75 | 59883.0 |
| 2021-07-28 12:00:00 | NQ | Futures | 17392.75 | 17415.35 | 17367.55 | 17378.27 | 36026.0 |
| 2021-07-28 13:00:00 | NQ | Futures | 17378.27 | 17389.28 | 17321.49 | 17348.43 | 39721.0 |
| 2021-07-28 14:00:00 | NQ | Futures | 17350.17 | 17428.38 | 17290.21 | 17391.01 | 71128.0 |
| 2021-07-28 15:00:00 | NQ | Futures | 17391.01 | 17426.36 | 17376.82 | 17387.83 | 57751.0 |
| 2021-07-28 16:00:00 | NQ | Futures | 17387.54 | 17397.1 | 17348.43 | 17363.2 | 16195.0 |
| 2021-07-28 18:00:00 | NQ | Futures | 17363.2 | 17369.0 | 17355.96 | 17366.1 | 2446.0 |
| 2021-07-28 19:00:00 | NQ | Futures | 17365.52 | 17368.42 | 17353.07 | 17368.13 | 2217.0 |
| 2021-07-28 20:00:00 | NQ | Futures | 17367.84 | 17372.47 | 17351.04 | 17372.19 | 3778.0 |
| 2021-07-28 21:00:00 | NQ | Futures | 17371.9 | 17372.76 | 17316.57 | 17322.94 | 6520.0 |
| 2021-07-28 22:00:00 | NQ | Futures | 17323.52 | 17345.53 | 17318.01 | 17336.84 | 4112.0 |
| 2021-07-28 23:00:00 | NQ | Futures | 17336.84 | 17348.43 | 17336.84 | 17340.03 | 2376.0 |
| 2021-07-28 00:00:00 | YM | Futures | 38968.6 | 38974.2 | 38945.2 | 38954.1 | 1323.0 |
| 2021-07-28 01:00:00 | YM | Futures | 38953.0 | 39024.5 | 38908.3 | 39021.1 | 3264.0 |
| 2021-07-28 02:00:00 | YM | Futures | 39018.9 | 39029.0 | 38942.9 | 38975.3 | 3877.0 |
| 2021-07-28 03:00:00 | YM | Futures | 38976.5 | 39020.0 | 38912.8 | 39018.9 | 5673.0 |
> showing 50 of 1,990 rows — these rows as CSV