PREVIEW / etf_5min / 2015-06-19
file: by_date/etf_5min/2015/2015-06-19.parquet size: 1.0 MB rows: 45,075
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-06-19 04:00:00 | SPY | ETF | 212.05 | 212.19 | 211.7 | 211.85 | 30020.0 |
| 2015-06-19 04:05:00 | SPY | ETF | 211.9 | 211.9 | 211.9 | 211.9 | 1000.0 |
| 2015-06-19 04:15:00 | SPY | ETF | 212.0 | 212.0 | 212.0 | 212.0 | 373.0 |
| 2015-06-19 04:20:00 | SPY | ETF | 211.97 | 211.97 | 211.97 | 211.97 | 500.0 |
| 2015-06-19 04:25:00 | SPY | ETF | 211.99 | 211.99 | 211.99 | 211.99 | 100.0 |
| 2015-06-19 04:40:00 | SPY | ETF | 212.09 | 212.09 | 212.01 | 212.01 | 2600.0 |
| 2015-06-19 04:45:00 | SPY | ETF | 211.99 | 211.99 | 211.99 | 211.99 | 100.0 |
| 2015-06-19 04:50:00 | SPY | ETF | 212.05 | 212.05 | 211.92 | 211.92 | 3500.0 |
| 2015-06-19 04:55:00 | SPY | ETF | 211.88 | 211.95 | 211.86 | 211.94 | 900.0 |
| 2015-06-19 05:00:00 | SPY | ETF | 211.92 | 211.92 | 211.88 | 211.88 | 200.0 |
| 2015-06-19 05:10:00 | SPY | ETF | 211.93 | 211.93 | 211.93 | 211.93 | 100.0 |
| 2015-06-19 05:25:00 | SPY | ETF | 212.04 | 212.09 | 212.04 | 212.09 | 2000.0 |
| 2015-06-19 05:30:00 | SPY | ETF | 212.16 | 212.16 | 212.16 | 212.16 | 500.0 |
| 2015-06-19 05:35:00 | SPY | ETF | 212.12 | 212.12 | 212.12 | 212.12 | 100.0 |
| 2015-06-19 05:45:00 | SPY | ETF | 212.14 | 212.14 | 212.11 | 212.11 | 1000.0 |
| 2015-06-19 05:50:00 | SPY | ETF | 212.11 | 212.13 | 212.1 | 212.13 | 6100.0 |
| 2015-06-19 05:55:00 | SPY | ETF | 212.01 | 212.01 | 212.01 | 212.01 | 100.0 |
| 2015-06-19 06:05:00 | SPY | ETF | 212.06 | 212.06 | 212.06 | 212.06 | 100.0 |
| 2015-06-19 06:10:00 | SPY | ETF | 212.05 | 212.05 | 212.05 | 212.05 | 100.0 |
| 2015-06-19 06:25:00 | SPY | ETF | 212.05 | 212.08 | 212.05 | 212.08 | 297.0 |
| 2015-06-19 06:30:00 | SPY | ETF | 212.08 | 212.08 | 212.03 | 212.03 | 300.0 |
| 2015-06-19 06:40:00 | SPY | ETF | 212.05 | 212.08 | 211.95 | 211.95 | 5500.0 |
| 2015-06-19 06:45:00 | SPY | ETF | 212.05 | 212.05 | 212.05 | 212.05 | 200.0 |
| 2015-06-19 06:50:00 | SPY | ETF | 212.05 | 212.09 | 212.0 | 212.09 | 3701.0 |
| 2015-06-19 06:55:00 | SPY | ETF | 212.09 | 212.1 | 212.07 | 212.09 | 4999.0 |
| 2015-06-19 07:00:00 | SPY | ETF | 212.1 | 212.15 | 212.07 | 212.11 | 88240.0 |
| 2015-06-19 07:05:00 | SPY | ETF | 212.07 | 212.07 | 212.07 | 212.07 | 2700.0 |
| 2015-06-19 07:10:00 | SPY | ETF | 212.02 | 212.07 | 212.0 | 212.06 | 9350.0 |
| 2015-06-19 07:15:00 | SPY | ETF | 212.06 | 212.12 | 212.06 | 212.1 | 23400.0 |
| 2015-06-19 07:20:00 | SPY | ETF | 212.17 | 212.17 | 212.12 | 212.12 | 22600.0 |
| 2015-06-19 07:25:00 | SPY | ETF | 212.12 | 212.15 | 212.0 | 212.0 | 42684.0 |
| 2015-06-19 07:30:00 | SPY | ETF | 212.0 | 212.08 | 211.99 | 212.04 | 20300.0 |
| 2015-06-19 07:35:00 | SPY | ETF | 212.07 | 212.07 | 212.03 | 212.05 | 14900.0 |
| 2015-06-19 07:40:00 | SPY | ETF | 212.03 | 212.03 | 211.95 | 211.97 | 19901.0 |
| 2015-06-19 07:45:00 | SPY | ETF | 211.99 | 212.02 | 211.96 | 212.02 | 40662.0 |
| 2015-06-19 07:50:00 | SPY | ETF | 212.03 | 212.03 | 211.95 | 212.0 | 56100.0 |
| 2015-06-19 07:55:00 | SPY | ETF | 212.01 | 212.08 | 211.99 | 212.08 | 42800.0 |
| 2015-06-19 08:00:00 | SPY | ETF | 212.09 | 212.1 | 212.05 | 212.08 | 87386.0 |
| 2015-06-19 08:05:00 | SPY | ETF | 212.06 | 212.06 | 212.01 | 212.02 | 14851.0 |
| 2015-06-19 08:10:00 | SPY | ETF | 212.03 | 212.03 | 211.98 | 211.99 | 83310.0 |
| 2015-06-19 08:15:00 | SPY | ETF | 211.99 | 212.04 | 211.98 | 212.02 | 19881.0 |
| 2015-06-19 08:20:00 | SPY | ETF | 212.04 | 212.08 | 212.01 | 212.07 | 22567.0 |
| 2015-06-19 08:25:00 | SPY | ETF | 212.06 | 212.09 | 212.06 | 212.09 | 9313.0 |
| 2015-06-19 08:30:00 | SPY | ETF | 212.09 | 212.09 | 212.043 | 212.07 | 30172.0 |
| 2015-06-19 08:35:00 | SPY | ETF | 212.05 | 212.07 | 211.98 | 212.0 | 34688.0 |
| 2015-06-19 08:40:00 | SPY | ETF | 212.01 | 212.01 | 211.94 | 211.96 | 137194.0 |
| 2015-06-19 08:45:00 | SPY | ETF | 211.96 | 211.96 | 211.81 | 211.88 | 106077.0 |
| 2015-06-19 08:50:00 | SPY | ETF | 211.88 | 211.92 | 211.82 | 211.84 | 197682.0 |
| 2015-06-19 08:55:00 | SPY | ETF | 211.82 | 211.84 | 211.75 | 211.78 | 165661.0 |
| 2015-06-19 09:00:00 | SPY | ETF | 211.77 | 211.77 | 211.67 | 211.68 | 162220.0 |
> showing 50 of 45,075 rows — these rows as CSV