PREVIEW / etf_5min / 2015-05-22
file: by_date/etf_5min/2015/2015-05-22.parquet size: 1.0 MB rows: 45,234
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-05-22 04:30:00 | SPY | ETF | 213.43 | 213.43 | 213.43 | 213.43 | 200.0 |
| 2015-05-22 05:05:00 | SPY | ETF | 213.42 | 213.42 | 213.41 | 213.41 | 200.0 |
| 2015-05-22 05:15:00 | SPY | ETF | 213.38 | 213.38 | 213.36 | 213.36 | 1200.0 |
| 2015-05-22 05:25:00 | SPY | ETF | 213.37 | 213.37 | 213.37 | 213.37 | 100.0 |
| 2015-05-22 05:35:00 | SPY | ETF | 213.26 | 213.26 | 213.26 | 213.26 | 500.0 |
| 2015-05-22 05:45:00 | SPY | ETF | 213.27 | 213.29 | 213.27 | 213.29 | 3100.0 |
| 2015-05-22 05:50:00 | SPY | ETF | 213.32 | 213.32 | 213.32 | 213.32 | 2100.0 |
| 2015-05-22 06:00:00 | SPY | ETF | 213.31 | 213.31 | 213.31 | 213.31 | 100.0 |
| 2015-05-22 06:05:00 | SPY | ETF | 213.26 | 213.26 | 213.26 | 213.26 | 508.0 |
| 2015-05-22 06:10:00 | SPY | ETF | 213.26 | 213.26 | 213.26 | 213.26 | 100.0 |
| 2015-05-22 06:15:00 | SPY | ETF | 213.24 | 213.24 | 213.22 | 213.22 | 740.0 |
| 2015-05-22 06:20:00 | SPY | ETF | 213.23 | 213.23 | 213.23 | 213.23 | 100.0 |
| 2015-05-22 06:30:00 | SPY | ETF | 213.27 | 213.27 | 213.27 | 213.27 | 100.0 |
| 2015-05-22 06:35:00 | SPY | ETF | 213.26 | 213.26 | 213.25 | 213.25 | 700.0 |
| 2015-05-22 06:40:00 | SPY | ETF | 213.24 | 213.26 | 213.24 | 213.26 | 200.0 |
| 2015-05-22 06:45:00 | SPY | ETF | 213.28 | 213.28 | 213.23 | 213.23 | 5400.0 |
| 2015-05-22 06:50:00 | SPY | ETF | 213.32 | 213.32 | 213.28 | 213.32 | 510.0 |
| 2015-05-22 06:55:00 | SPY | ETF | 213.28 | 213.39 | 213.28 | 213.39 | 2100.0 |
| 2015-05-22 07:00:00 | SPY | ETF | 213.41 | 213.42 | 213.38 | 213.42 | 62600.0 |
| 2015-05-22 07:05:00 | SPY | ETF | 213.42 | 213.43 | 213.42 | 213.43 | 470.0 |
| 2015-05-22 07:10:00 | SPY | ETF | 213.42 | 213.42 | 213.39 | 213.39 | 20600.0 |
| 2015-05-22 07:15:00 | SPY | ETF | 213.41 | 213.48 | 213.41 | 213.48 | 2300.0 |
| 2015-05-22 07:20:00 | SPY | ETF | 213.42 | 213.45 | 213.42 | 213.45 | 700.0 |
| 2015-05-22 07:30:00 | SPY | ETF | 213.45 | 213.45 | 213.45 | 213.45 | 100.0 |
| 2015-05-22 07:35:00 | SPY | ETF | 213.45 | 213.45 | 213.39 | 213.39 | 3300.0 |
| 2015-05-22 07:40:00 | SPY | ETF | 213.38 | 213.42 | 213.33 | 213.38 | 19713.0 |
| 2015-05-22 07:45:00 | SPY | ETF | 213.4 | 213.4 | 213.39 | 213.39 | 200.0 |
| 2015-05-22 07:50:00 | SPY | ETF | 213.37 | 213.38 | 213.37 | 213.38 | 10900.0 |
| 2015-05-22 07:55:00 | SPY | ETF | 213.41 | 213.51 | 213.4 | 213.51 | 60730.0 |
| 2015-05-22 08:00:00 | SPY | ETF | 213.5 | 213.5 | 213.44 | 213.47 | 32252.0 |
| 2015-05-22 08:05:00 | SPY | ETF | 213.49 | 213.5 | 213.45 | 213.45 | 6300.0 |
| 2015-05-22 08:10:00 | SPY | ETF | 213.45 | 213.48 | 213.45 | 213.47 | 13030.0 |
| 2015-05-22 08:15:00 | SPY | ETF | 213.47 | 213.52 | 213.47 | 213.47 | 14083.0 |
| 2015-05-22 08:20:00 | SPY | ETF | 213.49 | 213.5 | 213.47 | 213.49 | 8950.0 |
| 2015-05-22 08:25:00 | SPY | ETF | 213.47 | 213.5 | 213.43 | 213.45 | 31290.0 |
| 2015-05-22 08:30:00 | SPY | ETF | 213.41 | 213.44 | 213.03 | 213.05 | 647905.0 |
| 2015-05-22 08:35:00 | SPY | ETF | 213.04 | 213.09 | 212.94 | 212.95 | 71585.0 |
| 2015-05-22 08:40:00 | SPY | ETF | 212.95 | 213.02 | 212.9 | 212.98 | 69867.0 |
| 2015-05-22 08:45:00 | SPY | ETF | 213.0 | 213.04 | 212.93 | 212.99 | 91358.0 |
| 2015-05-22 08:50:00 | SPY | ETF | 213.02 | 213.02 | 212.94 | 212.97 | 105195.0 |
| 2015-05-22 08:55:00 | SPY | ETF | 213.0 | 213.1 | 213.0 | 213.07 | 119169.0 |
| 2015-05-22 09:00:00 | SPY | ETF | 213.07 | 213.07 | 212.99 | 213.03 | 36250.0 |
| 2015-05-22 09:05:00 | SPY | ETF | 213.04 | 213.05 | 212.92 | 212.92 | 71511.0 |
| 2015-05-22 09:10:00 | SPY | ETF | 212.95 | 213.03 | 212.92 | 212.98 | 152540.0 |
| 2015-05-22 09:15:00 | SPY | ETF | 212.97 | 213.01 | 212.97 | 213.0 | 43592.0 |
| 2015-05-22 09:20:00 | SPY | ETF | 212.99 | 213.04 | 212.99 | 213.02 | 41914.0 |
| 2015-05-22 09:25:00 | SPY | ETF | 213.0 | 213.04 | 212.99 | 213.03 | 112316.0 |
| 2015-05-22 09:30:00 | SPY | ETF | 213.04 | 213.17 | 212.91 | 212.9632 | 2445741.0 |
| 2015-05-22 09:35:00 | SPY | ETF | 212.96 | 213.34 | 212.93 | 213.27 | 2045430.0 |
| 2015-05-22 09:40:00 | SPY | ETF | 213.26 | 213.34 | 213.18 | 213.22 | 963734.0 |
> showing 50 of 45,234 rows — these rows as CSV