PREVIEW / futures_30min / 2012-12-23
file: by_date/futures_30min/2012/2012-12-23.parquet size: 18 KB rows: 479
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-12-23 18:00:00 | ES | Futures | 1461.8 | 1462.06 | 1458.98 | 1461.29 | 5126.0 |
| 2012-12-23 18:30:00 | ES | Futures | 1461.29 | 1461.29 | 1458.98 | 1459.23 | 2806.0 |
| 2012-12-23 19:00:00 | ES | Futures | 1459.23 | 1459.49 | 1454.87 | 1455.13 | 7937.0 |
| 2012-12-23 19:30:00 | ES | Futures | 1455.13 | 1456.41 | 1455.13 | 1455.9 | 3047.0 |
| 2012-12-23 20:00:00 | ES | Futures | 1455.64 | 1457.18 | 1455.64 | 1456.67 | 1287.0 |
| 2012-12-23 20:30:00 | ES | Futures | 1456.92 | 1458.46 | 1456.67 | 1456.92 | 2232.0 |
| 2012-12-23 21:00:00 | ES | Futures | 1457.18 | 1458.46 | 1456.67 | 1458.21 | 2259.0 |
| 2012-12-23 21:30:00 | ES | Futures | 1458.21 | 1458.46 | 1457.69 | 1457.69 | 2185.0 |
| 2012-12-23 22:00:00 | ES | Futures | 1457.69 | 1458.46 | 1457.44 | 1457.44 | 1031.0 |
| 2012-12-23 22:30:00 | ES | Futures | 1457.44 | 1457.69 | 1455.9 | 1455.9 | 2011.0 |
| 2012-12-23 23:00:00 | ES | Futures | 1455.9 | 1456.41 | 1455.38 | 1455.64 | 972.0 |
| 2012-12-23 23:30:00 | ES | Futures | 1455.64 | 1456.15 | 1455.38 | 1456.15 | 1068.0 |
| 2012-12-23 18:00:00 | NQ | Futures | 3096.98 | 3100.18 | 3093.48 | 3099.01 | 503.0 |
| 2012-12-23 18:30:00 | NQ | Futures | 3098.72 | 3099.89 | 3095.81 | 3096.98 | 405.0 |
| 2012-12-23 19:00:00 | NQ | Futures | 3096.98 | 3097.27 | 3089.12 | 3089.12 | 943.0 |
| 2012-12-23 19:30:00 | NQ | Futures | 3089.12 | 3090.86 | 3088.24 | 3088.53 | 334.0 |
| 2012-12-23 20:00:00 | NQ | Futures | 3088.53 | 3089.99 | 3086.5 | 3089.41 | 280.0 |
| 2012-12-23 20:30:00 | NQ | Futures | 3089.12 | 3091.74 | 3089.12 | 3089.99 | 223.0 |
| 2012-12-23 21:00:00 | NQ | Futures | 3089.7 | 3090.57 | 3087.66 | 3089.99 | 298.0 |
| 2012-12-23 21:30:00 | NQ | Futures | 3089.99 | 3090.28 | 3089.41 | 3089.41 | 60.0 |
| 2012-12-23 22:00:00 | NQ | Futures | 3089.12 | 3089.99 | 3088.24 | 3088.24 | 50.0 |
| 2012-12-23 22:30:00 | NQ | Futures | 3088.53 | 3088.53 | 3082.71 | 3083.88 | 436.0 |
| 2012-12-23 23:00:00 | NQ | Futures | 3084.17 | 3085.04 | 3083.59 | 3084.17 | 58.0 |
| 2012-12-23 23:30:00 | NQ | Futures | 3084.46 | 3085.04 | 3084.17 | 3084.75 | 107.0 |
| 2012-12-23 18:00:00 | YM | Futures | 13212.1 | 13215.1 | 13193.0 | 13202.1 | 244.0 |
| 2012-12-23 18:30:00 | YM | Futures | 13204.1 | 13204.1 | 13183.0 | 13187.0 | 158.0 |
| 2012-12-23 19:00:00 | YM | Futures | 13187.0 | 13188.0 | 13154.8 | 13157.8 | 500.0 |
| 2012-12-23 19:30:00 | YM | Futures | 13158.8 | 13164.8 | 13156.8 | 13160.8 | 235.0 |
| 2012-12-23 20:00:00 | YM | Futures | 13160.8 | 13171.9 | 13160.8 | 13170.9 | 198.0 |
| 2012-12-23 20:30:00 | YM | Futures | 13169.9 | 13178.9 | 13168.9 | 13172.9 | 214.0 |
| 2012-12-23 21:00:00 | YM | Futures | 13172.9 | 13178.9 | 13167.9 | 13177.9 | 169.0 |
| 2012-12-23 21:30:00 | YM | Futures | 13176.9 | 13177.9 | 13173.9 | 13176.9 | 66.0 |
| 2012-12-23 22:00:00 | YM | Futures | 13175.9 | 13177.9 | 13173.9 | 13173.9 | 44.0 |
| 2012-12-23 22:30:00 | YM | Futures | 13171.9 | 13171.9 | 13160.8 | 13161.8 | 155.0 |
| 2012-12-23 23:00:00 | YM | Futures | 13161.8 | 13162.8 | 13158.8 | 13158.8 | 106.0 |
| 2012-12-23 23:30:00 | YM | Futures | 13158.8 | 13160.8 | 13157.8 | 13159.8 | 142.0 |
| 2012-12-23 18:00:00 | CL | Futures | 142.24 | 142.66 | 142.24 | 142.37 | 342.0 |
| 2012-12-23 18:30:00 | CL | Futures | 142.35 | 142.42 | 142.27 | 142.27 | 79.0 |
| 2012-12-23 19:00:00 | CL | Futures | 142.27 | 142.34 | 142.23 | 142.27 | 429.0 |
| 2012-12-23 19:30:00 | CL | Futures | 142.27 | 142.29 | 141.98 | 142.03 | 371.0 |
| 2012-12-23 20:00:00 | CL | Futures | 142.03 | 142.13 | 142.0 | 142.1 | 224.0 |
| 2012-12-23 20:30:00 | CL | Futures | 142.1 | 142.21 | 142.1 | 142.19 | 340.0 |
| 2012-12-23 21:00:00 | CL | Futures | 142.19 | 142.24 | 142.02 | 142.08 | 313.0 |
| 2012-12-23 21:30:00 | CL | Futures | 142.08 | 142.13 | 142.05 | 142.13 | 98.0 |
| 2012-12-23 22:00:00 | CL | Futures | 142.13 | 142.16 | 142.08 | 142.08 | 197.0 |
| 2012-12-23 22:30:00 | CL | Futures | 142.08 | 142.15 | 142.08 | 142.11 | 110.0 |
| 2012-12-23 23:00:00 | CL | Futures | 142.1 | 142.21 | 142.08 | 142.15 | 166.0 |
| 2012-12-23 23:30:00 | CL | Futures | 142.16 | 142.16 | 142.07 | 142.11 | 210.0 |
| 2012-12-23 18:00:00 | GC | Futures | 2283.5 | 2285.8 | 2281.6 | 2284.2 | 486.0 |
| 2012-12-23 18:30:00 | GC | Futures | 2284.2 | 2285.6 | 2283.6 | 2284.6 | 184.0 |
> showing 50 of 479 rows — these rows as CSV