PREVIEW / etf_5min / 2015-04-06
file: by_date/etf_5min/2015/2015-04-06.parquet size: 1.1 MB rows: 48,763
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-04-06 04:00:00 | SPY | ETF | 205.5 | 205.5 | 204.71 | 204.9 | 4757.0 |
| 2015-04-06 04:05:00 | SPY | ETF | 204.88 | 204.88 | 204.88 | 204.88 | 100.0 |
| 2015-04-06 04:10:00 | SPY | ETF | 204.99 | 205.03 | 204.99 | 205.03 | 218.0 |
| 2015-04-06 04:15:00 | SPY | ETF | 205.05 | 205.05 | 204.96 | 204.96 | 600.0 |
| 2015-04-06 04:20:00 | SPY | ETF | 204.94 | 204.95 | 204.94 | 204.95 | 700.0 |
| 2015-04-06 04:40:00 | SPY | ETF | 205.07 | 205.07 | 205.07 | 205.07 | 800.0 |
| 2015-04-06 04:50:00 | SPY | ETF | 205.07 | 205.07 | 205.03 | 205.03 | 400.0 |
| 2015-04-06 05:10:00 | SPY | ETF | 205.08 | 205.08 | 205.05 | 205.05 | 216.0 |
| 2015-04-06 05:35:00 | SPY | ETF | 205.0 | 205.0 | 205.0 | 205.0 | 350.0 |
| 2015-04-06 05:50:00 | SPY | ETF | 204.96 | 204.96 | 204.95 | 204.95 | 400.0 |
| 2015-04-06 06:00:00 | SPY | ETF | 204.95 | 204.95 | 204.95 | 204.95 | 1500.0 |
| 2015-04-06 06:05:00 | SPY | ETF | 204.92 | 204.92 | 204.92 | 204.92 | 100.0 |
| 2015-04-06 06:15:00 | SPY | ETF | 204.95 | 204.95 | 204.95 | 204.95 | 100.0 |
| 2015-04-06 06:35:00 | SPY | ETF | 204.95 | 205.1 | 204.95 | 205.05 | 16100.0 |
| 2015-04-06 06:40:00 | SPY | ETF | 204.98 | 205.0 | 204.98 | 205.0 | 17000.0 |
| 2015-04-06 06:45:00 | SPY | ETF | 205.04 | 205.04 | 205.03 | 205.03 | 2600.0 |
| 2015-04-06 06:50:00 | SPY | ETF | 205.04 | 205.04 | 205.04 | 205.04 | 100.0 |
| 2015-04-06 06:55:00 | SPY | ETF | 205.04 | 205.04 | 205.04 | 205.04 | 250.0 |
| 2015-04-06 07:00:00 | SPY | ETF | 205.09 | 205.09 | 205.07 | 205.07 | 735.0 |
| 2015-04-06 07:05:00 | SPY | ETF | 205.1 | 205.21 | 205.1 | 205.17 | 5008.0 |
| 2015-04-06 07:10:00 | SPY | ETF | 205.18 | 205.18 | 205.15 | 205.15 | 13020.0 |
| 2015-04-06 07:15:00 | SPY | ETF | 205.11 | 205.11 | 204.96 | 204.96 | 20078.0 |
| 2015-04-06 07:20:00 | SPY | ETF | 204.96 | 205.0 | 204.87 | 205.0 | 30317.0 |
| 2015-04-06 07:25:00 | SPY | ETF | 205.06 | 205.06 | 205.0 | 205.0 | 5900.0 |
| 2015-04-06 07:30:00 | SPY | ETF | 205.01 | 205.11 | 205.01 | 205.11 | 11198.0 |
| 2015-04-06 07:35:00 | SPY | ETF | 205.09 | 205.1 | 205.01 | 205.01 | 6902.0 |
| 2015-04-06 07:40:00 | SPY | ETF | 205.0 | 205.0 | 204.86 | 204.88 | 27454.0 |
| 2015-04-06 07:45:00 | SPY | ETF | 204.9 | 204.99 | 204.87 | 204.87 | 177370.0 |
| 2015-04-06 07:50:00 | SPY | ETF | 204.9 | 204.93 | 204.9 | 204.92 | 17381.0 |
| 2015-04-06 07:55:00 | SPY | ETF | 204.92 | 204.93 | 204.86 | 204.88 | 25110.0 |
| 2015-04-06 08:00:00 | SPY | ETF | 204.92 | 205.18 | 204.76 | 204.93 | 59998.0 |
| 2015-04-06 08:05:00 | SPY | ETF | 204.95 | 205.02 | 204.93 | 205.0 | 89740.0 |
| 2015-04-06 08:10:00 | SPY | ETF | 204.99 | 205.0 | 204.94 | 204.96 | 33450.0 |
| 2015-04-06 08:15:00 | SPY | ETF | 204.96 | 205.0 | 204.94 | 204.951 | 27637.0 |
| 2015-04-06 08:20:00 | SPY | ETF | 204.979 | 205.04 | 204.979 | 205.01 | 21800.0 |
| 2015-04-06 08:25:00 | SPY | ETF | 205.02 | 205.06 | 205.02 | 205.06 | 5520.0 |
| 2015-04-06 08:30:00 | SPY | ETF | 205.07 | 205.2 | 205.07 | 205.14 | 21554.0 |
| 2015-04-06 08:35:00 | SPY | ETF | 205.149 | 205.15 | 205.06 | 205.06 | 36174.0 |
| 2015-04-06 08:40:00 | SPY | ETF | 205.07 | 205.08 | 205.03 | 205.06 | 49041.0 |
| 2015-04-06 08:45:00 | SPY | ETF | 205.1 | 205.15 | 205.1 | 205.12 | 21275.0 |
| 2015-04-06 08:50:00 | SPY | ETF | 205.12 | 205.12 | 205.07 | 205.11 | 58074.0 |
| 2015-04-06 08:55:00 | SPY | ETF | 205.1 | 205.12 | 205.06 | 205.08 | 41870.0 |
| 2015-04-06 09:00:00 | SPY | ETF | 205.08 | 205.15 | 205.06 | 205.12 | 13553.0 |
| 2015-04-06 09:05:00 | SPY | ETF | 205.11 | 205.23 | 205.11 | 205.23 | 55459.0 |
| 2015-04-06 09:10:00 | SPY | ETF | 205.23 | 205.3 | 205.23 | 205.29 | 116611.0 |
| 2015-04-06 09:15:00 | SPY | ETF | 205.29 | 205.35 | 205.26 | 205.3 | 120700.0 |
| 2015-04-06 09:20:00 | SPY | ETF | 205.31 | 205.37 | 205.23 | 205.35 | 178710.0 |
| 2015-04-06 09:25:00 | SPY | ETF | 205.32 | 205.41 | 205.31 | 205.37 | 222634.0 |
| 2015-04-06 09:30:00 | SPY | ETF | 205.37 | 205.64 | 205.21 | 205.6 | 3234094.0 |
| 2015-04-06 09:35:00 | SPY | ETF | 205.6 | 205.9 | 205.6 | 205.87 | 2880385.0 |
> showing 50 of 48,763 rows — these rows as CSV