PREVIEW / futures_30min / 2013-11-24
file: by_date/futures_30min/2013/2013-11-24.parquet size: 19 KB rows: 493
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-11-24 18:00:00 | ES | Futures | 1859.38 | 1864.54 | 1858.35 | 1864.02 | 14477.0 |
| 2013-11-24 18:30:00 | ES | Futures | 1864.28 | 1866.6 | 1863.76 | 1864.02 | 11149.0 |
| 2013-11-24 19:00:00 | ES | Futures | 1864.28 | 1864.8 | 1863.51 | 1864.8 | 3942.0 |
| 2013-11-24 19:30:00 | ES | Futures | 1864.8 | 1866.86 | 1864.54 | 1866.34 | 7296.0 |
| 2013-11-24 20:00:00 | ES | Futures | 1866.09 | 1866.6 | 1864.28 | 1864.54 | 5027.0 |
| 2013-11-24 20:30:00 | ES | Futures | 1864.54 | 1865.05 | 1864.28 | 1864.54 | 3162.0 |
| 2013-11-24 21:00:00 | ES | Futures | 1864.54 | 1864.8 | 1864.02 | 1864.02 | 1980.0 |
| 2013-11-24 21:30:00 | ES | Futures | 1864.02 | 1864.54 | 1863.76 | 1864.02 | 974.0 |
| 2013-11-24 22:00:00 | ES | Futures | 1864.02 | 1864.28 | 1863.76 | 1864.02 | 583.0 |
| 2013-11-24 22:30:00 | ES | Futures | 1864.02 | 1864.28 | 1863.25 | 1863.51 | 2064.0 |
| 2013-11-24 23:00:00 | ES | Futures | 1863.25 | 1863.51 | 1862.73 | 1863.25 | 1131.0 |
| 2013-11-24 23:30:00 | ES | Futures | 1863.25 | 1863.76 | 1862.73 | 1863.25 | 1494.0 |
| 2013-11-24 18:00:00 | NQ | Futures | 3976.02 | 3984.44 | 3973.41 | 3983.57 | 1807.0 |
| 2013-11-24 18:30:00 | NQ | Futures | 3984.44 | 3990.54 | 3983.57 | 3985.61 | 1185.0 |
| 2013-11-24 19:00:00 | NQ | Futures | 3986.19 | 3987.64 | 3984.44 | 3987.06 | 581.0 |
| 2013-11-24 19:30:00 | NQ | Futures | 3987.35 | 3991.12 | 3987.35 | 3989.96 | 678.0 |
| 2013-11-24 20:00:00 | NQ | Futures | 3989.96 | 3990.83 | 3985.02 | 3985.61 | 670.0 |
| 2013-11-24 20:30:00 | NQ | Futures | 3985.61 | 3986.48 | 3985.02 | 3985.61 | 352.0 |
| 2013-11-24 21:00:00 | NQ | Futures | 3985.61 | 3985.9 | 3983.86 | 3984.44 | 328.0 |
| 2013-11-24 21:30:00 | NQ | Futures | 3984.44 | 3985.61 | 3984.15 | 3985.31 | 170.0 |
| 2013-11-24 22:00:00 | NQ | Futures | 3985.31 | 3985.9 | 3984.73 | 3985.61 | 94.0 |
| 2013-11-24 22:30:00 | NQ | Futures | 3985.61 | 3986.19 | 3983.57 | 3984.73 | 336.0 |
| 2013-11-24 23:00:00 | NQ | Futures | 3984.73 | 3984.73 | 3983.28 | 3984.44 | 126.0 |
| 2013-11-24 23:30:00 | NQ | Futures | 3984.15 | 3985.02 | 3983.28 | 3984.44 | 120.0 |
| 2013-11-24 18:00:00 | YM | Futures | 16378.8 | 16421.7 | 16368.5 | 16421.7 | 1977.0 |
| 2013-11-24 18:30:00 | YM | Futures | 16419.6 | 16442.1 | 16415.5 | 16421.7 | 1539.0 |
| 2013-11-24 19:00:00 | YM | Futures | 16422.7 | 16426.8 | 16418.6 | 16423.7 | 498.0 |
| 2013-11-24 19:30:00 | YM | Futures | 16425.7 | 16441.1 | 16425.7 | 16437.0 | 1004.0 |
| 2013-11-24 20:00:00 | YM | Futures | 16437.0 | 16440.0 | 16419.6 | 16423.7 | 844.0 |
| 2013-11-24 20:30:00 | YM | Futures | 16422.7 | 16428.8 | 16419.6 | 16420.6 | 538.0 |
| 2013-11-24 21:00:00 | YM | Futures | 16421.7 | 16423.7 | 16419.6 | 16420.6 | 252.0 |
| 2013-11-24 21:30:00 | YM | Futures | 16420.6 | 16423.7 | 16419.6 | 16419.6 | 169.0 |
| 2013-11-24 22:00:00 | YM | Futures | 16419.6 | 16421.7 | 16418.6 | 16419.6 | 154.0 |
| 2013-11-24 22:30:00 | YM | Futures | 16420.6 | 16421.7 | 16411.4 | 16413.5 | 282.0 |
| 2013-11-24 23:00:00 | YM | Futures | 16413.5 | 16415.5 | 16409.4 | 16415.5 | 174.0 |
| 2013-11-24 23:30:00 | YM | Futures | 16414.5 | 16417.6 | 16409.4 | 16415.5 | 173.0 |
| 2013-11-24 18:00:00 | CL | Futures | 148.78 | 148.84 | 147.98 | 148.53 | 5202.0 |
| 2013-11-24 18:30:00 | CL | Futures | 148.53 | 148.7 | 148.5 | 148.69 | 588.0 |
| 2013-11-24 19:00:00 | CL | Futures | 148.67 | 148.8 | 148.54 | 148.59 | 609.0 |
| 2013-11-24 19:30:00 | CL | Futures | 148.59 | 148.62 | 148.4 | 148.42 | 545.0 |
| 2013-11-24 20:00:00 | CL | Futures | 148.45 | 148.65 | 148.42 | 148.54 | 692.0 |
| 2013-11-24 20:30:00 | CL | Futures | 148.54 | 148.59 | 148.43 | 148.47 | 400.0 |
| 2013-11-24 21:00:00 | CL | Futures | 148.47 | 148.59 | 148.34 | 148.56 | 567.0 |
| 2013-11-24 21:30:00 | CL | Futures | 148.56 | 148.65 | 148.48 | 148.59 | 524.0 |
| 2013-11-24 22:00:00 | CL | Futures | 148.61 | 148.69 | 148.51 | 148.62 | 418.0 |
| 2013-11-24 22:30:00 | CL | Futures | 148.61 | 148.62 | 148.51 | 148.58 | 173.0 |
| 2013-11-24 23:00:00 | CL | Futures | 148.56 | 148.69 | 148.54 | 148.65 | 174.0 |
| 2013-11-24 23:30:00 | CL | Futures | 148.65 | 148.67 | 148.42 | 148.43 | 400.0 |
| 2013-11-24 18:00:00 | GC | Futures | 1701.9 | 1702.8 | 1695.2 | 1699.8 | 3409.0 |
| 2013-11-24 18:30:00 | GC | Futures | 1699.8 | 1704.0 | 1699.3 | 1699.8 | 1204.0 |
> showing 50 of 493 rows — these rows as CSV