PREVIEW / etf_30min / 2015-02-03
file: by_date/etf_30min/2015/2015-02-03.parquet size: 397 KB rows: 13,298
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-02-03 04:00:00 | SPY | ETF | 202.87 | 202.99 | 202.7 | 202.7 | 8450.0 |
| 2015-02-03 04:30:00 | SPY | ETF | 202.25 | 202.25 | 202.15 | 202.21 | 6400.0 |
| 2015-02-03 05:00:00 | SPY | ETF | 202.2 | 202.46 | 202.2 | 202.42 | 11531.0 |
| 2015-02-03 05:30:00 | SPY | ETF | 202.28 | 202.76 | 202.28 | 202.59 | 22232.0 |
| 2015-02-03 06:00:00 | SPY | ETF | 202.55 | 202.84 | 202.5 | 202.8 | 95324.0 |
| 2015-02-03 06:30:00 | SPY | ETF | 202.79 | 203.2 | 202.77 | 202.97 | 115095.0 |
| 2015-02-03 07:00:00 | SPY | ETF | 202.96 | 203.14 | 202.82 | 202.88 | 247949.0 |
| 2015-02-03 07:30:00 | SPY | ETF | 202.87 | 202.91 | 202.59 | 202.75 | 210978.0 |
| 2015-02-03 08:00:00 | SPY | ETF | 202.3 | 202.89 | 202.3 | 202.72 | 671475.0 |
| 2015-02-03 08:30:00 | SPY | ETF | 202.7 | 202.96 | 202.42 | 202.88 | 463236.0 |
| 2015-02-03 09:00:00 | SPY | ETF | 202.9 | 203.12 | 202.82 | 203.0 | 998072.0 |
| 2015-02-03 09:30:00 | SPY | ETF | 203.0 | 203.89 | 202.86 | 203.82 | 16288252.0 |
| 2015-02-03 10:00:00 | SPY | ETF | 203.81 | 203.86 | 203.2 | 203.73 | 9361159.0 |
| 2015-02-03 10:30:00 | SPY | ETF | 203.74 | 203.8 | 202.74 | 202.76 | 8539502.0 |
| 2015-02-03 11:00:00 | SPY | ETF | 202.75 | 203.44 | 202.67 | 203.11 | 6144737.0 |
| 2015-02-03 11:30:00 | SPY | ETF | 203.11 | 203.54 | 202.75 | 202.8 | 5991838.0 |
| 2015-02-03 12:00:00 | SPY | ETF | 202.8 | 203.2 | 202.55 | 203.05 | 5237773.0 |
| 2015-02-03 12:30:00 | SPY | ETF | 203.05 | 203.43 | 202.81 | 203.22 | 4045910.0 |
| 2015-02-03 13:00:00 | SPY | ETF | 203.22 | 203.94 | 203.12 | 203.84 | 6115354.0 |
| 2015-02-03 13:30:00 | SPY | ETF | 203.84 | 204.32 | 203.65 | 204.29 | 6639294.0 |
| 2015-02-03 14:00:00 | SPY | ETF | 204.3 | 204.48 | 203.73 | 203.83 | 6615951.0 |
| 2015-02-03 14:30:00 | SPY | ETF | 203.825 | 204.21 | 203.63 | 204.2 | 6482548.0 |
| 2015-02-03 15:00:00 | SPY | ETF | 204.21 | 204.5 | 204.041 | 204.42 | 8475804.0 |
| 2015-02-03 15:30:00 | SPY | ETF | 204.42 | 204.85 | 204.21 | 204.8 | 21206655.0 |
| 2015-02-03 16:00:00 | SPY | ETF | 204.8 | 204.84 | 203.6572 | 204.66 | 5518721.0 |
| 2015-02-03 16:30:00 | SPY | ETF | 204.65 | 204.75 | 204.59 | 204.59 | 2438238.0 |
| 2015-02-03 17:00:00 | SPY | ETF | 204.58 | 204.61 | 204.52 | 204.53 | 1176265.0 |
| 2015-02-03 17:30:00 | SPY | ETF | 204.53 | 204.59 | 204.53 | 204.55 | 10460.0 |
| 2015-02-03 18:00:00 | SPY | ETF | 204.53 | 204.59 | 204.44 | 204.45 | 141821.0 |
| 2015-02-03 18:30:00 | SPY | ETF | 204.47 | 204.5 | 204.38 | 204.4 | 52941.0 |
| 2015-02-03 19:00:00 | SPY | ETF | 204.4 | 204.48 | 204.4 | 204.46 | 32325.0 |
| 2015-02-03 19:30:00 | SPY | ETF | 204.45 | 204.65 | 204.45 | 204.63 | 115261.0 |
| 2015-02-03 04:00:00 | QQQ | ETF | 102.35 | 102.35 | 102.31 | 102.31 | 13500.0 |
| 2015-02-03 05:00:00 | QQQ | ETF | 102.14 | 102.17 | 102.14 | 102.14 | 4550.0 |
| 2015-02-03 05:30:00 | QQQ | ETF | 102.1 | 102.35 | 102.1 | 102.35 | 4700.0 |
| 2015-02-03 06:00:00 | QQQ | ETF | 102.25 | 102.41 | 102.25 | 102.36 | 8400.0 |
| 2015-02-03 06:30:00 | QQQ | ETF | 102.41 | 102.5 | 102.41 | 102.47 | 6300.0 |
| 2015-02-03 07:00:00 | QQQ | ETF | 102.38 | 102.59 | 102.38 | 102.45 | 443900.0 |
| 2015-02-03 07:30:00 | QQQ | ETF | 102.44 | 102.45 | 102.29 | 102.4 | 95989.0 |
| 2015-02-03 08:00:00 | QQQ | ETF | 102.34 | 102.54 | 102.14 | 102.27 | 338214.0 |
| 2015-02-03 08:30:00 | QQQ | ETF | 102.27 | 102.43 | 102.2 | 102.37 | 41182.0 |
| 2015-02-03 09:00:00 | QQQ | ETF | 102.37 | 102.47 | 102.32 | 102.33 | 150365.0 |
| 2015-02-03 09:30:00 | QQQ | ETF | 102.34 | 102.79 | 102.26 | 102.61 | 3898235.0 |
| 2015-02-03 10:00:00 | QQQ | ETF | 102.61 | 102.64 | 102.19 | 102.54 | 3082084.0 |
| 2015-02-03 10:30:00 | QQQ | ETF | 102.56 | 102.59 | 101.861 | 101.9 | 2101681.0 |
| 2015-02-03 11:00:00 | QQQ | ETF | 101.9 | 102.19 | 101.82 | 102.01 | 1814455.0 |
| 2015-02-03 11:30:00 | QQQ | ETF | 102.01 | 102.24 | 101.771 | 101.81 | 1354322.0 |
| 2015-02-03 12:00:00 | QQQ | ETF | 101.81 | 102.07 | 101.68 | 101.99 | 1462954.0 |
| 2015-02-03 12:30:00 | QQQ | ETF | 102.0 | 102.19 | 101.88 | 102.09 | 991422.0 |
| 2015-02-03 13:00:00 | QQQ | ETF | 102.11 | 102.38 | 102.04 | 102.31 | 1013241.0 |
> showing 50 of 13,298 rows — these rows as CSV