PREVIEW / etf_30min / 2015-03-17
file: by_date/etf_30min/2015/2015-03-17.parquet size: 375 KB rows: 12,614
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-03-17 04:00:00 | SPY | ETF | 208.12 | 208.31 | 208.12 | 208.13 | 2300.0 |
| 2015-03-17 04:30:00 | SPY | ETF | 208.08 | 208.08 | 208.01 | 208.01 | 1800.0 |
| 2015-03-17 05:00:00 | SPY | ETF | 208.01 | 208.01 | 207.8 | 207.81 | 2080.0 |
| 2015-03-17 05:30:00 | SPY | ETF | 207.88 | 207.88 | 207.78 | 207.84 | 6941.0 |
| 2015-03-17 06:00:00 | SPY | ETF | 207.7 | 207.7 | 207.5 | 207.53 | 11516.0 |
| 2015-03-17 06:30:00 | SPY | ETF | 207.5 | 207.59 | 207.48 | 207.48 | 15187.0 |
| 2015-03-17 07:00:00 | SPY | ETF | 207.49 | 207.61 | 207.43 | 207.46 | 75605.0 |
| 2015-03-17 07:30:00 | SPY | ETF | 207.43 | 207.61 | 207.43 | 207.54 | 322440.0 |
| 2015-03-17 08:00:00 | SPY | ETF | 207.39 | 207.85 | 207.39 | 207.77 | 763589.0 |
| 2015-03-17 08:30:00 | SPY | ETF | 207.79 | 207.81 | 207.5 | 207.76 | 662379.0 |
| 2015-03-17 09:00:00 | SPY | ETF | 207.75 | 207.8 | 207.63 | 207.71 | 406254.0 |
| 2015-03-17 09:30:00 | SPY | ETF | 207.69 | 208.05 | 207.25 | 207.571 | 12867937.0 |
| 2015-03-17 10:00:00 | SPY | ETF | 207.57 | 207.75 | 207.435 | 207.72 | 7326476.0 |
| 2015-03-17 10:30:00 | SPY | ETF | 207.72 | 207.86 | 207.54 | 207.65 | 5153834.0 |
| 2015-03-17 11:00:00 | SPY | ETF | 207.65 | 207.65 | 206.98 | 207.29 | 8465851.0 |
| 2015-03-17 11:30:00 | SPY | ETF | 207.3 | 207.49 | 207.13 | 207.47 | 6274255.0 |
| 2015-03-17 12:00:00 | SPY | ETF | 207.47 | 207.57 | 207.14 | 207.495 | 4552993.0 |
| 2015-03-17 12:30:00 | SPY | ETF | 207.5 | 207.86 | 207.38 | 207.85 | 5152506.0 |
| 2015-03-17 13:00:00 | SPY | ETF | 207.85 | 208.05 | 207.72 | 207.905 | 3954567.0 |
| 2015-03-17 13:30:00 | SPY | ETF | 207.905 | 208.15 | 207.78 | 208.1 | 3905476.0 |
| 2015-03-17 14:00:00 | SPY | ETF | 208.09 | 208.25 | 207.79 | 207.845 | 4030826.0 |
| 2015-03-17 14:30:00 | SPY | ETF | 207.84 | 208.03 | 207.69 | 207.99 | 3648290.0 |
| 2015-03-17 15:00:00 | SPY | ETF | 207.99 | 208.34 | 207.97 | 208.29 | 6213862.0 |
| 2015-03-17 15:30:00 | SPY | ETF | 208.28 | 208.42 | 207.89 | 207.98 | 13280722.0 |
| 2015-03-17 16:00:00 | SPY | ETF | 207.99 | 208.06 | 207.6044 | 208.02 | 2999665.0 |
| 2015-03-17 16:30:00 | SPY | ETF | 208.03 | 208.05 | 207.91 | 207.96 | 3056325.0 |
| 2015-03-17 17:00:00 | SPY | ETF | 207.99 | 208.01 | 207.96 | 208.01 | 129286.0 |
| 2015-03-17 17:30:00 | SPY | ETF | 207.98 | 208.0 | 207.97 | 207.97 | 10150.0 |
| 2015-03-17 18:00:00 | SPY | ETF | 207.98 | 208.05 | 207.97 | 208.03 | 13293.0 |
| 2015-03-17 18:30:00 | SPY | ETF | 208.01 | 208.01 | 207.98 | 207.98 | 4650.0 |
| 2015-03-17 19:00:00 | SPY | ETF | 208.01 | 208.03 | 208.0 | 208.03 | 23919.0 |
| 2015-03-17 19:30:00 | SPY | ETF | 208.05 | 208.09 | 208.05 | 208.05 | 17835.0 |
| 2015-03-17 04:00:00 | QQQ | ETF | 106.58 | 106.58 | 106.58 | 106.58 | 728.0 |
| 2015-03-17 04:30:00 | QQQ | ETF | 106.45 | 106.45 | 106.45 | 106.45 | 380.0 |
| 2015-03-17 05:30:00 | QQQ | ETF | 106.3 | 106.3 | 106.3 | 106.3 | 3000.0 |
| 2015-03-17 06:00:00 | QQQ | ETF | 106.3 | 106.3 | 106.14 | 106.18 | 13000.0 |
| 2015-03-17 07:00:00 | QQQ | ETF | 106.24 | 106.24 | 106.2 | 106.2 | 4260.0 |
| 2015-03-17 07:30:00 | QQQ | ETF | 106.2 | 106.29 | 106.18 | 106.27 | 48260.0 |
| 2015-03-17 08:00:00 | QQQ | ETF | 106.3 | 106.41 | 106.3 | 106.38 | 74356.0 |
| 2015-03-17 08:30:00 | QQQ | ETF | 106.36 | 106.45 | 106.3 | 106.45 | 55634.0 |
| 2015-03-17 09:00:00 | QQQ | ETF | 106.44 | 106.47 | 106.4 | 106.41 | 105831.0 |
| 2015-03-17 09:30:00 | QQQ | ETF | 106.405 | 106.62 | 106.26 | 106.55 | 3227724.0 |
| 2015-03-17 10:00:00 | QQQ | ETF | 106.54 | 106.5699 | 106.395 | 106.52 | 1369026.0 |
| 2015-03-17 10:30:00 | QQQ | ETF | 106.52 | 106.57 | 106.41 | 106.47 | 1211519.0 |
| 2015-03-17 11:00:00 | QQQ | ETF | 106.46 | 106.46 | 106.16 | 106.33 | 1723260.0 |
| 2015-03-17 11:30:00 | QQQ | ETF | 106.33 | 106.54 | 106.27 | 106.53 | 770128.0 |
| 2015-03-17 12:00:00 | QQQ | ETF | 106.528 | 106.58 | 106.4 | 106.55 | 719910.0 |
| 2015-03-17 12:30:00 | QQQ | ETF | 106.5533 | 106.7 | 106.5 | 106.695 | 1105699.0 |
| 2015-03-17 13:00:00 | QQQ | ETF | 106.7 | 106.81 | 106.65 | 106.75 | 828369.0 |
| 2015-03-17 13:30:00 | QQQ | ETF | 106.7499 | 106.905 | 106.675 | 106.87 | 835533.0 |
> showing 50 of 12,614 rows — these rows as CSV