PREVIEW / futures_1hour / 2013-02-11
file: by_date/futures_1hour/2013/2013-02-11.parquet size: 48 KB rows: 1,486
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-02-11 00:00:00 | ES | Futures | 1552.89 | 1553.15 | 1552.12 | 1552.38 | 2070.0 |
| 2013-02-11 01:00:00 | ES | Futures | 1552.38 | 1553.4 | 1552.38 | 1552.89 | 1120.0 |
| 2013-02-11 02:00:00 | ES | Futures | 1552.89 | 1553.15 | 1552.12 | 1552.63 | 4896.0 |
| 2013-02-11 03:00:00 | ES | Futures | 1552.63 | 1553.92 | 1551.86 | 1553.92 | 21591.0 |
| 2013-02-11 04:00:00 | ES | Futures | 1553.92 | 1556.99 | 1553.15 | 1556.48 | 27155.0 |
| 2013-02-11 05:00:00 | ES | Futures | 1556.22 | 1556.74 | 1554.94 | 1555.71 | 11488.0 |
| 2013-02-11 06:00:00 | ES | Futures | 1555.71 | 1555.71 | 1554.17 | 1555.2 | 9313.0 |
| 2013-02-11 07:00:00 | ES | Futures | 1555.2 | 1556.22 | 1554.43 | 1555.97 | 16531.0 |
| 2013-02-11 08:00:00 | ES | Futures | 1556.22 | 1556.48 | 1552.38 | 1553.4 | 41688.0 |
| 2013-02-11 09:00:00 | ES | Futures | 1553.4 | 1554.17 | 1550.58 | 1551.86 | 217035.0 |
| 2013-02-11 10:00:00 | ES | Futures | 1551.86 | 1553.66 | 1549.55 | 1553.15 | 256819.0 |
| 2013-02-11 11:00:00 | ES | Futures | 1553.4 | 1554.43 | 1552.89 | 1553.66 | 146670.0 |
| 2013-02-11 12:00:00 | ES | Futures | 1553.66 | 1553.92 | 1550.58 | 1552.12 | 107132.0 |
| 2013-02-11 13:00:00 | ES | Futures | 1552.12 | 1553.4 | 1551.09 | 1551.86 | 57785.0 |
| 2013-02-11 14:00:00 | ES | Futures | 1551.86 | 1553.15 | 1551.35 | 1551.61 | 56722.0 |
| 2013-02-11 15:00:00 | ES | Futures | 1551.86 | 1554.94 | 1551.61 | 1553.4 | 168241.0 |
| 2013-02-11 16:00:00 | ES | Futures | 1553.15 | 1554.17 | 1552.63 | 1553.66 | 66387.0 |
| 2013-02-11 17:00:00 | ES | Futures | 1553.66 | 1553.66 | 1552.63 | 1552.89 | 2112.0 |
| 2013-02-11 18:00:00 | ES | Futures | 1552.38 | 1553.4 | 1552.12 | 1552.63 | 3938.0 |
| 2013-02-11 19:00:00 | ES | Futures | 1552.63 | 1552.89 | 1552.12 | 1552.38 | 4011.0 |
| 2013-02-11 20:00:00 | ES | Futures | 1552.63 | 1552.89 | 1552.12 | 1552.38 | 2261.0 |
| 2013-02-11 21:00:00 | ES | Futures | 1552.38 | 1552.89 | 1552.38 | 1552.38 | 1117.0 |
| 2013-02-11 22:00:00 | ES | Futures | 1552.63 | 1552.63 | 1551.09 | 1551.35 | 4175.0 |
| 2013-02-11 23:00:00 | ES | Futures | 1551.35 | 1551.61 | 1550.32 | 1551.35 | 5087.0 |
| 2013-02-11 00:00:00 | NQ | Futures | 3229.7 | 3229.7 | 3228.25 | 3228.54 | 173.0 |
| 2013-02-11 01:00:00 | NQ | Futures | 3228.54 | 3230.87 | 3228.54 | 3229.7 | 155.0 |
| 2013-02-11 02:00:00 | NQ | Futures | 3229.99 | 3230.87 | 3228.83 | 3229.7 | 526.0 |
| 2013-02-11 03:00:00 | NQ | Futures | 3229.7 | 3231.45 | 3228.25 | 3231.16 | 1498.0 |
| 2013-02-11 04:00:00 | NQ | Futures | 3231.16 | 3237.56 | 3229.99 | 3236.98 | 2152.0 |
| 2013-02-11 05:00:00 | NQ | Futures | 3237.27 | 3237.56 | 3233.2 | 3235.23 | 1097.0 |
| 2013-02-11 06:00:00 | NQ | Futures | 3234.94 | 3234.94 | 3230.87 | 3232.32 | 1220.0 |
| 2013-02-11 07:00:00 | NQ | Futures | 3232.9 | 3234.07 | 3231.45 | 3233.2 | 1212.0 |
| 2013-02-11 08:00:00 | NQ | Futures | 3233.49 | 3234.07 | 3229.41 | 3231.16 | 2761.0 |
| 2013-02-11 09:00:00 | NQ | Futures | 3231.45 | 3231.45 | 3218.35 | 3221.26 | 31163.0 |
| 2013-02-11 10:00:00 | NQ | Futures | 3221.55 | 3227.96 | 3217.48 | 3227.67 | 29032.0 |
| 2013-02-11 11:00:00 | NQ | Futures | 3227.37 | 3230.87 | 3226.5 | 3228.54 | 18027.0 |
| 2013-02-11 12:00:00 | NQ | Futures | 3228.54 | 3228.54 | 3219.52 | 3223.3 | 13318.0 |
| 2013-02-11 13:00:00 | NQ | Futures | 3223.3 | 3226.21 | 3220.68 | 3221.84 | 10571.0 |
| 2013-02-11 14:00:00 | NQ | Futures | 3222.13 | 3225.92 | 3220.97 | 3221.55 | 8835.0 |
| 2013-02-11 15:00:00 | NQ | Futures | 3221.84 | 3230.87 | 3221.84 | 3227.67 | 19031.0 |
| 2013-02-11 16:00:00 | NQ | Futures | 3227.37 | 3229.41 | 3225.34 | 3227.37 | 4301.0 |
| 2013-02-11 17:00:00 | NQ | Futures | 3227.37 | 3227.96 | 3225.92 | 3226.79 | 223.0 |
| 2013-02-11 18:00:00 | NQ | Futures | 3225.92 | 3226.79 | 3224.75 | 3225.34 | 329.0 |
| 2013-02-11 19:00:00 | NQ | Futures | 3225.05 | 3226.79 | 3224.75 | 3226.5 | 371.0 |
| 2013-02-11 20:00:00 | NQ | Futures | 3226.21 | 3226.79 | 3225.34 | 3225.63 | 206.0 |
| 2013-02-11 21:00:00 | NQ | Futures | 3225.92 | 3226.5 | 3225.63 | 3226.21 | 90.0 |
| 2013-02-11 22:00:00 | NQ | Futures | 3226.5 | 3226.5 | 3224.17 | 3224.17 | 459.0 |
| 2013-02-11 23:00:00 | NQ | Futures | 3224.17 | 3225.05 | 3221.84 | 3223.59 | 413.0 |
| 2013-02-11 00:00:00 | YM | Futures | 14019.0 | 14019.0 | 14014.9 | 14014.9 | 253.0 |
| 2013-02-11 01:00:00 | YM | Futures | 14015.9 | 14023.0 | 14014.9 | 14019.0 | 143.0 |
> showing 50 of 1,486 rows — these rows as CSV