PREVIEW / etf_5min / 2004-08-20
file: by_date/etf_5min/2004/2004-08-20.parquet size: 88 KB rows: 4,253
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-08-20 08:00:00 | SPY | ETF | 109.53 | 109.53 | 109.33 | 109.33 | 4000.0 |
| 2004-08-20 08:10:00 | SPY | ETF | 109.47 | 109.47 | 109.46 | 109.46 | 10500.0 |
| 2004-08-20 08:15:00 | SPY | ETF | 109.46 | 109.47 | 109.43 | 109.47 | 1400.0 |
| 2004-08-20 08:20:00 | SPY | ETF | 109.48 | 109.48 | 109.46 | 109.46 | 2600.0 |
| 2004-08-20 08:25:00 | SPY | ETF | 109.48 | 109.52 | 109.48 | 109.52 | 25000.0 |
| 2004-08-20 08:35:00 | SPY | ETF | 109.43 | 109.43 | 109.43 | 109.43 | 2900.0 |
| 2004-08-20 08:40:00 | SPY | ETF | 109.45 | 109.5 | 109.45 | 109.5 | 2300.0 |
| 2004-08-20 08:45:00 | SPY | ETF | 109.47 | 109.47 | 109.44 | 109.45 | 2000.0 |
| 2004-08-20 08:50:00 | SPY | ETF | 109.45 | 109.45 | 109.45 | 109.45 | 200.0 |
| 2004-08-20 08:55:00 | SPY | ETF | 109.45 | 109.45 | 109.44 | 109.44 | 1100.0 |
| 2004-08-20 09:00:00 | SPY | ETF | 109.43 | 109.44 | 109.43 | 109.44 | 11200.0 |
| 2004-08-20 09:05:00 | SPY | ETF | 109.41 | 109.42 | 109.41 | 109.42 | 1100.0 |
| 2004-08-20 09:10:00 | SPY | ETF | 109.44 | 109.45 | 109.43 | 109.45 | 2600.0 |
| 2004-08-20 09:15:00 | SPY | ETF | 109.44 | 109.48 | 109.44 | 109.48 | 6700.0 |
| 2004-08-20 09:20:00 | SPY | ETF | 109.48 | 109.5 | 109.48 | 109.48 | 6400.0 |
| 2004-08-20 09:25:00 | SPY | ETF | 109.5 | 109.62 | 109.48 | 109.62 | 14300.0 |
| 2004-08-20 09:30:00 | SPY | ETF | 109.61 | 109.68 | 109.51 | 109.64 | 1204100.0 |
| 2004-08-20 09:35:00 | SPY | ETF | 109.66 | 109.76 | 109.63 | 109.7 | 958700.0 |
| 2004-08-20 09:40:00 | SPY | ETF | 109.67 | 109.77 | 109.65 | 109.68 | 788300.0 |
| 2004-08-20 09:45:00 | SPY | ETF | 109.69 | 109.91 | 109.65 | 109.89 | 1158400.0 |
| 2004-08-20 09:50:00 | SPY | ETF | 109.91 | 109.99 | 109.86 | 109.94 | 706900.0 |
| 2004-08-20 09:55:00 | SPY | ETF | 109.92 | 109.95 | 109.84 | 109.87 | 1019300.0 |
| 2004-08-20 10:00:00 | SPY | ETF | 109.86 | 109.91 | 109.81 | 109.88 | 789700.0 |
| 2004-08-20 10:05:00 | SPY | ETF | 109.87 | 109.99 | 109.87 | 109.99 | 556200.0 |
| 2004-08-20 10:10:00 | SPY | ETF | 109.95 | 109.95 | 109.82 | 109.86 | 532400.0 |
| 2004-08-20 10:15:00 | SPY | ETF | 109.85 | 109.94 | 109.79 | 109.81 | 922100.0 |
| 2004-08-20 10:20:00 | SPY | ETF | 109.81 | 109.9 | 109.8 | 109.89 | 275800.0 |
| 2004-08-20 10:25:00 | SPY | ETF | 109.89 | 109.92 | 109.8 | 109.82 | 398400.0 |
| 2004-08-20 10:30:00 | SPY | ETF | 109.82 | 109.92 | 109.81 | 109.89 | 379800.0 |
| 2004-08-20 10:35:00 | SPY | ETF | 109.9 | 110.1 | 109.89 | 110.08 | 557000.0 |
| 2004-08-20 10:40:00 | SPY | ETF | 110.08 | 110.17 | 110.05 | 110.13 | 1125700.0 |
| 2004-08-20 10:45:00 | SPY | ETF | 110.06 | 110.1 | 110.02 | 110.06 | 451200.0 |
| 2004-08-20 10:50:00 | SPY | ETF | 110.05 | 110.05 | 109.92 | 109.97 | 473900.0 |
| 2004-08-20 10:55:00 | SPY | ETF | 109.95 | 109.97 | 109.9 | 109.94 | 540900.0 |
| 2004-08-20 11:00:00 | SPY | ETF | 109.94 | 109.95 | 109.84 | 109.86 | 326600.0 |
| 2004-08-20 11:05:00 | SPY | ETF | 109.84 | 109.9 | 109.84 | 109.89 | 232800.0 |
| 2004-08-20 11:10:00 | SPY | ETF | 109.89 | 109.94 | 109.88 | 109.92 | 548100.0 |
| 2004-08-20 11:15:00 | SPY | ETF | 109.92 | 109.99 | 109.91 | 109.95 | 372400.0 |
| 2004-08-20 11:20:00 | SPY | ETF | 109.95 | 109.98 | 109.91 | 109.94 | 98900.0 |
| 2004-08-20 11:25:00 | SPY | ETF | 109.94 | 110.0 | 109.93 | 109.96 | 182000.0 |
| 2004-08-20 11:30:00 | SPY | ETF | 109.96 | 109.97 | 109.87 | 109.91 | 322500.0 |
| 2004-08-20 11:35:00 | SPY | ETF | 109.91 | 109.95 | 109.89 | 109.91 | 168000.0 |
| 2004-08-20 11:40:00 | SPY | ETF | 109.92 | 109.95 | 109.89 | 109.9 | 143000.0 |
| 2004-08-20 11:45:00 | SPY | ETF | 109.89 | 109.93 | 109.81 | 109.88 | 238600.0 |
| 2004-08-20 11:50:00 | SPY | ETF | 109.88 | 109.96 | 109.85 | 109.94 | 282900.0 |
| 2004-08-20 11:55:00 | SPY | ETF | 109.94 | 109.99 | 109.86 | 109.93 | 542500.0 |
| 2004-08-20 12:00:00 | SPY | ETF | 109.92 | 109.96 | 109.91 | 109.92 | 439100.0 |
| 2004-08-20 12:05:00 | SPY | ETF | 109.92 | 110.03 | 109.91 | 109.96 | 668800.0 |
| 2004-08-20 12:10:00 | SPY | ETF | 109.98 | 110.14 | 109.94 | 110.11 | 2375600.0 |
| 2004-08-20 12:15:00 | SPY | ETF | 110.11 | 110.13 | 110.04 | 110.07 | 504600.0 |
> showing 50 of 4,253 rows — these rows as CSV