PREVIEW / futures_30min / 2013-02-24
file: by_date/futures_30min/2013/2013-02-24.parquet size: 19 KB rows: 503
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-24 18:00:00 | ES | Futures | 1555.46 | 1555.97 | 1554.43 | 1555.46 | 9675.0 |
| 2013-02-24 18:30:00 | ES | Futures | 1555.46 | 1556.22 | 1554.94 | 1556.22 | 3246.0 |
| 2013-02-24 19:00:00 | ES | Futures | 1556.22 | 1556.22 | 1554.43 | 1554.69 | 3539.0 |
| 2013-02-24 19:30:00 | ES | Futures | 1554.94 | 1554.94 | 1554.17 | 1554.43 | 2232.0 |
| 2013-02-24 20:00:00 | ES | Futures | 1554.69 | 1554.69 | 1553.15 | 1553.66 | 4705.0 |
| 2013-02-24 20:30:00 | ES | Futures | 1553.66 | 1554.17 | 1551.61 | 1551.61 | 8912.0 |
| 2013-02-24 21:00:00 | ES | Futures | 1551.86 | 1552.12 | 1551.35 | 1551.86 | 2746.0 |
| 2013-02-24 21:30:00 | ES | Futures | 1551.86 | 1552.89 | 1551.61 | 1552.89 | 2722.0 |
| 2013-02-24 22:00:00 | ES | Futures | 1552.63 | 1553.15 | 1552.63 | 1552.89 | 1889.0 |
| 2013-02-24 22:30:00 | ES | Futures | 1552.89 | 1553.15 | 1552.63 | 1553.15 | 921.0 |
| 2013-02-24 23:00:00 | ES | Futures | 1552.89 | 1553.15 | 1552.38 | 1552.63 | 601.0 |
| 2013-02-24 23:30:00 | ES | Futures | 1552.63 | 1553.92 | 1552.38 | 1553.4 | 1433.0 |
| 2013-02-24 18:00:00 | NQ | Futures | 3186.33 | 3188.66 | 3185.46 | 3186.62 | 1039.0 |
| 2013-02-24 18:30:00 | NQ | Futures | 3186.92 | 3188.66 | 3186.04 | 3188.37 | 173.0 |
| 2013-02-24 19:00:00 | NQ | Futures | 3188.66 | 3188.66 | 3185.17 | 3185.46 | 256.0 |
| 2013-02-24 19:30:00 | NQ | Futures | 3185.17 | 3186.04 | 3184.3 | 3184.88 | 191.0 |
| 2013-02-24 20:00:00 | NQ | Futures | 3184.88 | 3184.88 | 3182.26 | 3183.42 | 260.0 |
| 2013-02-24 20:30:00 | NQ | Futures | 3183.13 | 3184.0 | 3179.35 | 3179.35 | 843.0 |
| 2013-02-24 21:00:00 | NQ | Futures | 3179.35 | 3180.22 | 3179.06 | 3179.64 | 233.0 |
| 2013-02-24 21:30:00 | NQ | Futures | 3179.93 | 3181.97 | 3179.93 | 3181.39 | 313.0 |
| 2013-02-24 22:00:00 | NQ | Futures | 3181.68 | 3182.55 | 3181.39 | 3181.39 | 149.0 |
| 2013-02-24 22:30:00 | NQ | Futures | 3181.68 | 3181.97 | 3181.09 | 3181.68 | 109.0 |
| 2013-02-24 23:00:00 | NQ | Futures | 3181.68 | 3181.68 | 3180.8 | 3181.09 | 53.0 |
| 2013-02-24 23:30:00 | NQ | Futures | 3181.09 | 3182.84 | 3181.09 | 3182.55 | 119.0 |
| 2013-02-24 18:00:00 | YM | Futures | 14069.3 | 14076.3 | 14065.2 | 14070.3 | 705.0 |
| 2013-02-24 18:30:00 | YM | Futures | 14071.3 | 14075.3 | 14067.2 | 14075.3 | 219.0 |
| 2013-02-24 19:00:00 | YM | Futures | 14076.3 | 14076.3 | 14062.2 | 14064.2 | 290.0 |
| 2013-02-24 19:30:00 | YM | Futures | 14063.2 | 14065.2 | 14061.2 | 14064.2 | 204.0 |
| 2013-02-24 20:00:00 | YM | Futures | 14063.2 | 14063.2 | 14051.1 | 14055.2 | 338.0 |
| 2013-02-24 20:30:00 | YM | Futures | 14054.2 | 14058.2 | 14038.1 | 14039.1 | 1105.0 |
| 2013-02-24 21:00:00 | YM | Futures | 14040.1 | 14045.1 | 14039.1 | 14040.1 | 360.0 |
| 2013-02-24 21:30:00 | YM | Futures | 14042.1 | 14051.1 | 14040.1 | 14050.1 | 258.0 |
| 2013-02-24 22:00:00 | YM | Futures | 14050.1 | 14053.2 | 14049.1 | 14049.1 | 125.0 |
| 2013-02-24 22:30:00 | YM | Futures | 14049.1 | 14052.2 | 14048.1 | 14050.1 | 102.0 |
| 2013-02-24 23:00:00 | YM | Futures | 14052.2 | 14052.2 | 14047.1 | 14048.1 | 75.0 |
| 2013-02-24 23:30:00 | YM | Futures | 14048.1 | 14056.2 | 14047.1 | 14054.2 | 132.0 |
| 2013-02-24 18:00:00 | CL | Futures | 148.13 | 148.29 | 147.97 | 148.24 | 798.0 |
| 2013-02-24 18:30:00 | CL | Futures | 148.21 | 148.25 | 148.16 | 148.19 | 211.0 |
| 2013-02-24 19:00:00 | CL | Futures | 148.21 | 148.22 | 148.0 | 148.05 | 393.0 |
| 2013-02-24 19:30:00 | CL | Futures | 148.05 | 148.05 | 147.95 | 147.98 | 394.0 |
| 2013-02-24 20:00:00 | CL | Futures | 147.98 | 148.1 | 147.86 | 148.03 | 618.0 |
| 2013-02-24 20:30:00 | CL | Futures | 148.03 | 148.08 | 147.78 | 147.78 | 701.0 |
| 2013-02-24 21:00:00 | CL | Futures | 147.79 | 147.84 | 147.7 | 147.78 | 509.0 |
| 2013-02-24 21:30:00 | CL | Futures | 147.76 | 147.84 | 147.73 | 147.81 | 316.0 |
| 2013-02-24 22:00:00 | CL | Futures | 147.83 | 147.87 | 147.78 | 147.81 | 129.0 |
| 2013-02-24 22:30:00 | CL | Futures | 147.79 | 147.84 | 147.78 | 147.79 | 102.0 |
| 2013-02-24 23:00:00 | CL | Futures | 147.81 | 147.9 | 147.78 | 147.87 | 192.0 |
| 2013-02-24 23:30:00 | CL | Futures | 147.89 | 147.9 | 147.83 | 147.83 | 258.0 |
| 2013-02-24 18:00:00 | GC | Futures | 2172.4 | 2173.7 | 2169.3 | 2170.9 | 1370.0 |
| 2013-02-24 18:30:00 | GC | Futures | 2170.9 | 2171.5 | 2170.0 | 2170.2 | 573.0 |
> showing 50 of 503 rows — these rows as CSV