PREVIEW / etf_30min / 2015-10-12
file: by_date/etf_30min/2015/2015-10-12.parquet size: 357 KB rows: 12,079
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-10-12 04:00:00 | SPY | ETF | 201.52 | 201.6 | 201.52 | 201.52 | 2401.0 |
| 2015-10-12 04:30:00 | SPY | ETF | 201.51 | 201.51 | 201.3 | 201.3 | 2902.0 |
| 2015-10-12 05:00:00 | SPY | ETF | 201.32 | 201.35 | 201.15 | 201.32 | 8482.0 |
| 2015-10-12 05:30:00 | SPY | ETF | 201.27 | 201.37 | 201.27 | 201.37 | 6607.0 |
| 2015-10-12 06:00:00 | SPY | ETF | 201.39 | 201.43 | 201.34 | 201.42 | 50121.0 |
| 2015-10-12 06:30:00 | SPY | ETF | 201.41 | 201.54 | 201.39 | 201.5 | 11043.0 |
| 2015-10-12 07:00:00 | SPY | ETF | 201.51 | 201.57 | 201.31 | 201.31 | 33370.0 |
| 2015-10-12 07:30:00 | SPY | ETF | 201.39 | 201.51 | 201.38 | 201.51 | 41137.0 |
| 2015-10-12 08:00:00 | SPY | ETF | 201.51 | 201.56 | 201.3 | 201.41 | 126049.0 |
| 2015-10-12 08:30:00 | SPY | ETF | 201.4 | 201.41 | 201.21 | 201.29 | 197214.0 |
| 2015-10-12 09:00:00 | SPY | ETF | 201.31 | 201.48 | 201.19 | 201.4 | 642439.0 |
| 2015-10-12 09:30:00 | SPY | ETF | 201.42 | 201.56 | 200.98 | 201.18 | 6590190.0 |
| 2015-10-12 10:00:00 | SPY | ETF | 201.17 | 201.44 | 200.91 | 201.13 | 4657169.0 |
| 2015-10-12 10:30:00 | SPY | ETF | 201.125 | 201.39 | 200.98 | 201.05 | 2849430.0 |
| 2015-10-12 11:00:00 | SPY | ETF | 201.045 | 201.47 | 201.02 | 201.455 | 3095832.0 |
| 2015-10-12 11:30:00 | SPY | ETF | 201.45 | 201.76 | 201.31 | 201.5 | 4395837.0 |
| 2015-10-12 12:00:00 | SPY | ETF | 201.49 | 201.67 | 201.44 | 201.57 | 1877201.0 |
| 2015-10-12 12:30:00 | SPY | ETF | 201.565 | 201.58 | 201.31 | 201.41 | 2104805.0 |
| 2015-10-12 13:00:00 | SPY | ETF | 201.415 | 201.43 | 201.14 | 201.32 | 3039694.0 |
| 2015-10-12 13:30:00 | SPY | ETF | 201.32 | 201.47 | 201.26 | 201.32 | 1637194.0 |
| 2015-10-12 14:00:00 | SPY | ETF | 201.325 | 201.49 | 201.28 | 201.3 | 7053250.0 |
| 2015-10-12 14:30:00 | SPY | ETF | 201.305 | 201.48 | 201.25 | 201.39 | 2144124.0 |
| 2015-10-12 15:00:00 | SPY | ETF | 201.395 | 201.6 | 201.35 | 201.575 | 3125113.0 |
| 2015-10-12 15:30:00 | SPY | ETF | 201.575 | 201.7 | 201.42 | 201.55 | 7141399.0 |
| 2015-10-12 16:00:00 | SPY | ETF | 201.57 | 201.85 | 201.39 | 201.8 | 4280742.0 |
| 2015-10-12 16:30:00 | SPY | ETF | 201.83 | 202.06 | 201.3753 | 201.95 | 318410.0 |
| 2015-10-12 17:00:00 | SPY | ETF | 201.96 | 201.96 | 201.86 | 201.87 | 101387.0 |
| 2015-10-12 17:30:00 | SPY | ETF | 201.87 | 201.89 | 201.78 | 201.89 | 98188.0 |
| 2015-10-12 18:00:00 | SPY | ETF | 201.83 | 201.87 | 201.78 | 201.84 | 52844.0 |
| 2015-10-12 18:30:00 | SPY | ETF | 201.83 | 201.87 | 201.71 | 201.71 | 68578.0 |
| 2015-10-12 19:00:00 | SPY | ETF | 201.74 | 201.74 | 201.69 | 201.73 | 15618.0 |
| 2015-10-12 19:30:00 | SPY | ETF | 201.73 | 201.77 | 201.69 | 201.74 | 14980.0 |
| 2015-10-12 04:00:00 | QQQ | ETF | 106.59 | 106.59 | 106.59 | 106.59 | 100.0 |
| 2015-10-12 04:30:00 | QQQ | ETF | 106.58 | 106.58 | 106.58 | 106.58 | 400.0 |
| 2015-10-12 05:00:00 | QQQ | ETF | 106.47 | 106.47 | 106.34 | 106.35 | 2200.0 |
| 2015-10-12 06:00:00 | QQQ | ETF | 106.45 | 106.48 | 106.45 | 106.48 | 1200.0 |
| 2015-10-12 06:30:00 | QQQ | ETF | 106.5 | 106.5 | 106.48 | 106.48 | 250.0 |
| 2015-10-12 07:00:00 | QQQ | ETF | 106.58 | 106.58 | 106.45 | 106.48 | 4121.0 |
| 2015-10-12 07:30:00 | QQQ | ETF | 106.53 | 106.58 | 106.53 | 106.58 | 6730.0 |
| 2015-10-12 08:00:00 | QQQ | ETF | 106.53 | 106.63 | 106.53 | 106.62 | 19432.0 |
| 2015-10-12 08:30:00 | QQQ | ETF | 106.53 | 106.69 | 106.53 | 106.68 | 26034.0 |
| 2015-10-12 09:00:00 | QQQ | ETF | 106.69 | 106.75 | 106.64 | 106.73 | 105265.0 |
| 2015-10-12 09:30:00 | QQQ | ETF | 106.73 | 106.87 | 106.39 | 106.56 | 2309752.0 |
| 2015-10-12 10:00:00 | QQQ | ETF | 106.53 | 106.73 | 106.35 | 106.559 | 1606102.0 |
| 2015-10-12 10:30:00 | QQQ | ETF | 106.55 | 106.67 | 106.4101 | 106.58 | 1809235.0 |
| 2015-10-12 11:00:00 | QQQ | ETF | 106.58 | 106.83 | 106.56 | 106.8092 | 796734.0 |
| 2015-10-12 11:30:00 | QQQ | ETF | 106.81 | 106.9899 | 106.72 | 106.8 | 1187808.0 |
| 2015-10-12 12:00:00 | QQQ | ETF | 106.8 | 106.95 | 106.778 | 106.86 | 563765.0 |
| 2015-10-12 12:30:00 | QQQ | ETF | 106.86 | 106.89 | 106.685 | 106.71 | 663016.0 |
| 2015-10-12 13:00:00 | QQQ | ETF | 106.72 | 106.72 | 106.56 | 106.68 | 361140.0 |
> showing 50 of 12,079 rows — these rows as CSV