PREVIEW / etf_5min / 2006-04-28
file: by_date/etf_5min/2006/2006-04-28.parquet size: 182 KB rows: 9,315
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-28 04:15:00 | SPY | ETF | 130.77 | 130.77 | 130.77 | 130.77 | 100.0 |
| 2006-04-28 04:25:00 | SPY | ETF | 130.71 | 130.71 | 130.71 | 130.71 | 100.0 |
| 2006-04-28 07:00:00 | SPY | ETF | 130.75 | 130.75 | 130.73 | 130.73 | 2100.0 |
| 2006-04-28 07:20:00 | SPY | ETF | 130.78 | 130.78 | 130.78 | 130.78 | 100.0 |
| 2006-04-28 07:25:00 | SPY | ETF | 130.8 | 130.8 | 130.8 | 130.8 | 100.0 |
| 2006-04-28 07:35:00 | SPY | ETF | 130.81 | 130.82 | 130.81 | 130.81 | 300.0 |
| 2006-04-28 07:40:00 | SPY | ETF | 130.81 | 130.81 | 130.78 | 130.78 | 1000.0 |
| 2006-04-28 07:50:00 | SPY | ETF | 130.75 | 130.75 | 130.75 | 130.75 | 13100.0 |
| 2006-04-28 08:00:00 | SPY | ETF | 130.75 | 130.82 | 130.75 | 130.77 | 142300.0 |
| 2006-04-28 08:05:00 | SPY | ETF | 130.78 | 130.8 | 130.74 | 130.77 | 58000.0 |
| 2006-04-28 08:10:00 | SPY | ETF | 130.77 | 130.77 | 130.7 | 130.72 | 54500.0 |
| 2006-04-28 08:15:00 | SPY | ETF | 130.81 | 130.81 | 130.72 | 130.73 | 25600.0 |
| 2006-04-28 08:20:00 | SPY | ETF | 130.72 | 130.73 | 130.69 | 130.69 | 24000.0 |
| 2006-04-28 08:25:00 | SPY | ETF | 130.69 | 130.77 | 130.64 | 130.69 | 183100.0 |
| 2006-04-28 08:30:00 | SPY | ETF | 130.72 | 130.94 | 130.69 | 130.88 | 509400.0 |
| 2006-04-28 08:35:00 | SPY | ETF | 130.6 | 130.92 | 130.6 | 130.87 | 410300.0 |
| 2006-04-28 08:40:00 | SPY | ETF | 130.87 | 130.9 | 130.87 | 130.9 | 16300.0 |
| 2006-04-28 08:45:00 | SPY | ETF | 130.91 | 130.91 | 130.76 | 130.88 | 208600.0 |
| 2006-04-28 08:50:00 | SPY | ETF | 130.91 | 131.94 | 130.91 | 130.92 | 41600.0 |
| 2006-04-28 08:55:00 | SPY | ETF | 130.92 | 130.92 | 130.64 | 130.64 | 43800.0 |
| 2006-04-28 09:00:00 | SPY | ETF | 130.91 | 130.93 | 130.91 | 130.93 | 1400.0 |
| 2006-04-28 09:05:00 | SPY | ETF | 130.91 | 130.91 | 130.79 | 130.84 | 149300.0 |
| 2006-04-28 09:10:00 | SPY | ETF | 130.84 | 130.85 | 130.84 | 130.85 | 30200.0 |
| 2006-04-28 09:15:00 | SPY | ETF | 130.86 | 130.86 | 130.82 | 130.85 | 39300.0 |
| 2006-04-28 09:20:00 | SPY | ETF | 130.85 | 130.85 | 130.81 | 130.81 | 55100.0 |
| 2006-04-28 09:25:00 | SPY | ETF | 130.81 | 130.82 | 130.77 | 130.77 | 121000.0 |
| 2006-04-28 09:30:00 | SPY | ETF | 130.79 | 130.87 | 130.71 | 130.81 | 1169700.0 |
| 2006-04-28 09:35:00 | SPY | ETF | 130.81 | 131.02 | 130.81 | 130.88 | 1446600.0 |
| 2006-04-28 09:40:00 | SPY | ETF | 130.88 | 131.0 | 130.83 | 130.95 | 1923700.0 |
| 2006-04-28 09:45:00 | SPY | ETF | 130.93 | 130.99 | 130.82 | 130.85 | 1162500.0 |
| 2006-04-28 09:50:00 | SPY | ETF | 130.85 | 130.99 | 130.84 | 130.99 | 1097300.0 |
| 2006-04-28 09:55:00 | SPY | ETF | 130.99 | 131.01 | 130.92 | 130.92 | 520900.0 |
| 2006-04-28 10:00:00 | SPY | ETF | 130.92 | 131.25 | 130.91 | 131.18 | 1463600.0 |
| 2006-04-28 10:05:00 | SPY | ETF | 131.18 | 131.28 | 131.13 | 131.15 | 1034400.0 |
| 2006-04-28 10:10:00 | SPY | ETF | 131.15 | 131.45 | 131.1 | 131.45 | 983000.0 |
| 2006-04-28 10:15:00 | SPY | ETF | 131.45 | 131.75 | 131.44 | 131.6 | 2044300.0 |
| 2006-04-28 10:20:00 | SPY | ETF | 131.59 | 131.62 | 131.52 | 131.55 | 571200.0 |
| 2006-04-28 10:25:00 | SPY | ETF | 131.56 | 131.6 | 131.47 | 131.54 | 3746000.0 |
| 2006-04-28 10:30:00 | SPY | ETF | 131.55 | 131.56 | 131.35 | 131.41 | 967900.0 |
| 2006-04-28 10:35:00 | SPY | ETF | 131.41 | 131.45 | 131.37 | 131.45 | 536800.0 |
| 2006-04-28 10:40:00 | SPY | ETF | 131.45 | 131.51 | 131.29 | 131.31 | 519600.0 |
| 2006-04-28 10:45:00 | SPY | ETF | 131.3 | 131.43 | 131.29 | 131.43 | 1310500.0 |
| 2006-04-28 10:50:00 | SPY | ETF | 131.44 | 131.48 | 131.38 | 131.39 | 212200.0 |
| 2006-04-28 10:55:00 | SPY | ETF | 131.38 | 131.46 | 131.28 | 131.3 | 348600.0 |
| 2006-04-28 11:00:00 | SPY | ETF | 131.3 | 131.31 | 131.17 | 131.3 | 1048000.0 |
| 2006-04-28 11:05:00 | SPY | ETF | 131.31 | 131.43 | 131.28 | 131.33 | 557300.0 |
| 2006-04-28 11:10:00 | SPY | ETF | 131.34 | 131.45 | 131.34 | 131.4 | 477000.0 |
| 2006-04-28 11:15:00 | SPY | ETF | 131.41 | 131.5 | 131.35 | 131.3999 | 375400.0 |
| 2006-04-28 11:20:00 | SPY | ETF | 131.38 | 131.38 | 131.27 | 131.32 | 204300.0 |
| 2006-04-28 11:25:00 | SPY | ETF | 131.31 | 131.37 | 131.17 | 131.21 | 639100.0 |
> showing 50 of 9,315 rows — these rows as CSV