PREVIEW / futures_30min / 2013-11-08
file: by_date/futures_30min/2013/2013-11-08.parquet size: 68 KB rows: 2,387
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-11-08 00:00:00 | ES | Futures | 1803.92 | 1804.69 | 1803.92 | 1804.18 | 1797.0 |
| 2013-11-08 00:30:00 | ES | Futures | 1804.18 | 1804.18 | 1803.4 | 1803.92 | 1931.0 |
| 2013-11-08 01:00:00 | ES | Futures | 1803.66 | 1803.92 | 1802.37 | 1802.89 | 2105.0 |
| 2013-11-08 01:30:00 | ES | Futures | 1803.14 | 1803.66 | 1802.89 | 1803.4 | 965.0 |
| 2013-11-08 02:00:00 | ES | Futures | 1803.14 | 1803.92 | 1802.11 | 1802.37 | 4220.0 |
| 2013-11-08 02:30:00 | ES | Futures | 1802.63 | 1803.66 | 1802.37 | 1803.66 | 3360.0 |
| 2013-11-08 03:00:00 | ES | Futures | 1803.66 | 1804.69 | 1803.4 | 1804.43 | 14696.0 |
| 2013-11-08 03:30:00 | ES | Futures | 1804.43 | 1805.72 | 1803.92 | 1805.72 | 10320.0 |
| 2013-11-08 04:00:00 | ES | Futures | 1805.46 | 1806.75 | 1804.95 | 1805.46 | 12059.0 |
| 2013-11-08 04:30:00 | ES | Futures | 1805.46 | 1806.24 | 1805.21 | 1805.46 | 6415.0 |
| 2013-11-08 05:00:00 | ES | Futures | 1805.46 | 1805.72 | 1804.69 | 1805.72 | 6048.0 |
| 2013-11-08 05:30:00 | ES | Futures | 1805.46 | 1805.72 | 1804.69 | 1805.21 | 5134.0 |
| 2013-11-08 06:00:00 | ES | Futures | 1805.21 | 1805.46 | 1804.18 | 1804.43 | 9465.0 |
| 2013-11-08 06:30:00 | ES | Futures | 1804.43 | 1804.69 | 1803.14 | 1803.92 | 13858.0 |
| 2013-11-08 07:00:00 | ES | Futures | 1803.92 | 1805.21 | 1803.4 | 1804.43 | 19442.0 |
| 2013-11-08 07:30:00 | ES | Futures | 1804.69 | 1804.69 | 1801.08 | 1801.85 | 23568.0 |
| 2013-11-08 08:00:00 | ES | Futures | 1801.85 | 1804.95 | 1800.82 | 1803.66 | 30487.0 |
| 2013-11-08 08:30:00 | ES | Futures | 1803.66 | 1805.46 | 1791.79 | 1797.73 | 195644.0 |
| 2013-11-08 09:00:00 | ES | Futures | 1797.73 | 1803.4 | 1796.95 | 1798.76 | 98506.0 |
| 2013-11-08 09:30:00 | ES | Futures | 1798.76 | 1805.98 | 1798.76 | 1800.31 | 250274.0 |
| 2013-11-08 10:00:00 | ES | Futures | 1800.56 | 1810.62 | 1800.31 | 1810.11 | 214098.0 |
| 2013-11-08 10:30:00 | ES | Futures | 1810.11 | 1813.72 | 1809.85 | 1812.69 | 170372.0 |
| 2013-11-08 11:00:00 | ES | Futures | 1812.69 | 1813.72 | 1810.37 | 1811.91 | 85062.0 |
| 2013-11-08 11:30:00 | ES | Futures | 1811.91 | 1814.75 | 1811.4 | 1813.2 | 84077.0 |
| 2013-11-08 12:00:00 | ES | Futures | 1812.95 | 1816.3 | 1812.95 | 1816.04 | 84383.0 |
| 2013-11-08 12:30:00 | ES | Futures | 1816.04 | 1816.3 | 1814.75 | 1815.78 | 32219.0 |
| 2013-11-08 13:00:00 | ES | Futures | 1815.53 | 1817.85 | 1813.98 | 1817.33 | 53064.0 |
| 2013-11-08 13:30:00 | ES | Futures | 1817.33 | 1818.88 | 1816.04 | 1816.82 | 63376.0 |
| 2013-11-08 14:00:00 | ES | Futures | 1816.56 | 1818.62 | 1816.3 | 1818.36 | 54617.0 |
| 2013-11-08 14:30:00 | ES | Futures | 1818.11 | 1818.62 | 1816.82 | 1817.85 | 56645.0 |
| 2013-11-08 15:00:00 | ES | Futures | 1817.85 | 1818.62 | 1815.01 | 1817.07 | 77758.0 |
| 2013-11-08 15:30:00 | ES | Futures | 1817.07 | 1823.78 | 1816.56 | 1823.52 | 236717.0 |
| 2013-11-08 16:00:00 | ES | Futures | 1823.78 | 1824.3 | 1821.97 | 1822.75 | 96556.0 |
| 2013-11-08 16:30:00 | ES | Futures | 1823.01 | 1823.52 | 1821.46 | 1821.72 | 8878.0 |
| 2013-11-08 17:00:00 | ES | Futures | 1821.46 | 1823.01 | 1821.46 | 1823.01 | 1722.0 |
| 2013-11-08 00:00:00 | NQ | Futures | 3863.91 | 3865.66 | 3863.62 | 3865.08 | 299.0 |
| 2013-11-08 00:30:00 | NQ | Futures | 3864.79 | 3864.79 | 3863.33 | 3863.91 | 270.0 |
| 2013-11-08 01:00:00 | NQ | Futures | 3863.62 | 3863.91 | 3861.3 | 3862.46 | 307.0 |
| 2013-11-08 01:30:00 | NQ | Futures | 3862.75 | 3863.33 | 3861.59 | 3861.88 | 159.0 |
| 2013-11-08 02:00:00 | NQ | Futures | 3861.88 | 3864.49 | 3859.85 | 3861.01 | 887.0 |
| 2013-11-08 02:30:00 | NQ | Futures | 3861.3 | 3864.2 | 3860.72 | 3863.91 | 245.0 |
| 2013-11-08 03:00:00 | NQ | Futures | 3863.91 | 3866.53 | 3862.75 | 3865.66 | 1898.0 |
| 2013-11-08 03:30:00 | NQ | Futures | 3865.37 | 3869.43 | 3864.79 | 3869.43 | 1376.0 |
| 2013-11-08 04:00:00 | NQ | Futures | 3869.14 | 3872.05 | 3867.98 | 3870.01 | 1454.0 |
| 2013-11-08 04:30:00 | NQ | Futures | 3870.01 | 3871.47 | 3869.14 | 3869.72 | 1023.0 |
| 2013-11-08 05:00:00 | NQ | Futures | 3870.01 | 3871.17 | 3868.85 | 3870.59 | 995.0 |
| 2013-11-08 05:30:00 | NQ | Futures | 3870.3 | 3870.88 | 3869.14 | 3870.01 | 864.0 |
| 2013-11-08 06:00:00 | NQ | Futures | 3870.01 | 3870.3 | 3867.98 | 3868.27 | 982.0 |
| 2013-11-08 06:30:00 | NQ | Futures | 3868.27 | 3869.14 | 3866.24 | 3869.14 | 1320.0 |
| 2013-11-08 07:00:00 | NQ | Futures | 3869.14 | 3870.88 | 3867.98 | 3870.01 | 1651.0 |
> showing 50 of 2,387 rows — these rows as CSV