PREVIEW / futures_30min / 2012-09-09
file: by_date/futures_30min/2012/2012-09-09.parquet size: 18 KB rows: 468
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-09-09 18:00:00 | ES | Futures | 1461.37 | 1461.88 | 1460.86 | 1461.62 | 4403.0 |
| 2012-09-09 18:30:00 | ES | Futures | 1461.88 | 1461.88 | 1461.37 | 1461.37 | 423.0 |
| 2012-09-09 19:00:00 | ES | Futures | 1461.37 | 1461.88 | 1461.11 | 1461.37 | 503.0 |
| 2012-09-09 19:30:00 | ES | Futures | 1461.11 | 1461.37 | 1460.1 | 1460.86 | 2374.0 |
| 2012-09-09 20:00:00 | ES | Futures | 1460.6 | 1460.86 | 1459.84 | 1460.1 | 2794.0 |
| 2012-09-09 20:30:00 | ES | Futures | 1460.1 | 1460.1 | 1459.08 | 1459.08 | 3989.0 |
| 2012-09-09 21:00:00 | ES | Futures | 1459.08 | 1459.59 | 1458.82 | 1459.59 | 3007.0 |
| 2012-09-09 21:30:00 | ES | Futures | 1459.59 | 1459.59 | 1458.82 | 1459.08 | 3298.0 |
| 2012-09-09 22:00:00 | ES | Futures | 1459.33 | 1459.59 | 1458.82 | 1459.08 | 1915.0 |
| 2012-09-09 22:30:00 | ES | Futures | 1459.08 | 1459.33 | 1458.57 | 1458.82 | 1947.0 |
| 2012-09-09 23:00:00 | ES | Futures | 1459.08 | 1459.08 | 1457.55 | 1458.06 | 5393.0 |
| 2012-09-09 23:30:00 | ES | Futures | 1458.32 | 1458.32 | 1457.55 | 1457.81 | 1528.0 |
| 2012-09-09 18:00:00 | NQ | Futures | 3272.51 | 3273.09 | 3270.77 | 3272.51 | 331.0 |
| 2012-09-09 18:30:00 | NQ | Futures | 3272.51 | 3273.09 | 3271.93 | 3271.93 | 19.0 |
| 2012-09-09 19:00:00 | NQ | Futures | 3271.93 | 3272.8 | 3271.64 | 3272.51 | 30.0 |
| 2012-09-09 19:30:00 | NQ | Futures | 3272.22 | 3272.22 | 3269.03 | 3270.19 | 160.0 |
| 2012-09-09 20:00:00 | NQ | Futures | 3270.48 | 3271.06 | 3269.03 | 3269.03 | 176.0 |
| 2012-09-09 20:30:00 | NQ | Futures | 3269.03 | 3269.32 | 3267.58 | 3267.87 | 220.0 |
| 2012-09-09 21:00:00 | NQ | Futures | 3267.87 | 3268.74 | 3267.29 | 3268.74 | 151.0 |
| 2012-09-09 21:30:00 | NQ | Futures | 3268.45 | 3269.32 | 3267.87 | 3268.16 | 173.0 |
| 2012-09-09 22:00:00 | NQ | Futures | 3268.45 | 3269.32 | 3267.87 | 3269.03 | 183.0 |
| 2012-09-09 22:30:00 | NQ | Futures | 3268.74 | 3269.32 | 3267.87 | 3268.45 | 224.0 |
| 2012-09-09 23:00:00 | NQ | Futures | 3268.45 | 3268.45 | 3265.26 | 3267.0 | 460.0 |
| 2012-09-09 23:30:00 | NQ | Futures | 3267.0 | 3267.29 | 3265.55 | 3265.55 | 167.0 |
| 2012-09-09 18:00:00 | YM | Futures | 13210.6 | 13214.6 | 13207.7 | 13212.6 | 397.0 |
| 2012-09-09 18:30:00 | YM | Futures | 13214.6 | 13216.6 | 13211.6 | 13212.6 | 70.0 |
| 2012-09-09 19:00:00 | YM | Futures | 13211.6 | 13216.6 | 13209.6 | 13211.6 | 39.0 |
| 2012-09-09 19:30:00 | YM | Futures | 13211.6 | 13211.6 | 13203.7 | 13207.7 | 113.0 |
| 2012-09-09 20:00:00 | YM | Futures | 13205.7 | 13205.7 | 13199.7 | 13200.7 | 154.0 |
| 2012-09-09 20:30:00 | YM | Futures | 13201.7 | 13202.7 | 13194.7 | 13195.7 | 204.0 |
| 2012-09-09 21:00:00 | YM | Futures | 13196.7 | 13198.7 | 13193.7 | 13197.7 | 219.0 |
| 2012-09-09 21:30:00 | YM | Futures | 13196.7 | 13200.7 | 13193.7 | 13195.7 | 165.0 |
| 2012-09-09 22:00:00 | YM | Futures | 13196.7 | 13199.7 | 13194.7 | 13194.7 | 107.0 |
| 2012-09-09 22:30:00 | YM | Futures | 13195.7 | 13195.7 | 13191.7 | 13193.7 | 145.0 |
| 2012-09-09 23:00:00 | YM | Futures | 13194.7 | 13194.7 | 13182.8 | 13189.8 | 427.0 |
| 2012-09-09 23:30:00 | YM | Futures | 13188.8 | 13190.8 | 13184.8 | 13184.8 | 134.0 |
| 2012-09-09 18:00:00 | CL | Futures | 157.53 | 157.71 | 157.4 | 157.7 | 312.0 |
| 2012-09-09 18:30:00 | CL | Futures | 157.71 | 157.71 | 157.55 | 157.57 | 57.0 |
| 2012-09-09 19:00:00 | CL | Futures | 157.57 | 157.68 | 157.53 | 157.58 | 135.0 |
| 2012-09-09 19:30:00 | CL | Futures | 157.58 | 157.65 | 157.57 | 157.61 | 57.0 |
| 2012-09-09 20:00:00 | CL | Futures | 157.63 | 157.65 | 157.5 | 157.5 | 203.0 |
| 2012-09-09 20:30:00 | CL | Futures | 157.52 | 157.61 | 157.29 | 157.43 | 325.0 |
| 2012-09-09 21:00:00 | CL | Futures | 157.4 | 157.66 | 157.34 | 157.66 | 361.0 |
| 2012-09-09 21:30:00 | CL | Futures | 157.68 | 157.81 | 157.6 | 157.73 | 545.0 |
| 2012-09-09 22:00:00 | CL | Futures | 157.76 | 157.79 | 157.61 | 157.65 | 107.0 |
| 2012-09-09 22:30:00 | CL | Futures | 157.68 | 157.73 | 157.65 | 157.68 | 70.0 |
| 2012-09-09 23:00:00 | CL | Futures | 157.66 | 157.7 | 157.42 | 157.6 | 184.0 |
| 2012-09-09 23:30:00 | CL | Futures | 157.6 | 157.63 | 157.53 | 157.58 | 93.0 |
| 2012-09-09 18:00:00 | GC | Futures | 2397.6 | 2398.7 | 2395.7 | 2396.2 | 1017.0 |
| 2012-09-09 18:30:00 | GC | Futures | 2396.1 | 2396.9 | 2395.1 | 2395.8 | 479.0 |
> showing 50 of 468 rows — these rows as CSV