PREVIEW / futures_30min / 2013-10-06
file: by_date/futures_30min/2013/2013-10-06.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-10-06 18:00:00 | ES | Futures | 1730.14 | 1731.69 | 1726.53 | 1730.91 | 14436.0 |
| 2013-10-06 18:30:00 | ES | Futures | 1730.91 | 1731.43 | 1729.37 | 1729.62 | 3824.0 |
| 2013-10-06 19:00:00 | ES | Futures | 1729.37 | 1730.4 | 1729.37 | 1730.4 | 1126.0 |
| 2013-10-06 19:30:00 | ES | Futures | 1730.4 | 1730.4 | 1729.11 | 1729.88 | 2187.0 |
| 2013-10-06 20:00:00 | ES | Futures | 1730.14 | 1730.4 | 1728.85 | 1730.14 | 3518.0 |
| 2013-10-06 20:30:00 | ES | Futures | 1730.4 | 1730.66 | 1729.37 | 1729.88 | 1726.0 |
| 2013-10-06 21:00:00 | ES | Futures | 1729.88 | 1730.14 | 1729.11 | 1729.62 | 2038.0 |
| 2013-10-06 21:30:00 | ES | Futures | 1729.62 | 1729.88 | 1727.04 | 1727.56 | 5321.0 |
| 2013-10-06 22:00:00 | ES | Futures | 1727.56 | 1728.33 | 1726.79 | 1727.3 | 5386.0 |
| 2013-10-06 22:30:00 | ES | Futures | 1727.3 | 1727.3 | 1726.27 | 1727.3 | 2675.0 |
| 2013-10-06 23:00:00 | ES | Futures | 1727.3 | 1727.3 | 1727.04 | 1727.3 | 921.0 |
| 2013-10-06 23:30:00 | ES | Futures | 1727.04 | 1727.3 | 1726.27 | 1727.04 | 2404.0 |
| 2013-10-06 18:00:00 | NQ | Futures | 3745.42 | 3747.74 | 3737.87 | 3746.29 | 1933.0 |
| 2013-10-06 18:30:00 | NQ | Futures | 3746.29 | 3746.87 | 3744.26 | 3744.55 | 595.0 |
| 2013-10-06 19:00:00 | NQ | Futures | 3744.55 | 3746.29 | 3743.97 | 3746.29 | 224.0 |
| 2013-10-06 19:30:00 | NQ | Futures | 3746.0 | 3746.87 | 3744.26 | 3746.0 | 305.0 |
| 2013-10-06 20:00:00 | NQ | Futures | 3745.71 | 3746.58 | 3743.38 | 3746.29 | 690.0 |
| 2013-10-06 20:30:00 | NQ | Futures | 3746.58 | 3746.87 | 3744.55 | 3745.13 | 384.0 |
| 2013-10-06 21:00:00 | NQ | Futures | 3744.84 | 3744.84 | 3743.09 | 3743.97 | 465.0 |
| 2013-10-06 21:30:00 | NQ | Futures | 3743.97 | 3744.26 | 3739.03 | 3740.19 | 905.0 |
| 2013-10-06 22:00:00 | NQ | Futures | 3740.19 | 3741.06 | 3738.45 | 3739.03 | 907.0 |
| 2013-10-06 22:30:00 | NQ | Futures | 3739.32 | 3740.48 | 3737.87 | 3739.32 | 431.0 |
| 2013-10-06 23:00:00 | NQ | Futures | 3739.32 | 3739.9 | 3739.32 | 3739.9 | 53.0 |
| 2013-10-06 23:30:00 | NQ | Futures | 3739.32 | 3740.19 | 3738.45 | 3739.9 | 261.0 |
| 2013-10-06 18:00:00 | YM | Futures | 15257.4 | 15268.7 | 15228.8 | 15263.6 | 2107.0 |
| 2013-10-06 18:30:00 | YM | Futures | 15264.6 | 15265.6 | 15252.3 | 15252.3 | 293.0 |
| 2013-10-06 19:00:00 | YM | Futures | 15251.3 | 15261.5 | 15250.3 | 15259.5 | 288.0 |
| 2013-10-06 19:30:00 | YM | Futures | 15259.5 | 15262.5 | 15253.3 | 15259.5 | 315.0 |
| 2013-10-06 20:00:00 | YM | Futures | 15258.5 | 15259.5 | 15247.2 | 15259.5 | 533.0 |
| 2013-10-06 20:30:00 | YM | Futures | 15259.5 | 15260.5 | 15253.3 | 15257.4 | 229.0 |
| 2013-10-06 21:00:00 | YM | Futures | 15256.4 | 15256.4 | 15250.3 | 15252.3 | 292.0 |
| 2013-10-06 21:30:00 | YM | Futures | 15253.3 | 15254.4 | 15233.9 | 15238.0 | 584.0 |
| 2013-10-06 22:00:00 | YM | Futures | 15238.0 | 15245.2 | 15230.9 | 15237.0 | 683.0 |
| 2013-10-06 22:30:00 | YM | Futures | 15238.0 | 15239.0 | 15228.8 | 15237.0 | 271.0 |
| 2013-10-06 23:00:00 | YM | Futures | 15237.0 | 15238.0 | 15236.0 | 15237.0 | 107.0 |
| 2013-10-06 23:30:00 | YM | Futures | 15236.0 | 15238.0 | 15230.9 | 15237.0 | 268.0 |
| 2013-10-06 18:00:00 | CL | Futures | 164.49 | 164.58 | 164.26 | 164.42 | 542.0 |
| 2013-10-06 18:30:00 | CL | Futures | 164.44 | 164.47 | 164.44 | 164.45 | 79.0 |
| 2013-10-06 19:00:00 | CL | Futures | 164.45 | 164.58 | 164.44 | 164.55 | 191.0 |
| 2013-10-06 19:30:00 | CL | Futures | 164.52 | 164.71 | 164.52 | 164.52 | 175.0 |
| 2013-10-06 20:00:00 | CL | Futures | 164.52 | 164.55 | 164.47 | 164.5 | 243.0 |
| 2013-10-06 20:30:00 | CL | Futures | 164.53 | 164.55 | 164.42 | 164.42 | 104.0 |
| 2013-10-06 21:00:00 | CL | Futures | 164.45 | 164.45 | 164.2 | 164.29 | 459.0 |
| 2013-10-06 21:30:00 | CL | Futures | 164.28 | 164.31 | 164.14 | 164.22 | 307.0 |
| 2013-10-06 22:00:00 | CL | Futures | 164.2 | 164.29 | 164.18 | 164.23 | 145.0 |
| 2013-10-06 22:30:00 | CL | Futures | 164.25 | 164.39 | 164.22 | 164.34 | 167.0 |
| 2013-10-06 23:00:00 | CL | Futures | 164.33 | 164.36 | 164.25 | 164.36 | 238.0 |
| 2013-10-06 23:30:00 | CL | Futures | 164.36 | 164.39 | 164.28 | 164.28 | 125.0 |
| 2013-10-06 18:00:00 | GC | Futures | 1798.9 | 1802.8 | 1797.8 | 1801.2 | 856.0 |
| 2013-10-06 18:30:00 | GC | Futures | 1801.3 | 1804.2 | 1800.8 | 1804.2 | 407.0 |
> showing 50 of 493 rows — these rows as CSV