PREVIEW / etf_30min / 2016-03-15
file: by_date/etf_30min/2016/2016-03-15.parquet size: 380 KB rows: 13,049
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-15 04:00:00 | SPY | ETF | 201.69 | 201.73 | 201.49 | 201.6 | 35828.0 |
| 2016-03-15 04:30:00 | SPY | ETF | 201.47 | 201.6 | 201.33 | 201.41 | 25514.0 |
| 2016-03-15 05:00:00 | SPY | ETF | 201.34 | 201.66 | 201.34 | 201.52 | 11475.0 |
| 2016-03-15 05:30:00 | SPY | ETF | 201.49 | 201.49 | 201.35 | 201.42 | 15730.0 |
| 2016-03-15 06:00:00 | SPY | ETF | 201.46 | 201.46 | 201.24 | 201.24 | 62263.0 |
| 2016-03-15 06:30:00 | SPY | ETF | 201.28 | 201.56 | 201.25 | 201.48 | 89226.0 |
| 2016-03-15 07:00:00 | SPY | ETF | 201.47 | 201.5 | 201.34 | 201.45 | 206617.0 |
| 2016-03-15 07:30:00 | SPY | ETF | 201.44 | 201.53 | 201.39 | 201.45 | 137609.0 |
| 2016-03-15 08:00:00 | SPY | ETF | 201.45 | 201.55 | 201.34 | 201.39 | 320981.0 |
| 2016-03-15 08:30:00 | SPY | ETF | 201.46 | 201.5 | 201.14 | 201.38 | 529479.0 |
| 2016-03-15 09:00:00 | SPY | ETF | 201.41 | 201.54 | 201.31 | 201.36 | 605320.0 |
| 2016-03-15 09:30:00 | SPY | ETF | 201.36 | 201.61 | 201.1 | 201.24 | 9726959.0 |
| 2016-03-15 10:00:00 | SPY | ETF | 201.2401 | 201.69 | 201.05 | 201.68 | 7837254.0 |
| 2016-03-15 10:30:00 | SPY | ETF | 201.68 | 201.83 | 201.35 | 201.4801 | 8101782.0 |
| 2016-03-15 11:00:00 | SPY | ETF | 201.49 | 201.8 | 201.34 | 201.73 | 6299094.0 |
| 2016-03-15 11:30:00 | SPY | ETF | 201.73 | 201.83 | 201.41 | 201.44 | 5190293.0 |
| 2016-03-15 12:00:00 | SPY | ETF | 201.44 | 201.66 | 201.34 | 201.652 | 5430906.0 |
| 2016-03-15 12:30:00 | SPY | ETF | 201.65 | 201.66 | 201.39 | 201.4537 | 2642767.0 |
| 2016-03-15 13:00:00 | SPY | ETF | 201.45 | 201.78 | 201.42 | 201.74 | 2572864.0 |
| 2016-03-15 13:30:00 | SPY | ETF | 201.74 | 201.96 | 201.74 | 201.9 | 4355697.0 |
| 2016-03-15 14:00:00 | SPY | ETF | 201.8976 | 202.1 | 201.775 | 201.9 | 3566625.0 |
| 2016-03-15 14:30:00 | SPY | ETF | 201.91 | 202.01 | 201.66 | 201.76 | 3938185.0 |
| 2016-03-15 15:00:00 | SPY | ETF | 201.76 | 202.19 | 201.71 | 202.06 | 7008408.0 |
| 2016-03-15 15:30:00 | SPY | ETF | 202.055 | 202.5307 | 201.835 | 202.18 | 11734900.0 |
| 2016-03-15 16:00:00 | SPY | ETF | 202.17 | 202.23 | 201.9722 | 202.12 | 7062879.0 |
| 2016-03-15 16:30:00 | SPY | ETF | 202.13 | 202.26 | 201.48 | 202.24 | 302814.0 |
| 2016-03-15 17:00:00 | SPY | ETF | 202.23 | 202.31 | 202.21 | 202.28 | 110547.0 |
| 2016-03-15 17:30:00 | SPY | ETF | 202.27 | 202.29 | 202.21 | 202.21 | 47633.0 |
| 2016-03-15 18:00:00 | SPY | ETF | 202.22 | 202.3 | 202.17 | 202.19 | 61910.0 |
| 2016-03-15 18:30:00 | SPY | ETF | 202.19 | 202.29 | 202.19 | 202.25 | 11942.0 |
| 2016-03-15 19:00:00 | SPY | ETF | 202.27 | 202.32 | 202.22 | 202.32 | 21164.0 |
| 2016-03-15 19:30:00 | SPY | ETF | 202.32 | 202.44 | 202.31 | 202.44 | 47301.0 |
| 2016-03-15 04:00:00 | QQQ | ETF | 106.13 | 106.16 | 106.13 | 106.16 | 424.0 |
| 2016-03-15 04:30:00 | QQQ | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 100.0 |
| 2016-03-15 05:30:00 | QQQ | ETF | 106.08 | 106.08 | 106.04 | 106.08 | 700.0 |
| 2016-03-15 06:00:00 | QQQ | ETF | 106.08 | 106.1 | 106.04 | 106.04 | 1385.0 |
| 2016-03-15 06:30:00 | QQQ | ETF | 106.2 | 106.21 | 106.2 | 106.21 | 600.0 |
| 2016-03-15 07:00:00 | QQQ | ETF | 106.2 | 106.26 | 106.17 | 106.26 | 14051.0 |
| 2016-03-15 07:30:00 | QQQ | ETF | 106.24 | 106.35 | 106.2 | 106.33 | 40182.0 |
| 2016-03-15 08:00:00 | QQQ | ETF | 106.22 | 106.36 | 106.22 | 106.29 | 32821.0 |
| 2016-03-15 08:30:00 | QQQ | ETF | 106.29 | 106.31 | 106.12 | 106.24 | 112431.0 |
| 2016-03-15 09:00:00 | QQQ | ETF | 106.26 | 106.32 | 106.24 | 106.27 | 41972.0 |
| 2016-03-15 09:30:00 | QQQ | ETF | 106.27 | 106.438 | 106.07 | 106.16 | 2397722.0 |
| 2016-03-15 10:00:00 | QQQ | ETF | 106.16 | 106.4 | 105.95 | 106.4 | 2334623.0 |
| 2016-03-15 10:30:00 | QQQ | ETF | 106.4 | 106.49 | 106.25 | 106.35 | 1720287.0 |
| 2016-03-15 11:00:00 | QQQ | ETF | 106.35 | 106.65 | 106.2923 | 106.58 | 1470886.0 |
| 2016-03-15 11:30:00 | QQQ | ETF | 106.59 | 106.61 | 106.31 | 106.3299 | 1286452.0 |
| 2016-03-15 12:00:00 | QQQ | ETF | 106.33 | 106.5 | 106.28 | 106.495 | 1059476.0 |
| 2016-03-15 12:30:00 | QQQ | ETF | 106.5 | 106.53 | 106.36 | 106.379 | 976781.0 |
| 2016-03-15 13:00:00 | QQQ | ETF | 106.38 | 106.46 | 106.32 | 106.43 | 974763.0 |
> showing 50 of 13,049 rows — these rows as CSV