PREVIEW / futures_30min / 2021-08-29
file: by_date/futures_30min/2021/2021-08-29.parquet size: 27 KB rows: 724
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-08-29 18:00:00 | ES | Futures | 5078.34 | 5079.74 | 5074.96 | 5078.62 | 4482.0 |
| 2021-08-29 18:30:00 | ES | Futures | 5078.62 | 5078.9 | 5076.65 | 5077.21 | 1384.0 |
| 2021-08-29 19:00:00 | ES | Futures | 5077.49 | 5078.62 | 5076.36 | 5078.05 | 1407.0 |
| 2021-08-29 19:30:00 | ES | Futures | 5078.34 | 5083.4 | 5078.05 | 5080.59 | 5164.0 |
| 2021-08-29 20:00:00 | ES | Futures | 5080.59 | 5082.0 | 5074.11 | 5074.96 | 6819.0 |
| 2021-08-29 20:30:00 | ES | Futures | 5074.67 | 5074.67 | 5071.01 | 5072.42 | 4685.0 |
| 2021-08-29 21:00:00 | ES | Futures | 5072.42 | 5074.39 | 5071.01 | 5074.39 | 3647.0 |
| 2021-08-29 21:30:00 | ES | Futures | 5074.39 | 5074.96 | 5069.32 | 5073.27 | 4950.0 |
| 2021-08-29 22:00:00 | ES | Futures | 5073.55 | 5076.36 | 5072.99 | 5075.52 | 4039.0 |
| 2021-08-29 22:30:00 | ES | Futures | 5075.52 | 5076.08 | 5074.67 | 5075.24 | 1683.0 |
| 2021-08-29 23:00:00 | ES | Futures | 5075.24 | 5076.65 | 5074.96 | 5076.36 | 1602.0 |
| 2021-08-29 23:30:00 | ES | Futures | 5076.08 | 5079.18 | 5076.08 | 5078.62 | 3021.0 |
| 2021-08-29 18:00:00 | NQ | Futures | 17882.31 | 17893.32 | 17873.91 | 17889.27 | 1936.0 |
| 2021-08-29 18:30:00 | NQ | Futures | 17889.27 | 17891.87 | 17885.79 | 17889.27 | 1071.0 |
| 2021-08-29 19:00:00 | NQ | Futures | 17889.27 | 17891.58 | 17885.79 | 17888.11 | 633.0 |
| 2021-08-29 19:30:00 | NQ | Futures | 17888.4 | 17908.67 | 17888.4 | 17904.91 | 2530.0 |
| 2021-08-29 20:00:00 | NQ | Futures | 17905.2 | 17908.96 | 17884.92 | 17887.82 | 2725.0 |
| 2021-08-29 20:30:00 | NQ | Futures | 17887.24 | 17887.53 | 17875.65 | 17877.68 | 1951.0 |
| 2021-08-29 21:00:00 | NQ | Futures | 17877.68 | 17884.05 | 17872.17 | 17882.6 | 1935.0 |
| 2021-08-29 21:30:00 | NQ | Futures | 17882.6 | 17885.79 | 17867.54 | 17878.26 | 2595.0 |
| 2021-08-29 22:00:00 | NQ | Futures | 17878.26 | 17887.82 | 17875.07 | 17884.05 | 1951.0 |
| 2021-08-29 22:30:00 | NQ | Futures | 17883.47 | 17885.21 | 17879.42 | 17882.89 | 1165.0 |
| 2021-08-29 23:00:00 | NQ | Futures | 17883.18 | 17887.53 | 17880.58 | 17885.79 | 768.0 |
| 2021-08-29 23:30:00 | NQ | Futures | 17886.08 | 17893.03 | 17883.47 | 17891.0 | 1109.0 |
| 2021-08-29 18:00:00 | YM | Futures | 39570.8 | 39590.9 | 39550.7 | 39580.9 | 961.0 |
| 2021-08-29 18:30:00 | YM | Futures | 39579.8 | 39586.5 | 39559.7 | 39573.1 | 510.0 |
| 2021-08-29 19:00:00 | YM | Futures | 39574.2 | 39587.6 | 39567.5 | 39583.1 | 280.0 |
| 2021-08-29 19:30:00 | YM | Futures | 39584.2 | 39622.2 | 39582.0 | 39595.4 | 1113.0 |
| 2021-08-29 20:00:00 | YM | Futures | 39597.6 | 39609.9 | 39541.8 | 39546.3 | 971.0 |
| 2021-08-29 20:30:00 | YM | Futures | 39546.3 | 39546.3 | 39518.3 | 39530.6 | 1251.0 |
| 2021-08-29 21:00:00 | YM | Futures | 39531.7 | 39549.6 | 39521.7 | 39547.4 | 721.0 |
| 2021-08-29 21:30:00 | YM | Futures | 39547.4 | 39551.8 | 39507.1 | 39539.5 | 1082.0 |
| 2021-08-29 22:00:00 | YM | Futures | 39542.9 | 39567.5 | 39538.4 | 39555.2 | 837.0 |
| 2021-08-29 22:30:00 | YM | Futures | 39554.1 | 39564.1 | 39550.7 | 39555.2 | 280.0 |
| 2021-08-29 23:00:00 | YM | Futures | 39553.0 | 39564.1 | 39548.5 | 39561.9 | 314.0 |
| 2021-08-29 23:30:00 | YM | Futures | 39561.9 | 39588.7 | 39561.9 | 39583.1 | 560.0 |
| 2021-08-29 18:00:00 | CL | Futures | 47.87 | 48.11 | 47.57 | 47.87 | 9269.0 |
| 2021-08-29 18:30:00 | CL | Futures | 47.89 | 47.92 | 47.8 | 47.86 | 2319.0 |
| 2021-08-29 19:00:00 | CL | Futures | 47.84 | 47.96 | 47.83 | 47.91 | 1590.0 |
| 2021-08-29 19:30:00 | CL | Futures | 47.91 | 47.98 | 47.89 | 47.89 | 1034.0 |
| 2021-08-29 20:00:00 | CL | Futures | 47.9 | 47.92 | 47.71 | 47.75 | 3168.0 |
| 2021-08-29 20:30:00 | CL | Futures | 47.75 | 47.77 | 47.6 | 47.65 | 1693.0 |
| 2021-08-29 21:00:00 | CL | Futures | 47.66 | 47.68 | 47.42 | 47.5 | 5887.0 |
| 2021-08-29 21:30:00 | CL | Futures | 47.51 | 47.54 | 47.27 | 47.39 | 5069.0 |
| 2021-08-29 22:00:00 | CL | Futures | 47.39 | 47.56 | 47.38 | 47.55 | 2628.0 |
| 2021-08-29 22:30:00 | CL | Futures | 47.55 | 47.62 | 47.44 | 47.46 | 2935.0 |
| 2021-08-29 23:00:00 | CL | Futures | 47.46 | 47.47 | 47.34 | 47.39 | 2334.0 |
| 2021-08-29 23:30:00 | CL | Futures | 47.39 | 47.46 | 47.37 | 47.42 | 1488.0 |
| 2021-08-29 18:00:00 | GC | Futures | 2192.8 | 2193.5 | 2191.3 | 2192.6 | 1306.0 |
| 2021-08-29 18:30:00 | GC | Futures | 2192.6 | 2192.6 | 2191.3 | 2192.0 | 716.0 |
> showing 50 of 724 rows — these rows as CSV