PREVIEW / etf_30min / 2015-04-17
file: by_date/etf_30min/2015/2015-04-17.parquet size: 392 KB rows: 13,065
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-04-17 04:00:00 | SPY | ETF | 210.25 | 210.25 | 210.17 | 210.19 | 2875.0 |
| 2015-04-17 04:30:00 | SPY | ETF | 210.18 | 210.28 | 210.18 | 210.28 | 3796.0 |
| 2015-04-17 05:00:00 | SPY | ETF | 210.28 | 210.28 | 210.17 | 210.19 | 9175.0 |
| 2015-04-17 05:30:00 | SPY | ETF | 210.21 | 210.21 | 210.04 | 210.04 | 17701.0 |
| 2015-04-17 06:00:00 | SPY | ETF | 209.99 | 209.99 | 208.75 | 208.76 | 194787.0 |
| 2015-04-17 06:30:00 | SPY | ETF | 208.81 | 209.32 | 208.79 | 209.21 | 309446.0 |
| 2015-04-17 07:00:00 | SPY | ETF | 209.2 | 209.38 | 209.12 | 209.38 | 299585.0 |
| 2015-04-17 07:30:00 | SPY | ETF | 209.37 | 209.37 | 209.16 | 209.24 | 166435.0 |
| 2015-04-17 08:00:00 | SPY | ETF | 209.29 | 209.72 | 209.0 | 209.38 | 897242.0 |
| 2015-04-17 08:30:00 | SPY | ETF | 209.42 | 209.44 | 209.16 | 209.27 | 885986.0 |
| 2015-04-17 09:00:00 | SPY | ETF | 209.26 | 209.26 | 208.93 | 208.95 | 1407890.0 |
| 2015-04-17 09:30:00 | SPY | ETF | 208.94 | 209.23 | 208.17 | 208.395 | 23498121.0 |
| 2015-04-17 10:00:00 | SPY | ETF | 208.4 | 208.51 | 207.8 | 208.05 | 15030777.0 |
| 2015-04-17 10:30:00 | SPY | ETF | 208.055 | 208.49 | 207.97 | 207.97 | 11657543.0 |
| 2015-04-17 11:00:00 | SPY | ETF | 207.98 | 208.25 | 207.69 | 208.17 | 8101480.0 |
| 2015-04-17 11:30:00 | SPY | ETF | 208.175 | 208.35 | 207.86 | 208.19 | 7535648.0 |
| 2015-04-17 12:00:00 | SPY | ETF | 208.19 | 208.33 | 208.01 | 208.09 | 4399586.0 |
| 2015-04-17 12:30:00 | SPY | ETF | 208.09 | 208.29 | 207.98 | 208.16 | 5851818.0 |
| 2015-04-17 13:00:00 | SPY | ETF | 208.15 | 208.3 | 208.01 | 208.06 | 6276398.0 |
| 2015-04-17 13:30:00 | SPY | ETF | 208.06 | 208.07 | 207.34 | 207.45 | 10764678.0 |
| 2015-04-17 14:00:00 | SPY | ETF | 207.46 | 207.56 | 207.01 | 207.365 | 17453601.0 |
| 2015-04-17 14:30:00 | SPY | ETF | 207.37 | 207.52 | 207.2 | 207.38 | 12761715.0 |
| 2015-04-17 15:00:00 | SPY | ETF | 207.38 | 207.71 | 207.33 | 207.64 | 12708977.0 |
| 2015-04-17 15:30:00 | SPY | ETF | 207.635 | 208.2 | 207.615 | 207.93 | 21974991.0 |
| 2015-04-17 16:00:00 | SPY | ETF | 207.93 | 210.3261 | 207.45 | 208.06 | 10199771.0 |
| 2015-04-17 16:30:00 | SPY | ETF | 208.07 | 210.3261 | 207.95 | 208.13 | 4023011.0 |
| 2015-04-17 17:00:00 | SPY | ETF | 208.14 | 208.17 | 207.7476 | 208.139 | 7798993.0 |
| 2015-04-17 17:30:00 | SPY | ETF | 208.14 | 208.15 | 208.1 | 208.13 | 19790.0 |
| 2015-04-17 18:00:00 | SPY | ETF | 208.14 | 208.15 | 208.11 | 208.11 | 48402.0 |
| 2015-04-17 18:30:00 | SPY | ETF | 208.1 | 208.11 | 208.1 | 208.11 | 1290.0 |
| 2015-04-17 19:00:00 | SPY | ETF | 208.1 | 208.1 | 208.08 | 208.08 | 7259.0 |
| 2015-04-17 19:30:00 | SPY | ETF | 208.089 | 208.089 | 208.06 | 208.08 | 33584.0 |
| 2015-04-17 05:30:00 | QQQ | ETF | 107.43 | 107.43 | 107.43 | 107.43 | 100.0 |
| 2015-04-17 06:00:00 | QQQ | ETF | 107.3 | 107.3 | 106.5 | 106.5 | 67950.0 |
| 2015-04-17 06:30:00 | QQQ | ETF | 106.51 | 106.8 | 106.51 | 106.77 | 55091.0 |
| 2015-04-17 07:00:00 | QQQ | ETF | 106.77 | 106.87 | 106.75 | 106.87 | 16737.0 |
| 2015-04-17 07:30:00 | QQQ | ETF | 106.85 | 106.85 | 106.8 | 106.82 | 64310.0 |
| 2015-04-17 08:00:00 | QQQ | ETF | 106.88 | 107.1 | 106.75 | 106.96 | 115631.0 |
| 2015-04-17 08:30:00 | QQQ | ETF | 106.99 | 106.99 | 106.84 | 106.85 | 88995.0 |
| 2015-04-17 09:00:00 | QQQ | ETF | 106.84 | 106.9 | 106.67 | 106.67 | 326175.0 |
| 2015-04-17 09:30:00 | QQQ | ETF | 106.66 | 106.95 | 106.19 | 106.32 | 7388671.0 |
| 2015-04-17 10:00:00 | QQQ | ETF | 106.34 | 106.4 | 105.97 | 106.1 | 5048061.0 |
| 2015-04-17 10:30:00 | QQQ | ETF | 106.08 | 106.31 | 106.05 | 106.07 | 2252712.0 |
| 2015-04-17 11:00:00 | QQQ | ETF | 106.06 | 106.23 | 105.94 | 106.13 | 1866142.0 |
| 2015-04-17 11:30:00 | QQQ | ETF | 106.13 | 106.2 | 105.97 | 106.13 | 1582209.0 |
| 2015-04-17 12:00:00 | QQQ | ETF | 106.125 | 106.21 | 106.05 | 106.1 | 865068.0 |
| 2015-04-17 12:30:00 | QQQ | ETF | 106.09 | 106.17 | 105.99 | 106.11 | 1107831.0 |
| 2015-04-17 13:00:00 | QQQ | ETF | 106.1 | 106.19 | 106.07 | 106.11 | 751652.0 |
| 2015-04-17 13:30:00 | QQQ | ETF | 106.1 | 106.1 | 105.74 | 105.78 | 2255884.0 |
| 2015-04-17 14:00:00 | QQQ | ETF | 105.78 | 105.85 | 105.55 | 105.7761 | 2763659.0 |
> showing 50 of 13,065 rows — these rows as CSV