PREVIEW / futures_1hour / 2013-02-15
file: by_date/futures_1hour/2013/2013-02-15.parquet size: 41 KB rows: 1,238
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-15 00:00:00 | ES | Futures | 1555.46 | 1555.97 | 1554.69 | 1555.71 | 7845.0 |
| 2013-02-15 01:00:00 | ES | Futures | 1555.71 | 1556.22 | 1555.46 | 1555.97 | 3516.0 |
| 2013-02-15 02:00:00 | ES | Futures | 1555.97 | 1556.22 | 1555.46 | 1555.97 | 5812.0 |
| 2013-02-15 03:00:00 | ES | Futures | 1555.97 | 1556.48 | 1554.17 | 1554.69 | 30266.0 |
| 2013-02-15 04:00:00 | ES | Futures | 1554.94 | 1555.46 | 1554.17 | 1554.94 | 15700.0 |
| 2013-02-15 05:00:00 | ES | Futures | 1554.94 | 1557.25 | 1554.69 | 1556.22 | 24083.0 |
| 2013-02-15 06:00:00 | ES | Futures | 1556.22 | 1557.51 | 1555.97 | 1557.25 | 13410.0 |
| 2013-02-15 07:00:00 | ES | Futures | 1557.25 | 1557.51 | 1556.22 | 1556.48 | 17065.0 |
| 2013-02-15 08:00:00 | ES | Futures | 1556.74 | 1559.56 | 1556.48 | 1558.79 | 61207.0 |
| 2013-02-15 09:00:00 | ES | Futures | 1558.53 | 1561.36 | 1557.51 | 1560.59 | 226692.0 |
| 2013-02-15 10:00:00 | ES | Futures | 1560.84 | 1561.87 | 1558.28 | 1560.84 | 208293.0 |
| 2013-02-15 11:00:00 | ES | Futures | 1560.84 | 1561.1 | 1556.99 | 1558.53 | 180537.0 |
| 2013-02-15 12:00:00 | ES | Futures | 1558.53 | 1558.53 | 1555.2 | 1557.51 | 131030.0 |
| 2013-02-15 13:00:00 | ES | Futures | 1557.51 | 1559.3 | 1556.99 | 1559.05 | 85712.0 |
| 2013-02-15 14:00:00 | ES | Futures | 1559.05 | 1559.3 | 1551.09 | 1552.38 | 279741.0 |
| 2013-02-15 15:00:00 | ES | Futures | 1552.38 | 1557.51 | 1552.12 | 1557.51 | 243222.0 |
| 2013-02-15 16:00:00 | ES | Futures | 1557.51 | 1558.53 | 1556.48 | 1557.25 | 112626.0 |
| 2013-02-15 17:00:00 | ES | Futures | 1557.25 | 1557.76 | 1556.99 | 1556.99 | 1957.0 |
| 2013-02-15 00:00:00 | NQ | Futures | 3218.64 | 3219.22 | 3216.9 | 3219.22 | 384.0 |
| 2013-02-15 01:00:00 | NQ | Futures | 3218.93 | 3220.1 | 3218.35 | 3219.81 | 201.0 |
| 2013-02-15 02:00:00 | NQ | Futures | 3220.1 | 3220.68 | 3218.35 | 3220.1 | 449.0 |
| 2013-02-15 03:00:00 | NQ | Futures | 3220.1 | 3221.55 | 3216.6 | 3217.48 | 1748.0 |
| 2013-02-15 04:00:00 | NQ | Futures | 3217.77 | 3218.64 | 3214.57 | 3215.73 | 1332.0 |
| 2013-02-15 05:00:00 | NQ | Futures | 3215.73 | 3221.84 | 3215.44 | 3217.48 | 2330.0 |
| 2013-02-15 06:00:00 | NQ | Futures | 3217.48 | 3220.1 | 3216.31 | 3219.52 | 1601.0 |
| 2013-02-15 07:00:00 | NQ | Futures | 3219.52 | 3220.39 | 3218.64 | 3219.52 | 1549.0 |
| 2013-02-15 08:00:00 | NQ | Futures | 3219.81 | 3225.63 | 3219.52 | 3224.17 | 6243.0 |
| 2013-02-15 09:00:00 | NQ | Futures | 3223.88 | 3230.28 | 3222.43 | 3229.12 | 27655.0 |
| 2013-02-15 10:00:00 | NQ | Futures | 3229.12 | 3232.9 | 3225.05 | 3228.83 | 22858.0 |
| 2013-02-15 11:00:00 | NQ | Futures | 3229.12 | 3230.58 | 3220.1 | 3223.01 | 19184.0 |
| 2013-02-15 12:00:00 | NQ | Futures | 3223.3 | 3223.59 | 3217.19 | 3221.84 | 12658.0 |
| 2013-02-15 13:00:00 | NQ | Futures | 3221.84 | 3225.05 | 3218.35 | 3224.46 | 8292.0 |
| 2013-02-15 14:00:00 | NQ | Futures | 3224.46 | 3225.34 | 3206.71 | 3209.04 | 30803.0 |
| 2013-02-15 15:00:00 | NQ | Futures | 3209.04 | 3216.31 | 3208.16 | 3216.31 | 24081.0 |
| 2013-02-15 16:00:00 | NQ | Futures | 3216.31 | 3219.52 | 3213.69 | 3214.28 | 6372.0 |
| 2013-02-15 17:00:00 | NQ | Futures | 3215.15 | 3216.02 | 3214.57 | 3215.15 | 125.0 |
| 2013-02-15 00:00:00 | YM | Futures | 14009.9 | 14012.9 | 14003.9 | 14011.9 | 712.0 |
| 2013-02-15 01:00:00 | YM | Futures | 14010.9 | 14015.9 | 14008.9 | 14013.9 | 291.0 |
| 2013-02-15 02:00:00 | YM | Futures | 14014.9 | 14019.0 | 14010.9 | 14016.9 | 626.0 |
| 2013-02-15 03:00:00 | YM | Futures | 14015.9 | 14020.0 | 14001.9 | 14008.9 | 2110.0 |
| 2013-02-15 04:00:00 | YM | Futures | 14007.9 | 14012.9 | 14003.9 | 14008.9 | 1085.0 |
| 2013-02-15 05:00:00 | YM | Futures | 14008.9 | 14030.0 | 14007.9 | 14019.0 | 1974.0 |
| 2013-02-15 06:00:00 | YM | Futures | 14019.0 | 14028.0 | 14012.9 | 14027.0 | 1531.0 |
| 2013-02-15 07:00:00 | YM | Futures | 14026.0 | 14028.0 | 14019.0 | 14019.0 | 1438.0 |
| 2013-02-15 08:00:00 | YM | Futures | 14019.0 | 14036.1 | 14016.9 | 14030.0 | 5480.0 |
| 2013-02-15 09:00:00 | YM | Futures | 14030.0 | 14051.1 | 14020.0 | 14047.1 | 13727.0 |
| 2013-02-15 10:00:00 | YM | Futures | 14047.1 | 14061.2 | 14035.1 | 14053.2 | 13185.0 |
| 2013-02-15 11:00:00 | YM | Futures | 14054.2 | 14056.2 | 14023.0 | 14033.0 | 11583.0 |
| 2013-02-15 12:00:00 | YM | Futures | 14033.0 | 14034.0 | 14004.9 | 14025.0 | 7547.0 |
| 2013-02-15 13:00:00 | YM | Futures | 14025.0 | 14041.1 | 14023.0 | 14041.1 | 4755.0 |
> showing 50 of 1,238 rows — these rows as CSV