PREVIEW / futures_30min / 2012-10-14
file: by_date/futures_30min/2012/2012-10-14.parquet size: 20 KB rows: 515
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-10-14 18:00:00 | ES | Futures | 1454.61 | 1455.12 | 1451.54 | 1451.8 | 7889.0 |
| 2012-10-14 18:30:00 | ES | Futures | 1451.8 | 1452.82 | 1451.54 | 1452.57 | 1426.0 |
| 2012-10-14 19:00:00 | ES | Futures | 1452.31 | 1452.57 | 1451.29 | 1451.8 | 1415.0 |
| 2012-10-14 19:30:00 | ES | Futures | 1451.8 | 1453.08 | 1451.03 | 1451.29 | 4045.0 |
| 2012-10-14 20:00:00 | ES | Futures | 1451.29 | 1452.06 | 1447.46 | 1448.48 | 18638.0 |
| 2012-10-14 20:30:00 | ES | Futures | 1448.48 | 1450.01 | 1448.22 | 1449.5 | 4988.0 |
| 2012-10-14 21:00:00 | ES | Futures | 1449.5 | 1451.8 | 1448.48 | 1451.54 | 5258.0 |
| 2012-10-14 21:30:00 | ES | Futures | 1451.54 | 1453.08 | 1450.52 | 1452.82 | 3853.0 |
| 2012-10-14 22:00:00 | ES | Futures | 1452.82 | 1452.82 | 1449.5 | 1449.76 | 3799.0 |
| 2012-10-14 22:30:00 | ES | Futures | 1449.76 | 1450.78 | 1449.5 | 1450.78 | 2026.0 |
| 2012-10-14 23:00:00 | ES | Futures | 1450.78 | 1451.03 | 1450.01 | 1451.03 | 1327.0 |
| 2012-10-14 23:30:00 | ES | Futures | 1451.03 | 1451.8 | 1451.03 | 1451.29 | 1040.0 |
| 2012-10-14 18:00:00 | NQ | Futures | 3153.33 | 3157.98 | 3149.85 | 3150.43 | 591.0 |
| 2012-10-14 18:30:00 | NQ | Futures | 3149.85 | 3151.88 | 3149.85 | 3151.01 | 141.0 |
| 2012-10-14 19:00:00 | NQ | Futures | 3150.72 | 3151.01 | 3149.85 | 3151.01 | 359.0 |
| 2012-10-14 19:30:00 | NQ | Futures | 3151.3 | 3153.63 | 3149.85 | 3150.14 | 374.0 |
| 2012-10-14 20:00:00 | NQ | Futures | 3150.14 | 3151.59 | 3144.04 | 3146.36 | 2245.0 |
| 2012-10-14 20:30:00 | NQ | Futures | 3146.07 | 3149.27 | 3145.49 | 3148.1 | 682.0 |
| 2012-10-14 21:00:00 | NQ | Futures | 3147.81 | 3152.75 | 3146.36 | 3151.88 | 674.0 |
| 2012-10-14 21:30:00 | NQ | Futures | 3152.46 | 3155.08 | 3149.85 | 3154.21 | 874.0 |
| 2012-10-14 22:00:00 | NQ | Futures | 3153.92 | 3153.92 | 3147.23 | 3148.1 | 608.0 |
| 2012-10-14 22:30:00 | NQ | Futures | 3148.1 | 3150.43 | 3147.81 | 3150.14 | 244.0 |
| 2012-10-14 23:00:00 | NQ | Futures | 3150.43 | 3150.72 | 3148.1 | 3150.72 | 157.0 |
| 2012-10-14 23:30:00 | NQ | Futures | 3151.01 | 3152.17 | 3150.72 | 3151.59 | 146.0 |
| 2012-10-14 18:00:00 | YM | Futures | 13261.8 | 13275.8 | 13248.8 | 13249.8 | 270.0 |
| 2012-10-14 18:30:00 | YM | Futures | 13251.8 | 13257.8 | 13248.8 | 13253.8 | 126.0 |
| 2012-10-14 19:00:00 | YM | Futures | 13253.8 | 13253.8 | 13245.8 | 13249.8 | 75.0 |
| 2012-10-14 19:30:00 | YM | Futures | 13249.8 | 13258.8 | 13243.8 | 13244.8 | 171.0 |
| 2012-10-14 20:00:00 | YM | Futures | 13244.8 | 13251.8 | 13214.8 | 13222.8 | 1078.0 |
| 2012-10-14 20:30:00 | YM | Futures | 13222.8 | 13232.8 | 13220.8 | 13229.8 | 465.0 |
| 2012-10-14 21:00:00 | YM | Futures | 13228.8 | 13244.8 | 13222.8 | 13240.8 | 666.0 |
| 2012-10-14 21:30:00 | YM | Futures | 13242.8 | 13256.8 | 13234.8 | 13251.8 | 568.0 |
| 2012-10-14 22:00:00 | YM | Futures | 13251.8 | 13251.8 | 13226.8 | 13229.8 | 612.0 |
| 2012-10-14 22:30:00 | YM | Futures | 13231.8 | 13237.8 | 13229.8 | 13237.8 | 231.0 |
| 2012-10-14 23:00:00 | YM | Futures | 13237.8 | 13241.8 | 13231.8 | 13240.8 | 142.0 |
| 2012-10-14 23:30:00 | YM | Futures | 13241.8 | 13245.8 | 13240.8 | 13243.8 | 149.0 |
| 2012-10-14 18:00:00 | CL | Futures | 149.48 | 149.71 | 148.94 | 148.99 | 151.0 |
| 2012-10-14 18:30:00 | CL | Futures | 148.98 | 149.02 | 148.68 | 148.81 | 86.0 |
| 2012-10-14 19:00:00 | CL | Futures | 148.78 | 148.94 | 148.72 | 148.94 | 83.0 |
| 2012-10-14 19:30:00 | CL | Futures | 148.93 | 148.94 | 148.85 | 148.88 | 25.0 |
| 2012-10-14 20:00:00 | CL | Futures | 148.73 | 148.93 | 148.6 | 148.7 | 312.0 |
| 2012-10-14 20:30:00 | CL | Futures | 148.68 | 148.81 | 148.62 | 148.67 | 82.0 |
| 2012-10-14 21:00:00 | CL | Futures | 148.68 | 148.88 | 148.28 | 148.88 | 164.0 |
| 2012-10-14 21:30:00 | CL | Futures | 148.88 | 148.99 | 148.75 | 148.94 | 119.0 |
| 2012-10-14 22:00:00 | CL | Futures | 148.85 | 148.85 | 148.57 | 148.57 | 27.0 |
| 2012-10-14 22:30:00 | CL | Futures | 148.67 | 148.78 | 148.67 | 148.72 | 44.0 |
| 2012-10-14 23:00:00 | CL | Futures | 148.78 | 148.83 | 148.62 | 148.76 | 58.0 |
| 2012-10-14 23:30:00 | CL | Futures | 148.7 | 148.73 | 148.63 | 148.63 | 25.0 |
| 2012-10-14 18:00:00 | GC | Futures | 2421.4 | 2421.8 | 2408.9 | 2409.4 | 4605.0 |
| 2012-10-14 18:30:00 | GC | Futures | 2409.4 | 2411.3 | 2407.4 | 2410.0 | 1750.0 |
> showing 50 of 515 rows — these rows as CSV