PREVIEW / etf_5min / 2005-04-28
file: by_date/etf_5min/2005/2005-04-28.parquet size: 120 KB rows: 5,969
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-28 04:35:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 3600.0 |
| 2005-04-28 04:50:00 | SPY | ETF | 115.62 | 115.62 | 115.62 | 115.62 | 200.0 |
| 2005-04-28 05:15:00 | SPY | ETF | 115.62 | 115.62 | 115.62 | 115.62 | 400.0 |
| 2005-04-28 05:45:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 5000.0 |
| 2005-04-28 06:55:00 | SPY | ETF | 115.34 | 115.34 | 115.34 | 115.34 | 400.0 |
| 2005-04-28 07:00:00 | SPY | ETF | 115.34 | 115.34 | 115.33 | 115.33 | 800.0 |
| 2005-04-28 07:05:00 | SPY | ETF | 115.35 | 115.35 | 115.35 | 115.35 | 3600.0 |
| 2005-04-28 07:10:00 | SPY | ETF | 115.46 | 115.49 | 115.46 | 115.49 | 5800.0 |
| 2005-04-28 07:15:00 | SPY | ETF | 115.5 | 115.5 | 115.46 | 115.46 | 17400.0 |
| 2005-04-28 07:20:00 | SPY | ETF | 115.46 | 115.46 | 115.46 | 115.46 | 2600.0 |
| 2005-04-28 07:25:00 | SPY | ETF | 115.47 | 115.47 | 115.46 | 115.46 | 10000.0 |
| 2005-04-28 07:30:00 | SPY | ETF | 115.47 | 115.47 | 115.45 | 115.45 | 30100.0 |
| 2005-04-28 07:35:00 | SPY | ETF | 115.45 | 115.47 | 115.45 | 115.47 | 4900.0 |
| 2005-04-28 07:40:00 | SPY | ETF | 115.49 | 115.5 | 115.49 | 115.49 | 4500.0 |
| 2005-04-28 07:45:00 | SPY | ETF | 115.48 | 115.52 | 115.45 | 115.45 | 12600.0 |
| 2005-04-28 07:50:00 | SPY | ETF | 115.44 | 115.44 | 115.4 | 115.4 | 8400.0 |
| 2005-04-28 07:55:00 | SPY | ETF | 115.4 | 115.45 | 115.4 | 115.45 | 25600.0 |
| 2005-04-28 08:00:00 | SPY | ETF | 115.44 | 115.45 | 115.4 | 115.43 | 81500.0 |
| 2005-04-28 08:05:00 | SPY | ETF | 115.46 | 115.5 | 115.46 | 115.46 | 15800.0 |
| 2005-04-28 08:10:00 | SPY | ETF | 115.52 | 115.52 | 115.47 | 115.47 | 5200.0 |
| 2005-04-28 08:15:00 | SPY | ETF | 115.51 | 115.58 | 115.51 | 115.58 | 26000.0 |
| 2005-04-28 08:20:00 | SPY | ETF | 115.56 | 115.64 | 115.56 | 115.57 | 92100.0 |
| 2005-04-28 08:25:00 | SPY | ETF | 115.56 | 115.68 | 115.55 | 115.68 | 14400.0 |
| 2005-04-28 08:30:00 | SPY | ETF | 115.44 | 115.47 | 115.26 | 115.33 | 492300.0 |
| 2005-04-28 08:35:00 | SPY | ETF | 115.29 | 115.3 | 115.19 | 115.3 | 188400.0 |
| 2005-04-28 08:40:00 | SPY | ETF | 115.3 | 115.35 | 115.3 | 115.31 | 75500.0 |
| 2005-04-28 08:45:00 | SPY | ETF | 115.34 | 115.4 | 115.25 | 115.25 | 116100.0 |
| 2005-04-28 08:50:00 | SPY | ETF | 115.25 | 115.32 | 115.22 | 115.3 | 97500.0 |
| 2005-04-28 08:55:00 | SPY | ETF | 115.28 | 115.28 | 115.23 | 115.26 | 3700.0 |
| 2005-04-28 09:00:00 | SPY | ETF | 115.28 | 115.33 | 115.28 | 115.33 | 14300.0 |
| 2005-04-28 09:05:00 | SPY | ETF | 115.3 | 115.31 | 115.28 | 115.3 | 18800.0 |
| 2005-04-28 09:10:00 | SPY | ETF | 115.3 | 115.3 | 115.25 | 115.28 | 12400.0 |
| 2005-04-28 09:15:00 | SPY | ETF | 115.27 | 115.37 | 115.27 | 115.35 | 52200.0 |
| 2005-04-28 09:20:00 | SPY | ETF | 115.35 | 115.37 | 115.34 | 115.35 | 130900.0 |
| 2005-04-28 09:25:00 | SPY | ETF | 115.35 | 115.35 | 115.27 | 115.27 | 55400.0 |
| 2005-04-28 09:30:00 | SPY | ETF | 115.27 | 115.44 | 115.26 | 115.42 | 1174900.0 |
| 2005-04-28 09:35:00 | SPY | ETF | 115.42 | 115.45 | 115.27 | 115.29 | 1000200.0 |
| 2005-04-28 09:40:00 | SPY | ETF | 115.3 | 115.38 | 115.11 | 115.13 | 838400.0 |
| 2005-04-28 09:45:00 | SPY | ETF | 115.13 | 115.15 | 114.91 | 114.95 | 1861300.0 |
| 2005-04-28 09:50:00 | SPY | ETF | 114.92 | 115.05 | 114.88 | 114.88 | 942000.0 |
| 2005-04-28 09:55:00 | SPY | ETF | 114.88 | 115.03 | 114.83 | 114.95 | 1431900.0 |
| 2005-04-28 10:00:00 | SPY | ETF | 114.95 | 115.16 | 114.89 | 115.11 | 1540400.0 |
| 2005-04-28 10:05:00 | SPY | ETF | 115.1 | 115.16 | 114.98 | 115.07 | 879000.0 |
| 2005-04-28 10:10:00 | SPY | ETF | 115.07 | 115.3 | 115.03 | 115.24 | 1702100.0 |
| 2005-04-28 10:15:00 | SPY | ETF | 115.23 | 115.3 | 115.0 | 115.2 | 1128600.0 |
| 2005-04-28 10:20:00 | SPY | ETF | 115.2 | 115.45 | 115.16 | 115.4 | 1196900.0 |
| 2005-04-28 10:25:00 | SPY | ETF | 115.39 | 115.46 | 115.36 | 115.44 | 1273700.0 |
| 2005-04-28 10:30:00 | SPY | ETF | 115.44 | 115.68 | 115.42 | 115.57 | 1618900.0 |
| 2005-04-28 10:35:00 | SPY | ETF | 115.56 | 115.57 | 115.39 | 115.4 | 848100.0 |
| 2005-04-28 10:40:00 | SPY | ETF | 115.4 | 115.45 | 115.28 | 115.36 | 838600.0 |
> showing 50 of 5,969 rows — these rows as CSV