PREVIEW / etf_30min / 2015-10-09
file: by_date/etf_30min/2015/2015-10-09.parquet size: 374 KB rows: 12,642
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-09 04:00:00 | SPY | ETF | 200.81 | 200.94 | 200.6 | 200.6 | 28605.0 |
| 2015-10-09 04:30:00 | SPY | ETF | 200.72 | 201.02 | 200.58 | 201.0 | 28679.0 |
| 2015-10-09 05:00:00 | SPY | ETF | 201.0 | 201.34 | 200.96 | 201.34 | 10155.0 |
| 2015-10-09 05:30:00 | SPY | ETF | 201.3 | 201.34 | 201.1 | 201.16 | 5610.0 |
| 2015-10-09 06:00:00 | SPY | ETF | 201.09 | 201.39 | 201.09 | 201.34 | 5838.0 |
| 2015-10-09 06:30:00 | SPY | ETF | 201.44 | 201.65 | 201.44 | 201.54 | 28532.0 |
| 2015-10-09 07:00:00 | SPY | ETF | 201.51 | 201.65 | 201.33 | 201.58 | 234368.0 |
| 2015-10-09 07:30:00 | SPY | ETF | 201.59 | 201.68 | 201.4 | 201.67 | 241143.0 |
| 2015-10-09 08:00:00 | SPY | ETF | 201.65 | 201.93 | 201.06 | 201.77 | 746268.0 |
| 2015-10-09 08:30:00 | SPY | ETF | 201.79 | 202.05 | 201.65 | 201.77 | 577438.0 |
| 2015-10-09 09:00:00 | SPY | ETF | 201.75 | 201.75 | 201.21 | 201.38 | 932625.0 |
| 2015-10-09 09:30:00 | SPY | ETF | 201.38 | 201.9 | 201.23 | 201.6396 | 10188560.0 |
| 2015-10-09 10:00:00 | SPY | ETF | 201.64 | 201.72 | 200.94 | 201.28 | 8925237.0 |
| 2015-10-09 10:30:00 | SPY | ETF | 201.275 | 201.82 | 201.225 | 201.79 | 6172320.0 |
| 2015-10-09 11:00:00 | SPY | ETF | 201.79 | 201.89 | 201.38 | 201.67 | 4725012.0 |
| 2015-10-09 11:30:00 | SPY | ETF | 201.67 | 201.72 | 201.14 | 201.38 | 5212913.0 |
| 2015-10-09 12:00:00 | SPY | ETF | 201.38 | 201.56 | 200.91 | 201.13 | 3780547.0 |
| 2015-10-09 12:30:00 | SPY | ETF | 201.12 | 201.12 | 200.77 | 200.95 | 5167822.0 |
| 2015-10-09 13:00:00 | SPY | ETF | 200.96 | 201.12 | 200.58 | 200.8499 | 7964672.0 |
| 2015-10-09 13:30:00 | SPY | ETF | 200.85 | 201.09 | 200.635 | 200.89 | 2516981.0 |
| 2015-10-09 14:00:00 | SPY | ETF | 200.89 | 201.05 | 200.6911 | 201.04 | 3529902.0 |
| 2015-10-09 14:30:00 | SPY | ETF | 201.03 | 201.23 | 200.85 | 201.21 | 5056203.0 |
| 2015-10-09 15:00:00 | SPY | ETF | 201.215 | 201.24 | 200.96 | 201.18 | 5511609.0 |
| 2015-10-09 15:30:00 | SPY | ETF | 201.18 | 201.52 | 201.18 | 201.36 | 18938110.0 |
| 2015-10-09 16:00:00 | SPY | ETF | 201.36 | 201.47 | 201.26 | 201.43 | 12403669.0 |
| 2015-10-09 16:30:00 | SPY | ETF | 201.42 | 201.45 | 201.3033 | 201.36 | 694231.0 |
| 2015-10-09 17:00:00 | SPY | ETF | 201.35 | 201.39 | 201.26 | 201.27 | 917694.0 |
| 2015-10-09 17:30:00 | SPY | ETF | 201.28 | 201.35 | 201.27 | 201.35 | 15550.0 |
| 2015-10-09 18:00:00 | SPY | ETF | 201.33 | 201.34 | 201.3 | 201.3 | 8010.0 |
| 2015-10-09 18:30:00 | SPY | ETF | 201.32 | 201.32 | 201.27 | 201.32 | 22756.0 |
| 2015-10-09 19:00:00 | SPY | ETF | 201.3 | 201.31 | 201.29 | 201.31 | 23150.0 |
| 2015-10-09 19:30:00 | SPY | ETF | 201.3 | 201.31 | 201.29 | 201.3 | 8176.0 |
| 2015-10-09 04:00:00 | QQQ | ETF | 105.75 | 105.86 | 105.69 | 105.69 | 1600.0 |
| 2015-10-09 04:30:00 | QQQ | ETF | 105.84 | 105.84 | 105.83 | 105.83 | 15000.0 |
| 2015-10-09 05:00:00 | QQQ | ETF | 106.02 | 106.02 | 106.01 | 106.01 | 300.0 |
| 2015-10-09 05:30:00 | QQQ | ETF | 106.06 | 106.06 | 106.05 | 106.05 | 1244.0 |
| 2015-10-09 06:00:00 | QQQ | ETF | 105.95 | 106.05 | 105.95 | 106.05 | 400.0 |
| 2015-10-09 06:30:00 | QQQ | ETF | 106.15 | 106.2 | 106.14 | 106.2 | 1830.0 |
| 2015-10-09 07:00:00 | QQQ | ETF | 106.05 | 106.14 | 106.05 | 106.1 | 4200.0 |
| 2015-10-09 07:30:00 | QQQ | ETF | 106.19 | 106.2 | 106.07 | 106.15 | 2142.0 |
| 2015-10-09 08:00:00 | QQQ | ETF | 106.12 | 106.36 | 106.06 | 106.25 | 61659.0 |
| 2015-10-09 08:30:00 | QQQ | ETF | 106.29 | 106.42 | 106.18 | 106.26 | 44630.0 |
| 2015-10-09 09:00:00 | QQQ | ETF | 106.23 | 106.26 | 106.05 | 106.08 | 133550.0 |
| 2015-10-09 09:30:00 | QQQ | ETF | 106.09 | 106.42 | 105.81 | 106.2025 | 2892849.0 |
| 2015-10-09 10:00:00 | QQQ | ETF | 106.21 | 106.34 | 105.85 | 106.23 | 3231177.0 |
| 2015-10-09 10:30:00 | QQQ | ETF | 106.23 | 106.68 | 106.21 | 106.655 | 2813345.0 |
| 2015-10-09 11:00:00 | QQQ | ETF | 106.65 | 106.73 | 106.45 | 106.61 | 1373849.0 |
| 2015-10-09 11:30:00 | QQQ | ETF | 106.61 | 106.64 | 106.24 | 106.46 | 1109775.0 |
| 2015-10-09 12:00:00 | QQQ | ETF | 106.46 | 106.5714 | 106.2 | 106.37 | 1029909.0 |
| 2015-10-09 12:30:00 | QQQ | ETF | 106.36 | 106.37 | 106.09 | 106.23 | 851339.0 |
> showing 50 of 12,642 rows — these rows as CSV