PREVIEW / futures_30min / 2022-03-20
file: by_date/futures_30min/2022/2022-03-20.parquet size: 28 KB rows: 759
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-03-20 18:00:00 | ES | Futures | 5056.57 | 5060.26 | 5050.9 | 5054.02 | 7320.0 |
| 2022-03-20 18:30:00 | ES | Futures | 5054.31 | 5057.42 | 5049.77 | 5052.61 | 4593.0 |
| 2022-03-20 19:00:00 | ES | Futures | 5052.89 | 5052.89 | 5049.77 | 5051.47 | 2511.0 |
| 2022-03-20 19:30:00 | ES | Futures | 5051.75 | 5052.61 | 5046.65 | 5047.79 | 3320.0 |
| 2022-03-20 20:00:00 | ES | Futures | 5047.79 | 5048.92 | 5038.43 | 5041.55 | 4914.0 |
| 2022-03-20 20:30:00 | ES | Futures | 5041.55 | 5045.24 | 5040.13 | 5044.39 | 3078.0 |
| 2022-03-20 21:00:00 | ES | Futures | 5044.39 | 5046.65 | 5037.3 | 5039.0 | 3681.0 |
| 2022-03-20 21:30:00 | ES | Futures | 5039.28 | 5039.57 | 5033.9 | 5035.32 | 5427.0 |
| 2022-03-20 22:00:00 | ES | Futures | 5035.6 | 5040.13 | 5033.61 | 5038.15 | 3678.0 |
| 2022-03-20 22:30:00 | ES | Futures | 5037.87 | 5037.87 | 5033.61 | 5035.32 | 2584.0 |
| 2022-03-20 23:00:00 | ES | Futures | 5035.32 | 5037.87 | 5034.46 | 5035.03 | 1408.0 |
| 2022-03-20 23:30:00 | ES | Futures | 5035.03 | 5038.72 | 5034.18 | 5037.58 | 1785.0 |
| 2022-03-20 18:00:00 | NQ | Futures | 16707.2 | 16743.16 | 16705.17 | 16715.61 | 4529.0 |
| 2022-03-20 18:30:00 | NQ | Futures | 16715.9 | 16727.21 | 16708.36 | 16721.7 | 1803.0 |
| 2022-03-20 19:00:00 | NQ | Futures | 16722.28 | 16722.86 | 16708.36 | 16716.19 | 1146.0 |
| 2022-03-20 19:30:00 | NQ | Futures | 16716.48 | 16720.25 | 16705.46 | 16707.78 | 1244.0 |
| 2022-03-20 20:00:00 | NQ | Futures | 16708.36 | 16710.1 | 16669.8 | 16677.04 | 2365.0 |
| 2022-03-20 20:30:00 | NQ | Futures | 16677.62 | 16697.63 | 16670.38 | 16692.7 | 1484.0 |
| 2022-03-20 21:00:00 | NQ | Futures | 16692.7 | 16696.76 | 16666.32 | 16673.86 | 1836.0 |
| 2022-03-20 21:30:00 | NQ | Futures | 16673.86 | 16676.17 | 16642.25 | 16642.83 | 2913.0 |
| 2022-03-20 22:00:00 | NQ | Futures | 16642.25 | 16678.49 | 16634.13 | 16668.35 | 3094.0 |
| 2022-03-20 22:30:00 | NQ | Futures | 16668.35 | 16678.2 | 16655.01 | 16659.65 | 1515.0 |
| 2022-03-20 23:00:00 | NQ | Futures | 16660.52 | 16668.93 | 16656.17 | 16659.65 | 777.0 |
| 2022-03-20 23:30:00 | NQ | Futures | 16659.65 | 16674.15 | 16658.49 | 16668.64 | 742.0 |
| 2022-03-20 18:00:00 | YM | Futures | 39084.6 | 39104.8 | 39040.6 | 39059.8 | 846.0 |
| 2022-03-20 18:30:00 | YM | Futures | 39062.0 | 39085.7 | 39036.1 | 39046.2 | 491.0 |
| 2022-03-20 19:00:00 | YM | Futures | 39045.1 | 39045.1 | 39024.8 | 39039.5 | 415.0 |
| 2022-03-20 19:30:00 | YM | Futures | 39041.7 | 39048.5 | 38996.6 | 39005.6 | 574.0 |
| 2022-03-20 20:00:00 | YM | Futures | 39007.9 | 39018.0 | 38936.9 | 38958.3 | 974.0 |
| 2022-03-20 20:30:00 | YM | Futures | 38958.3 | 38986.5 | 38949.3 | 38979.7 | 501.0 |
| 2022-03-20 21:00:00 | YM | Futures | 38980.8 | 38996.6 | 38924.5 | 38940.3 | 617.0 |
| 2022-03-20 21:30:00 | YM | Futures | 38940.3 | 38943.6 | 38908.7 | 38922.2 | 715.0 |
| 2022-03-20 22:00:00 | YM | Futures | 38922.2 | 38941.4 | 38912.1 | 38938.0 | 817.0 |
| 2022-03-20 22:30:00 | YM | Futures | 38934.6 | 38934.6 | 38900.8 | 38916.6 | 501.0 |
| 2022-03-20 23:00:00 | YM | Futures | 38916.6 | 38930.1 | 38905.3 | 38913.2 | 262.0 |
| 2022-03-20 23:30:00 | YM | Futures | 38915.5 | 38933.5 | 38908.7 | 38926.7 | 254.0 |
| 2022-03-20 18:00:00 | CL | Futures | 77.3 | 77.58 | 76.44 | 77.31 | 2170.0 |
| 2022-03-20 18:30:00 | CL | Futures | 77.32 | 77.94 | 77.22 | 77.84 | 1229.0 |
| 2022-03-20 19:00:00 | CL | Futures | 77.84 | 78.28 | 77.83 | 78.15 | 1539.0 |
| 2022-03-20 19:30:00 | CL | Futures | 78.16 | 78.2 | 78.07 | 78.1 | 389.0 |
| 2022-03-20 20:00:00 | CL | Futures | 78.12 | 78.84 | 78.12 | 78.55 | 1869.0 |
| 2022-03-20 20:30:00 | CL | Futures | 78.57 | 78.73 | 78.31 | 78.5 | 1054.0 |
| 2022-03-20 21:00:00 | CL | Futures | 78.52 | 79.42 | 78.5 | 79.39 | 2952.0 |
| 2022-03-20 21:30:00 | CL | Futures | 79.37 | 79.42 | 78.91 | 79.18 | 1997.0 |
| 2022-03-20 22:00:00 | CL | Futures | 79.15 | 79.37 | 79.06 | 79.25 | 1186.0 |
| 2022-03-20 22:30:00 | CL | Futures | 79.25 | 79.37 | 79.07 | 79.34 | 1107.0 |
| 2022-03-20 23:00:00 | CL | Futures | 79.36 | 79.54 | 79.07 | 79.12 | 1661.0 |
| 2022-03-20 23:30:00 | CL | Futures | 79.09 | 79.32 | 79.07 | 79.26 | 658.0 |
| 2022-03-20 18:00:00 | GC | Futures | 2307.7 | 2314.7 | 2303.1 | 2303.6 | 1762.0 |
| 2022-03-20 18:30:00 | GC | Futures | 2303.6 | 2306.6 | 2303.6 | 2305.2 | 536.0 |
> showing 50 of 759 rows — these rows as CSV