PREVIEW / etf_30min / 2015-12-29
file: by_date/etf_30min/2015/2015-12-29.parquet size: 397 KB rows: 13,400
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-29 04:00:00 | SPY | ETF | 206.02 | 206.31 | 206.02 | 206.31 | 19933.0 |
| 2015-12-29 04:30:00 | SPY | ETF | 206.3 | 206.3 | 206.26 | 206.3 | 1410.0 |
| 2015-12-29 05:00:00 | SPY | ETF | 206.21 | 206.24 | 206.09 | 206.18 | 1700.0 |
| 2015-12-29 05:30:00 | SPY | ETF | 206.15 | 206.22 | 206.15 | 206.16 | 1200.0 |
| 2015-12-29 06:00:00 | SPY | ETF | 206.19 | 206.19 | 206.05 | 206.14 | 3300.0 |
| 2015-12-29 06:30:00 | SPY | ETF | 206.1 | 206.17 | 205.94 | 205.94 | 8910.0 |
| 2015-12-29 07:00:00 | SPY | ETF | 206.08 | 206.22 | 206.05 | 206.21 | 107583.0 |
| 2015-12-29 07:30:00 | SPY | ETF | 206.25 | 206.33 | 206.22 | 206.22 | 56910.0 |
| 2015-12-29 08:00:00 | SPY | ETF | 206.24 | 206.33 | 205.235 | 206.3 | 266667.0 |
| 2015-12-29 08:30:00 | SPY | ETF | 206.31 | 206.75 | 206.31 | 206.69 | 580921.0 |
| 2015-12-29 09:00:00 | SPY | ETF | 206.69 | 206.71 | 206.51 | 206.51 | 316951.0 |
| 2015-12-29 09:30:00 | SPY | ETF | 206.51 | 207.09 | 206.47 | 207.0289 | 10072463.0 |
| 2015-12-29 10:00:00 | SPY | ETF | 207.02 | 207.24 | 207.01 | 207.18 | 6713364.0 |
| 2015-12-29 10:30:00 | SPY | ETF | 207.17 | 207.25 | 206.91 | 206.96 | 4439850.0 |
| 2015-12-29 11:00:00 | SPY | ETF | 206.9599 | 207.2 | 206.9599 | 207.15 | 5953079.0 |
| 2015-12-29 11:30:00 | SPY | ETF | 207.15 | 207.28 | 206.77 | 206.92 | 4459701.0 |
| 2015-12-29 12:00:00 | SPY | ETF | 206.925 | 207.19 | 206.88 | 207.075 | 4309143.0 |
| 2015-12-29 12:30:00 | SPY | ETF | 207.07 | 207.16 | 207.0 | 207.1 | 2106169.0 |
| 2015-12-29 13:00:00 | SPY | ETF | 207.11 | 207.36 | 207.08 | 207.26 | 3637210.0 |
| 2015-12-29 13:30:00 | SPY | ETF | 207.26 | 207.55 | 207.17 | 207.513 | 6242033.0 |
| 2015-12-29 14:00:00 | SPY | ETF | 207.52 | 207.61 | 207.42 | 207.59 | 5160591.0 |
| 2015-12-29 14:30:00 | SPY | ETF | 207.581 | 207.64 | 207.34 | 207.605 | 7121120.0 |
| 2015-12-29 15:00:00 | SPY | ETF | 207.6 | 207.79 | 207.57 | 207.6375 | 7852643.0 |
| 2015-12-29 15:30:00 | SPY | ETF | 207.64 | 207.69 | 207.25 | 207.43 | 14212918.0 |
| 2015-12-29 16:00:00 | SPY | ETF | 207.43 | 207.68 | 207.2547 | 207.64 | 7843745.0 |
| 2015-12-29 16:30:00 | SPY | ETF | 207.65 | 207.73 | 207.62 | 207.7 | 189840.0 |
| 2015-12-29 17:00:00 | SPY | ETF | 207.7 | 207.75 | 207.68 | 207.7 | 47495.0 |
| 2015-12-29 17:30:00 | SPY | ETF | 207.69 | 207.71 | 207.63 | 207.63 | 58200.0 |
| 2015-12-29 18:00:00 | SPY | ETF | 207.63 | 207.65 | 207.51 | 207.51 | 97247.0 |
| 2015-12-29 18:30:00 | SPY | ETF | 207.51 | 207.55 | 207.51 | 207.51 | 7741.0 |
| 2015-12-29 19:00:00 | SPY | ETF | 207.55 | 207.62 | 207.55 | 207.59 | 14629.0 |
| 2015-12-29 19:30:00 | SPY | ETF | 207.62 | 207.69 | 207.55 | 207.69 | 51960.0 |
| 2015-12-29 04:00:00 | QQQ | ETF | 112.84 | 113.11 | 112.84 | 113.11 | 20636.0 |
| 2015-12-29 04:30:00 | QQQ | ETF | 113.2 | 113.2 | 113.17 | 113.19 | 800.0 |
| 2015-12-29 05:00:00 | QQQ | ETF | 113.11 | 113.13 | 113.05 | 113.05 | 10850.0 |
| 2015-12-29 06:00:00 | QQQ | ETF | 113.13 | 113.13 | 113.06 | 113.06 | 3420.0 |
| 2015-12-29 06:30:00 | QQQ | ETF | 113.09 | 113.09 | 113.09 | 113.09 | 100.0 |
| 2015-12-29 07:00:00 | QQQ | ETF | 113.0 | 113.06 | 113.0 | 113.06 | 1200.0 |
| 2015-12-29 07:30:00 | QQQ | ETF | 113.17 | 113.17 | 113.1 | 113.1 | 3121.0 |
| 2015-12-29 08:00:00 | QQQ | ETF | 113.1 | 113.16 | 113.06 | 113.15 | 68281.0 |
| 2015-12-29 08:30:00 | QQQ | ETF | 113.15 | 113.37 | 113.15 | 113.3 | 90496.0 |
| 2015-12-29 09:00:00 | QQQ | ETF | 113.31 | 113.31 | 113.2 | 113.21 | 100432.0 |
| 2015-12-29 09:30:00 | QQQ | ETF | 113.215 | 113.61 | 113.13 | 113.605 | 3105285.0 |
| 2015-12-29 10:00:00 | QQQ | ETF | 113.61 | 113.8817 | 113.6 | 113.87 | 2435060.0 |
| 2015-12-29 10:30:00 | QQQ | ETF | 113.87 | 113.93 | 113.755 | 113.86 | 1226488.0 |
| 2015-12-29 11:00:00 | QQQ | ETF | 113.86 | 114.07 | 113.85 | 114.01 | 1143747.0 |
| 2015-12-29 11:30:00 | QQQ | ETF | 114.02 | 114.12 | 113.87 | 113.98 | 1142202.0 |
| 2015-12-29 12:00:00 | QQQ | ETF | 113.97 | 114.1399 | 113.95 | 114.03 | 984843.0 |
| 2015-12-29 12:30:00 | QQQ | ETF | 114.03 | 114.15 | 114.01 | 114.14 | 763793.0 |
| 2015-12-29 13:00:00 | QQQ | ETF | 114.1349 | 114.26 | 114.08 | 114.23 | 1180792.0 |
> showing 50 of 13,400 rows — these rows as CSV