PREVIEW / futures_1hour / 2022-01-20
file: by_date/futures_1hour/2022/2022-01-20.parquet size: 69 KB rows: 2,066
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-01-20 00:00:00 | ES | Futures | 5139.36 | 5143.6 | 5133.42 | 5136.25 | 8318.0 |
| 2022-01-20 01:00:00 | ES | Futures | 5136.53 | 5149.26 | 5135.4 | 5147.56 | 8552.0 |
| 2022-01-20 02:00:00 | ES | Futures | 5147.28 | 5150.96 | 5138.8 | 5139.08 | 11355.0 |
| 2022-01-20 03:00:00 | ES | Futures | 5139.65 | 5144.17 | 5123.81 | 5134.27 | 25626.0 |
| 2022-01-20 04:00:00 | ES | Futures | 5134.27 | 5139.65 | 5122.96 | 5136.82 | 22255.0 |
| 2022-01-20 05:00:00 | ES | Futures | 5136.82 | 5142.19 | 5134.27 | 5140.78 | 12573.0 |
| 2022-01-20 06:00:00 | ES | Futures | 5140.78 | 5149.26 | 5139.65 | 5144.74 | 21435.0 |
| 2022-01-20 07:00:00 | ES | Futures | 5144.74 | 5146.43 | 5132.01 | 5137.67 | 27591.0 |
| 2022-01-20 08:00:00 | ES | Futures | 5137.67 | 5148.41 | 5133.42 | 5142.76 | 44824.0 |
| 2022-01-20 09:00:00 | ES | Futures | 5142.76 | 5177.26 | 5137.38 | 5173.86 | 235074.0 |
| 2022-01-20 10:00:00 | ES | Futures | 5173.86 | 5192.81 | 5160.57 | 5189.42 | 238932.0 |
| 2022-01-20 11:00:00 | ES | Futures | 5189.42 | 5197.05 | 5176.69 | 5182.91 | 151600.0 |
| 2022-01-20 12:00:00 | ES | Futures | 5182.91 | 5187.16 | 5171.88 | 5174.15 | 95809.0 |
| 2022-01-20 13:00:00 | ES | Futures | 5174.43 | 5174.43 | 5156.61 | 5158.03 | 163315.0 |
| 2022-01-20 14:00:00 | ES | Futures | 5158.03 | 5172.45 | 5132.01 | 5135.12 | 227592.0 |
| 2022-01-20 15:00:00 | ES | Futures | 5134.84 | 5141.91 | 5055.37 | 5061.31 | 467758.0 |
| 2022-01-20 16:00:00 | ES | Futures | 5061.31 | 5064.99 | 5020.02 | 5040.95 | 137904.0 |
| 2022-01-20 18:00:00 | ES | Futures | 5038.68 | 5050.85 | 5031.61 | 5048.02 | 31346.0 |
| 2022-01-20 19:00:00 | ES | Futures | 5047.73 | 5050.85 | 5035.57 | 5035.86 | 20360.0 |
| 2022-01-20 20:00:00 | ES | Futures | 5035.86 | 5044.34 | 5020.59 | 5037.27 | 30327.0 |
| 2022-01-20 21:00:00 | ES | Futures | 5037.27 | 5044.62 | 5010.69 | 5021.43 | 30459.0 |
| 2022-01-20 22:00:00 | ES | Futures | 5021.15 | 5022.57 | 5011.25 | 5020.3 | 17236.0 |
| 2022-01-20 23:00:00 | ES | Futures | 5020.3 | 5034.16 | 5019.74 | 5025.39 | 16232.0 |
| 2022-01-20 00:00:00 | NQ | Futures | 17521.19 | 17538.29 | 17494.52 | 17510.46 | 4857.0 |
| 2022-01-20 01:00:00 | NQ | Futures | 17511.04 | 17572.19 | 17505.54 | 17567.56 | 5615.0 |
| 2022-01-20 02:00:00 | NQ | Futures | 17567.85 | 17578.57 | 17529.88 | 17535.1 | 6448.0 |
| 2022-01-20 03:00:00 | NQ | Futures | 17537.13 | 17566.4 | 17441.49 | 17514.52 | 17532.0 |
| 2022-01-20 04:00:00 | NQ | Futures | 17514.52 | 17555.67 | 17471.05 | 17540.89 | 11900.0 |
| 2022-01-20 05:00:00 | NQ | Futures | 17540.6 | 17561.47 | 17519.45 | 17550.75 | 6471.0 |
| 2022-01-20 06:00:00 | NQ | Futures | 17550.17 | 17599.15 | 17550.17 | 17581.47 | 9624.0 |
| 2022-01-20 07:00:00 | NQ | Futures | 17580.31 | 17591.61 | 17524.08 | 17557.41 | 12074.0 |
| 2022-01-20 08:00:00 | NQ | Futures | 17558.28 | 17628.13 | 17542.92 | 17607.84 | 21277.0 |
| 2022-01-20 09:00:00 | NQ | Futures | 17606.68 | 17720.29 | 17574.8 | 17710.15 | 84385.0 |
| 2022-01-20 10:00:00 | NQ | Futures | 17710.44 | 17770.14 | 17641.46 | 17749.56 | 90789.0 |
| 2022-01-20 11:00:00 | NQ | Futures | 17748.69 | 17783.47 | 17667.83 | 17717.68 | 64105.0 |
| 2022-01-20 12:00:00 | NQ | Futures | 17717.39 | 17737.68 | 17659.72 | 17673.63 | 42340.0 |
| 2022-01-20 13:00:00 | NQ | Futures | 17673.34 | 17673.63 | 17589.0 | 17597.7 | 63182.0 |
| 2022-01-20 14:00:00 | NQ | Futures | 17596.54 | 17659.72 | 17476.26 | 17486.12 | 76554.0 |
| 2022-01-20 15:00:00 | NQ | Futures | 17485.83 | 17520.32 | 17176.3 | 17199.49 | 147877.0 |
| 2022-01-20 16:00:00 | NQ | Futures | 17198.91 | 17222.09 | 16979.52 | 17071.1 | 47837.0 |
| 2022-01-20 18:00:00 | NQ | Futures | 17066.75 | 17104.14 | 17022.7 | 17092.55 | 16252.0 |
| 2022-01-20 19:00:00 | NQ | Futures | 17091.97 | 17110.23 | 17037.48 | 17037.48 | 12103.0 |
| 2022-01-20 20:00:00 | NQ | Futures | 17037.19 | 17080.37 | 16967.06 | 17066.75 | 19500.0 |
| 2022-01-20 21:00:00 | NQ | Futures | 17065.59 | 17091.68 | 16940.39 | 16982.13 | 16762.0 |
| 2022-01-20 22:00:00 | NQ | Futures | 16982.42 | 16990.82 | 16927.93 | 16945.9 | 12933.0 |
| 2022-01-20 23:00:00 | NQ | Futures | 16945.61 | 17013.43 | 16945.03 | 16976.33 | 10810.0 |
| 2022-01-20 00:00:00 | YM | Futures | 39388.1 | 39422.9 | 39354.4 | 39374.6 | 1822.0 |
| 2022-01-20 01:00:00 | YM | Futures | 39376.8 | 39452.1 | 39365.6 | 39439.8 | 1579.0 |
| 2022-01-20 02:00:00 | YM | Futures | 39439.8 | 39474.6 | 39379.1 | 39384.7 | 3003.0 |
| 2022-01-20 03:00:00 | YM | Futures | 39384.7 | 39404.9 | 39291.4 | 39348.7 | 6734.0 |
> showing 50 of 2,066 rows — these rows as CSV