PREVIEW / etf_5min / 2008-04-28
file: by_date/etf_5min/2008/2008-04-28.parquet size: 430 KB rows: 20,758
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-28 04:30:00 | SPY | ETF | 139.69 | 139.69 | 139.69 | 139.69 | 500.0 |
| 2008-04-28 04:35:00 | SPY | ETF | 139.73 | 139.73 | 139.73 | 139.73 | 100.0 |
| 2008-04-28 06:00:00 | SPY | ETF | 140.0 | 140.0 | 140.0 | 140.0 | 2300.0 |
| 2008-04-28 06:05:00 | SPY | ETF | 140.17 | 140.17 | 140.17 | 140.17 | 200.0 |
| 2008-04-28 06:15:00 | SPY | ETF | 140.16 | 140.2 | 140.16 | 140.19 | 15000.0 |
| 2008-04-28 06:25:00 | SPY | ETF | 140.12 | 140.19 | 140.1 | 140.13 | 23000.0 |
| 2008-04-28 06:30:00 | SPY | ETF | 140.14 | 140.19 | 140.14 | 140.19 | 16000.0 |
| 2008-04-28 06:40:00 | SPY | ETF | 140.2 | 140.26 | 140.18 | 140.26 | 5600.0 |
| 2008-04-28 06:45:00 | SPY | ETF | 140.31 | 140.31 | 140.25 | 140.25 | 6039.0 |
| 2008-04-28 06:50:00 | SPY | ETF | 140.23 | 140.23 | 140.23 | 140.23 | 5000.0 |
| 2008-04-28 06:55:00 | SPY | ETF | 140.18 | 140.24 | 140.18 | 140.24 | 8500.0 |
| 2008-04-28 07:00:00 | SPY | ETF | 140.15 | 140.25 | 140.15 | 140.2 | 45000.0 |
| 2008-04-28 07:05:00 | SPY | ETF | 140.2 | 140.2 | 140.17 | 140.17 | 11300.0 |
| 2008-04-28 07:10:00 | SPY | ETF | 140.18 | 140.23 | 140.17 | 140.23 | 20300.0 |
| 2008-04-28 07:15:00 | SPY | ETF | 140.2 | 140.21 | 140.13 | 140.15 | 11900.0 |
| 2008-04-28 07:20:00 | SPY | ETF | 140.17 | 140.2 | 140.17 | 140.2 | 23000.0 |
| 2008-04-28 07:25:00 | SPY | ETF | 140.2 | 140.25 | 140.1 | 140.1 | 105700.0 |
| 2008-04-28 07:30:00 | SPY | ETF | 140.02 | 140.07 | 140.0 | 140.07 | 58800.0 |
| 2008-04-28 07:35:00 | SPY | ETF | 140.02 | 140.1 | 140.0 | 140.0 | 53895.0 |
| 2008-04-28 07:40:00 | SPY | ETF | 140.02 | 140.02 | 139.97 | 140.01 | 8230.0 |
| 2008-04-28 07:45:00 | SPY | ETF | 140.02 | 140.04 | 140.0 | 140.0 | 5900.0 |
| 2008-04-28 07:50:00 | SPY | ETF | 140.03 | 140.03 | 139.97 | 139.98 | 7100.0 |
| 2008-04-28 07:55:00 | SPY | ETF | 139.98 | 139.98 | 139.95 | 139.96 | 10200.0 |
| 2008-04-28 08:00:00 | SPY | ETF | 139.98 | 140.28 | 139.96 | 140.0 | 136040.0 |
| 2008-04-28 08:05:00 | SPY | ETF | 139.99 | 140.06 | 139.98 | 140.02 | 21800.0 |
| 2008-04-28 08:10:00 | SPY | ETF | 140.03 | 140.05 | 140.0 | 140.0 | 50300.0 |
| 2008-04-28 08:15:00 | SPY | ETF | 140.0 | 140.0 | 139.88 | 139.9 | 327820.0 |
| 2008-04-28 08:20:00 | SPY | ETF | 139.91 | 139.93 | 139.9 | 139.93 | 16307.0 |
| 2008-04-28 08:25:00 | SPY | ETF | 139.93 | 139.99 | 139.88 | 139.95 | 116732.0 |
| 2008-04-28 08:30:00 | SPY | ETF | 139.95 | 140.13 | 139.94 | 140.03 | 193835.0 |
| 2008-04-28 08:35:00 | SPY | ETF | 140.03 | 140.04 | 140.0 | 140.02 | 24723.0 |
| 2008-04-28 08:40:00 | SPY | ETF | 140.0 | 140.02 | 139.96 | 139.98 | 14300.0 |
| 2008-04-28 08:45:00 | SPY | ETF | 139.96 | 140.02 | 139.67 | 139.94 | 106433.0 |
| 2008-04-28 08:50:00 | SPY | ETF | 139.94 | 139.94 | 139.77 | 139.78 | 215841.0 |
| 2008-04-28 08:55:00 | SPY | ETF | 139.77 | 139.78 | 139.71 | 139.74 | 483195.0 |
| 2008-04-28 09:00:00 | SPY | ETF | 139.75 | 139.78 | 139.66 | 139.78 | 582349.0 |
| 2008-04-28 09:05:00 | SPY | ETF | 139.77 | 139.82 | 139.73 | 139.73 | 389000.0 |
| 2008-04-28 09:10:00 | SPY | ETF | 139.76 | 139.78 | 139.73 | 139.75 | 100463.0 |
| 2008-04-28 09:15:00 | SPY | ETF | 139.75 | 139.84 | 139.74 | 139.84 | 300616.0 |
| 2008-04-28 09:20:00 | SPY | ETF | 139.85 | 139.9 | 139.85 | 139.89 | 95673.0 |
| 2008-04-28 09:25:00 | SPY | ETF | 139.89 | 139.89 | 139.85 | 139.87 | 97733.0 |
| 2008-04-28 09:30:00 | SPY | ETF | 139.88 | 139.99 | 139.78 | 139.79 | 2278253.0 |
| 2008-04-28 09:35:00 | SPY | ETF | 139.79 | 139.9601 | 139.65 | 139.68 | 2604805.0 |
| 2008-04-28 09:40:00 | SPY | ETF | 139.68 | 139.8801 | 139.44 | 139.56 | 2585520.0 |
| 2008-04-28 09:45:00 | SPY | ETF | 139.57 | 139.6201 | 139.38 | 139.54 | 1924666.0 |
| 2008-04-28 09:50:00 | SPY | ETF | 139.55 | 139.68 | 139.5 | 139.63 | 2507849.0 |
| 2008-04-28 09:55:00 | SPY | ETF | 139.63 | 139.78 | 139.62 | 139.7101 | 2336360.0 |
| 2008-04-28 10:00:00 | SPY | ETF | 139.72 | 139.72 | 139.54 | 139.59 | 1900460.0 |
| 2008-04-28 10:05:00 | SPY | ETF | 139.58 | 139.72 | 139.48 | 139.63 | 2375899.0 |
| 2008-04-28 10:10:00 | SPY | ETF | 139.63 | 139.98 | 139.63 | 139.96 | 3049361.0 |
> showing 50 of 20,758 rows — these rows as CSV