PREVIEW / futures_30min / 2012-11-04
file: by_date/futures_30min/2012/2012-11-04.parquet size: 19 KB rows: 528
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-04 18:00:00 | ES | Futures | 1433.41 | 1436.47 | 1433.15 | 1435.45 | 12801.0 |
| 2012-11-04 18:30:00 | ES | Futures | 1435.45 | 1435.71 | 1433.92 | 1434.17 | 2629.0 |
| 2012-11-04 19:00:00 | ES | Futures | 1434.17 | 1437.49 | 1434.17 | 1437.24 | 5220.0 |
| 2012-11-04 19:30:00 | ES | Futures | 1437.24 | 1439.03 | 1437.24 | 1438.26 | 4509.0 |
| 2012-11-04 20:00:00 | ES | Futures | 1438.26 | 1439.03 | 1438.01 | 1438.52 | 2664.0 |
| 2012-11-04 20:30:00 | ES | Futures | 1438.52 | 1440.3 | 1438.26 | 1439.54 | 3828.0 |
| 2012-11-04 21:00:00 | ES | Futures | 1439.28 | 1439.79 | 1438.77 | 1439.28 | 1831.0 |
| 2012-11-04 21:30:00 | ES | Futures | 1439.28 | 1439.54 | 1437.24 | 1437.49 | 2681.0 |
| 2012-11-04 22:00:00 | ES | Futures | 1437.24 | 1438.26 | 1436.98 | 1438.01 | 1332.0 |
| 2012-11-04 22:30:00 | ES | Futures | 1437.75 | 1438.77 | 1437.75 | 1438.26 | 996.0 |
| 2012-11-04 23:00:00 | ES | Futures | 1438.26 | 1439.28 | 1438.26 | 1438.77 | 1218.0 |
| 2012-11-04 23:30:00 | ES | Futures | 1438.52 | 1439.28 | 1438.52 | 1439.03 | 878.0 |
| 2012-11-04 18:00:00 | NQ | Futures | 3069.07 | 3073.14 | 3062.38 | 3070.81 | 908.0 |
| 2012-11-04 18:30:00 | NQ | Futures | 3070.81 | 3071.1 | 3066.16 | 3067.32 | 302.0 |
| 2012-11-04 19:00:00 | NQ | Futures | 3067.32 | 3074.3 | 3067.32 | 3073.43 | 375.0 |
| 2012-11-04 19:30:00 | NQ | Futures | 3074.01 | 3075.75 | 3073.72 | 3074.3 | 668.0 |
| 2012-11-04 20:00:00 | NQ | Futures | 3074.59 | 3075.75 | 3074.3 | 3074.88 | 276.0 |
| 2012-11-04 20:30:00 | NQ | Futures | 3075.17 | 3079.53 | 3074.88 | 3078.95 | 591.0 |
| 2012-11-04 21:00:00 | NQ | Futures | 3078.95 | 3079.82 | 3078.66 | 3079.24 | 304.0 |
| 2012-11-04 21:30:00 | NQ | Futures | 3079.24 | 3079.53 | 3075.17 | 3075.17 | 446.0 |
| 2012-11-04 22:00:00 | NQ | Futures | 3075.17 | 3076.91 | 3074.3 | 3076.62 | 172.0 |
| 2012-11-04 22:30:00 | NQ | Futures | 3076.33 | 3078.08 | 3076.33 | 3076.91 | 93.0 |
| 2012-11-04 23:00:00 | NQ | Futures | 3076.62 | 3078.95 | 3076.62 | 3078.08 | 167.0 |
| 2012-11-04 23:30:00 | NQ | Futures | 3078.08 | 3078.95 | 3077.79 | 3078.37 | 55.0 |
| 2012-11-04 18:00:00 | YM | Futures | 12995.7 | 13008.7 | 12979.7 | 13001.7 | 1153.0 |
| 2012-11-04 18:30:00 | YM | Futures | 13001.7 | 13001.7 | 12989.7 | 12992.7 | 164.0 |
| 2012-11-04 19:00:00 | YM | Futures | 12991.7 | 13008.7 | 12991.7 | 13007.7 | 772.0 |
| 2012-11-04 19:30:00 | YM | Futures | 13007.7 | 13028.7 | 13007.7 | 13024.7 | 734.0 |
| 2012-11-04 20:00:00 | YM | Futures | 13024.7 | 13028.7 | 13022.7 | 13024.7 | 413.0 |
| 2012-11-04 20:30:00 | YM | Futures | 13025.7 | 13036.7 | 13023.7 | 13031.7 | 450.0 |
| 2012-11-04 21:00:00 | YM | Futures | 13032.7 | 13034.7 | 13027.7 | 13029.7 | 227.0 |
| 2012-11-04 21:30:00 | YM | Futures | 13029.7 | 13031.7 | 13017.7 | 13018.7 | 303.0 |
| 2012-11-04 22:00:00 | YM | Futures | 13016.7 | 13022.7 | 13012.7 | 13018.7 | 172.0 |
| 2012-11-04 22:30:00 | YM | Futures | 13020.7 | 13026.7 | 13018.7 | 13023.7 | 130.0 |
| 2012-11-04 23:00:00 | YM | Futures | 13024.7 | 13029.7 | 13022.7 | 13025.7 | 176.0 |
| 2012-11-04 23:30:00 | YM | Futures | 13025.7 | 13028.7 | 13025.7 | 13026.7 | 96.0 |
| 2012-11-04 18:00:00 | CL | Futures | 137.55 | 137.96 | 137.47 | 137.73 | 1143.0 |
| 2012-11-04 18:30:00 | CL | Futures | 137.71 | 137.8 | 137.63 | 137.76 | 385.0 |
| 2012-11-04 19:00:00 | CL | Futures | 137.76 | 137.93 | 137.68 | 137.89 | 466.0 |
| 2012-11-04 19:30:00 | CL | Futures | 137.89 | 138.07 | 137.88 | 138.02 | 443.0 |
| 2012-11-04 20:00:00 | CL | Futures | 138.04 | 138.09 | 137.76 | 137.86 | 650.0 |
| 2012-11-04 20:30:00 | CL | Futures | 137.86 | 138.2 | 137.81 | 138.07 | 764.0 |
| 2012-11-04 21:00:00 | CL | Futures | 138.06 | 138.1 | 137.91 | 138.06 | 396.0 |
| 2012-11-04 21:30:00 | CL | Futures | 138.06 | 138.12 | 137.88 | 137.91 | 696.0 |
| 2012-11-04 22:00:00 | CL | Futures | 137.91 | 138.07 | 137.83 | 138.01 | 548.0 |
| 2012-11-04 22:30:00 | CL | Futures | 137.99 | 138.15 | 137.97 | 138.12 | 490.0 |
| 2012-11-04 23:00:00 | CL | Futures | 138.12 | 138.38 | 138.12 | 138.28 | 652.0 |
| 2012-11-04 23:30:00 | CL | Futures | 138.27 | 138.49 | 138.27 | 138.38 | 696.0 |
| 2012-11-04 18:00:00 | GC | Futures | 2313.1 | 2317.2 | 2312.1 | 2315.8 | 1046.0 |
| 2012-11-04 18:30:00 | GC | Futures | 2316.1 | 2320.9 | 2316.0 | 2320.8 | 1274.0 |
> showing 50 of 528 rows — these rows as CSV