PREVIEW / futures_30min / 2013-07-28
file: by_date/futures_30min/2013/2013-07-28.parquet size: 20 KB rows: 505
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-07-28 18:00:00 | ES | Futures | 1743.81 | 1745.36 | 1743.29 | 1744.58 | 3289.0 |
| 2013-07-28 18:30:00 | ES | Futures | 1744.32 | 1745.1 | 1744.32 | 1744.84 | 601.0 |
| 2013-07-28 19:00:00 | ES | Futures | 1744.84 | 1744.84 | 1743.81 | 1743.81 | 952.0 |
| 2013-07-28 19:30:00 | ES | Futures | 1743.81 | 1744.58 | 1743.55 | 1744.06 | 1149.0 |
| 2013-07-28 20:00:00 | ES | Futures | 1743.81 | 1744.58 | 1743.55 | 1744.32 | 2641.0 |
| 2013-07-28 20:30:00 | ES | Futures | 1744.06 | 1744.84 | 1743.55 | 1744.32 | 1422.0 |
| 2013-07-28 21:00:00 | ES | Futures | 1744.32 | 1744.58 | 1743.29 | 1744.32 | 1824.0 |
| 2013-07-28 21:30:00 | ES | Futures | 1744.06 | 1744.32 | 1742.0 | 1742.51 | 3526.0 |
| 2013-07-28 22:00:00 | ES | Futures | 1742.26 | 1743.55 | 1741.22 | 1742.26 | 3230.0 |
| 2013-07-28 22:30:00 | ES | Futures | 1742.26 | 1743.03 | 1742.0 | 1742.0 | 1298.0 |
| 2013-07-28 23:00:00 | ES | Futures | 1742.0 | 1742.26 | 1739.93 | 1739.93 | 3464.0 |
| 2013-07-28 23:30:00 | ES | Futures | 1739.93 | 1740.45 | 1739.41 | 1739.93 | 3121.0 |
| 2013-07-28 18:00:00 | NQ | Futures | 3588.66 | 3592.46 | 3588.66 | 3591.58 | 339.0 |
| 2013-07-28 18:30:00 | NQ | Futures | 3591.58 | 3592.75 | 3591.29 | 3592.16 | 183.0 |
| 2013-07-28 19:00:00 | NQ | Futures | 3592.46 | 3592.46 | 3589.83 | 3589.83 | 84.0 |
| 2013-07-28 19:30:00 | NQ | Futures | 3590.12 | 3591.58 | 3589.53 | 3589.83 | 125.0 |
| 2013-07-28 20:00:00 | NQ | Futures | 3589.83 | 3590.7 | 3588.66 | 3590.41 | 494.0 |
| 2013-07-28 20:30:00 | NQ | Futures | 3590.41 | 3591.58 | 3588.95 | 3591.58 | 319.0 |
| 2013-07-28 21:00:00 | NQ | Futures | 3591.58 | 3591.58 | 3589.24 | 3590.12 | 217.0 |
| 2013-07-28 21:30:00 | NQ | Futures | 3590.7 | 3591.29 | 3587.2 | 3587.49 | 586.0 |
| 2013-07-28 22:00:00 | NQ | Futures | 3588.07 | 3590.99 | 3586.03 | 3588.07 | 644.0 |
| 2013-07-28 22:30:00 | NQ | Futures | 3588.36 | 3588.95 | 3587.49 | 3587.49 | 147.0 |
| 2013-07-28 23:00:00 | NQ | Futures | 3587.78 | 3587.78 | 3583.69 | 3583.69 | 348.0 |
| 2013-07-28 23:30:00 | NQ | Futures | 3583.4 | 3584.27 | 3582.81 | 3583.69 | 352.0 |
| 2013-07-28 18:00:00 | YM | Futures | 15736.0 | 15747.1 | 15732.9 | 15744.1 | 325.0 |
| 2013-07-28 18:30:00 | YM | Futures | 15743.1 | 15748.1 | 15743.1 | 15745.1 | 104.0 |
| 2013-07-28 19:00:00 | YM | Futures | 15745.1 | 15746.1 | 15737.0 | 15738.0 | 170.0 |
| 2013-07-28 19:30:00 | YM | Futures | 15738.0 | 15743.1 | 15734.9 | 15736.0 | 193.0 |
| 2013-07-28 20:00:00 | YM | Futures | 15736.0 | 15741.0 | 15732.9 | 15740.0 | 406.0 |
| 2013-07-28 20:30:00 | YM | Futures | 15739.0 | 15744.1 | 15733.9 | 15744.1 | 327.0 |
| 2013-07-28 21:00:00 | YM | Futures | 15742.0 | 15743.1 | 15736.0 | 15740.0 | 350.0 |
| 2013-07-28 21:30:00 | YM | Futures | 15741.0 | 15742.0 | 15724.8 | 15726.8 | 697.0 |
| 2013-07-28 22:00:00 | YM | Futures | 15726.8 | 15737.0 | 15719.7 | 15728.8 | 664.0 |
| 2013-07-28 22:30:00 | YM | Futures | 15728.8 | 15734.9 | 15726.8 | 15727.8 | 340.0 |
| 2013-07-28 23:00:00 | YM | Futures | 15728.8 | 15728.8 | 15710.6 | 15710.6 | 639.0 |
| 2013-07-28 23:30:00 | YM | Futures | 15710.6 | 15715.6 | 15708.5 | 15709.5 | 435.0 |
| 2013-07-28 18:00:00 | CL | Futures | 164.44 | 164.88 | 163.95 | 164.31 | 1476.0 |
| 2013-07-28 18:30:00 | CL | Futures | 164.33 | 164.47 | 164.33 | 164.39 | 157.0 |
| 2013-07-28 19:00:00 | CL | Futures | 164.39 | 164.51 | 164.39 | 164.5 | 275.0 |
| 2013-07-28 19:30:00 | CL | Futures | 164.48 | 164.5 | 164.29 | 164.33 | 176.0 |
| 2013-07-28 20:00:00 | CL | Futures | 164.36 | 164.42 | 164.31 | 164.34 | 245.0 |
| 2013-07-28 20:30:00 | CL | Futures | 164.33 | 164.61 | 164.33 | 164.56 | 385.0 |
| 2013-07-28 21:00:00 | CL | Futures | 164.56 | 164.61 | 164.37 | 164.4 | 469.0 |
| 2013-07-28 21:30:00 | CL | Futures | 164.42 | 164.53 | 164.23 | 164.25 | 453.0 |
| 2013-07-28 22:00:00 | CL | Futures | 164.23 | 164.26 | 164.01 | 164.09 | 702.0 |
| 2013-07-28 22:30:00 | CL | Futures | 164.07 | 164.15 | 164.03 | 164.14 | 245.0 |
| 2013-07-28 23:00:00 | CL | Futures | 164.14 | 164.22 | 163.9 | 163.96 | 473.0 |
| 2013-07-28 23:30:00 | CL | Futures | 163.95 | 164.0 | 163.89 | 163.9 | 361.0 |
| 2013-07-28 18:00:00 | GC | Futures | 1827.9 | 1829.0 | 1827.2 | 1828.5 | 368.0 |
| 2013-07-28 18:30:00 | GC | Futures | 1828.6 | 1830.0 | 1827.4 | 1827.4 | 119.0 |
> showing 50 of 505 rows — these rows as CSV