PREVIEW / futures_1hour / 2013-10-06
file: by_date/futures_1hour/2013/2013-10-06.parquet size: 14 KB rows: 262
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 | 1729.62 | 18260.0 |
| 2013-10-06 19:00:00 | ES | Futures | 1729.37 | 1730.4 | 1729.11 | 1729.88 | 3313.0 |
| 2013-10-06 20:00:00 | ES | Futures | 1730.14 | 1730.66 | 1728.85 | 1729.88 | 5244.0 |
| 2013-10-06 21:00:00 | ES | Futures | 1729.88 | 1730.14 | 1727.04 | 1727.56 | 7359.0 |
| 2013-10-06 22:00:00 | ES | Futures | 1727.56 | 1728.33 | 1726.27 | 1727.3 | 8061.0 |
| 2013-10-06 23:00:00 | ES | Futures | 1727.3 | 1727.3 | 1726.27 | 1727.04 | 3325.0 |
| 2013-10-06 18:00:00 | NQ | Futures | 3745.42 | 3747.74 | 3737.87 | 3744.55 | 2528.0 |
| 2013-10-06 19:00:00 | NQ | Futures | 3744.55 | 3746.87 | 3743.97 | 3746.0 | 529.0 |
| 2013-10-06 20:00:00 | NQ | Futures | 3745.71 | 3746.87 | 3743.38 | 3745.13 | 1074.0 |
| 2013-10-06 21:00:00 | NQ | Futures | 3744.84 | 3744.84 | 3739.03 | 3740.19 | 1370.0 |
| 2013-10-06 22:00:00 | NQ | Futures | 3740.19 | 3741.06 | 3737.87 | 3739.32 | 1338.0 |
| 2013-10-06 23:00:00 | NQ | Futures | 3739.32 | 3740.19 | 3738.45 | 3739.9 | 314.0 |
| 2013-10-06 18:00:00 | YM | Futures | 15257.4 | 15268.7 | 15228.8 | 15252.3 | 2400.0 |
| 2013-10-06 19:00:00 | YM | Futures | 15251.3 | 15262.5 | 15250.3 | 15259.5 | 603.0 |
| 2013-10-06 20:00:00 | YM | Futures | 15258.5 | 15260.5 | 15247.2 | 15257.4 | 762.0 |
| 2013-10-06 21:00:00 | YM | Futures | 15256.4 | 15256.4 | 15233.9 | 15238.0 | 876.0 |
| 2013-10-06 22:00:00 | YM | Futures | 15238.0 | 15245.2 | 15228.8 | 15237.0 | 954.0 |
| 2013-10-06 23:00:00 | YM | Futures | 15237.0 | 15238.0 | 15230.9 | 15237.0 | 375.0 |
| 2013-10-06 18:00:00 | CL | Futures | 164.49 | 164.58 | 164.26 | 164.45 | 621.0 |
| 2013-10-06 19:00:00 | CL | Futures | 164.45 | 164.71 | 164.44 | 164.52 | 366.0 |
| 2013-10-06 20:00:00 | CL | Futures | 164.52 | 164.55 | 164.42 | 164.42 | 347.0 |
| 2013-10-06 21:00:00 | CL | Futures | 164.45 | 164.45 | 164.14 | 164.22 | 766.0 |
| 2013-10-06 22:00:00 | CL | Futures | 164.2 | 164.39 | 164.18 | 164.34 | 312.0 |
| 2013-10-06 23:00:00 | CL | Futures | 164.33 | 164.39 | 164.25 | 164.28 | 363.0 |
| 2013-10-06 18:00:00 | GC | Futures | 1798.9 | 1804.2 | 1797.8 | 1804.2 | 1263.0 |
| 2013-10-06 19:00:00 | GC | Futures | 1803.8 | 1804.3 | 1800.8 | 1800.9 | 671.0 |
| 2013-10-06 20:00:00 | GC | Futures | 1800.8 | 1804.2 | 1799.7 | 1802.6 | 1015.0 |
| 2013-10-06 21:00:00 | GC | Futures | 1802.4 | 1803.2 | 1800.1 | 1800.8 | 1102.0 |
| 2013-10-06 22:00:00 | GC | Futures | 1800.8 | 1801.1 | 1798.0 | 1799.1 | 763.0 |
| 2013-10-06 23:00:00 | GC | Futures | 1799.0 | 1801.5 | 1798.7 | 1800.5 | 491.0 |
| 2013-10-06 18:00:00 | ZN | Futures | 115.429006 | 115.5147 | 115.429006 | 115.486135 | 5952.0 |
| 2013-10-06 19:00:00 | ZN | Futures | 115.486135 | 115.500418 | 115.457571 | 115.457571 | 3464.0 |
| 2013-10-06 20:00:00 | ZN | Futures | 115.471853 | 115.543264 | 115.457571 | 115.500418 | 8364.0 |
| 2013-10-06 21:00:00 | ZN | Futures | 115.5147 | 115.5147 | 115.471853 | 115.500418 | 5721.0 |
| 2013-10-06 22:00:00 | ZN | Futures | 115.500418 | 115.5147 | 115.486135 | 115.500418 | 2975.0 |
| 2013-10-06 23:00:00 | ZN | Futures | 115.5147 | 115.543264 | 115.486135 | 115.500418 | 3803.0 |
> showing 36 of 262 rows — these rows as CSV