PREVIEW / etf_30min / 2016-03-16
file: by_date/etf_30min/2016/2016-03-16.parquet size: 387 KB rows: 13,071
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-16 04:00:00 | SPY | ETF | 202.27 | 202.52 | 202.27 | 202.52 | 8035.0 |
| 2016-03-16 04:30:00 | SPY | ETF | 202.49 | 202.51 | 202.42 | 202.51 | 902.0 |
| 2016-03-16 05:00:00 | SPY | ETF | 202.49 | 202.49 | 202.45 | 202.48 | 3116.0 |
| 2016-03-16 05:30:00 | SPY | ETF | 202.42 | 202.44 | 202.42 | 202.43 | 1310.0 |
| 2016-03-16 06:00:00 | SPY | ETF | 202.46 | 202.48 | 202.21 | 202.29 | 22471.0 |
| 2016-03-16 06:30:00 | SPY | ETF | 202.31 | 202.33 | 202.18 | 202.23 | 10305.0 |
| 2016-03-16 07:00:00 | SPY | ETF | 202.15 | 202.23 | 202.1 | 202.16 | 61341.0 |
| 2016-03-16 07:30:00 | SPY | ETF | 202.13 | 202.14 | 201.98 | 202.04 | 50975.0 |
| 2016-03-16 08:00:00 | SPY | ETF | 202.05 | 202.15 | 201.97 | 201.99 | 314554.0 |
| 2016-03-16 08:30:00 | SPY | ETF | 201.99 | 202.1 | 201.41 | 201.47 | 572293.0 |
| 2016-03-16 09:00:00 | SPY | ETF | 201.47 | 201.61 | 201.28 | 201.6 | 450640.0 |
| 2016-03-16 09:30:00 | SPY | ETF | 201.6 | 202.41 | 201.6 | 202.19 | 8449968.0 |
| 2016-03-16 10:00:00 | SPY | ETF | 202.19 | 202.36 | 202.12 | 202.16 | 5550642.0 |
| 2016-03-16 10:30:00 | SPY | ETF | 202.17 | 202.5 | 202.1 | 202.325 | 4928462.0 |
| 2016-03-16 11:00:00 | SPY | ETF | 202.33 | 202.4861 | 202.26 | 202.35 | 5015684.0 |
| 2016-03-16 11:30:00 | SPY | ETF | 202.35 | 202.47 | 202.2 | 202.24 | 3393256.0 |
| 2016-03-16 12:00:00 | SPY | ETF | 202.25 | 202.405 | 202.24 | 202.27 | 2818192.0 |
| 2016-03-16 12:30:00 | SPY | ETF | 202.27 | 202.31 | 201.845 | 201.92 | 3719062.0 |
| 2016-03-16 13:00:00 | SPY | ETF | 201.92 | 202.01 | 201.55 | 201.69 | 3802204.0 |
| 2016-03-16 13:30:00 | SPY | ETF | 201.685 | 201.94 | 201.63 | 201.77 | 4356764.0 |
| 2016-03-16 14:00:00 | SPY | ETF | 201.77 | 203.31 | 201.765 | 203.16 | 25613221.0 |
| 2016-03-16 14:30:00 | SPY | ETF | 203.15 | 203.72 | 202.2648 | 202.83 | 16594858.0 |
| 2016-03-16 15:00:00 | SPY | ETF | 202.83 | 203.62 | 202.79 | 203.43 | 12784836.0 |
| 2016-03-16 15:30:00 | SPY | ETF | 203.43 | 203.82 | 203.19 | 203.4 | 16141641.0 |
| 2016-03-16 16:00:00 | SPY | ETF | 203.4 | 203.41 | 202.1738 | 203.25 | 5488889.0 |
| 2016-03-16 16:30:00 | SPY | ETF | 203.24 | 203.37 | 202.1738 | 203.3 | 2369661.0 |
| 2016-03-16 17:00:00 | SPY | ETF | 203.3 | 203.34 | 203.13 | 203.19 | 771930.0 |
| 2016-03-16 17:30:00 | SPY | ETF | 203.18 | 203.34 | 203.15 | 203.2 | 542244.0 |
| 2016-03-16 18:00:00 | SPY | ETF | 203.21 | 203.32 | 203.15 | 203.26 | 115153.0 |
| 2016-03-16 18:30:00 | SPY | ETF | 203.24 | 203.31 | 203.2 | 203.3 | 42023.0 |
| 2016-03-16 19:00:00 | SPY | ETF | 203.25 | 203.35 | 203.22 | 203.33 | 22133.0 |
| 2016-03-16 19:30:00 | SPY | ETF | 203.35 | 203.55 | 203.3008 | 203.5 | 202205.0 |
| 2016-03-16 04:00:00 | QQQ | ETF | 106.81 | 106.83 | 106.81 | 106.83 | 200.0 |
| 2016-03-16 07:00:00 | QQQ | ETF | 106.63 | 106.63 | 106.61 | 106.61 | 2200.0 |
| 2016-03-16 07:30:00 | QQQ | ETF | 106.63 | 106.63 | 106.56 | 106.56 | 7418.0 |
| 2016-03-16 08:00:00 | QQQ | ETF | 106.62 | 106.67 | 106.58 | 106.6 | 30101.0 |
| 2016-03-16 08:30:00 | QQQ | ETF | 106.6 | 106.64 | 106.29 | 106.31 | 188489.0 |
| 2016-03-16 09:00:00 | QQQ | ETF | 106.3 | 106.39 | 106.23 | 106.37 | 64605.0 |
| 2016-03-16 09:30:00 | QQQ | ETF | 106.37 | 106.82 | 106.34 | 106.76 | 1988731.0 |
| 2016-03-16 10:00:00 | QQQ | ETF | 106.76 | 106.85 | 106.6999 | 106.74 | 763699.0 |
| 2016-03-16 10:30:00 | QQQ | ETF | 106.75 | 106.92 | 106.73 | 106.84 | 881825.0 |
| 2016-03-16 11:00:00 | QQQ | ETF | 106.83 | 106.93 | 106.7701 | 106.92 | 587739.0 |
| 2016-03-16 11:30:00 | QQQ | ETF | 106.92 | 107.0339 | 106.87 | 106.9599 | 863092.0 |
| 2016-03-16 12:00:00 | QQQ | ETF | 106.96 | 107.08 | 106.96 | 106.995 | 542857.0 |
| 2016-03-16 12:30:00 | QQQ | ETF | 106.98 | 107.015 | 106.61 | 106.645 | 783116.0 |
| 2016-03-16 13:00:00 | QQQ | ETF | 106.64 | 106.7 | 106.46 | 106.55 | 792551.0 |
| 2016-03-16 13:30:00 | QQQ | ETF | 106.55 | 106.71 | 106.52 | 106.69 | 877512.0 |
| 2016-03-16 14:00:00 | QQQ | ETF | 106.7 | 107.44 | 106.7 | 107.31 | 5396812.0 |
| 2016-03-16 14:30:00 | QQQ | ETF | 107.31 | 107.68 | 107.17 | 107.26 | 3057305.0 |
| 2016-03-16 15:00:00 | QQQ | ETF | 107.25 | 107.68 | 107.24 | 107.57 | 2865915.0 |
> showing 50 of 13,071 rows — these rows as CSV