PREVIEW / futures_30min / 2019-09-01
file: by_date/futures_30min/2019/2019-09-01.parquet size: 22 KB rows: 580
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 |
|---|---|---|---|---|---|---|---|
| 2019-09-01 18:00:00 | ES | Futures | 3141.26 | 3148.3 | 3133.41 | 3146.95 | 16595.0 |
| 2019-09-01 18:30:00 | ES | Futures | 3147.22 | 3148.84 | 3143.43 | 3148.03 | 4346.0 |
| 2019-09-01 19:00:00 | ES | Futures | 3148.3 | 3148.84 | 3145.05 | 3148.03 | 3031.0 |
| 2019-09-01 19:30:00 | ES | Futures | 3148.03 | 3151.01 | 3148.03 | 3149.92 | 5815.0 |
| 2019-09-01 20:00:00 | ES | Futures | 3149.92 | 3152.63 | 3149.11 | 3151.28 | 6354.0 |
| 2019-09-01 20:30:00 | ES | Futures | 3151.55 | 3152.36 | 3148.57 | 3149.65 | 4675.0 |
| 2019-09-01 21:00:00 | ES | Futures | 3149.65 | 3154.26 | 3149.11 | 3153.17 | 6920.0 |
| 2019-09-01 21:30:00 | ES | Futures | 3153.17 | 3156.69 | 3152.36 | 3154.8 | 7963.0 |
| 2019-09-01 22:00:00 | ES | Futures | 3154.8 | 3157.23 | 3154.8 | 3155.61 | 3087.0 |
| 2019-09-01 22:30:00 | ES | Futures | 3155.61 | 3155.88 | 3148.03 | 3149.11 | 5242.0 |
| 2019-09-01 23:00:00 | ES | Futures | 3149.11 | 3151.82 | 3146.95 | 3151.55 | 3945.0 |
| 2019-09-01 23:30:00 | ES | Futures | 3151.55 | 3153.98 | 3150.47 | 3153.17 | 2259.0 |
| 2019-09-01 18:00:00 | NQ | Futures | 8853.12 | 8853.41 | 8812.21 | 8845.86 | 4810.0 |
| 2019-09-01 18:30:00 | NQ | Futures | 8845.86 | 8851.96 | 8831.65 | 8846.15 | 2152.0 |
| 2019-09-01 19:00:00 | NQ | Futures | 8846.15 | 8850.8 | 8839.19 | 8846.73 | 1329.0 |
| 2019-09-01 19:30:00 | NQ | Futures | 8847.02 | 8858.05 | 8847.02 | 8855.44 | 2084.0 |
| 2019-09-01 20:00:00 | NQ | Futures | 8855.44 | 8861.53 | 8851.67 | 8857.47 | 1992.0 |
| 2019-09-01 20:30:00 | NQ | Futures | 8857.76 | 8859.79 | 8849.63 | 8855.73 | 2037.0 |
| 2019-09-01 21:00:00 | NQ | Futures | 8855.73 | 8869.65 | 8854.28 | 8864.72 | 2910.0 |
| 2019-09-01 21:30:00 | NQ | Futures | 8865.3 | 8876.62 | 8862.4 | 8869.94 | 3284.0 |
| 2019-09-01 22:00:00 | NQ | Futures | 8870.23 | 8879.81 | 8870.23 | 8876.62 | 2281.0 |
| 2019-09-01 22:30:00 | NQ | Futures | 8876.33 | 8876.62 | 8849.92 | 8853.41 | 3306.0 |
| 2019-09-01 23:00:00 | NQ | Futures | 8853.99 | 8862.4 | 8845.86 | 8859.5 | 2053.0 |
| 2019-09-01 23:30:00 | NQ | Futures | 8859.79 | 8868.2 | 8856.89 | 8867.04 | 1350.0 |
| 2019-09-01 18:00:00 | YM | Futures | 28539.3 | 28575.2 | 28352.2 | 28563.2 | 3280.0 |
| 2019-09-01 18:30:00 | YM | Futures | 28565.4 | 28576.2 | 28538.2 | 28565.4 | 940.0 |
| 2019-09-01 19:00:00 | YM | Futures | 28564.3 | 28581.7 | 28546.9 | 28573.0 | 493.0 |
| 2019-09-01 19:30:00 | YM | Futures | 28574.1 | 28594.7 | 28565.4 | 28575.2 | 1122.0 |
| 2019-09-01 20:00:00 | YM | Futures | 28576.2 | 28604.5 | 28573.0 | 28592.6 | 1236.0 |
| 2019-09-01 20:30:00 | YM | Futures | 28592.6 | 28601.3 | 28568.6 | 28577.3 | 766.0 |
| 2019-09-01 21:00:00 | YM | Futures | 28578.4 | 28628.4 | 28574.1 | 28619.7 | 1101.0 |
| 2019-09-01 21:30:00 | YM | Futures | 28621.9 | 28653.5 | 28611.0 | 28633.9 | 1300.0 |
| 2019-09-01 22:00:00 | YM | Futures | 28635.0 | 28649.1 | 28629.5 | 28635.0 | 464.0 |
| 2019-09-01 22:30:00 | YM | Futures | 28635.0 | 28636.1 | 28571.9 | 28582.8 | 1084.0 |
| 2019-09-01 23:00:00 | YM | Futures | 28581.7 | 28603.4 | 28559.9 | 28598.0 | 678.0 |
| 2019-09-01 23:30:00 | YM | Futures | 28599.1 | 28615.4 | 28590.4 | 28612.1 | 385.0 |
| 2019-09-01 18:00:00 | CL | Futures | 48.83 | 48.89 | 48.4 | 48.67 | 3239.0 |
| 2019-09-01 18:30:00 | CL | Futures | 48.66 | 48.75 | 48.57 | 48.69 | 1264.0 |
| 2019-09-01 19:00:00 | CL | Futures | 48.69 | 48.73 | 48.63 | 48.68 | 892.0 |
| 2019-09-01 19:30:00 | CL | Futures | 48.68 | 48.72 | 48.62 | 48.66 | 1259.0 |
| 2019-09-01 20:00:00 | CL | Futures | 48.66 | 48.7 | 48.63 | 48.68 | 1463.0 |
| 2019-09-01 20:30:00 | CL | Futures | 48.68 | 48.7 | 48.64 | 48.7 | 1051.0 |
| 2019-09-01 21:00:00 | CL | Futures | 48.7 | 48.85 | 48.69 | 48.81 | 4050.0 |
| 2019-09-01 21:30:00 | CL | Futures | 48.82 | 48.91 | 48.79 | 48.8 | 2753.0 |
| 2019-09-01 22:00:00 | CL | Futures | 48.8 | 48.87 | 48.79 | 48.85 | 1657.0 |
| 2019-09-01 22:30:00 | CL | Futures | 48.85 | 48.87 | 48.79 | 48.83 | 1842.0 |
| 2019-09-01 23:00:00 | CL | Futures | 48.83 | 48.93 | 48.81 | 48.89 | 2009.0 |
| 2019-09-01 23:30:00 | CL | Futures | 48.89 | 48.93 | 48.87 | 48.93 | 1165.0 |
| 2019-09-01 18:00:00 | GC | Futures | 1944.9 | 1956.7 | 1944.9 | 1950.2 | 7439.0 |
| 2019-09-01 18:30:00 | GC | Futures | 1950.1 | 1953.8 | 1948.1 | 1949.2 | 2625.0 |
> showing 50 of 580 rows — these rows as CSV