PREVIEW / futures_30min / 2011-10-30
file: by_date/futures_30min/2011/2011-10-30.parquet size: 21 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 |
|---|---|---|---|---|---|---|---|
| 2011-10-30 18:00:00 | ES | Futures | 1283.88 | 1284.63 | 1281.37 | 1281.62 | 4424.0 |
| 2011-10-30 18:30:00 | ES | Futures | 1281.62 | 1282.63 | 1279.12 | 1279.37 | 3155.0 |
| 2011-10-30 19:00:00 | ES | Futures | 1279.37 | 1280.37 | 1278.11 | 1278.11 | 2813.0 |
| 2011-10-30 19:30:00 | ES | Futures | 1278.36 | 1279.62 | 1277.61 | 1277.86 | 2464.0 |
| 2011-10-30 20:00:00 | ES | Futures | 1277.86 | 1278.87 | 1277.11 | 1277.61 | 2714.0 |
| 2011-10-30 20:30:00 | ES | Futures | 1277.61 | 1279.37 | 1277.36 | 1278.87 | 2309.0 |
| 2011-10-30 21:00:00 | ES | Futures | 1278.87 | 1282.13 | 1278.36 | 1281.12 | 5893.0 |
| 2011-10-30 21:30:00 | ES | Futures | 1281.12 | 1281.62 | 1278.87 | 1280.37 | 5304.0 |
| 2011-10-30 22:00:00 | ES | Futures | 1280.37 | 1281.37 | 1277.61 | 1278.11 | 4239.0 |
| 2011-10-30 22:30:00 | ES | Futures | 1278.11 | 1278.62 | 1276.86 | 1278.36 | 5018.0 |
| 2011-10-30 23:00:00 | ES | Futures | 1278.36 | 1279.37 | 1276.36 | 1276.36 | 4430.0 |
| 2011-10-30 23:30:00 | ES | Futures | 1276.36 | 1277.11 | 1275.86 | 1275.86 | 2198.0 |
| 2011-10-30 18:00:00 | NQ | Futures | 2765.3 | 2765.59 | 2759.82 | 2760.11 | 553.0 |
| 2011-10-30 18:30:00 | NQ | Futures | 2760.98 | 2761.26 | 2755.79 | 2755.79 | 211.0 |
| 2011-10-30 19:00:00 | NQ | Futures | 2756.07 | 2757.23 | 2752.61 | 2752.61 | 249.0 |
| 2011-10-30 19:30:00 | NQ | Futures | 2752.9 | 2754.63 | 2751.17 | 2752.33 | 187.0 |
| 2011-10-30 20:00:00 | NQ | Futures | 2752.33 | 2753.77 | 2750.88 | 2752.04 | 241.0 |
| 2011-10-30 20:30:00 | NQ | Futures | 2751.46 | 2755.21 | 2751.17 | 2754.63 | 123.0 |
| 2011-10-30 21:00:00 | NQ | Futures | 2754.06 | 2760.4 | 2753.19 | 2759.53 | 455.0 |
| 2011-10-30 21:30:00 | NQ | Futures | 2759.25 | 2760.4 | 2753.77 | 2757.23 | 476.0 |
| 2011-10-30 22:00:00 | NQ | Futures | 2757.23 | 2758.67 | 2748.87 | 2749.44 | 657.0 |
| 2011-10-30 22:30:00 | NQ | Futures | 2749.73 | 2750.31 | 2746.56 | 2750.02 | 698.0 |
| 2011-10-30 23:00:00 | NQ | Futures | 2750.31 | 2751.17 | 2746.56 | 2746.85 | 528.0 |
| 2011-10-30 23:30:00 | NQ | Futures | 2747.14 | 2748.58 | 2746.56 | 2746.56 | 287.0 |
| 2011-10-30 18:00:00 | YM | Futures | 11964.4 | 11972.3 | 11948.6 | 11949.6 | 107.0 |
| 2011-10-30 18:30:00 | YM | Futures | 11949.6 | 11960.4 | 11931.9 | 11931.9 | 135.0 |
| 2011-10-30 19:00:00 | YM | Futures | 11933.9 | 11939.8 | 11925.0 | 11925.0 | 137.0 |
| 2011-10-30 19:30:00 | YM | Futures | 11925.0 | 11935.8 | 11921.1 | 11925.0 | 141.0 |
| 2011-10-30 20:00:00 | YM | Futures | 11925.0 | 11928.9 | 11916.1 | 11922.0 | 171.0 |
| 2011-10-30 20:30:00 | YM | Futures | 11921.1 | 11936.8 | 11918.1 | 11933.9 | 163.0 |
| 2011-10-30 21:00:00 | YM | Futures | 11931.9 | 11957.5 | 11927.9 | 11952.6 | 412.0 |
| 2011-10-30 21:30:00 | YM | Futures | 11951.6 | 11956.5 | 11931.9 | 11941.7 | 326.0 |
| 2011-10-30 22:00:00 | YM | Futures | 11940.7 | 11950.6 | 11922.0 | 11926.0 | 556.0 |
| 2011-10-30 22:30:00 | YM | Futures | 11927.0 | 11930.9 | 11916.1 | 11928.9 | 481.0 |
| 2011-10-30 23:00:00 | YM | Futures | 11927.0 | 11932.9 | 11909.2 | 11910.2 | 447.0 |
| 2011-10-30 23:30:00 | YM | Futures | 11911.2 | 11916.1 | 11906.3 | 11908.3 | 141.0 |
| 2011-10-30 18:00:00 | CL | Futures | 157.78 | 158.24 | 157.59 | 157.75 | 412.0 |
| 2011-10-30 18:30:00 | CL | Futures | 157.7 | 158.07 | 157.7 | 157.93 | 244.0 |
| 2011-10-30 19:00:00 | CL | Futures | 157.95 | 157.98 | 157.43 | 157.53 | 311.0 |
| 2011-10-30 19:30:00 | CL | Futures | 157.51 | 157.71 | 157.31 | 157.31 | 211.0 |
| 2011-10-30 20:00:00 | CL | Futures | 157.31 | 157.39 | 156.97 | 157.07 | 352.0 |
| 2011-10-30 20:30:00 | CL | Futures | 157.02 | 157.59 | 157.02 | 157.48 | 260.0 |
| 2011-10-30 21:00:00 | CL | Futures | 157.43 | 157.81 | 157.14 | 157.43 | 419.0 |
| 2011-10-30 21:30:00 | CL | Futures | 157.38 | 157.46 | 156.8 | 157.02 | 746.0 |
| 2011-10-30 22:00:00 | CL | Futures | 157.0 | 157.17 | 156.46 | 156.62 | 695.0 |
| 2011-10-30 22:30:00 | CL | Futures | 156.55 | 156.65 | 156.3 | 156.51 | 812.0 |
| 2011-10-30 23:00:00 | CL | Futures | 156.48 | 156.53 | 156.09 | 156.09 | 417.0 |
| 2011-10-30 23:30:00 | CL | Futures | 156.09 | 156.3 | 155.87 | 156.16 | 591.0 |
| 2011-10-30 18:00:00 | GC | Futures | 2427.4 | 2430.9 | 2426.3 | 2428.0 | 404.0 |
| 2011-10-30 18:30:00 | GC | Futures | 2427.4 | 2431.5 | 2427.2 | 2428.8 | 138.0 |
> showing 50 of 519 rows — these rows as CSV