PREVIEW / futures_1hour / 2014-09-28
file: by_date/futures_1hour/2014/2014-09-28.parquet size: 14 KB rows: 286
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-28 18:00:00 | ES | Futures | 2069.28 | 2069.8 | 2066.92 | 2067.97 | 5468.0 |
| 2014-09-28 19:00:00 | ES | Futures | 2068.23 | 2068.23 | 2065.87 | 2066.14 | 4363.0 |
| 2014-09-28 20:00:00 | ES | Futures | 2066.4 | 2068.49 | 2066.14 | 2067.97 | 5726.0 |
| 2014-09-28 21:00:00 | ES | Futures | 2067.97 | 2071.64 | 2067.45 | 2070.33 | 7697.0 |
| 2014-09-28 22:00:00 | ES | Futures | 2070.33 | 2070.33 | 2065.09 | 2066.14 | 8416.0 |
| 2014-09-28 23:00:00 | ES | Futures | 2066.14 | 2066.92 | 2064.56 | 2064.83 | 4730.0 |
| 2014-09-28 18:00:00 | NQ | Futures | 4741.71 | 4742.0 | 4734.09 | 4736.44 | 955.0 |
| 2014-09-28 19:00:00 | NQ | Futures | 4736.73 | 4737.02 | 4732.92 | 4733.21 | 519.0 |
| 2014-09-28 20:00:00 | NQ | Futures | 4733.8 | 4738.2 | 4733.8 | 4736.73 | 684.0 |
| 2014-09-28 21:00:00 | NQ | Futures | 4736.44 | 4748.16 | 4735.85 | 4743.76 | 1368.0 |
| 2014-09-28 22:00:00 | NQ | Futures | 4743.76 | 4743.76 | 4732.04 | 4734.09 | 1458.0 |
| 2014-09-28 23:00:00 | NQ | Futures | 4734.09 | 4735.85 | 4729.99 | 4730.28 | 932.0 |
| 2014-09-28 18:00:00 | YM | Futures | 17716.5 | 17716.5 | 17686.4 | 17692.6 | 703.0 |
| 2014-09-28 19:00:00 | YM | Futures | 17693.7 | 17693.7 | 17680.1 | 17680.1 | 392.0 |
| 2014-09-28 20:00:00 | YM | Futures | 17680.1 | 17694.7 | 17679.1 | 17684.3 | 1212.0 |
| 2014-09-28 21:00:00 | YM | Futures | 17685.3 | 17713.4 | 17682.2 | 17703.0 | 1704.0 |
| 2014-09-28 22:00:00 | YM | Futures | 17703.0 | 17703.0 | 17660.4 | 17669.7 | 1733.0 |
| 2014-09-28 23:00:00 | YM | Futures | 17668.7 | 17672.9 | 17655.2 | 17657.3 | 452.0 |
| 2014-09-28 18:00:00 | CL | Futures | 155.51 | 155.63 | 154.86 | 155.04 | 1548.0 |
| 2014-09-28 19:00:00 | CL | Futures | 155.03 | 155.04 | 154.79 | 154.86 | 842.0 |
| 2014-09-28 20:00:00 | CL | Futures | 154.86 | 154.99 | 154.81 | 154.89 | 1157.0 |
| 2014-09-28 21:00:00 | CL | Futures | 154.88 | 155.06 | 154.78 | 154.94 | 1059.0 |
| 2014-09-28 22:00:00 | CL | Futures | 154.94 | 154.99 | 154.78 | 154.83 | 925.0 |
| 2014-09-28 23:00:00 | CL | Futures | 154.81 | 154.96 | 154.81 | 154.86 | 484.0 |
| 2014-09-28 18:00:00 | GC | Futures | 1668.9 | 1669.7 | 1665.1 | 1666.7 | 1251.0 |
| 2014-09-28 19:00:00 | GC | Futures | 1666.6 | 1667.9 | 1665.6 | 1666.4 | 353.0 |
| 2014-09-28 20:00:00 | GC | Futures | 1666.3 | 1670.0 | 1665.7 | 1668.3 | 1840.0 |
| 2014-09-28 21:00:00 | GC | Futures | 1668.3 | 1669.4 | 1666.1 | 1669.4 | 3684.0 |
| 2014-09-28 22:00:00 | GC | Futures | 1669.4 | 1669.7 | 1668.5 | 1668.7 | 1698.0 |
| 2014-09-28 23:00:00 | GC | Futures | 1668.7 | 1669.0 | 1667.2 | 1668.6 | 1482.0 |
| 2014-09-28 18:00:00 | ZN | Futures | 117.81738 | 117.846952 | 117.81738 | 117.832166 | 4081.0 |
| 2014-09-28 19:00:00 | ZN | Futures | 117.832166 | 117.846952 | 117.832166 | 117.832166 | 3456.0 |
| 2014-09-28 20:00:00 | ZN | Futures | 117.832166 | 117.846952 | 117.832166 | 117.846952 | 4734.0 |
| 2014-09-28 21:00:00 | ZN | Futures | 117.846952 | 117.846952 | 117.773021 | 117.802593 | 9180.0 |
| 2014-09-28 22:00:00 | ZN | Futures | 117.802593 | 117.846952 | 117.802593 | 117.81738 | 3686.0 |
| 2014-09-28 23:00:00 | ZN | Futures | 117.81738 | 117.846952 | 117.802593 | 117.832166 | 2133.0 |
> showing 36 of 286 rows — these rows as CSV