PREVIEW / futures_30min / 2013-01-18
file: by_date/futures_30min/2013/2013-01-18.parquet size: 66 KB rows: 2,375
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-01-18 00:00:00 | ES | Futures | 1513.89 | 1514.4 | 1513.63 | 1514.4 | 2427.0 |
| 2013-01-18 00:30:00 | ES | Futures | 1514.4 | 1515.43 | 1514.14 | 1515.17 | 2625.0 |
| 2013-01-18 01:00:00 | ES | Futures | 1515.17 | 1515.43 | 1514.66 | 1514.91 | 1839.0 |
| 2013-01-18 01:30:00 | ES | Futures | 1514.66 | 1515.94 | 1514.66 | 1515.94 | 1967.0 |
| 2013-01-18 02:00:00 | ES | Futures | 1515.68 | 1516.45 | 1515.43 | 1516.2 | 4388.0 |
| 2013-01-18 02:30:00 | ES | Futures | 1516.2 | 1516.97 | 1515.43 | 1516.71 | 7412.0 |
| 2013-01-18 03:00:00 | ES | Futures | 1516.71 | 1516.97 | 1514.91 | 1515.17 | 12088.0 |
| 2013-01-18 03:30:00 | ES | Futures | 1515.43 | 1516.97 | 1514.91 | 1515.43 | 12600.0 |
| 2013-01-18 04:00:00 | ES | Futures | 1515.17 | 1515.94 | 1514.4 | 1514.91 | 11306.0 |
| 2013-01-18 04:30:00 | ES | Futures | 1514.91 | 1515.68 | 1514.4 | 1515.17 | 7296.0 |
| 2013-01-18 05:00:00 | ES | Futures | 1514.91 | 1515.68 | 1514.14 | 1515.43 | 8920.0 |
| 2013-01-18 05:30:00 | ES | Futures | 1515.43 | 1516.2 | 1514.91 | 1515.43 | 8984.0 |
| 2013-01-18 06:00:00 | ES | Futures | 1515.43 | 1516.2 | 1514.14 | 1514.66 | 12112.0 |
| 2013-01-18 06:30:00 | ES | Futures | 1514.4 | 1514.91 | 1514.14 | 1514.66 | 7772.0 |
| 2013-01-18 07:00:00 | ES | Futures | 1514.4 | 1515.17 | 1513.12 | 1514.14 | 13622.0 |
| 2013-01-18 07:30:00 | ES | Futures | 1514.14 | 1515.94 | 1513.89 | 1514.66 | 16862.0 |
| 2013-01-18 08:00:00 | ES | Futures | 1514.66 | 1516.45 | 1513.89 | 1515.94 | 25903.0 |
| 2013-01-18 08:30:00 | ES | Futures | 1515.94 | 1516.2 | 1514.91 | 1515.17 | 15665.0 |
| 2013-01-18 09:00:00 | ES | Futures | 1515.17 | 1516.2 | 1514.4 | 1514.91 | 38198.0 |
| 2013-01-18 09:30:00 | ES | Futures | 1515.17 | 1516.2 | 1511.83 | 1513.89 | 179554.0 |
| 2013-01-18 10:00:00 | ES | Futures | 1513.63 | 1514.66 | 1512.35 | 1512.86 | 83670.0 |
| 2013-01-18 10:30:00 | ES | Futures | 1513.12 | 1513.12 | 1511.58 | 1511.83 | 71801.0 |
| 2013-01-18 11:00:00 | ES | Futures | 1512.09 | 1513.12 | 1509.78 | 1511.83 | 162501.0 |
| 2013-01-18 11:30:00 | ES | Futures | 1512.09 | 1512.35 | 1509.27 | 1510.3 | 102746.0 |
| 2013-01-18 12:00:00 | ES | Futures | 1510.55 | 1511.32 | 1510.3 | 1510.81 | 30626.0 |
| 2013-01-18 12:30:00 | ES | Futures | 1510.81 | 1513.63 | 1510.55 | 1513.12 | 64319.0 |
| 2013-01-18 13:00:00 | ES | Futures | 1513.37 | 1515.94 | 1513.12 | 1514.66 | 73253.0 |
| 2013-01-18 13:30:00 | ES | Futures | 1514.66 | 1515.43 | 1514.14 | 1514.91 | 26787.0 |
| 2013-01-18 14:00:00 | ES | Futures | 1514.91 | 1515.43 | 1514.4 | 1515.43 | 24738.0 |
| 2013-01-18 14:30:00 | ES | Futures | 1515.43 | 1516.45 | 1514.91 | 1515.17 | 38801.0 |
| 2013-01-18 15:00:00 | ES | Futures | 1515.43 | 1516.2 | 1514.66 | 1516.2 | 37632.0 |
| 2013-01-18 15:30:00 | ES | Futures | 1515.94 | 1520.05 | 1515.94 | 1518.51 | 206459.0 |
| 2013-01-18 16:00:00 | ES | Futures | 1518.51 | 1519.28 | 1516.71 | 1517.99 | 90172.0 |
| 2013-01-18 16:30:00 | ES | Futures | 1517.99 | 1519.02 | 1517.48 | 1518.25 | 7746.0 |
| 2013-01-18 17:00:00 | ES | Futures | 1518.25 | 1519.02 | 1517.99 | 1518.76 | 1535.0 |
| 2013-01-18 00:00:00 | NQ | Futures | 3184.88 | 3186.92 | 3184.3 | 3185.75 | 253.0 |
| 2013-01-18 00:30:00 | NQ | Futures | 3185.75 | 3188.08 | 3185.75 | 3187.79 | 161.0 |
| 2013-01-18 01:00:00 | NQ | Futures | 3188.08 | 3188.37 | 3186.92 | 3186.92 | 140.0 |
| 2013-01-18 01:30:00 | NQ | Futures | 3186.92 | 3188.66 | 3186.92 | 3188.66 | 74.0 |
| 2013-01-18 02:00:00 | NQ | Futures | 3188.66 | 3191.28 | 3188.37 | 3190.99 | 525.0 |
| 2013-01-18 02:30:00 | NQ | Futures | 3190.7 | 3192.15 | 3188.95 | 3191.57 | 769.0 |
| 2013-01-18 03:00:00 | NQ | Futures | 3191.28 | 3191.28 | 3186.92 | 3186.92 | 1965.0 |
| 2013-01-18 03:30:00 | NQ | Futures | 3186.92 | 3190.7 | 3186.04 | 3186.62 | 1384.0 |
| 2013-01-18 04:00:00 | NQ | Futures | 3186.33 | 3187.5 | 3184.0 | 3184.59 | 1146.0 |
| 2013-01-18 04:30:00 | NQ | Futures | 3184.88 | 3185.46 | 3182.84 | 3184.3 | 801.0 |
| 2013-01-18 05:00:00 | NQ | Futures | 3184.59 | 3187.21 | 3184.0 | 3186.04 | 680.0 |
| 2013-01-18 05:30:00 | NQ | Futures | 3186.33 | 3187.79 | 3184.88 | 3185.46 | 732.0 |
| 2013-01-18 06:00:00 | NQ | Futures | 3185.46 | 3187.5 | 3183.42 | 3184.0 | 972.0 |
| 2013-01-18 06:30:00 | NQ | Futures | 3183.71 | 3184.59 | 3180.51 | 3181.39 | 1473.0 |
| 2013-01-18 07:00:00 | NQ | Futures | 3181.39 | 3181.97 | 3177.89 | 3180.8 | 3684.0 |
> showing 50 of 2,375 rows — these rows as CSV