PREVIEW / etf_5min / 2004-07-16
file: by_date/etf_5min/2004/2004-07-16.parquet size: 85 KB rows: 4,153
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-16 08:00:00 | SPY | ETF | 111.2 | 111.2 | 111.19 | 111.19 | 500.0 |
| 2004-07-16 08:05:00 | SPY | ETF | 111.18 | 111.18 | 111.15 | 111.15 | 700.0 |
| 2004-07-16 08:10:00 | SPY | ETF | 111.1 | 111.1 | 111.09 | 111.09 | 2300.0 |
| 2004-07-16 08:15:00 | SPY | ETF | 111.09 | 111.11 | 111.09 | 111.09 | 36100.0 |
| 2004-07-16 08:20:00 | SPY | ETF | 111.09 | 111.09 | 111.09 | 111.09 | 1200.0 |
| 2004-07-16 08:25:00 | SPY | ETF | 111.09 | 111.13 | 111.09 | 111.1 | 2000.0 |
| 2004-07-16 08:30:00 | SPY | ETF | 111.17 | 111.42 | 111.14 | 111.4 | 717000.0 |
| 2004-07-16 08:35:00 | SPY | ETF | 111.36 | 111.39 | 111.33 | 111.35 | 5800.0 |
| 2004-07-16 08:40:00 | SPY | ETF | 111.36 | 111.39 | 111.35 | 111.35 | 25000.0 |
| 2004-07-16 08:45:00 | SPY | ETF | 111.35 | 111.42 | 111.35 | 111.37 | 27700.0 |
| 2004-07-16 08:50:00 | SPY | ETF | 111.37 | 111.37 | 111.35 | 111.35 | 400.0 |
| 2004-07-16 08:55:00 | SPY | ETF | 111.38 | 111.4 | 111.38 | 111.4 | 3400.0 |
| 2004-07-16 09:00:00 | SPY | ETF | 111.42 | 111.48 | 111.42 | 111.48 | 2600.0 |
| 2004-07-16 09:05:00 | SPY | ETF | 111.47 | 111.47 | 111.4 | 111.4 | 6400.0 |
| 2004-07-16 09:10:00 | SPY | ETF | 111.4 | 111.41 | 111.39 | 111.41 | 1200.0 |
| 2004-07-16 09:15:00 | SPY | ETF | 111.4 | 111.4 | 111.39 | 111.39 | 11400.0 |
| 2004-07-16 09:20:00 | SPY | ETF | 111.39 | 111.46 | 111.39 | 111.45 | 13800.0 |
| 2004-07-16 09:25:00 | SPY | ETF | 111.42 | 111.6 | 111.42 | 111.58 | 17000.0 |
| 2004-07-16 09:30:00 | SPY | ETF | 111.57 | 111.67 | 111.45 | 111.48 | 1915500.0 |
| 2004-07-16 09:35:00 | SPY | ETF | 111.47 | 111.59 | 111.41 | 111.55 | 1461700.0 |
| 2004-07-16 09:40:00 | SPY | ETF | 111.54 | 111.58 | 111.48 | 111.53 | 1109200.0 |
| 2004-07-16 09:45:00 | SPY | ETF | 111.52 | 111.59 | 111.48 | 111.5 | 492400.0 |
| 2004-07-16 09:50:00 | SPY | ETF | 111.5 | 111.52 | 111.32 | 111.39 | 652600.0 |
| 2004-07-16 09:55:00 | SPY | ETF | 111.4 | 111.51 | 111.36 | 111.45 | 796100.0 |
| 2004-07-16 10:00:00 | SPY | ETF | 111.47 | 111.53 | 111.37 | 111.38 | 554600.0 |
| 2004-07-16 10:05:00 | SPY | ETF | 111.35 | 111.48 | 111.23 | 111.23 | 885200.0 |
| 2004-07-16 10:10:00 | SPY | ETF | 111.24 | 111.3 | 111.12 | 111.22 | 1118500.0 |
| 2004-07-16 10:15:00 | SPY | ETF | 111.23 | 111.32 | 111.19 | 111.32 | 729800.0 |
| 2004-07-16 10:20:00 | SPY | ETF | 111.32 | 111.36 | 111.25 | 111.29 | 744100.0 |
| 2004-07-16 10:25:00 | SPY | ETF | 111.29 | 111.32 | 111.22 | 111.24 | 173300.0 |
| 2004-07-16 10:30:00 | SPY | ETF | 111.23 | 111.24 | 111.15 | 111.18 | 483100.0 |
| 2004-07-16 10:35:00 | SPY | ETF | 111.18 | 111.19 | 110.93 | 111.01 | 868400.0 |
| 2004-07-16 10:40:00 | SPY | ETF | 111.0 | 111.05 | 110.85 | 110.97 | 718600.0 |
| 2004-07-16 10:45:00 | SPY | ETF | 110.97 | 111.04 | 110.88 | 110.93 | 603100.0 |
| 2004-07-16 10:50:00 | SPY | ETF | 110.93 | 111.03 | 110.91 | 111.0 | 399300.0 |
| 2004-07-16 10:55:00 | SPY | ETF | 110.98 | 111.1 | 110.89 | 110.93 | 575200.0 |
| 2004-07-16 11:00:00 | SPY | ETF | 110.92 | 111.09 | 110.89 | 111.08 | 424200.0 |
| 2004-07-16 11:05:00 | SPY | ETF | 111.07 | 111.09 | 110.99 | 111.08 | 192800.0 |
| 2004-07-16 11:10:00 | SPY | ETF | 111.07 | 111.14 | 111.03 | 111.09 | 316200.0 |
| 2004-07-16 11:15:00 | SPY | ETF | 111.09 | 111.24 | 111.08 | 111.24 | 233800.0 |
| 2004-07-16 11:20:00 | SPY | ETF | 111.2 | 111.29 | 111.1 | 111.1 | 534900.0 |
| 2004-07-16 11:25:00 | SPY | ETF | 111.12 | 111.18 | 111.04 | 111.08 | 191100.0 |
| 2004-07-16 11:30:00 | SPY | ETF | 111.09 | 111.15 | 111.05 | 111.13 | 173900.0 |
| 2004-07-16 11:35:00 | SPY | ETF | 111.13 | 111.16 | 111.1015 | 111.15 | 185400.0 |
| 2004-07-16 11:40:00 | SPY | ETF | 111.16 | 111.16 | 111.03 | 111.11 | 165100.0 |
| 2004-07-16 11:45:00 | SPY | ETF | 111.11 | 111.14 | 111.05 | 111.09 | 94400.0 |
| 2004-07-16 11:50:00 | SPY | ETF | 111.1 | 111.12 | 111.04 | 111.09 | 402200.0 |
| 2004-07-16 11:55:00 | SPY | ETF | 111.08 | 111.12 | 111.01 | 111.11 | 208700.0 |
| 2004-07-16 12:00:00 | SPY | ETF | 111.11 | 111.19 | 111.07 | 111.08 | 351900.0 |
| 2004-07-16 12:05:00 | SPY | ETF | 111.08 | 111.18 | 111.08 | 111.13 | 129000.0 |
> showing 50 of 4,153 rows — these rows as CSV