PREVIEW / etf_30min / 2015-03-25
file: by_date/etf_30min/2015/2015-03-25.parquet size: 386 KB rows: 12,766
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-25 04:00:00 | SPY | ETF | 208.92 | 209.09 | 208.92 | 209.07 | 34800.0 |
| 2015-03-25 04:30:00 | SPY | ETF | 209.02 | 209.07 | 208.99 | 208.99 | 10800.0 |
| 2015-03-25 05:00:00 | SPY | ETF | 209.01 | 209.07 | 208.97 | 208.97 | 1744.0 |
| 2015-03-25 05:30:00 | SPY | ETF | 208.97 | 209.18 | 208.93 | 209.17 | 14023.0 |
| 2015-03-25 06:00:00 | SPY | ETF | 209.17 | 209.2 | 209.02 | 209.03 | 2700.0 |
| 2015-03-25 06:30:00 | SPY | ETF | 209.0 | 209.07 | 208.99 | 209.04 | 9718.0 |
| 2015-03-25 07:00:00 | SPY | ETF | 208.95 | 208.98 | 208.79 | 208.8 | 26640.0 |
| 2015-03-25 07:30:00 | SPY | ETF | 208.8 | 208.85 | 208.58 | 208.76 | 85546.0 |
| 2015-03-25 08:00:00 | SPY | ETF | 208.75 | 208.95 | 208.61 | 208.88 | 284453.0 |
| 2015-03-25 08:30:00 | SPY | ETF | 208.9 | 209.05 | 208.79 | 209.0 | 289163.0 |
| 2015-03-25 09:00:00 | SPY | ETF | 208.98 | 209.19 | 208.98 | 209.07 | 1045105.0 |
| 2015-03-25 09:30:00 | SPY | ETF | 209.07 | 209.35 | 208.29 | 208.52 | 12887876.0 |
| 2015-03-25 10:00:00 | SPY | ETF | 208.51 | 208.96 | 208.39 | 208.81 | 8291928.0 |
| 2015-03-25 10:30:00 | SPY | ETF | 208.81 | 208.81 | 208.29 | 208.74 | 6652615.0 |
| 2015-03-25 11:00:00 | SPY | ETF | 208.74 | 208.87 | 208.181 | 208.33 | 6335441.0 |
| 2015-03-25 11:30:00 | SPY | ETF | 208.32 | 208.32 | 207.08 | 207.3545 | 12316948.0 |
| 2015-03-25 12:00:00 | SPY | ETF | 207.36 | 207.42 | 206.82 | 207.07 | 10326099.0 |
| 2015-03-25 12:30:00 | SPY | ETF | 207.07 | 207.2531 | 206.65 | 207.03 | 7803689.0 |
| 2015-03-25 13:00:00 | SPY | ETF | 207.03 | 207.09 | 206.495 | 206.79 | 5919050.0 |
| 2015-03-25 13:30:00 | SPY | ETF | 206.7901 | 207.16 | 206.62 | 206.89 | 9115243.0 |
| 2015-03-25 14:00:00 | SPY | ETF | 206.8901 | 207.13 | 206.7 | 207.125 | 7554681.0 |
| 2015-03-25 14:30:00 | SPY | ETF | 207.12 | 207.13 | 206.64 | 206.74 | 7409002.0 |
| 2015-03-25 15:00:00 | SPY | ETF | 206.75 | 206.76 | 206.15 | 206.21 | 15195913.0 |
| 2015-03-25 15:30:00 | SPY | ETF | 206.21 | 206.3 | 205.71 | 205.75 | 31062614.0 |
| 2015-03-25 16:00:00 | SPY | ETF | 205.74 | 208.7623 | 205.72 | 205.85 | 10532841.0 |
| 2015-03-25 16:30:00 | SPY | ETF | 205.86 | 206.0 | 205.8 | 205.99 | 3182751.0 |
| 2015-03-25 17:00:00 | SPY | ETF | 205.99 | 206.07 | 205.97 | 206.04 | 1243377.0 |
| 2015-03-25 17:30:00 | SPY | ETF | 206.04 | 206.08 | 206.02 | 206.06 | 27113.0 |
| 2015-03-25 18:00:00 | SPY | ETF | 206.06 | 206.09 | 205.87 | 205.97 | 85936.0 |
| 2015-03-25 18:30:00 | SPY | ETF | 205.93 | 206.0 | 205.87 | 206.0 | 20981.0 |
| 2015-03-25 19:00:00 | SPY | ETF | 206.0 | 206.02 | 205.97 | 205.97 | 4654.0 |
| 2015-03-25 19:30:00 | SPY | ETF | 206.0 | 206.08 | 205.98 | 206.08 | 98739.0 |
| 2015-03-25 06:30:00 | QQQ | ETF | 108.22 | 108.22 | 108.14 | 108.15 | 2100.0 |
| 2015-03-25 07:00:00 | QQQ | ETF | 108.12 | 108.14 | 108.07 | 108.07 | 7420.0 |
| 2015-03-25 07:30:00 | QQQ | ETF | 108.02 | 108.1 | 107.92 | 107.92 | 6821.0 |
| 2015-03-25 08:00:00 | QQQ | ETF | 108.02 | 108.1 | 108.0 | 108.1 | 85934.0 |
| 2015-03-25 08:30:00 | QQQ | ETF | 108.07 | 108.15 | 108.04 | 108.12 | 89215.0 |
| 2015-03-25 09:00:00 | QQQ | ETF | 108.17 | 108.25 | 108.1 | 108.1 | 176912.0 |
| 2015-03-25 09:30:00 | QQQ | ETF | 108.1 | 108.2 | 107.2627 | 107.371 | 4654101.0 |
| 2015-03-25 10:00:00 | QQQ | ETF | 107.365 | 107.7 | 107.2301 | 107.59 | 2559872.0 |
| 2015-03-25 10:30:00 | QQQ | ETF | 107.59 | 107.63 | 107.26 | 107.5 | 1771785.0 |
| 2015-03-25 11:00:00 | QQQ | ETF | 107.5 | 107.56 | 107.1 | 107.13 | 1999481.0 |
| 2015-03-25 11:30:00 | QQQ | ETF | 107.13 | 107.13 | 106.36 | 106.579 | 5214363.0 |
| 2015-03-25 12:00:00 | QQQ | ETF | 106.578 | 106.59 | 106.19 | 106.34 | 2982496.0 |
| 2015-03-25 12:30:00 | QQQ | ETF | 106.33 | 106.34 | 106.05 | 106.27 | 2617478.0 |
| 2015-03-25 13:00:00 | QQQ | ETF | 106.275 | 106.33 | 105.92 | 106.091 | 2497256.0 |
| 2015-03-25 13:30:00 | QQQ | ETF | 106.1 | 106.36 | 105.96 | 106.17 | 1700895.0 |
| 2015-03-25 14:00:00 | QQQ | ETF | 106.17 | 106.32 | 106.0 | 106.315 | 1373375.0 |
| 2015-03-25 14:30:00 | QQQ | ETF | 106.319 | 106.32 | 105.98 | 106.01 | 1263547.0 |
| 2015-03-25 15:00:00 | QQQ | ETF | 106.02 | 106.03 | 105.63 | 105.68 | 2459776.0 |
> showing 50 of 12,766 rows — these rows as CSV