PREVIEW / futures_30min / 2013-01-13
file: by_date/futures_30min/2013/2013-01-13.parquet size: 20 KB rows: 535
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-13 18:00:00 | ES | Futures | 1505.42 | 1505.93 | 1504.14 | 1504.65 | 3566.0 |
| 2013-01-13 18:30:00 | ES | Futures | 1504.65 | 1505.68 | 1504.39 | 1505.68 | 1603.0 |
| 2013-01-13 19:00:00 | ES | Futures | 1505.93 | 1507.22 | 1505.16 | 1507.22 | 2934.0 |
| 2013-01-13 19:30:00 | ES | Futures | 1506.96 | 1507.47 | 1506.45 | 1506.7 | 1811.0 |
| 2013-01-13 20:00:00 | ES | Futures | 1506.7 | 1508.5 | 1506.45 | 1507.47 | 3370.0 |
| 2013-01-13 20:30:00 | ES | Futures | 1507.73 | 1509.53 | 1507.22 | 1509.01 | 4320.0 |
| 2013-01-13 21:00:00 | ES | Futures | 1509.01 | 1510.04 | 1509.01 | 1509.27 | 2916.0 |
| 2013-01-13 21:30:00 | ES | Futures | 1509.27 | 1510.04 | 1509.01 | 1509.27 | 1732.0 |
| 2013-01-13 22:00:00 | ES | Futures | 1509.27 | 1509.78 | 1509.27 | 1509.78 | 1300.0 |
| 2013-01-13 22:30:00 | ES | Futures | 1509.53 | 1509.78 | 1509.01 | 1509.27 | 1246.0 |
| 2013-01-13 23:00:00 | ES | Futures | 1509.01 | 1509.78 | 1509.01 | 1509.53 | 724.0 |
| 2013-01-13 23:30:00 | ES | Futures | 1509.53 | 1509.53 | 1508.5 | 1508.5 | 1004.0 |
| 2013-01-13 18:00:00 | NQ | Futures | 3194.77 | 3194.77 | 3190.41 | 3191.28 | 299.0 |
| 2013-01-13 18:30:00 | NQ | Futures | 3191.28 | 3192.15 | 3190.7 | 3191.86 | 193.0 |
| 2013-01-13 19:00:00 | NQ | Futures | 3192.15 | 3194.48 | 3191.28 | 3194.48 | 249.0 |
| 2013-01-13 19:30:00 | NQ | Futures | 3194.77 | 3195.36 | 3193.03 | 3193.03 | 265.0 |
| 2013-01-13 20:00:00 | NQ | Futures | 3193.32 | 3196.81 | 3192.74 | 3195.65 | 387.0 |
| 2013-01-13 20:30:00 | NQ | Futures | 3195.65 | 3199.72 | 3194.48 | 3198.56 | 546.0 |
| 2013-01-13 21:00:00 | NQ | Futures | 3198.56 | 3202.05 | 3197.98 | 3200.01 | 646.0 |
| 2013-01-13 21:30:00 | NQ | Futures | 3199.43 | 3200.6 | 3199.14 | 3199.14 | 206.0 |
| 2013-01-13 22:00:00 | NQ | Futures | 3199.43 | 3200.3 | 3199.14 | 3199.72 | 147.0 |
| 2013-01-13 22:30:00 | NQ | Futures | 3199.72 | 3200.3 | 3198.85 | 3198.85 | 227.0 |
| 2013-01-13 23:00:00 | NQ | Futures | 3198.85 | 3199.14 | 3198.27 | 3198.85 | 284.0 |
| 2013-01-13 23:30:00 | NQ | Futures | 3198.85 | 3199.14 | 3196.52 | 3196.52 | 135.0 |
| 2013-01-13 18:00:00 | YM | Futures | 13512.9 | 13512.9 | 13498.8 | 13498.8 | 231.0 |
| 2013-01-13 18:30:00 | YM | Futures | 13499.8 | 13507.9 | 13498.8 | 13507.9 | 161.0 |
| 2013-01-13 19:00:00 | YM | Futures | 13507.9 | 13517.0 | 13504.9 | 13515.9 | 155.0 |
| 2013-01-13 19:30:00 | YM | Futures | 13515.9 | 13519.0 | 13511.9 | 13514.9 | 147.0 |
| 2013-01-13 20:00:00 | YM | Futures | 13513.9 | 13528.0 | 13512.9 | 13523.0 | 247.0 |
| 2013-01-13 20:30:00 | YM | Futures | 13523.0 | 13536.1 | 13519.0 | 13533.0 | 380.0 |
| 2013-01-13 21:00:00 | YM | Futures | 13532.0 | 13538.1 | 13531.0 | 13535.1 | 216.0 |
| 2013-01-13 21:30:00 | YM | Futures | 13536.1 | 13538.1 | 13532.0 | 13532.0 | 126.0 |
| 2013-01-13 22:00:00 | YM | Futures | 13532.0 | 13538.1 | 13531.0 | 13536.1 | 106.0 |
| 2013-01-13 22:30:00 | YM | Futures | 13535.1 | 13537.1 | 13533.0 | 13533.0 | 136.0 |
| 2013-01-13 23:00:00 | YM | Futures | 13532.0 | 13536.1 | 13532.0 | 13534.1 | 51.0 |
| 2013-01-13 23:30:00 | YM | Futures | 13534.1 | 13535.1 | 13528.0 | 13528.0 | 132.0 |
| 2013-01-13 18:00:00 | CL | Futures | 150.49 | 150.57 | 150.35 | 150.53 | 647.0 |
| 2013-01-13 18:30:00 | CL | Futures | 150.56 | 150.69 | 150.56 | 150.65 | 286.0 |
| 2013-01-13 19:00:00 | CL | Futures | 150.64 | 150.73 | 150.62 | 150.7 | 355.0 |
| 2013-01-13 19:30:00 | CL | Futures | 150.67 | 150.73 | 150.59 | 150.7 | 233.0 |
| 2013-01-13 20:00:00 | CL | Futures | 150.7 | 151.04 | 150.7 | 150.94 | 1172.0 |
| 2013-01-13 20:30:00 | CL | Futures | 150.96 | 151.01 | 150.9 | 150.91 | 442.0 |
| 2013-01-13 21:00:00 | CL | Futures | 150.91 | 151.33 | 150.88 | 151.26 | 954.0 |
| 2013-01-13 21:30:00 | CL | Futures | 151.26 | 151.28 | 151.12 | 151.15 | 445.0 |
| 2013-01-13 22:00:00 | CL | Futures | 151.17 | 151.18 | 151.12 | 151.18 | 273.0 |
| 2013-01-13 22:30:00 | CL | Futures | 151.15 | 151.18 | 151.12 | 151.12 | 128.0 |
| 2013-01-13 23:00:00 | CL | Futures | 151.14 | 151.18 | 151.1 | 151.18 | 161.0 |
| 2013-01-13 23:30:00 | CL | Futures | 151.17 | 151.18 | 151.09 | 151.15 | 223.0 |
| 2013-01-13 18:00:00 | GC | Futures | 2285.6 | 2291.2 | 2285.6 | 2287.1 | 1286.0 |
| 2013-01-13 18:30:00 | GC | Futures | 2287.1 | 2289.7 | 2286.5 | 2286.9 | 554.0 |
> showing 50 of 535 rows — these rows as CSV