PREVIEW / futures_1hour / 2013-02-13
file: by_date/futures_1hour/2013/2013-02-13.parquet size: 49 KB rows: 1,548
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-13 00:00:00 | ES | Futures | 1557.25 | 1557.76 | 1556.48 | 1556.74 | 3768.0 |
| 2013-02-13 01:00:00 | ES | Futures | 1556.74 | 1557.76 | 1556.48 | 1557.25 | 3105.0 |
| 2013-02-13 02:00:00 | ES | Futures | 1557.25 | 1558.28 | 1556.48 | 1558.02 | 6766.0 |
| 2013-02-13 03:00:00 | ES | Futures | 1558.28 | 1558.28 | 1556.74 | 1557.76 | 18872.0 |
| 2013-02-13 04:00:00 | ES | Futures | 1557.51 | 1558.79 | 1557.25 | 1557.51 | 13317.0 |
| 2013-02-13 05:00:00 | ES | Futures | 1557.51 | 1558.02 | 1556.74 | 1557.25 | 18058.0 |
| 2013-02-13 06:00:00 | ES | Futures | 1557.51 | 1559.3 | 1557.25 | 1559.05 | 20365.0 |
| 2013-02-13 07:00:00 | ES | Futures | 1559.3 | 1559.82 | 1558.79 | 1559.05 | 25729.0 |
| 2013-02-13 08:00:00 | ES | Futures | 1559.3 | 1560.07 | 1558.02 | 1558.79 | 33325.0 |
| 2013-02-13 09:00:00 | ES | Futures | 1558.79 | 1561.1 | 1557.25 | 1560.59 | 214410.0 |
| 2013-02-13 10:00:00 | ES | Futures | 1560.33 | 1562.13 | 1558.28 | 1559.05 | 207718.0 |
| 2013-02-13 11:00:00 | ES | Futures | 1559.3 | 1559.56 | 1554.69 | 1555.97 | 189448.0 |
| 2013-02-13 12:00:00 | ES | Futures | 1555.97 | 1558.02 | 1555.97 | 1556.99 | 88928.0 |
| 2013-02-13 13:00:00 | ES | Futures | 1556.99 | 1558.53 | 1556.74 | 1558.02 | 71758.0 |
| 2013-02-13 14:00:00 | ES | Futures | 1557.76 | 1558.28 | 1552.89 | 1553.92 | 126935.0 |
| 2013-02-13 15:00:00 | ES | Futures | 1553.66 | 1557.76 | 1553.66 | 1557.51 | 139364.0 |
| 2013-02-13 16:00:00 | ES | Futures | 1557.51 | 1558.02 | 1556.48 | 1556.99 | 62441.0 |
| 2013-02-13 17:00:00 | ES | Futures | 1557.25 | 1557.25 | 1556.22 | 1556.22 | 3068.0 |
| 2013-02-13 18:00:00 | ES | Futures | 1556.22 | 1556.48 | 1555.2 | 1555.71 | 3470.0 |
| 2013-02-13 19:00:00 | ES | Futures | 1555.97 | 1556.48 | 1555.46 | 1555.46 | 3705.0 |
| 2013-02-13 20:00:00 | ES | Futures | 1555.46 | 1557.25 | 1555.46 | 1556.99 | 5641.0 |
| 2013-02-13 21:00:00 | ES | Futures | 1556.99 | 1558.28 | 1556.74 | 1557.51 | 6693.0 |
| 2013-02-13 22:00:00 | ES | Futures | 1557.25 | 1558.28 | 1557.25 | 1558.02 | 3783.0 |
| 2013-02-13 23:00:00 | ES | Futures | 1558.02 | 1558.28 | 1557.25 | 1557.51 | 3666.0 |
| 2013-02-13 00:00:00 | NQ | Futures | 3219.22 | 3219.52 | 3217.77 | 3218.64 | 206.0 |
| 2013-02-13 01:00:00 | NQ | Futures | 3218.06 | 3219.81 | 3218.06 | 3219.52 | 201.0 |
| 2013-02-13 02:00:00 | NQ | Futures | 3219.52 | 3220.97 | 3218.06 | 3220.39 | 621.0 |
| 2013-02-13 03:00:00 | NQ | Futures | 3220.39 | 3220.97 | 3218.06 | 3219.81 | 1333.0 |
| 2013-02-13 04:00:00 | NQ | Futures | 3220.1 | 3222.43 | 3219.52 | 3220.97 | 1032.0 |
| 2013-02-13 05:00:00 | NQ | Futures | 3220.97 | 3221.26 | 3218.64 | 3219.22 | 1054.0 |
| 2013-02-13 06:00:00 | NQ | Futures | 3219.52 | 3222.43 | 3219.22 | 3222.13 | 1469.0 |
| 2013-02-13 07:00:00 | NQ | Futures | 3222.13 | 3225.05 | 3221.55 | 3223.59 | 2743.0 |
| 2013-02-13 08:00:00 | NQ | Futures | 3223.88 | 3226.79 | 3222.43 | 3223.3 | 3772.0 |
| 2013-02-13 09:00:00 | NQ | Futures | 3223.3 | 3235.81 | 3217.48 | 3235.81 | 24225.0 |
| 2013-02-13 10:00:00 | NQ | Futures | 3235.52 | 3238.73 | 3231.16 | 3234.07 | 32623.0 |
| 2013-02-13 11:00:00 | NQ | Futures | 3234.07 | 3234.94 | 3216.6 | 3220.39 | 27140.0 |
| 2013-02-13 12:00:00 | NQ | Futures | 3220.68 | 3226.79 | 3218.93 | 3222.13 | 13111.0 |
| 2013-02-13 13:00:00 | NQ | Futures | 3222.13 | 3231.16 | 3221.84 | 3229.12 | 10631.0 |
| 2013-02-13 14:00:00 | NQ | Futures | 3229.41 | 3230.28 | 3216.6 | 3219.22 | 16228.0 |
| 2013-02-13 15:00:00 | NQ | Futures | 3219.22 | 3227.37 | 3218.06 | 3226.79 | 19024.0 |
| 2013-02-13 16:00:00 | NQ | Futures | 3226.5 | 3228.54 | 3220.68 | 3225.34 | 6795.0 |
| 2013-02-13 17:00:00 | NQ | Futures | 3224.75 | 3225.05 | 3221.55 | 3221.55 | 215.0 |
| 2013-02-13 18:00:00 | NQ | Futures | 3221.26 | 3221.55 | 3219.52 | 3220.97 | 229.0 |
| 2013-02-13 19:00:00 | NQ | Futures | 3220.97 | 3221.55 | 3219.52 | 3219.52 | 236.0 |
| 2013-02-13 20:00:00 | NQ | Futures | 3220.1 | 3223.01 | 3219.81 | 3222.72 | 412.0 |
| 2013-02-13 21:00:00 | NQ | Futures | 3222.43 | 3224.75 | 3221.84 | 3223.01 | 386.0 |
| 2013-02-13 22:00:00 | NQ | Futures | 3223.3 | 3224.75 | 3223.3 | 3223.88 | 279.0 |
| 2013-02-13 23:00:00 | NQ | Futures | 3224.17 | 3224.75 | 3223.3 | 3223.59 | 242.0 |
| 2013-02-13 00:00:00 | YM | Futures | 14066.2 | 14066.2 | 14060.2 | 14061.2 | 312.0 |
| 2013-02-13 01:00:00 | YM | Futures | 14060.2 | 14067.2 | 14059.2 | 14063.2 | 263.0 |
> showing 50 of 1,548 rows — these rows as CSV