PREVIEW / futures_1hour / 2013-02-08
file: by_date/futures_1hour/2013/2013-02-08.parquet size: 42 KB rows: 1,253
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-08 00:00:00 | ES | Futures | 1547.24 | 1548.01 | 1546.73 | 1546.99 | 4679.0 |
| 2013-02-08 01:00:00 | ES | Futures | 1546.99 | 1547.24 | 1546.22 | 1546.99 | 3588.0 |
| 2013-02-08 02:00:00 | ES | Futures | 1546.99 | 1547.5 | 1544.68 | 1544.93 | 14442.0 |
| 2013-02-08 03:00:00 | ES | Futures | 1544.68 | 1546.73 | 1544.68 | 1546.47 | 27257.0 |
| 2013-02-08 04:00:00 | ES | Futures | 1546.47 | 1547.24 | 1544.68 | 1544.68 | 19147.0 |
| 2013-02-08 05:00:00 | ES | Futures | 1544.68 | 1546.22 | 1543.4 | 1544.93 | 22643.0 |
| 2013-02-08 06:00:00 | ES | Futures | 1544.93 | 1546.47 | 1544.42 | 1546.47 | 12237.0 |
| 2013-02-08 07:00:00 | ES | Futures | 1546.47 | 1546.99 | 1544.68 | 1545.45 | 24792.0 |
| 2013-02-08 08:00:00 | ES | Futures | 1545.19 | 1547.5 | 1543.65 | 1547.24 | 47075.0 |
| 2013-02-08 09:00:00 | ES | Futures | 1547.24 | 1554.43 | 1546.73 | 1553.15 | 272954.0 |
| 2013-02-08 10:00:00 | ES | Futures | 1553.4 | 1554.94 | 1552.12 | 1553.4 | 222767.0 |
| 2013-02-08 11:00:00 | ES | Futures | 1553.4 | 1553.92 | 1551.09 | 1553.15 | 177957.0 |
| 2013-02-08 12:00:00 | ES | Futures | 1553.4 | 1553.92 | 1551.35 | 1552.63 | 90394.0 |
| 2013-02-08 13:00:00 | ES | Futures | 1552.38 | 1553.66 | 1551.86 | 1553.15 | 66586.0 |
| 2013-02-08 14:00:00 | ES | Futures | 1553.15 | 1554.17 | 1552.63 | 1553.15 | 60722.0 |
| 2013-02-08 15:00:00 | ES | Futures | 1553.15 | 1553.66 | 1550.84 | 1553.66 | 242819.0 |
| 2013-02-08 16:00:00 | ES | Futures | 1553.4 | 1553.92 | 1552.12 | 1553.92 | 81933.0 |
| 2013-02-08 17:00:00 | ES | Futures | 1553.66 | 1554.17 | 1553.66 | 1553.66 | 2450.0 |
| 2013-02-08 00:00:00 | NQ | Futures | 3197.98 | 3200.01 | 3196.52 | 3197.1 | 379.0 |
| 2013-02-08 01:00:00 | NQ | Futures | 3197.1 | 3197.39 | 3195.94 | 3197.1 | 198.0 |
| 2013-02-08 02:00:00 | NQ | Futures | 3197.1 | 3197.68 | 3194.77 | 3195.07 | 856.0 |
| 2013-02-08 03:00:00 | NQ | Futures | 3195.07 | 3197.1 | 3193.32 | 3195.94 | 2389.0 |
| 2013-02-08 04:00:00 | NQ | Futures | 3196.23 | 3198.85 | 3192.45 | 3194.19 | 1499.0 |
| 2013-02-08 05:00:00 | NQ | Futures | 3194.19 | 3197.98 | 3193.32 | 3196.23 | 2187.0 |
| 2013-02-08 06:00:00 | NQ | Futures | 3195.94 | 3198.56 | 3194.77 | 3198.27 | 1041.0 |
| 2013-02-08 07:00:00 | NQ | Futures | 3198.27 | 3199.72 | 3195.07 | 3198.27 | 2896.0 |
| 2013-02-08 08:00:00 | NQ | Futures | 3197.98 | 3204.96 | 3195.65 | 3204.09 | 5942.0 |
| 2013-02-08 09:00:00 | NQ | Futures | 3203.8 | 3232.32 | 3203.22 | 3230.28 | 58449.0 |
| 2013-02-08 10:00:00 | NQ | Futures | 3230.28 | 3234.36 | 3226.79 | 3233.49 | 38530.0 |
| 2013-02-08 11:00:00 | NQ | Futures | 3233.2 | 3234.94 | 3228.54 | 3231.45 | 24270.0 |
| 2013-02-08 12:00:00 | NQ | Futures | 3231.16 | 3232.61 | 3225.92 | 3229.99 | 13934.0 |
| 2013-02-08 13:00:00 | NQ | Futures | 3230.28 | 3234.65 | 3229.41 | 3232.03 | 13511.0 |
| 2013-02-08 14:00:00 | NQ | Futures | 3232.03 | 3234.36 | 3228.25 | 3229.12 | 10843.0 |
| 2013-02-08 15:00:00 | NQ | Futures | 3229.12 | 3231.74 | 3225.63 | 3227.37 | 24042.0 |
| 2013-02-08 16:00:00 | NQ | Futures | 3227.67 | 3229.41 | 3226.21 | 3228.54 | 6904.0 |
| 2013-02-08 17:00:00 | NQ | Futures | 3228.54 | 3229.41 | 3227.37 | 3227.37 | 126.0 |
| 2013-02-08 00:00:00 | YM | Futures | 14002.9 | 14006.9 | 13998.8 | 14001.9 | 244.0 |
| 2013-02-08 01:00:00 | YM | Futures | 14001.9 | 14001.9 | 13995.8 | 13999.8 | 273.0 |
| 2013-02-08 02:00:00 | YM | Futures | 13998.8 | 13998.8 | 13980.7 | 13981.7 | 704.0 |
| 2013-02-08 03:00:00 | YM | Futures | 13981.7 | 13995.8 | 13980.7 | 13994.8 | 1377.0 |
| 2013-02-08 04:00:00 | YM | Futures | 13994.8 | 14000.8 | 13982.7 | 13983.7 | 1269.0 |
| 2013-02-08 05:00:00 | YM | Futures | 13982.7 | 13992.8 | 13972.7 | 13982.7 | 1506.0 |
| 2013-02-08 06:00:00 | YM | Futures | 13982.7 | 13987.8 | 13968.7 | 13980.7 | 2334.0 |
| 2013-02-08 07:00:00 | YM | Futures | 13980.7 | 13984.8 | 13971.7 | 13975.7 | 1941.0 |
| 2013-02-08 08:00:00 | YM | Futures | 13974.7 | 13990.8 | 13966.6 | 13990.8 | 3526.0 |
| 2013-02-08 09:00:00 | YM | Futures | 13990.8 | 14057.2 | 13985.8 | 14048.1 | 19912.0 |
| 2013-02-08 10:00:00 | YM | Futures | 14049.1 | 14059.2 | 14037.1 | 14038.1 | 17680.0 |
| 2013-02-08 11:00:00 | YM | Futures | 14039.1 | 14042.1 | 14011.9 | 14029.0 | 14310.0 |
| 2013-02-08 12:00:00 | YM | Futures | 14031.0 | 14036.1 | 14022.0 | 14025.0 | 7107.0 |
| 2013-02-08 13:00:00 | YM | Futures | 14026.0 | 14032.0 | 14020.0 | 14026.0 | 4574.0 |
> showing 50 of 1,253 rows — these rows as CSV