PREVIEW / futures_30min / 2010-03-21
file: by_date/futures_30min/2010/2010-03-21.parquet size: 16 KB rows: 410
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-21 18:00:00 | ES | Futures | 1127.54 | 1127.54 | 1122.89 | 1123.87 | 12650.0 |
| 2010-03-21 18:30:00 | ES | Futures | 1123.87 | 1124.12 | 1122.65 | 1123.38 | 4626.0 |
| 2010-03-21 19:00:00 | ES | Futures | 1123.63 | 1124.36 | 1123.14 | 1124.36 | 1747.0 |
| 2010-03-21 19:30:00 | ES | Futures | 1124.36 | 1124.61 | 1123.87 | 1124.36 | 1726.0 |
| 2010-03-21 20:00:00 | ES | Futures | 1124.36 | 1125.34 | 1124.36 | 1124.36 | 2629.0 |
| 2010-03-21 20:30:00 | ES | Futures | 1124.12 | 1124.36 | 1123.63 | 1124.12 | 1221.0 |
| 2010-03-21 21:00:00 | ES | Futures | 1124.36 | 1124.85 | 1123.38 | 1124.61 | 2912.0 |
| 2010-03-21 21:30:00 | ES | Futures | 1124.61 | 1125.09 | 1123.38 | 1123.63 | 2408.0 |
| 2010-03-21 22:00:00 | ES | Futures | 1123.63 | 1123.87 | 1122.89 | 1123.38 | 2920.0 |
| 2010-03-21 22:30:00 | ES | Futures | 1123.38 | 1123.38 | 1122.16 | 1122.65 | 6139.0 |
| 2010-03-21 23:00:00 | ES | Futures | 1122.89 | 1124.36 | 1122.89 | 1124.12 | 3370.0 |
| 2010-03-21 23:30:00 | ES | Futures | 1124.12 | 1124.61 | 1123.63 | 1123.87 | 1125.0 |
| 2010-03-21 18:00:00 | NQ | Futures | 2207.65 | 2209.94 | 2200.49 | 2201.92 | 877.0 |
| 2010-03-21 18:30:00 | NQ | Futures | 2201.92 | 2202.49 | 2200.49 | 2201.35 | 326.0 |
| 2010-03-21 19:00:00 | NQ | Futures | 2201.35 | 2203.64 | 2201.35 | 2201.92 | 237.0 |
| 2010-03-21 19:30:00 | NQ | Futures | 2202.21 | 2203.06 | 2201.63 | 2202.78 | 248.0 |
| 2010-03-21 20:00:00 | NQ | Futures | 2203.06 | 2204.21 | 2202.78 | 2203.35 | 196.0 |
| 2010-03-21 20:30:00 | NQ | Futures | 2203.06 | 2203.35 | 2202.49 | 2202.78 | 116.0 |
| 2010-03-21 21:00:00 | NQ | Futures | 2202.78 | 2202.78 | 2201.63 | 2202.78 | 522.0 |
| 2010-03-21 21:30:00 | NQ | Futures | 2202.78 | 2202.78 | 2201.35 | 2201.63 | 167.0 |
| 2010-03-21 22:00:00 | NQ | Futures | 2201.92 | 2201.92 | 2200.77 | 2201.06 | 287.0 |
| 2010-03-21 22:30:00 | NQ | Futures | 2201.06 | 2201.35 | 2199.91 | 2201.06 | 337.0 |
| 2010-03-21 23:00:00 | NQ | Futures | 2201.06 | 2202.21 | 2200.49 | 2201.35 | 324.0 |
| 2010-03-21 23:30:00 | NQ | Futures | 2201.63 | 2202.21 | 2200.77 | 2201.63 | 169.0 |
| 2010-03-21 18:00:00 | YM | Futures | 10032.7 | 10032.7 | 9993.2 | 10000.7 | 707.0 |
| 2010-03-21 18:30:00 | YM | Futures | 10002.6 | 10003.6 | 9995.1 | 10001.7 | 238.0 |
| 2010-03-21 19:00:00 | YM | Futures | 10001.7 | 10008.3 | 9999.8 | 10005.4 | 195.0 |
| 2010-03-21 19:30:00 | YM | Futures | 10007.3 | 10008.3 | 10004.5 | 10006.4 | 179.0 |
| 2010-03-21 20:00:00 | YM | Futures | 10006.4 | 10012.0 | 10006.4 | 10006.4 | 103.0 |
| 2010-03-21 20:30:00 | YM | Futures | 10007.3 | 10007.3 | 10003.6 | 10005.4 | 59.0 |
| 2010-03-21 21:00:00 | YM | Futures | 10006.4 | 10012.0 | 10001.7 | 10011.1 | 109.0 |
| 2010-03-21 21:30:00 | YM | Futures | 10011.1 | 10013.0 | 10002.6 | 10004.5 | 161.0 |
| 2010-03-21 22:00:00 | YM | Futures | 10003.6 | 10005.4 | 9999.8 | 10003.6 | 152.0 |
| 2010-03-21 22:30:00 | YM | Futures | 10002.6 | 10005.4 | 9997.0 | 10001.7 | 355.0 |
| 2010-03-21 23:00:00 | YM | Futures | 10001.7 | 10013.0 | 10001.7 | 10013.0 | 278.0 |
| 2010-03-21 23:30:00 | YM | Futures | 10013.0 | 10014.8 | 10010.1 | 10012.0 | 301.0 |
| 2010-03-21 18:00:00 | CL | Futures | 171.15 | 171.27 | 170.09 | 170.41 | 865.0 |
| 2010-03-21 18:30:00 | CL | Futures | 170.36 | 170.36 | 170.09 | 170.22 | 412.0 |
| 2010-03-21 19:00:00 | CL | Futures | 170.26 | 170.57 | 170.24 | 170.28 | 215.0 |
| 2010-03-21 19:30:00 | CL | Futures | 170.26 | 170.47 | 170.13 | 170.19 | 158.0 |
| 2010-03-21 20:00:00 | CL | Futures | 170.24 | 170.34 | 170.17 | 170.3 | 108.0 |
| 2010-03-21 20:30:00 | CL | Futures | 170.3 | 170.3 | 170.07 | 170.15 | 397.0 |
| 2010-03-21 21:00:00 | CL | Futures | 170.13 | 170.24 | 170.0 | 170.17 | 419.0 |
| 2010-03-21 21:30:00 | CL | Futures | 170.19 | 170.3 | 170.11 | 170.13 | 372.0 |
| 2010-03-21 22:00:00 | CL | Futures | 170.13 | 170.19 | 170.0 | 170.19 | 286.0 |
| 2010-03-21 22:30:00 | CL | Futures | 170.19 | 170.22 | 170.13 | 170.19 | 161.0 |
| 2010-03-21 23:00:00 | CL | Futures | 170.15 | 170.34 | 170.15 | 170.3 | 157.0 |
| 2010-03-21 23:30:00 | CL | Futures | 170.28 | 170.32 | 170.09 | 170.13 | 164.0 |
| 2010-03-21 18:00:00 | GC | Futures | 1559.9 | 1559.9 | 1556.5 | 1558.5 | 466.0 |
| 2010-03-21 18:30:00 | GC | Futures | 1558.6 | 1558.8 | 1553.9 | 1554.0 | 574.0 |
> showing 50 of 410 rows — these rows as CSV