PREVIEW / futures_30min / 2018-06-10
file: by_date/futures_30min/2018/2018-06-10.parquet size: 20 KB rows: 519
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-10 18:00:00 | ES | Futures | 3024.91 | 3028.46 | 3024.37 | 3027.37 | 4353.0 |
| 2018-06-10 18:30:00 | ES | Futures | 3027.37 | 3027.37 | 3026.0 | 3026.55 | 854.0 |
| 2018-06-10 19:00:00 | ES | Futures | 3026.55 | 3026.82 | 3024.64 | 3024.91 | 1281.0 |
| 2018-06-10 19:30:00 | ES | Futures | 3024.91 | 3027.91 | 3024.37 | 3027.64 | 997.0 |
| 2018-06-10 20:00:00 | ES | Futures | 3027.91 | 3030.37 | 3027.64 | 3028.19 | 2009.0 |
| 2018-06-10 20:30:00 | ES | Futures | 3028.19 | 3031.46 | 3028.19 | 3030.64 | 1468.0 |
| 2018-06-10 21:00:00 | ES | Futures | 3030.92 | 3032.28 | 3029.55 | 3030.1 | 2150.0 |
| 2018-06-10 21:30:00 | ES | Futures | 3030.1 | 3030.92 | 3027.91 | 3030.64 | 1824.0 |
| 2018-06-10 22:00:00 | ES | Futures | 3030.92 | 3031.19 | 3029.01 | 3029.55 | 1271.0 |
| 2018-06-10 22:30:00 | ES | Futures | 3029.55 | 3031.46 | 3029.28 | 3031.19 | 1337.0 |
| 2018-06-10 23:00:00 | ES | Futures | 3031.46 | 3032.01 | 3030.64 | 3030.64 | 1049.0 |
| 2018-06-10 23:30:00 | ES | Futures | 3030.64 | 3032.01 | 3030.64 | 3032.01 | 703.0 |
| 2018-06-10 18:00:00 | NQ | Futures | 8434.49 | 8443.94 | 8422.67 | 8442.17 | 851.0 |
| 2018-06-10 18:30:00 | NQ | Futures | 8441.88 | 8441.88 | 8433.9 | 8435.67 | 239.0 |
| 2018-06-10 19:00:00 | NQ | Futures | 8435.67 | 8435.67 | 8426.21 | 8428.87 | 389.0 |
| 2018-06-10 19:30:00 | NQ | Futures | 8429.17 | 8439.51 | 8426.8 | 8438.33 | 376.0 |
| 2018-06-10 20:00:00 | NQ | Futures | 8438.92 | 8444.54 | 8436.56 | 8438.03 | 499.0 |
| 2018-06-10 20:30:00 | NQ | Futures | 8438.03 | 8449.85 | 8437.15 | 8447.2 | 421.0 |
| 2018-06-10 21:00:00 | NQ | Futures | 8447.2 | 8451.92 | 8438.33 | 8440.69 | 432.0 |
| 2018-06-10 21:30:00 | NQ | Futures | 8441.88 | 8444.54 | 8432.42 | 8443.65 | 359.0 |
| 2018-06-10 22:00:00 | NQ | Futures | 8443.06 | 8445.13 | 8438.62 | 8439.81 | 301.0 |
| 2018-06-10 22:30:00 | NQ | Futures | 8439.81 | 8446.01 | 8438.62 | 8445.72 | 222.0 |
| 2018-06-10 23:00:00 | NQ | Futures | 8445.72 | 8448.67 | 8443.06 | 8444.54 | 265.0 |
| 2018-06-10 23:30:00 | NQ | Futures | 8444.83 | 8448.08 | 8443.94 | 8447.49 | 134.0 |
| 2018-06-10 18:00:00 | YM | Futures | 27504.6 | 27504.6 | 27457.9 | 27485.1 | 1005.0 |
| 2018-06-10 18:30:00 | YM | Futures | 27486.1 | 27487.2 | 27476.4 | 27482.9 | 234.0 |
| 2018-06-10 19:00:00 | YM | Futures | 27482.9 | 27486.1 | 27468.7 | 27470.9 | 264.0 |
| 2018-06-10 19:30:00 | YM | Futures | 27470.9 | 27501.4 | 27462.2 | 27500.3 | 518.0 |
| 2018-06-10 20:00:00 | YM | Futures | 27500.3 | 27525.3 | 27499.2 | 27506.8 | 1218.0 |
| 2018-06-10 20:30:00 | YM | Futures | 27507.9 | 27542.7 | 27506.8 | 27532.9 | 723.0 |
| 2018-06-10 21:00:00 | YM | Futures | 27535.1 | 27548.1 | 27514.4 | 27519.8 | 773.0 |
| 2018-06-10 21:30:00 | YM | Futures | 27523.1 | 27534.0 | 27501.4 | 27528.5 | 652.0 |
| 2018-06-10 22:00:00 | YM | Futures | 27531.8 | 27535.1 | 27514.4 | 27519.8 | 433.0 |
| 2018-06-10 22:30:00 | YM | Futures | 27519.8 | 27543.8 | 27516.6 | 27541.6 | 433.0 |
| 2018-06-10 23:00:00 | YM | Futures | 27542.7 | 27548.1 | 27532.9 | 27534.0 | 223.0 |
| 2018-06-10 23:30:00 | YM | Futures | 27534.0 | 27548.1 | 27532.9 | 27545.9 | 186.0 |
| 2018-06-10 18:00:00 | CL | Futures | 58.62 | 58.64 | 58.39 | 58.54 | 1706.0 |
| 2018-06-10 18:30:00 | CL | Futures | 58.54 | 58.63 | 58.53 | 58.62 | 624.0 |
| 2018-06-10 19:00:00 | CL | Futures | 58.62 | 58.63 | 58.53 | 58.56 | 770.0 |
| 2018-06-10 19:30:00 | CL | Futures | 58.55 | 58.62 | 58.53 | 58.6 | 588.0 |
| 2018-06-10 20:00:00 | CL | Futures | 58.6 | 58.69 | 58.59 | 58.64 | 1846.0 |
| 2018-06-10 20:30:00 | CL | Futures | 58.64 | 58.7 | 58.64 | 58.67 | 1274.0 |
| 2018-06-10 21:00:00 | CL | Futures | 58.67 | 58.75 | 58.62 | 58.62 | 2682.0 |
| 2018-06-10 21:30:00 | CL | Futures | 58.62 | 58.7 | 58.62 | 58.7 | 1668.0 |
| 2018-06-10 22:00:00 | CL | Futures | 58.7 | 58.76 | 58.68 | 58.71 | 1528.0 |
| 2018-06-10 22:30:00 | CL | Futures | 58.71 | 58.78 | 58.7 | 58.76 | 2149.0 |
| 2018-06-10 23:00:00 | CL | Futures | 58.76 | 58.76 | 58.7 | 58.72 | 1004.0 |
| 2018-06-10 23:30:00 | CL | Futures | 58.73 | 58.73 | 58.7 | 58.71 | 613.0 |
| 2018-06-10 18:00:00 | GC | Futures | 1711.5 | 1712.6 | 1710.5 | 1710.7 | 1073.0 |
| 2018-06-10 18:30:00 | GC | Futures | 1710.6 | 1710.7 | 1709.9 | 1710.7 | 498.0 |
> showing 50 of 519 rows — these rows as CSV