PREVIEW / futures_1hour / 2013-12-13
file: by_date/futures_1hour/2013/2013-12-13.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-12-13 00:00:00 | ES | Futures | 1835.65 | 1835.9 | 1833.58 | 1834.61 | 2672.0 |
| 2013-12-13 01:00:00 | ES | Futures | 1834.61 | 1836.68 | 1834.61 | 1835.65 | 1704.0 |
| 2013-12-13 02:00:00 | ES | Futures | 1835.9 | 1836.94 | 1835.13 | 1836.42 | 2940.0 |
| 2013-12-13 03:00:00 | ES | Futures | 1836.16 | 1838.23 | 1834.61 | 1837.45 | 8620.0 |
| 2013-12-13 04:00:00 | ES | Futures | 1837.71 | 1838.74 | 1836.94 | 1838.48 | 4054.0 |
| 2013-12-13 05:00:00 | ES | Futures | 1838.48 | 1838.74 | 1835.9 | 1837.71 | 5288.0 |
| 2013-12-13 06:00:00 | ES | Futures | 1837.71 | 1839.77 | 1837.71 | 1838.74 | 7731.0 |
| 2013-12-13 07:00:00 | ES | Futures | 1839.0 | 1839.26 | 1837.97 | 1838.23 | 6047.0 |
| 2013-12-13 08:00:00 | ES | Futures | 1837.97 | 1838.74 | 1833.58 | 1835.39 | 21632.0 |
| 2013-12-13 09:00:00 | ES | Futures | 1835.13 | 1837.45 | 1830.49 | 1831.0 | 54818.0 |
| 2013-12-13 10:00:00 | ES | Futures | 1831.26 | 1833.32 | 1828.17 | 1831.52 | 65659.0 |
| 2013-12-13 11:00:00 | ES | Futures | 1831.78 | 1832.81 | 1829.46 | 1832.29 | 40353.0 |
| 2013-12-13 12:00:00 | ES | Futures | 1832.03 | 1834.87 | 1830.75 | 1833.58 | 30656.0 |
| 2013-12-13 13:00:00 | ES | Futures | 1833.58 | 1836.16 | 1833.32 | 1833.84 | 16993.0 |
| 2013-12-13 14:00:00 | ES | Futures | 1833.58 | 1833.84 | 1828.42 | 1832.55 | 44388.0 |
| 2013-12-13 15:00:00 | ES | Futures | 1832.81 | 1836.16 | 1830.75 | 1831.52 | 72504.0 |
| 2013-12-13 16:00:00 | ES | Futures | 1831.78 | 1832.03 | 1829.46 | 1831.52 | 32436.0 |
| 2013-12-13 17:00:00 | ES | Futures | 1831.52 | 1831.52 | 1829.71 | 1829.71 | 1180.0 |
| 2013-12-13 00:00:00 | NQ | Futures | 4030.04 | 4030.91 | 4027.14 | 4030.04 | 253.0 |
| 2013-12-13 01:00:00 | NQ | Futures | 4029.46 | 4032.36 | 4029.46 | 4030.33 | 176.0 |
| 2013-12-13 02:00:00 | NQ | Futures | 4031.2 | 4033.24 | 4029.46 | 4032.95 | 369.0 |
| 2013-12-13 03:00:00 | NQ | Futures | 4032.66 | 4034.98 | 4029.17 | 4033.53 | 917.0 |
| 2013-12-13 04:00:00 | NQ | Futures | 4033.24 | 4036.72 | 4031.2 | 4035.27 | 799.0 |
| 2013-12-13 05:00:00 | NQ | Futures | 4035.27 | 4036.43 | 4028.88 | 4034.4 | 541.0 |
| 2013-12-13 06:00:00 | NQ | Futures | 4033.53 | 4036.43 | 4033.53 | 4034.98 | 415.0 |
| 2013-12-13 07:00:00 | NQ | Futures | 4034.69 | 4037.01 | 4033.82 | 4035.27 | 714.0 |
| 2013-12-13 08:00:00 | NQ | Futures | 4035.27 | 4037.59 | 4027.72 | 4031.2 | 1716.0 |
| 2013-12-13 09:00:00 | NQ | Futures | 4031.2 | 4040.79 | 4018.71 | 4019.88 | 11274.0 |
| 2013-12-13 10:00:00 | NQ | Futures | 4019.88 | 4028.3 | 4017.55 | 4023.65 | 8286.0 |
| 2013-12-13 11:00:00 | NQ | Futures | 4022.78 | 4025.98 | 4015.52 | 4019.88 | 4850.0 |
| 2013-12-13 12:00:00 | NQ | Futures | 4020.46 | 4024.23 | 4017.26 | 4020.17 | 6860.0 |
| 2013-12-13 13:00:00 | NQ | Futures | 4020.46 | 4025.69 | 4019.01 | 4019.3 | 3758.0 |
| 2013-12-13 14:00:00 | NQ | Futures | 4019.01 | 4019.3 | 4007.68 | 4016.39 | 7592.0 |
| 2013-12-13 15:00:00 | NQ | Futures | 4016.39 | 4024.81 | 4013.49 | 4014.65 | 13227.0 |
| 2013-12-13 16:00:00 | NQ | Futures | 4014.65 | 4019.01 | 4013.78 | 4018.13 | 1390.0 |
| 2013-12-13 17:00:00 | NQ | Futures | 4017.84 | 4017.84 | 4015.52 | 4016.39 | 42.0 |
| 2013-12-13 00:00:00 | YM | Futures | 16113.2 | 16115.2 | 16096.8 | 16105.0 | 1178.0 |
| 2013-12-13 01:00:00 | YM | Futures | 16105.0 | 16122.4 | 16105.0 | 16115.2 | 412.0 |
| 2013-12-13 02:00:00 | YM | Futures | 16117.3 | 16122.4 | 16107.0 | 16115.2 | 824.0 |
| 2013-12-13 03:00:00 | YM | Futures | 16113.2 | 16127.5 | 16101.9 | 16119.3 | 1912.0 |
| 2013-12-13 04:00:00 | YM | Futures | 16119.3 | 16125.5 | 16114.2 | 16122.4 | 1252.0 |
| 2013-12-13 05:00:00 | YM | Futures | 16123.4 | 16124.5 | 16100.9 | 16114.2 | 1018.0 |
| 2013-12-13 06:00:00 | YM | Futures | 16115.2 | 16129.6 | 16115.2 | 16119.3 | 1090.0 |
| 2013-12-13 07:00:00 | YM | Futures | 16118.3 | 16124.5 | 16114.2 | 16117.3 | 1292.0 |
| 2013-12-13 08:00:00 | YM | Futures | 16117.3 | 16121.4 | 16083.4 | 16093.7 | 3145.0 |
| 2013-12-13 09:00:00 | YM | Futures | 16092.7 | 16111.1 | 16070.1 | 16077.3 | 12953.0 |
| 2013-12-13 10:00:00 | YM | Futures | 16077.3 | 16104.0 | 16056.8 | 16092.7 | 11103.0 |
| 2013-12-13 11:00:00 | YM | Futures | 16091.6 | 16105.0 | 16074.2 | 16101.9 | 7775.0 |
| 2013-12-13 12:00:00 | YM | Futures | 16100.9 | 16120.4 | 16087.5 | 16111.1 | 5525.0 |
| 2013-12-13 13:00:00 | YM | Futures | 16112.2 | 16129.6 | 16106.0 | 16114.2 | 4490.0 |
> showing 50 of 1,238 rows — these rows as CSV