PREVIEW / etf_30min / 2015-03-18
file: by_date/etf_30min/2015/2015-03-18.parquet size: 388 KB rows: 12,901
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-18 04:00:00 | SPY | ETF | 208.18 | 208.26 | 208.04 | 208.21 | 424.0 |
| 2015-03-18 04:30:00 | SPY | ETF | 208.35 | 208.35 | 208.19 | 208.22 | 21185.0 |
| 2015-03-18 05:00:00 | SPY | ETF | 208.15 | 208.15 | 208.03 | 208.05 | 600.0 |
| 2015-03-18 05:30:00 | SPY | ETF | 208.06 | 208.13 | 208.04 | 208.04 | 3600.0 |
| 2015-03-18 06:00:00 | SPY | ETF | 208.04 | 208.04 | 207.65 | 207.65 | 7004.0 |
| 2015-03-18 06:30:00 | SPY | ETF | 207.7 | 207.71 | 207.24 | 207.24 | 57124.0 |
| 2015-03-18 07:00:00 | SPY | ETF | 207.47 | 207.54 | 207.12 | 207.19 | 32715.0 |
| 2015-03-18 07:30:00 | SPY | ETF | 207.18 | 207.31 | 207.08 | 207.18 | 393452.0 |
| 2015-03-18 08:00:00 | SPY | ETF | 207.18 | 207.5 | 207.08 | 207.17 | 700982.0 |
| 2015-03-18 08:30:00 | SPY | ETF | 207.17 | 207.98 | 207.16 | 207.35 | 467971.0 |
| 2015-03-18 09:00:00 | SPY | ETF | 207.32 | 207.47 | 207.24 | 207.37 | 349626.0 |
| 2015-03-18 09:30:00 | SPY | ETF | 207.39 | 207.44 | 206.95 | 207.135 | 9389486.0 |
| 2015-03-18 10:00:00 | SPY | ETF | 207.135 | 207.57 | 207.11 | 207.47 | 6192088.0 |
| 2015-03-18 10:30:00 | SPY | ETF | 207.47 | 207.54 | 207.22 | 207.51 | 4917328.0 |
| 2015-03-18 11:00:00 | SPY | ETF | 207.5 | 207.58 | 207.14 | 207.17 | 4485771.0 |
| 2015-03-18 11:30:00 | SPY | ETF | 207.165 | 207.39 | 207.12 | 207.27 | 4280238.0 |
| 2015-03-18 12:00:00 | SPY | ETF | 207.27 | 207.32 | 206.95 | 207.12 | 4817074.0 |
| 2015-03-18 12:30:00 | SPY | ETF | 207.12 | 207.34 | 207.01 | 207.04 | 6285690.0 |
| 2015-03-18 13:00:00 | SPY | ETF | 207.03 | 207.13 | 206.86 | 206.97 | 7483313.0 |
| 2015-03-18 13:30:00 | SPY | ETF | 206.98 | 207.34 | 206.62 | 207.29 | 9681133.0 |
| 2015-03-18 14:00:00 | SPY | ETF | 207.3 | 210.06 | 207.24 | 209.73 | 47100704.0 |
| 2015-03-18 14:30:00 | SPY | ETF | 209.73 | 210.37 | 209.65 | 210.11 | 29549673.0 |
| 2015-03-18 15:00:00 | SPY | ETF | 210.1 | 211.27 | 209.99 | 210.68 | 31338884.0 |
| 2015-03-18 15:30:00 | SPY | ETF | 210.685 | 210.81 | 210.16 | 210.44 | 35863094.0 |
| 2015-03-18 16:00:00 | SPY | ETF | 210.44 | 210.69 | 207.952 | 210.61 | 13880399.0 |
| 2015-03-18 16:30:00 | SPY | ETF | 210.61 | 210.69 | 209.01 | 210.58 | 3503077.0 |
| 2015-03-18 17:00:00 | SPY | ETF | 210.59 | 210.62 | 210.53 | 210.58 | 128381.0 |
| 2015-03-18 17:30:00 | SPY | ETF | 210.57 | 210.59 | 210.5 | 210.58 | 1186108.0 |
| 2015-03-18 18:00:00 | SPY | ETF | 210.58 | 210.72 | 210.58 | 210.65 | 139443.0 |
| 2015-03-18 18:30:00 | SPY | ETF | 210.69 | 210.69 | 210.6 | 210.6 | 42207.0 |
| 2015-03-18 19:00:00 | SPY | ETF | 210.6 | 210.7 | 210.59 | 210.7 | 41110.0 |
| 2015-03-18 19:30:00 | SPY | ETF | 210.7 | 210.99 | 210.7 | 210.81 | 124857.0 |
| 2015-03-18 07:00:00 | QQQ | ETF | 106.6 | 106.6 | 106.49 | 106.49 | 19700.0 |
| 2015-03-18 07:30:00 | QQQ | ETF | 106.49 | 106.54 | 106.48 | 106.48 | 17576.0 |
| 2015-03-18 08:00:00 | QQQ | ETF | 106.5 | 106.5 | 106.44 | 106.48 | 27096.0 |
| 2015-03-18 08:30:00 | QQQ | ETF | 106.48 | 106.56 | 106.46 | 106.54 | 50663.0 |
| 2015-03-18 09:00:00 | QQQ | ETF | 106.53 | 106.63 | 106.51 | 106.57 | 28305.0 |
| 2015-03-18 09:30:00 | QQQ | ETF | 106.59 | 106.62 | 106.3 | 106.45 | 2377209.0 |
| 2015-03-18 10:00:00 | QQQ | ETF | 106.46 | 106.64 | 106.45 | 106.59 | 1127301.0 |
| 2015-03-18 10:30:00 | QQQ | ETF | 106.59 | 106.65 | 106.43 | 106.64 | 952027.0 |
| 2015-03-18 11:00:00 | QQQ | ETF | 106.64 | 106.6965 | 106.5 | 106.52 | 919755.0 |
| 2015-03-18 11:30:00 | QQQ | ETF | 106.51 | 106.61 | 106.4 | 106.494 | 928282.0 |
| 2015-03-18 12:00:00 | QQQ | ETF | 106.49 | 106.51 | 106.345 | 106.388 | 713051.0 |
| 2015-03-18 12:30:00 | QQQ | ETF | 106.38 | 106.5 | 106.32 | 106.33 | 500654.0 |
| 2015-03-18 13:00:00 | QQQ | ETF | 106.33 | 106.3744 | 106.23 | 106.2499 | 916202.0 |
| 2015-03-18 13:30:00 | QQQ | ETF | 106.249 | 106.4 | 106.03 | 106.375 | 1730104.0 |
| 2015-03-18 14:00:00 | QQQ | ETF | 106.3786 | 107.76 | 106.36 | 107.57 | 9700472.0 |
| 2015-03-18 14:30:00 | QQQ | ETF | 107.58 | 107.91 | 107.5749 | 107.82 | 3886817.0 |
| 2015-03-18 15:00:00 | QQQ | ETF | 107.81 | 108.41 | 107.74 | 108.14 | 5089200.0 |
| 2015-03-18 15:30:00 | QQQ | ETF | 108.14 | 108.21 | 107.83 | 107.92 | 3838287.0 |
> showing 50 of 12,901 rows — these rows as CSV