PREVIEW / futures_30min / 2013-08-25
file: by_date/futures_30min/2013/2013-08-25.parquet size: 18 KB rows: 450
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-08-25 18:00:00 | ES | Futures | 1717.18 | 1718.99 | 1716.92 | 1717.7 | 2538.0 |
| 2013-08-25 18:30:00 | ES | Futures | 1717.7 | 1717.7 | 1716.92 | 1717.18 | 423.0 |
| 2013-08-25 19:00:00 | ES | Futures | 1717.44 | 1717.96 | 1716.92 | 1717.96 | 670.0 |
| 2013-08-25 19:30:00 | ES | Futures | 1717.96 | 1717.96 | 1716.92 | 1716.92 | 779.0 |
| 2013-08-25 20:00:00 | ES | Futures | 1716.92 | 1717.96 | 1716.92 | 1717.44 | 1243.0 |
| 2013-08-25 20:30:00 | ES | Futures | 1717.44 | 1717.96 | 1717.18 | 1717.7 | 2374.0 |
| 2013-08-25 21:00:00 | ES | Futures | 1717.96 | 1717.96 | 1716.92 | 1717.44 | 1310.0 |
| 2013-08-25 21:30:00 | ES | Futures | 1717.18 | 1717.96 | 1716.92 | 1717.96 | 1216.0 |
| 2013-08-25 22:00:00 | ES | Futures | 1717.96 | 1717.96 | 1717.18 | 1717.44 | 885.0 |
| 2013-08-25 22:30:00 | ES | Futures | 1717.7 | 1718.99 | 1717.7 | 1718.73 | 1431.0 |
| 2013-08-25 23:00:00 | ES | Futures | 1718.73 | 1719.51 | 1718.47 | 1719.51 | 1683.0 |
| 2013-08-25 23:30:00 | ES | Futures | 1719.77 | 1722.35 | 1719.77 | 1722.09 | 6321.0 |
| 2013-08-25 18:00:00 | NQ | Futures | 3647.4 | 3651.19 | 3647.1 | 3649.15 | 235.0 |
| 2013-08-25 18:30:00 | NQ | Futures | 3648.86 | 3648.86 | 3647.69 | 3648.27 | 26.0 |
| 2013-08-25 19:00:00 | NQ | Futures | 3648.27 | 3649.15 | 3646.52 | 3649.15 | 158.0 |
| 2013-08-25 19:30:00 | NQ | Futures | 3649.15 | 3649.44 | 3647.69 | 3647.69 | 59.0 |
| 2013-08-25 20:00:00 | NQ | Futures | 3647.4 | 3649.44 | 3646.81 | 3647.98 | 141.0 |
| 2013-08-25 20:30:00 | NQ | Futures | 3647.98 | 3649.73 | 3647.98 | 3649.15 | 143.0 |
| 2013-08-25 21:00:00 | NQ | Futures | 3649.44 | 3649.44 | 3647.69 | 3647.98 | 152.0 |
| 2013-08-25 21:30:00 | NQ | Futures | 3647.69 | 3649.73 | 3647.4 | 3649.44 | 174.0 |
| 2013-08-25 22:00:00 | NQ | Futures | 3649.73 | 3650.03 | 3647.98 | 3648.86 | 113.0 |
| 2013-08-25 22:30:00 | NQ | Futures | 3649.15 | 3651.49 | 3648.86 | 3651.49 | 155.0 |
| 2013-08-25 23:00:00 | NQ | Futures | 3651.19 | 3652.66 | 3651.19 | 3652.66 | 161.0 |
| 2013-08-25 23:30:00 | NQ | Futures | 3652.95 | 3657.33 | 3652.95 | 3657.04 | 641.0 |
| 2013-08-25 18:00:00 | YM | Futures | 15220.0 | 15231.2 | 15212.9 | 15224.0 | 165.0 |
| 2013-08-25 18:30:00 | YM | Futures | 15223.0 | 15225.1 | 15219.0 | 15221.0 | 55.0 |
| 2013-08-25 19:00:00 | YM | Futures | 15220.0 | 15226.1 | 15218.0 | 15226.1 | 100.0 |
| 2013-08-25 19:30:00 | YM | Futures | 15226.1 | 15227.1 | 15220.0 | 15221.0 | 99.0 |
| 2013-08-25 20:00:00 | YM | Futures | 15220.0 | 15227.1 | 15219.0 | 15224.0 | 172.0 |
| 2013-08-25 20:30:00 | YM | Futures | 15223.0 | 15229.1 | 15222.0 | 15227.1 | 368.0 |
| 2013-08-25 21:00:00 | YM | Futures | 15228.1 | 15230.1 | 15221.0 | 15224.0 | 244.0 |
| 2013-08-25 21:30:00 | YM | Futures | 15223.0 | 15231.2 | 15221.0 | 15230.1 | 337.0 |
| 2013-08-25 22:00:00 | YM | Futures | 15230.1 | 15231.2 | 15225.1 | 15226.1 | 231.0 |
| 2013-08-25 22:30:00 | YM | Futures | 15227.1 | 15235.2 | 15225.1 | 15233.2 | 231.0 |
| 2013-08-25 23:00:00 | YM | Futures | 15233.2 | 15240.3 | 15233.2 | 15240.3 | 193.0 |
| 2013-08-25 23:30:00 | YM | Futures | 15241.3 | 15257.6 | 15241.3 | 15257.6 | 609.0 |
| 2013-08-25 18:00:00 | CL | Futures | 168.78 | 169.51 | 168.62 | 168.92 | 2554.0 |
| 2013-08-25 18:30:00 | CL | Futures | 168.97 | 168.99 | 168.72 | 168.81 | 247.0 |
| 2013-08-25 19:00:00 | CL | Futures | 168.8 | 168.97 | 168.8 | 168.94 | 252.0 |
| 2013-08-25 19:30:00 | CL | Futures | 168.94 | 169.24 | 168.92 | 169.21 | 401.0 |
| 2013-08-25 20:00:00 | CL | Futures | 169.22 | 169.29 | 168.89 | 168.99 | 486.0 |
| 2013-08-25 20:30:00 | CL | Futures | 168.97 | 169.08 | 168.81 | 169.05 | 444.0 |
| 2013-08-25 21:00:00 | CL | Futures | 169.02 | 169.1 | 168.75 | 168.83 | 447.0 |
| 2013-08-25 21:30:00 | CL | Futures | 168.84 | 168.84 | 168.58 | 168.69 | 468.0 |
| 2013-08-25 22:00:00 | CL | Futures | 168.67 | 168.78 | 168.56 | 168.73 | 418.0 |
| 2013-08-25 22:30:00 | CL | Futures | 168.77 | 168.91 | 168.69 | 168.86 | 188.0 |
| 2013-08-25 23:00:00 | CL | Futures | 168.83 | 169.02 | 168.81 | 168.92 | 451.0 |
| 2013-08-25 23:30:00 | CL | Futures | 168.95 | 169.02 | 168.88 | 168.97 | 133.0 |
| 2013-08-25 18:00:00 | GC | Futures | 1917.7 | 1918.3 | 1915.1 | 1916.5 | 1228.0 |
| 2013-08-25 18:30:00 | GC | Futures | 1916.3 | 1924.1 | 1915.5 | 1924.0 | 2857.0 |
> showing 50 of 450 rows — these rows as CSV