PREVIEW / futures_30min / 2013-09-29
file: by_date/futures_30min/2013/2013-09-29.parquet size: 19 KB rows: 495
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-09-29 18:00:00 | ES | Futures | 1728.33 | 1728.85 | 1725.24 | 1727.04 | 23000.0 |
| 2013-09-29 18:30:00 | ES | Futures | 1727.04 | 1729.62 | 1726.79 | 1729.11 | 6992.0 |
| 2013-09-29 19:00:00 | ES | Futures | 1728.85 | 1729.37 | 1726.79 | 1727.56 | 4339.0 |
| 2013-09-29 19:30:00 | ES | Futures | 1727.56 | 1728.59 | 1726.79 | 1728.08 | 2599.0 |
| 2013-09-29 20:00:00 | ES | Futures | 1728.08 | 1728.08 | 1725.24 | 1725.76 | 5881.0 |
| 2013-09-29 20:30:00 | ES | Futures | 1725.5 | 1726.53 | 1724.47 | 1725.5 | 6109.0 |
| 2013-09-29 21:00:00 | ES | Futures | 1725.76 | 1726.79 | 1725.5 | 1726.01 | 2346.0 |
| 2013-09-29 21:30:00 | ES | Futures | 1726.27 | 1726.27 | 1724.98 | 1725.5 | 5150.0 |
| 2013-09-29 22:00:00 | ES | Futures | 1725.5 | 1727.56 | 1725.24 | 1727.3 | 2460.0 |
| 2013-09-29 22:30:00 | ES | Futures | 1727.56 | 1728.59 | 1726.79 | 1728.08 | 3595.0 |
| 2013-09-29 23:00:00 | ES | Futures | 1728.33 | 1728.33 | 1727.56 | 1728.33 | 1250.0 |
| 2013-09-29 23:30:00 | ES | Futures | 1728.33 | 1729.37 | 1728.33 | 1729.37 | 1896.0 |
| 2013-09-29 18:00:00 | NQ | Futures | 3730.9 | 3731.77 | 3721.02 | 3723.34 | 2119.0 |
| 2013-09-29 18:30:00 | NQ | Futures | 3723.34 | 3729.15 | 3723.05 | 3727.41 | 672.0 |
| 2013-09-29 19:00:00 | NQ | Futures | 3728.28 | 3728.86 | 3724.22 | 3724.8 | 345.0 |
| 2013-09-29 19:30:00 | NQ | Futures | 3725.67 | 3726.54 | 3723.34 | 3725.67 | 422.0 |
| 2013-09-29 20:00:00 | NQ | Futures | 3725.38 | 3725.67 | 3718.99 | 3719.86 | 949.0 |
| 2013-09-29 20:30:00 | NQ | Futures | 3719.86 | 3721.89 | 3717.83 | 3720.44 | 759.0 |
| 2013-09-29 21:00:00 | NQ | Futures | 3720.44 | 3722.47 | 3720.44 | 3721.02 | 290.0 |
| 2013-09-29 21:30:00 | NQ | Futures | 3721.6 | 3722.47 | 3719.28 | 3720.15 | 683.0 |
| 2013-09-29 22:00:00 | NQ | Futures | 3720.15 | 3725.67 | 3719.86 | 3725.09 | 652.0 |
| 2013-09-29 22:30:00 | NQ | Futures | 3725.09 | 3726.83 | 3723.93 | 3726.25 | 435.0 |
| 2013-09-29 23:00:00 | NQ | Futures | 3726.25 | 3726.83 | 3725.67 | 3725.96 | 99.0 |
| 2013-09-29 23:30:00 | NQ | Futures | 3726.25 | 3728.86 | 3726.25 | 3727.99 | 332.0 |
| 2013-09-29 18:00:00 | YM | Futures | 15438.2 | 15440.2 | 15397.3 | 15407.6 | 1780.0 |
| 2013-09-29 18:30:00 | YM | Futures | 15406.5 | 15420.8 | 15405.5 | 15415.7 | 904.0 |
| 2013-09-29 19:00:00 | YM | Futures | 15416.7 | 15417.8 | 15404.5 | 15409.6 | 471.0 |
| 2013-09-29 19:30:00 | YM | Futures | 15410.6 | 15414.7 | 15404.5 | 15411.6 | 397.0 |
| 2013-09-29 20:00:00 | YM | Futures | 15410.6 | 15412.7 | 15394.3 | 15398.4 | 783.0 |
| 2013-09-29 20:30:00 | YM | Futures | 15399.4 | 15402.4 | 15389.2 | 15395.3 | 677.0 |
| 2013-09-29 21:00:00 | YM | Futures | 15395.3 | 15402.4 | 15394.3 | 15399.4 | 257.0 |
| 2013-09-29 21:30:00 | YM | Futures | 15400.4 | 15400.4 | 15391.2 | 15393.3 | 657.0 |
| 2013-09-29 22:00:00 | YM | Futures | 15393.3 | 15410.6 | 15393.3 | 15410.6 | 460.0 |
| 2013-09-29 22:30:00 | YM | Futures | 15410.6 | 15416.7 | 15406.5 | 15413.7 | 445.0 |
| 2013-09-29 23:00:00 | YM | Futures | 15414.7 | 15414.7 | 15411.6 | 15413.7 | 166.0 |
| 2013-09-29 23:30:00 | YM | Futures | 15414.7 | 15424.9 | 15414.7 | 15421.9 | 304.0 |
| 2013-09-29 18:00:00 | CL | Futures | 162.91 | 163.04 | 161.86 | 162.24 | 3054.0 |
| 2013-09-29 18:30:00 | CL | Futures | 162.26 | 162.31 | 162.1 | 162.29 | 475.0 |
| 2013-09-29 19:00:00 | CL | Futures | 162.31 | 162.39 | 162.18 | 162.28 | 391.0 |
| 2013-09-29 19:30:00 | CL | Futures | 162.28 | 162.28 | 162.12 | 162.18 | 341.0 |
| 2013-09-29 20:00:00 | CL | Futures | 162.18 | 162.18 | 161.61 | 161.77 | 2192.0 |
| 2013-09-29 20:30:00 | CL | Futures | 161.77 | 161.81 | 161.31 | 161.42 | 2373.0 |
| 2013-09-29 21:00:00 | CL | Futures | 161.4 | 161.66 | 161.37 | 161.66 | 960.0 |
| 2013-09-29 21:30:00 | CL | Futures | 161.62 | 161.72 | 161.54 | 161.59 | 491.0 |
| 2013-09-29 22:00:00 | CL | Futures | 161.59 | 161.72 | 161.58 | 161.67 | 282.0 |
| 2013-09-29 22:30:00 | CL | Futures | 161.67 | 161.69 | 161.61 | 161.67 | 258.0 |
| 2013-09-29 23:00:00 | CL | Futures | 161.66 | 161.67 | 161.45 | 161.53 | 555.0 |
| 2013-09-29 23:30:00 | CL | Futures | 161.53 | 161.58 | 161.45 | 161.51 | 291.0 |
| 2013-09-29 18:00:00 | GC | Futures | 1841.6 | 1855.7 | 1830.8 | 1836.1 | 4689.0 |
| 2013-09-29 18:30:00 | GC | Futures | 1836.6 | 1838.3 | 1836.1 | 1837.5 | 387.0 |
> showing 50 of 495 rows — these rows as CSV