PREVIEW / etf_30min / 2015-09-25
file: by_date/etf_30min/2015/2015-09-25.parquet size: 377 KB rows: 12,819
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-09-25 04:00:00 | SPY | ETF | 193.85 | 194.85 | 193.85 | 194.66 | 47662.0 |
| 2015-09-25 04:30:00 | SPY | ETF | 194.59 | 195.9 | 194.51 | 195.51 | 53793.0 |
| 2015-09-25 05:00:00 | SPY | ETF | 195.4 | 195.72 | 195.3 | 195.4 | 8760.0 |
| 2015-09-25 05:30:00 | SPY | ETF | 195.51 | 195.7 | 195.45 | 195.5 | 21096.0 |
| 2015-09-25 06:00:00 | SPY | ETF | 195.43 | 195.49 | 195.12 | 195.16 | 148646.0 |
| 2015-09-25 06:30:00 | SPY | ETF | 195.16 | 195.22 | 194.94 | 194.94 | 109475.0 |
| 2015-09-25 07:00:00 | SPY | ETF | 195.0 | 195.07 | 194.65 | 194.98 | 401324.0 |
| 2015-09-25 07:30:00 | SPY | ETF | 194.98 | 195.53 | 194.95 | 195.4 | 1170109.0 |
| 2015-09-25 08:00:00 | SPY | ETF | 195.39 | 195.44 | 192.77 | 195.09 | 826166.0 |
| 2015-09-25 08:30:00 | SPY | ETF | 195.09 | 195.29 | 194.67 | 194.86 | 1598999.0 |
| 2015-09-25 09:00:00 | SPY | ETF | 194.85 | 195.3349 | 194.58 | 194.64 | 1454585.0 |
| 2015-09-25 09:30:00 | SPY | ETF | 194.64 | 194.83 | 193.95 | 194.43 | 17176733.0 |
| 2015-09-25 10:00:00 | SPY | ETF | 194.42 | 194.62 | 193.85 | 194.02 | 8192150.0 |
| 2015-09-25 10:30:00 | SPY | ETF | 194.02 | 194.7 | 193.85 | 194.67 | 8984358.0 |
| 2015-09-25 11:00:00 | SPY | ETF | 194.67 | 194.7 | 194.29 | 194.52 | 5305758.0 |
| 2015-09-25 11:30:00 | SPY | ETF | 194.53 | 194.59 | 194.135 | 194.455 | 5240221.0 |
| 2015-09-25 12:00:00 | SPY | ETF | 194.46 | 194.47 | 193.94 | 194.17 | 5084069.0 |
| 2015-09-25 12:30:00 | SPY | ETF | 194.175 | 194.61 | 194.16 | 194.51 | 4989662.0 |
| 2015-09-25 13:00:00 | SPY | ETF | 194.515 | 195.0 | 194.4708 | 194.58 | 7521107.0 |
| 2015-09-25 13:30:00 | SPY | ETF | 194.58 | 194.67 | 194.36 | 194.481 | 6223260.0 |
| 2015-09-25 14:00:00 | SPY | ETF | 194.49 | 194.72 | 193.28 | 193.365 | 8654242.0 |
| 2015-09-25 14:30:00 | SPY | ETF | 193.35 | 193.54 | 192.31 | 193.02 | 17144932.0 |
| 2015-09-25 15:00:00 | SPY | ETF | 193.03 | 193.08 | 191.81 | 192.6 | 16650890.0 |
| 2015-09-25 15:30:00 | SPY | ETF | 192.6 | 193.26 | 192.45 | 192.81 | 19963653.0 |
| 2015-09-25 16:00:00 | SPY | ETF | 192.81 | 192.99 | 192.61 | 192.66 | 8793795.0 |
| 2015-09-25 16:30:00 | SPY | ETF | 192.63 | 192.865 | 192.21 | 192.31 | 7978333.0 |
| 2015-09-25 17:00:00 | SPY | ETF | 192.32 | 193.1549 | 192.32 | 192.35 | 131131.0 |
| 2015-09-25 17:30:00 | SPY | ETF | 192.35 | 192.85 | 192.16 | 192.17 | 126863.0 |
| 2015-09-25 18:00:00 | SPY | ETF | 192.17 | 192.41 | 192.16 | 192.3 | 83573.0 |
| 2015-09-25 18:30:00 | SPY | ETF | 192.27 | 192.38 | 192.27 | 192.32 | 4996.0 |
| 2015-09-25 19:00:00 | SPY | ETF | 192.36 | 192.41 | 192.35 | 192.35 | 8115.0 |
| 2015-09-25 19:30:00 | SPY | ETF | 192.37 | 192.37 | 192.3 | 192.3 | 15314.0 |
| 2015-09-25 04:00:00 | QQQ | ETF | 104.29 | 104.76 | 104.29 | 104.71 | 16400.0 |
| 2015-09-25 04:30:00 | QQQ | ETF | 104.85 | 105.27 | 104.8 | 105.27 | 8120.0 |
| 2015-09-25 05:00:00 | QQQ | ETF | 105.29 | 105.32 | 105.17 | 105.2 | 50200.0 |
| 2015-09-25 05:30:00 | QQQ | ETF | 105.09 | 105.19 | 105.05 | 105.05 | 2185.0 |
| 2015-09-25 06:00:00 | QQQ | ETF | 105.0 | 105.03 | 104.89 | 104.93 | 24078.0 |
| 2015-09-25 06:30:00 | QQQ | ETF | 104.92 | 104.95 | 104.85 | 104.95 | 93485.0 |
| 2015-09-25 07:00:00 | QQQ | ETF | 104.9 | 104.91 | 104.73 | 104.89 | 13118.0 |
| 2015-09-25 07:30:00 | QQQ | ETF | 104.89 | 105.14 | 104.89 | 105.1 | 154893.0 |
| 2015-09-25 08:00:00 | QQQ | ETF | 105.1 | 105.14 | 104.92 | 105.03 | 110502.0 |
| 2015-09-25 08:30:00 | QQQ | ETF | 105.04 | 105.13 | 104.86 | 104.97 | 100812.0 |
| 2015-09-25 09:00:00 | QQQ | ETF | 104.94 | 105.03 | 104.76 | 104.9 | 411898.0 |
| 2015-09-25 09:30:00 | QQQ | ETF | 104.91 | 105.01 | 104.46 | 104.68 | 4596779.0 |
| 2015-09-25 10:00:00 | QQQ | ETF | 104.68 | 104.81 | 104.211 | 104.28 | 1876823.0 |
| 2015-09-25 10:30:00 | QQQ | ETF | 104.27 | 104.72 | 104.17 | 104.709 | 2812604.0 |
| 2015-09-25 11:00:00 | QQQ | ETF | 104.7 | 104.78 | 104.51 | 104.6199 | 1116991.0 |
| 2015-09-25 11:30:00 | QQQ | ETF | 104.62 | 104.66 | 104.26 | 104.419 | 950699.0 |
| 2015-09-25 12:00:00 | QQQ | ETF | 104.405 | 104.41 | 104.0 | 104.13 | 1468795.0 |
| 2015-09-25 12:30:00 | QQQ | ETF | 104.13 | 104.4185 | 104.11 | 104.37 | 1247450.0 |
> showing 50 of 12,819 rows — these rows as CSV