PREVIEW / futures_30min / 2012-12-09
file: by_date/futures_30min/2012/2012-12-09.parquet size: 18 KB rows: 486
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-09 18:00:00 | ES | Futures | 1446.95 | 1449.25 | 1446.95 | 1447.97 | 6360.0 |
| 2012-12-09 18:30:00 | ES | Futures | 1447.97 | 1448.22 | 1447.46 | 1447.97 | 1531.0 |
| 2012-12-09 19:00:00 | ES | Futures | 1447.71 | 1449.76 | 1447.71 | 1449.5 | 2752.0 |
| 2012-12-09 19:30:00 | ES | Futures | 1449.5 | 1449.76 | 1449.25 | 1449.25 | 921.0 |
| 2012-12-09 20:00:00 | ES | Futures | 1449.25 | 1450.01 | 1448.22 | 1448.73 | 2353.0 |
| 2012-12-09 20:30:00 | ES | Futures | 1448.48 | 1449.25 | 1447.97 | 1448.99 | 2092.0 |
| 2012-12-09 21:00:00 | ES | Futures | 1448.99 | 1449.25 | 1446.95 | 1448.22 | 4079.0 |
| 2012-12-09 21:30:00 | ES | Futures | 1448.22 | 1449.76 | 1448.22 | 1448.73 | 2725.0 |
| 2012-12-09 22:00:00 | ES | Futures | 1448.73 | 1448.99 | 1447.71 | 1448.48 | 1540.0 |
| 2012-12-09 22:30:00 | ES | Futures | 1448.48 | 1448.48 | 1446.95 | 1446.95 | 1462.0 |
| 2012-12-09 23:00:00 | ES | Futures | 1447.2 | 1447.71 | 1446.95 | 1447.2 | 1076.0 |
| 2012-12-09 23:30:00 | ES | Futures | 1447.2 | 1447.46 | 1446.95 | 1447.46 | 542.0 |
| 2012-12-09 18:00:00 | NQ | Futures | 3065.0 | 3068.78 | 3063.26 | 3067.61 | 242.0 |
| 2012-12-09 18:30:00 | NQ | Futures | 3067.61 | 3068.49 | 3066.45 | 3067.61 | 144.0 |
| 2012-12-09 19:00:00 | NQ | Futures | 3067.91 | 3071.39 | 3067.91 | 3071.1 | 420.0 |
| 2012-12-09 19:30:00 | NQ | Futures | 3071.1 | 3071.1 | 3069.94 | 3069.94 | 117.0 |
| 2012-12-09 20:00:00 | NQ | Futures | 3069.94 | 3071.1 | 3068.2 | 3068.78 | 267.0 |
| 2012-12-09 20:30:00 | NQ | Futures | 3068.49 | 3070.52 | 3067.61 | 3069.65 | 255.0 |
| 2012-12-09 21:00:00 | NQ | Futures | 3069.94 | 3070.23 | 3065.87 | 3069.07 | 811.0 |
| 2012-12-09 21:30:00 | NQ | Futures | 3069.07 | 3072.26 | 3068.78 | 3070.23 | 588.0 |
| 2012-12-09 22:00:00 | NQ | Futures | 3070.52 | 3070.81 | 3068.2 | 3069.07 | 230.0 |
| 2012-12-09 22:30:00 | NQ | Futures | 3069.36 | 3069.36 | 3066.45 | 3067.03 | 135.0 |
| 2012-12-09 23:00:00 | NQ | Futures | 3067.03 | 3067.91 | 3065.58 | 3065.58 | 227.0 |
| 2012-12-09 23:30:00 | NQ | Futures | 3065.58 | 3065.58 | 3063.55 | 3063.84 | 259.0 |
| 2012-12-09 18:00:00 | YM | Futures | 13153.8 | 13169.8 | 13149.8 | 13156.8 | 379.0 |
| 2012-12-09 18:30:00 | YM | Futures | 13157.8 | 13159.8 | 13152.8 | 13155.8 | 177.0 |
| 2012-12-09 19:00:00 | YM | Futures | 13156.8 | 13167.8 | 13153.8 | 13167.8 | 409.0 |
| 2012-12-09 19:30:00 | YM | Futures | 13166.8 | 13168.8 | 13164.8 | 13167.8 | 134.0 |
| 2012-12-09 20:00:00 | YM | Futures | 13167.8 | 13174.8 | 13162.8 | 13164.8 | 529.0 |
| 2012-12-09 20:30:00 | YM | Futures | 13163.8 | 13169.8 | 13157.8 | 13167.8 | 532.0 |
| 2012-12-09 21:00:00 | YM | Futures | 13167.8 | 13170.8 | 13151.8 | 13162.8 | 958.0 |
| 2012-12-09 21:30:00 | YM | Futures | 13162.8 | 13172.8 | 13161.8 | 13167.8 | 533.0 |
| 2012-12-09 22:00:00 | YM | Futures | 13166.8 | 13168.8 | 13160.8 | 13161.8 | 192.0 |
| 2012-12-09 22:30:00 | YM | Futures | 13161.8 | 13162.8 | 13152.8 | 13153.8 | 261.0 |
| 2012-12-09 23:00:00 | YM | Futures | 13154.8 | 13155.8 | 13150.8 | 13151.8 | 150.0 |
| 2012-12-09 23:30:00 | YM | Futures | 13151.8 | 13152.8 | 13148.8 | 13152.8 | 190.0 |
| 2012-12-09 18:00:00 | CL | Futures | 138.9 | 139.11 | 138.77 | 139.06 | 426.0 |
| 2012-12-09 18:30:00 | CL | Futures | 139.06 | 139.17 | 139.01 | 139.11 | 348.0 |
| 2012-12-09 19:00:00 | CL | Futures | 139.12 | 139.22 | 139.09 | 139.22 | 447.0 |
| 2012-12-09 19:30:00 | CL | Futures | 139.2 | 139.25 | 139.11 | 139.24 | 447.0 |
| 2012-12-09 20:00:00 | CL | Futures | 139.22 | 139.35 | 139.17 | 139.2 | 680.0 |
| 2012-12-09 20:30:00 | CL | Futures | 139.2 | 139.35 | 139.17 | 139.32 | 372.0 |
| 2012-12-09 21:00:00 | CL | Futures | 139.32 | 139.37 | 138.98 | 139.19 | 717.0 |
| 2012-12-09 21:30:00 | CL | Futures | 139.2 | 139.37 | 139.17 | 139.25 | 351.0 |
| 2012-12-09 22:00:00 | CL | Futures | 139.25 | 139.3 | 139.24 | 139.3 | 101.0 |
| 2012-12-09 22:30:00 | CL | Futures | 139.3 | 139.32 | 139.19 | 139.19 | 93.0 |
| 2012-12-09 23:00:00 | CL | Futures | 139.19 | 139.2 | 139.14 | 139.16 | 171.0 |
| 2012-12-09 23:30:00 | CL | Futures | 139.17 | 139.25 | 139.17 | 139.24 | 208.0 |
| 2012-12-09 18:00:00 | GC | Futures | 2348.8 | 2350.3 | 2345.9 | 2350.0 | 721.0 |
| 2012-12-09 18:30:00 | GC | Futures | 2350.0 | 2350.3 | 2346.7 | 2347.9 | 530.0 |
> showing 50 of 486 rows — these rows as CSV