PREVIEW / futures_30min / 2013-10-24
file: by_date/futures_30min/2013/2013-10-24.parquet size: 73 KB rows: 2,894
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-10-24 00:00:00 | ES | Futures | 1801.6 | 1802.11 | 1801.08 | 1801.34 | 478.0 |
| 2013-10-24 00:30:00 | ES | Futures | 1801.34 | 1802.11 | 1801.08 | 1801.85 | 913.0 |
| 2013-10-24 01:00:00 | ES | Futures | 1801.6 | 1802.89 | 1801.34 | 1802.63 | 1819.0 |
| 2013-10-24 01:30:00 | ES | Futures | 1802.63 | 1805.46 | 1802.63 | 1805.21 | 6793.0 |
| 2013-10-24 02:00:00 | ES | Futures | 1804.95 | 1807.53 | 1804.69 | 1804.95 | 11585.0 |
| 2013-10-24 02:30:00 | ES | Futures | 1805.21 | 1805.98 | 1804.43 | 1804.43 | 3694.0 |
| 2013-10-24 03:00:00 | ES | Futures | 1804.43 | 1805.21 | 1802.63 | 1804.43 | 11924.0 |
| 2013-10-24 03:30:00 | ES | Futures | 1804.43 | 1805.98 | 1803.92 | 1804.69 | 7875.0 |
| 2013-10-24 04:00:00 | ES | Futures | 1804.43 | 1804.43 | 1801.85 | 1803.4 | 10546.0 |
| 2013-10-24 04:30:00 | ES | Futures | 1803.4 | 1803.4 | 1802.37 | 1803.4 | 3416.0 |
| 2013-10-24 05:00:00 | ES | Futures | 1803.14 | 1803.14 | 1801.6 | 1802.37 | 4664.0 |
| 2013-10-24 05:30:00 | ES | Futures | 1802.63 | 1803.4 | 1801.85 | 1803.4 | 3848.0 |
| 2013-10-24 06:00:00 | ES | Futures | 1803.4 | 1804.69 | 1802.63 | 1804.43 | 6748.0 |
| 2013-10-24 06:30:00 | ES | Futures | 1804.43 | 1806.75 | 1804.18 | 1804.69 | 11826.0 |
| 2013-10-24 07:00:00 | ES | Futures | 1804.95 | 1805.72 | 1803.4 | 1803.4 | 8042.0 |
| 2013-10-24 07:30:00 | ES | Futures | 1803.4 | 1804.18 | 1802.37 | 1803.14 | 8933.0 |
| 2013-10-24 08:00:00 | ES | Futures | 1803.14 | 1803.4 | 1801.85 | 1802.63 | 12693.0 |
| 2013-10-24 08:30:00 | ES | Futures | 1802.63 | 1803.14 | 1800.31 | 1800.56 | 23064.0 |
| 2013-10-24 09:00:00 | ES | Futures | 1800.31 | 1801.85 | 1798.76 | 1799.79 | 26303.0 |
| 2013-10-24 09:30:00 | ES | Futures | 1799.79 | 1800.82 | 1795.4 | 1798.24 | 175508.0 |
| 2013-10-24 10:00:00 | ES | Futures | 1798.5 | 1800.82 | 1795.92 | 1797.73 | 116052.0 |
| 2013-10-24 10:30:00 | ES | Futures | 1797.73 | 1800.05 | 1796.18 | 1799.53 | 98723.0 |
| 2013-10-24 11:00:00 | ES | Futures | 1799.79 | 1802.37 | 1799.02 | 1801.85 | 74460.0 |
| 2013-10-24 11:30:00 | ES | Futures | 1801.85 | 1802.11 | 1800.31 | 1801.34 | 50222.0 |
| 2013-10-24 12:00:00 | ES | Futures | 1801.34 | 1802.11 | 1800.31 | 1801.08 | 44774.0 |
| 2013-10-24 12:30:00 | ES | Futures | 1801.34 | 1802.89 | 1798.76 | 1802.89 | 61485.0 |
| 2013-10-24 13:00:00 | ES | Futures | 1802.89 | 1802.89 | 1800.05 | 1802.11 | 44332.0 |
| 2013-10-24 13:30:00 | ES | Futures | 1802.11 | 1802.37 | 1800.82 | 1801.08 | 30377.0 |
| 2013-10-24 14:00:00 | ES | Futures | 1801.08 | 1802.89 | 1800.82 | 1802.37 | 36913.0 |
| 2013-10-24 14:30:00 | ES | Futures | 1802.37 | 1804.43 | 1801.85 | 1804.43 | 42972.0 |
| 2013-10-24 15:00:00 | ES | Futures | 1804.43 | 1804.69 | 1802.63 | 1803.14 | 42835.0 |
| 2013-10-24 15:30:00 | ES | Futures | 1803.14 | 1803.4 | 1800.82 | 1802.37 | 119522.0 |
| 2013-10-24 16:00:00 | ES | Futures | 1802.37 | 1805.98 | 1802.11 | 1804.18 | 90855.0 |
| 2013-10-24 16:30:00 | ES | Futures | 1804.43 | 1805.46 | 1804.18 | 1804.69 | 5846.0 |
| 2013-10-24 17:00:00 | ES | Futures | 1804.43 | 1804.95 | 1803.92 | 1804.43 | 3265.0 |
| 2013-10-24 18:00:00 | ES | Futures | 1803.66 | 1804.95 | 1803.66 | 1804.69 | 3192.0 |
| 2013-10-24 18:30:00 | ES | Futures | 1804.69 | 1804.95 | 1804.18 | 1804.43 | 997.0 |
| 2013-10-24 19:00:00 | ES | Futures | 1804.69 | 1804.69 | 1804.18 | 1804.69 | 325.0 |
| 2013-10-24 19:30:00 | ES | Futures | 1804.69 | 1804.69 | 1804.43 | 1804.43 | 594.0 |
| 2013-10-24 20:00:00 | ES | Futures | 1804.43 | 1804.69 | 1803.4 | 1803.66 | 2270.0 |
| 2013-10-24 20:30:00 | ES | Futures | 1803.4 | 1803.92 | 1803.14 | 1803.4 | 2384.0 |
| 2013-10-24 21:00:00 | ES | Futures | 1803.4 | 1805.46 | 1803.4 | 1804.43 | 2303.0 |
| 2013-10-24 21:30:00 | ES | Futures | 1804.18 | 1804.95 | 1803.14 | 1803.66 | 2635.0 |
| 2013-10-24 22:00:00 | ES | Futures | 1803.92 | 1804.43 | 1802.89 | 1803.92 | 2105.0 |
| 2013-10-24 22:30:00 | ES | Futures | 1803.92 | 1805.46 | 1803.4 | 1803.66 | 3400.0 |
| 2013-10-24 23:00:00 | ES | Futures | 1803.66 | 1804.43 | 1803.4 | 1804.18 | 1017.0 |
| 2013-10-24 23:30:00 | ES | Futures | 1803.92 | 1803.92 | 1802.63 | 1802.89 | 2172.0 |
| 2013-10-24 00:00:00 | NQ | Futures | 3890.34 | 3891.21 | 3889.18 | 3889.76 | 165.0 |
| 2013-10-24 00:30:00 | NQ | Futures | 3890.05 | 3892.09 | 3889.76 | 3891.51 | 408.0 |
| 2013-10-24 01:00:00 | NQ | Futures | 3891.21 | 3895.28 | 3891.21 | 3894.7 | 512.0 |
> showing 50 of 2,894 rows — these rows as CSV