PREVIEW / futures_1hour / 2013-10-13
file: by_date/futures_1hour/2013/2013-10-13.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-13 18:00:00 | ES | Futures | 1737.62 | 1740.72 | 1734.78 | 1735.3 | 54694.0 |
| 2013-10-13 19:00:00 | ES | Futures | 1735.3 | 1741.75 | 1734.27 | 1741.75 | 11076.0 |
| 2013-10-13 20:00:00 | ES | Futures | 1741.75 | 1741.75 | 1737.36 | 1738.4 | 10918.0 |
| 2013-10-13 21:00:00 | ES | Futures | 1738.65 | 1742.01 | 1737.88 | 1740.97 | 5579.0 |
| 2013-10-13 22:00:00 | ES | Futures | 1740.97 | 1741.75 | 1738.65 | 1739.69 | 4786.0 |
| 2013-10-13 23:00:00 | ES | Futures | 1739.43 | 1741.49 | 1739.43 | 1741.23 | 1598.0 |
| 2013-10-13 18:00:00 | NQ | Futures | 3723.34 | 3724.51 | 3711.73 | 3715.21 | 6076.0 |
| 2013-10-13 19:00:00 | NQ | Futures | 3715.21 | 3729.44 | 3714.05 | 3729.44 | 1426.0 |
| 2013-10-13 20:00:00 | NQ | Futures | 3729.44 | 3729.44 | 3721.31 | 3723.64 | 1388.0 |
| 2013-10-13 21:00:00 | NQ | Futures | 3723.93 | 3732.35 | 3721.02 | 3729.44 | 1736.0 |
| 2013-10-13 22:00:00 | NQ | Futures | 3729.44 | 3730.9 | 3724.8 | 3727.12 | 813.0 |
| 2013-10-13 23:00:00 | NQ | Futures | 3727.12 | 3730.9 | 3726.83 | 3730.9 | 322.0 |
| 2013-10-13 18:00:00 | YM | Futures | 15398.4 | 15404.5 | 15358.5 | 15362.6 | 4427.0 |
| 2013-10-13 19:00:00 | YM | Futures | 15363.6 | 15412.7 | 15356.5 | 15412.7 | 1280.0 |
| 2013-10-13 20:00:00 | YM | Futures | 15411.6 | 15412.7 | 15381.0 | 15387.1 | 2072.0 |
| 2013-10-13 21:00:00 | YM | Futures | 15387.1 | 15413.7 | 15383.0 | 15404.5 | 1559.0 |
| 2013-10-13 22:00:00 | YM | Futures | 15404.5 | 15410.6 | 15386.1 | 15394.3 | 752.0 |
| 2013-10-13 23:00:00 | YM | Futures | 15395.3 | 15404.5 | 15393.3 | 15404.5 | 265.0 |
| 2013-10-13 18:00:00 | CL | Futures | 161.18 | 161.45 | 160.92 | 161.24 | 997.0 |
| 2013-10-13 19:00:00 | CL | Futures | 161.24 | 161.39 | 161.23 | 161.29 | 184.0 |
| 2013-10-13 20:00:00 | CL | Futures | 161.31 | 161.54 | 161.29 | 161.5 | 344.0 |
| 2013-10-13 21:00:00 | CL | Futures | 161.5 | 161.97 | 161.48 | 161.78 | 940.0 |
| 2013-10-13 22:00:00 | CL | Futures | 161.78 | 162.13 | 161.78 | 161.89 | 981.0 |
| 2013-10-13 23:00:00 | CL | Futures | 161.89 | 162.02 | 161.88 | 162.01 | 290.0 |
| 2013-10-13 18:00:00 | GC | Futures | 1748.4 | 1753.6 | 1744.0 | 1747.0 | 3787.0 |
| 2013-10-13 19:00:00 | GC | Futures | 1747.0 | 1747.7 | 1744.3 | 1744.4 | 800.0 |
| 2013-10-13 20:00:00 | GC | Futures | 1744.4 | 1746.2 | 1742.8 | 1744.9 | 1650.0 |
| 2013-10-13 21:00:00 | GC | Futures | 1744.7 | 1744.7 | 1738.7 | 1740.9 | 5014.0 |
| 2013-10-13 22:00:00 | GC | Futures | 1740.7 | 1743.9 | 1739.8 | 1743.5 | 2133.0 |
| 2013-10-13 23:00:00 | GC | Futures | 1743.6 | 1744.7 | 1740.7 | 1741.6 | 1299.0 |
| 2013-10-13 18:00:00 | ZN | Futures | 115.486135 | 115.500418 | 115.38616 | 115.443289 | 10287.0 |
| 2013-10-13 19:00:00 | ZN | Futures | 115.443289 | 115.457571 | 115.38616 | 115.38616 | 3824.0 |
| 2013-10-13 20:00:00 | ZN | Futures | 115.38616 | 115.429006 | 115.343313 | 115.414724 | 3860.0 |
| 2013-10-13 21:00:00 | ZN | Futures | 115.400442 | 115.429006 | 115.400442 | 115.400442 | 2187.0 |
| 2013-10-13 22:00:00 | ZN | Futures | 115.38616 | 115.400442 | 115.38616 | 115.38616 | 1168.0 |
| 2013-10-13 23:00:00 | ZN | Futures | 115.38616 | 115.38616 | 115.357595 | 115.38616 | 1262.0 |
> showing 36 of 262 rows — these rows as CSV