PREVIEW / futures_30min / 2013-11-01
file: by_date/futures_30min/2013/2013-11-01.parquet size: 66 KB rows: 2,364
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-01 00:00:00 | ES | Futures | 1807.53 | 1808.04 | 1807.01 | 1808.04 | 1694.0 |
| 2013-11-01 00:30:00 | ES | Futures | 1808.04 | 1808.56 | 1808.04 | 1808.3 | 907.0 |
| 2013-11-01 01:00:00 | ES | Futures | 1808.3 | 1808.56 | 1807.27 | 1807.53 | 873.0 |
| 2013-11-01 01:30:00 | ES | Futures | 1807.53 | 1809.08 | 1807.53 | 1808.82 | 1352.0 |
| 2013-11-01 02:00:00 | ES | Futures | 1808.56 | 1809.08 | 1808.3 | 1809.08 | 839.0 |
| 2013-11-01 02:30:00 | ES | Futures | 1809.08 | 1809.33 | 1808.82 | 1809.33 | 991.0 |
| 2013-11-01 03:00:00 | ES | Futures | 1809.33 | 1810.37 | 1808.82 | 1809.33 | 4475.0 |
| 2013-11-01 03:30:00 | ES | Futures | 1809.33 | 1811.14 | 1809.33 | 1810.88 | 3555.0 |
| 2013-11-01 04:00:00 | ES | Futures | 1810.62 | 1810.88 | 1807.79 | 1808.82 | 14268.0 |
| 2013-11-01 04:30:00 | ES | Futures | 1808.56 | 1810.11 | 1808.04 | 1808.82 | 8503.0 |
| 2013-11-01 05:00:00 | ES | Futures | 1808.82 | 1809.59 | 1808.04 | 1809.59 | 5261.0 |
| 2013-11-01 05:30:00 | ES | Futures | 1809.59 | 1809.85 | 1808.56 | 1808.82 | 4894.0 |
| 2013-11-01 06:00:00 | ES | Futures | 1809.08 | 1809.85 | 1808.3 | 1808.82 | 5713.0 |
| 2013-11-01 06:30:00 | ES | Futures | 1808.56 | 1809.33 | 1807.27 | 1809.08 | 6574.0 |
| 2013-11-01 07:00:00 | ES | Futures | 1809.33 | 1810.62 | 1808.82 | 1810.37 | 7604.0 |
| 2013-11-01 07:30:00 | ES | Futures | 1810.37 | 1810.88 | 1809.33 | 1809.85 | 12237.0 |
| 2013-11-01 08:00:00 | ES | Futures | 1809.85 | 1811.4 | 1809.85 | 1810.88 | 9353.0 |
| 2013-11-01 08:30:00 | ES | Futures | 1810.88 | 1811.91 | 1810.37 | 1810.88 | 17696.0 |
| 2013-11-01 09:00:00 | ES | Futures | 1810.88 | 1811.66 | 1809.85 | 1811.14 | 17745.0 |
| 2013-11-01 09:30:00 | ES | Futures | 1811.4 | 1815.01 | 1810.88 | 1813.72 | 125691.0 |
| 2013-11-01 10:00:00 | ES | Futures | 1813.98 | 1817.33 | 1808.3 | 1809.85 | 221302.0 |
| 2013-11-01 10:30:00 | ES | Futures | 1809.85 | 1812.69 | 1809.08 | 1811.91 | 111471.0 |
| 2013-11-01 11:00:00 | ES | Futures | 1812.17 | 1812.17 | 1803.92 | 1806.5 | 193829.0 |
| 2013-11-01 11:30:00 | ES | Futures | 1806.75 | 1807.79 | 1803.14 | 1803.66 | 83303.0 |
| 2013-11-01 12:00:00 | ES | Futures | 1803.66 | 1806.75 | 1802.63 | 1805.98 | 98253.0 |
| 2013-11-01 12:30:00 | ES | Futures | 1805.72 | 1807.79 | 1805.46 | 1806.24 | 59916.0 |
| 2013-11-01 13:00:00 | ES | Futures | 1806.5 | 1806.75 | 1804.18 | 1806.5 | 47254.0 |
| 2013-11-01 13:30:00 | ES | Futures | 1806.24 | 1810.37 | 1805.46 | 1809.59 | 61690.0 |
| 2013-11-01 14:00:00 | ES | Futures | 1809.59 | 1810.62 | 1809.08 | 1809.59 | 46409.0 |
| 2013-11-01 14:30:00 | ES | Futures | 1809.59 | 1810.62 | 1808.3 | 1808.82 | 49765.0 |
| 2013-11-01 15:00:00 | ES | Futures | 1808.82 | 1811.91 | 1808.56 | 1810.88 | 73611.0 |
| 2013-11-01 15:30:00 | ES | Futures | 1811.14 | 1815.01 | 1810.11 | 1811.91 | 175575.0 |
| 2013-11-01 16:00:00 | ES | Futures | 1812.17 | 1812.43 | 1810.11 | 1810.37 | 82903.0 |
| 2013-11-01 16:30:00 | ES | Futures | 1810.11 | 1810.37 | 1809.59 | 1810.11 | 9698.0 |
| 2013-11-01 17:00:00 | ES | Futures | 1810.11 | 1811.14 | 1809.59 | 1810.62 | 2958.0 |
| 2013-11-01 00:00:00 | NQ | Futures | 3917.35 | 3919.1 | 3916.48 | 3919.1 | 152.0 |
| 2013-11-01 00:30:00 | NQ | Futures | 3918.81 | 3919.39 | 3917.64 | 3917.93 | 217.0 |
| 2013-11-01 01:00:00 | NQ | Futures | 3918.52 | 3919.68 | 3918.22 | 3918.52 | 175.0 |
| 2013-11-01 01:30:00 | NQ | Futures | 3918.52 | 3922.58 | 3918.52 | 3921.13 | 188.0 |
| 2013-11-01 02:00:00 | NQ | Futures | 3921.13 | 3922.58 | 3920.84 | 3921.71 | 127.0 |
| 2013-11-01 02:30:00 | NQ | Futures | 3922.0 | 3922.58 | 3921.71 | 3922.0 | 144.0 |
| 2013-11-01 03:00:00 | NQ | Futures | 3922.29 | 3925.2 | 3922.0 | 3922.29 | 583.0 |
| 2013-11-01 03:30:00 | NQ | Futures | 3922.0 | 3926.07 | 3921.71 | 3924.61 | 428.0 |
| 2013-11-01 04:00:00 | NQ | Futures | 3924.61 | 3924.61 | 3917.93 | 3920.84 | 1547.0 |
| 2013-11-01 04:30:00 | NQ | Futures | 3920.26 | 3923.45 | 3919.97 | 3921.42 | 734.0 |
| 2013-11-01 05:00:00 | NQ | Futures | 3921.42 | 3924.03 | 3920.26 | 3923.45 | 658.0 |
| 2013-11-01 05:30:00 | NQ | Futures | 3923.45 | 3924.32 | 3921.71 | 3922.58 | 481.0 |
| 2013-11-01 06:00:00 | NQ | Futures | 3922.29 | 3924.03 | 3921.13 | 3922.29 | 662.0 |
| 2013-11-01 06:30:00 | NQ | Futures | 3922.29 | 3923.16 | 3918.81 | 3922.87 | 882.0 |
| 2013-11-01 07:00:00 | NQ | Futures | 3922.87 | 3926.07 | 3922.29 | 3925.78 | 958.0 |
> showing 50 of 2,364 rows — these rows as CSV