PREVIEW / etf_5min / 2005-04-19
file: by_date/etf_5min/2005/2005-04-19.parquet size: 121 KB rows: 6,395
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-19 04:40:00 | SPY | ETF | 114.72 | 114.72 | 114.72 | 114.72 | 1000.0 |
| 2005-04-19 04:45:00 | SPY | ETF | 114.71 | 114.71 | 114.71 | 114.71 | 1000.0 |
| 2005-04-19 07:05:00 | SPY | ETF | 114.84 | 114.84 | 114.84 | 114.84 | 4600.0 |
| 2005-04-19 07:10:00 | SPY | ETF | 114.81 | 114.81 | 114.8 | 114.8 | 23400.0 |
| 2005-04-19 07:20:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 24900.0 |
| 2005-04-19 07:25:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 10600.0 |
| 2005-04-19 07:30:00 | SPY | ETF | 115.0 | 115.0 | 115.0 | 115.0 | 49900.0 |
| 2005-04-19 07:35:00 | SPY | ETF | 114.99 | 114.99 | 114.99 | 114.99 | 2900.0 |
| 2005-04-19 07:40:00 | SPY | ETF | 114.99 | 114.99 | 114.96 | 114.97 | 18100.0 |
| 2005-04-19 07:45:00 | SPY | ETF | 115.03 | 115.04 | 114.99 | 114.99 | 56100.0 |
| 2005-04-19 07:50:00 | SPY | ETF | 114.96 | 115.0 | 114.96 | 115.0 | 9900.0 |
| 2005-04-19 07:55:00 | SPY | ETF | 114.93 | 114.95 | 114.91 | 114.91 | 12100.0 |
| 2005-04-19 08:00:00 | SPY | ETF | 114.9 | 114.93 | 114.86 | 114.91 | 6200.0 |
| 2005-04-19 08:05:00 | SPY | ETF | 114.93 | 114.93 | 114.93 | 114.93 | 100.0 |
| 2005-04-19 08:10:00 | SPY | ETF | 114.9 | 114.9 | 114.8 | 114.9 | 57500.0 |
| 2005-04-19 08:15:00 | SPY | ETF | 114.88 | 114.95 | 114.88 | 114.95 | 89700.0 |
| 2005-04-19 08:20:00 | SPY | ETF | 114.91 | 114.91 | 114.78 | 114.83 | 21200.0 |
| 2005-04-19 08:25:00 | SPY | ETF | 114.86 | 114.88 | 114.8 | 114.87 | 108400.0 |
| 2005-04-19 08:30:00 | SPY | ETF | 114.95 | 115.12 | 114.9 | 115.01 | 368000.0 |
| 2005-04-19 08:35:00 | SPY | ETF | 115.0 | 115.07 | 115.0 | 115.05 | 51000.0 |
| 2005-04-19 08:40:00 | SPY | ETF | 115.05 | 115.05 | 115.03 | 115.05 | 27900.0 |
| 2005-04-19 08:45:00 | SPY | ETF | 115.05 | 115.05 | 114.98 | 114.99 | 109400.0 |
| 2005-04-19 08:50:00 | SPY | ETF | 115.0 | 115.03 | 114.99 | 115.02 | 36400.0 |
| 2005-04-19 08:55:00 | SPY | ETF | 114.99 | 115.02 | 114.99 | 115.02 | 21200.0 |
| 2005-04-19 09:00:00 | SPY | ETF | 115.03 | 115.03 | 115.01 | 115.03 | 68700.0 |
| 2005-04-19 09:05:00 | SPY | ETF | 115.02 | 115.06 | 115.02 | 115.05 | 104500.0 |
| 2005-04-19 09:10:00 | SPY | ETF | 115.05 | 115.07 | 115.04 | 115.05 | 7500.0 |
| 2005-04-19 09:15:00 | SPY | ETF | 115.05 | 115.06 | 115.04 | 115.05 | 104000.0 |
| 2005-04-19 09:20:00 | SPY | ETF | 115.05 | 115.06 | 115.04 | 115.06 | 24900.0 |
| 2005-04-19 09:25:00 | SPY | ETF | 115.06 | 115.11 | 115.06 | 115.06 | 61000.0 |
| 2005-04-19 09:30:00 | SPY | ETF | 115.1 | 115.22 | 115.0 | 115.2 | 3425900.0 |
| 2005-04-19 09:35:00 | SPY | ETF | 115.2 | 115.24 | 115.14 | 115.19 | 1739400.0 |
| 2005-04-19 09:40:00 | SPY | ETF | 115.19 | 115.24 | 115.12 | 115.19 | 1103000.0 |
| 2005-04-19 09:45:00 | SPY | ETF | 115.18 | 115.24 | 115.03 | 115.0492 | 1212900.0 |
| 2005-04-19 09:50:00 | SPY | ETF | 115.05 | 115.14 | 115.0 | 115.13 | 2325900.0 |
| 2005-04-19 09:55:00 | SPY | ETF | 115.14 | 115.27 | 115.1 | 115.25 | 1749800.0 |
| 2005-04-19 10:00:00 | SPY | ETF | 115.26 | 115.32 | 115.05 | 115.28 | 2310000.0 |
| 2005-04-19 10:05:00 | SPY | ETF | 115.28 | 115.33 | 115.15 | 115.2 | 1575900.0 |
| 2005-04-19 10:10:00 | SPY | ETF | 115.21 | 115.26 | 115.12 | 115.13 | 954700.0 |
| 2005-04-19 10:15:00 | SPY | ETF | 115.12 | 115.2 | 115.06 | 115.11 | 971600.0 |
| 2005-04-19 10:20:00 | SPY | ETF | 115.11 | 115.24 | 115.06 | 115.21 | 1350400.0 |
| 2005-04-19 10:25:00 | SPY | ETF | 115.19 | 115.29 | 115.1 | 115.13 | 936900.0 |
| 2005-04-19 10:30:00 | SPY | ETF | 115.13 | 115.23 | 115.1 | 115.18 | 363600.0 |
| 2005-04-19 10:35:00 | SPY | ETF | 115.18 | 115.19 | 115.07 | 115.1 | 780500.0 |
| 2005-04-19 10:40:00 | SPY | ETF | 115.11 | 115.12 | 114.93 | 114.93 | 1361500.0 |
| 2005-04-19 10:45:00 | SPY | ETF | 114.92 | 115.16 | 114.83 | 114.85 | 1381100.0 |
| 2005-04-19 10:50:00 | SPY | ETF | 114.86 | 114.97 | 114.84 | 114.91 | 931100.0 |
| 2005-04-19 10:55:00 | SPY | ETF | 114.9 | 114.98 | 114.89 | 114.98 | 661700.0 |
| 2005-04-19 11:00:00 | SPY | ETF | 114.98 | 115.06 | 114.93 | 115.0 | 455300.0 |
| 2005-04-19 11:05:00 | SPY | ETF | 115.0 | 115.05 | 114.94 | 115.05 | 354500.0 |
> showing 50 of 6,395 rows — these rows as CSV