PREVIEW / futures_30min / 2012-02-19
file: by_date/futures_30min/2012/2012-02-19.parquet size: 16 KB rows: 395
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-02-19 18:00:00 | ES | Futures | 1377.62 | 1380.39 | 1377.37 | 1379.13 | 18660.0 |
| 2012-02-19 18:30:00 | ES | Futures | 1379.38 | 1379.63 | 1378.12 | 1379.13 | 5253.0 |
| 2012-02-19 19:00:00 | ES | Futures | 1379.38 | 1379.63 | 1378.37 | 1378.88 | 5509.0 |
| 2012-02-19 19:30:00 | ES | Futures | 1379.13 | 1379.63 | 1378.63 | 1379.13 | 2516.0 |
| 2012-02-19 20:00:00 | ES | Futures | 1378.88 | 1379.13 | 1378.12 | 1378.63 | 2463.0 |
| 2012-02-19 20:30:00 | ES | Futures | 1378.37 | 1379.13 | 1377.87 | 1378.37 | 1689.0 |
| 2012-02-19 21:00:00 | ES | Futures | 1378.37 | 1379.38 | 1378.37 | 1379.13 | 1081.0 |
| 2012-02-19 21:30:00 | ES | Futures | 1378.88 | 1379.13 | 1378.12 | 1378.12 | 1550.0 |
| 2012-02-19 22:00:00 | ES | Futures | 1378.12 | 1378.88 | 1377.87 | 1378.88 | 1657.0 |
| 2012-02-19 22:30:00 | ES | Futures | 1378.63 | 1379.13 | 1378.12 | 1378.37 | 1420.0 |
| 2012-02-19 23:00:00 | ES | Futures | 1378.37 | 1378.63 | 1377.11 | 1377.11 | 1938.0 |
| 2012-02-19 23:30:00 | ES | Futures | 1377.37 | 1378.12 | 1376.61 | 1377.87 | 2019.0 |
| 2012-02-19 18:00:00 | NQ | Futures | 2996.28 | 3000.33 | 2995.99 | 3000.04 | 1008.0 |
| 2012-02-19 18:30:00 | NQ | Futures | 2999.75 | 3000.33 | 2998.3 | 2999.46 | 522.0 |
| 2012-02-19 19:00:00 | NQ | Futures | 2999.75 | 3000.33 | 2998.59 | 2999.17 | 413.0 |
| 2012-02-19 19:30:00 | NQ | Futures | 2999.17 | 3000.33 | 2999.17 | 2999.46 | 165.0 |
| 2012-02-19 20:00:00 | NQ | Futures | 2999.75 | 3000.04 | 2998.88 | 2999.17 | 262.0 |
| 2012-02-19 20:30:00 | NQ | Futures | 2999.17 | 3000.04 | 2998.88 | 2999.46 | 144.0 |
| 2012-02-19 21:00:00 | NQ | Futures | 2999.46 | 3000.61 | 2999.17 | 3000.33 | 132.0 |
| 2012-02-19 21:30:00 | NQ | Futures | 3000.33 | 3000.33 | 2999.46 | 2999.46 | 100.0 |
| 2012-02-19 22:00:00 | NQ | Futures | 2999.46 | 3000.04 | 2999.17 | 2999.75 | 89.0 |
| 2012-02-19 22:30:00 | NQ | Futures | 2999.75 | 3000.33 | 2999.17 | 2999.75 | 50.0 |
| 2012-02-19 23:00:00 | NQ | Futures | 2999.75 | 2999.75 | 2998.3 | 2998.59 | 188.0 |
| 2012-02-19 23:30:00 | NQ | Futures | 2998.59 | 3000.33 | 2997.15 | 3000.33 | 234.0 |
| 2012-02-19 18:00:00 | YM | Futures | 12877.8 | 12908.5 | 12875.8 | 12893.7 | 2365.0 |
| 2012-02-19 18:30:00 | YM | Futures | 12892.7 | 12902.6 | 12885.8 | 12891.7 | 646.0 |
| 2012-02-19 19:00:00 | YM | Futures | 12891.7 | 12893.7 | 12885.8 | 12889.7 | 259.0 |
| 2012-02-19 19:30:00 | YM | Futures | 12888.7 | 12892.7 | 12887.7 | 12889.7 | 125.0 |
| 2012-02-19 20:00:00 | YM | Futures | 12889.7 | 12889.7 | 12878.8 | 12880.8 | 201.0 |
| 2012-02-19 20:30:00 | YM | Futures | 12881.8 | 12887.7 | 12879.8 | 12882.8 | 108.0 |
| 2012-02-19 21:00:00 | YM | Futures | 12882.8 | 12887.7 | 12882.8 | 12884.8 | 109.0 |
| 2012-02-19 21:30:00 | YM | Futures | 12885.8 | 12885.8 | 12877.8 | 12878.8 | 79.0 |
| 2012-02-19 22:00:00 | YM | Futures | 12877.8 | 12882.8 | 12875.8 | 12880.8 | 171.0 |
| 2012-02-19 22:30:00 | YM | Futures | 12879.8 | 12883.8 | 12878.8 | 12880.8 | 57.0 |
| 2012-02-19 23:00:00 | YM | Futures | 12878.8 | 12880.8 | 12871.9 | 12873.9 | 68.0 |
| 2012-02-19 23:30:00 | YM | Futures | 12872.9 | 12881.8 | 12870.9 | 12878.8 | 71.0 |
| 2012-02-19 18:00:00 | CL | Futures | 175.75 | 177.11 | 175.67 | 176.79 | 3706.0 |
| 2012-02-19 18:30:00 | CL | Futures | 176.78 | 176.99 | 176.31 | 176.44 | 1391.0 |
| 2012-02-19 19:00:00 | CL | Futures | 176.42 | 176.52 | 176.36 | 176.44 | 548.0 |
| 2012-02-19 19:30:00 | CL | Futures | 176.41 | 176.71 | 176.34 | 176.57 | 630.0 |
| 2012-02-19 20:00:00 | CL | Futures | 176.56 | 176.67 | 176.44 | 176.49 | 458.0 |
| 2012-02-19 20:30:00 | CL | Futures | 176.51 | 176.86 | 176.41 | 176.86 | 582.0 |
| 2012-02-19 21:00:00 | CL | Futures | 176.86 | 176.88 | 176.57 | 176.73 | 512.0 |
| 2012-02-19 21:30:00 | CL | Futures | 176.73 | 176.79 | 176.62 | 176.74 | 431.0 |
| 2012-02-19 22:00:00 | CL | Futures | 176.73 | 176.83 | 176.54 | 176.54 | 499.0 |
| 2012-02-19 22:30:00 | CL | Futures | 176.54 | 176.81 | 176.54 | 176.74 | 252.0 |
| 2012-02-19 23:00:00 | CL | Futures | 176.74 | 176.78 | 176.59 | 176.66 | 135.0 |
| 2012-02-19 23:30:00 | CL | Futures | 176.66 | 176.76 | 176.61 | 176.76 | 269.0 |
| 2012-02-19 18:00:00 | GC | Futures | 2398.9 | 2407.4 | 2397.0 | 2407.1 | 2404.0 |
| 2012-02-19 18:30:00 | GC | Futures | 2407.4 | 2408.9 | 2406.4 | 2408.8 | 726.0 |
> showing 50 of 395 rows — these rows as CSV