PREVIEW / etf_5min / 2006-04-19
file: by_date/etf_5min/2006/2006-04-19.parquet size: 193 KB rows: 9,767
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-19 06:35:00 | SPY | ETF | 131.14 | 131.14 | 131.14 | 131.14 | 16400.0 |
| 2006-04-19 06:40:00 | SPY | ETF | 131.12 | 131.12 | 131.12 | 131.12 | 2000.0 |
| 2006-04-19 07:00:00 | SPY | ETF | 131.08 | 131.08 | 131.08 | 131.08 | 1000.0 |
| 2006-04-19 07:05:00 | SPY | ETF | 131.1 | 131.1 | 131.1 | 131.1 | 100.0 |
| 2006-04-19 07:10:00 | SPY | ETF | 131.16 | 131.16 | 131.16 | 131.16 | 4500.0 |
| 2006-04-19 07:15:00 | SPY | ETF | 131.15 | 131.2 | 131.15 | 131.2 | 4100.0 |
| 2006-04-19 07:20:00 | SPY | ETF | 131.13 | 131.13 | 131.12 | 131.12 | 25600.0 |
| 2006-04-19 07:30:00 | SPY | ETF | 131.15 | 131.15 | 131.15 | 131.15 | 10500.0 |
| 2006-04-19 07:35:00 | SPY | ETF | 131.15 | 131.16 | 131.15 | 131.16 | 17000.0 |
| 2006-04-19 07:40:00 | SPY | ETF | 131.19 | 131.21 | 131.17 | 131.18 | 6000.0 |
| 2006-04-19 07:45:00 | SPY | ETF | 131.18 | 131.21 | 131.18 | 131.2 | 31500.0 |
| 2006-04-19 07:50:00 | SPY | ETF | 131.19 | 131.19 | 131.19 | 131.19 | 100.0 |
| 2006-04-19 07:55:00 | SPY | ETF | 131.2 | 131.2 | 131.16 | 131.18 | 53400.0 |
| 2006-04-19 08:00:00 | SPY | ETF | 131.16 | 131.21 | 131.08 | 131.2 | 182800.0 |
| 2006-04-19 08:05:00 | SPY | ETF | 131.19 | 131.25 | 131.17 | 131.22 | 150100.0 |
| 2006-04-19 08:10:00 | SPY | ETF | 131.24 | 131.25 | 131.22 | 131.25 | 17800.0 |
| 2006-04-19 08:15:00 | SPY | ETF | 131.25 | 131.27 | 131.25 | 131.26 | 34900.0 |
| 2006-04-19 08:20:00 | SPY | ETF | 131.24 | 131.29 | 131.17 | 131.17 | 217100.0 |
| 2006-04-19 08:25:00 | SPY | ETF | 131.21 | 131.23 | 131.15 | 131.19 | 63600.0 |
| 2006-04-19 08:30:00 | SPY | ETF | 131.15 | 131.19 | 130.97 | 130.99 | 851700.0 |
| 2006-04-19 08:35:00 | SPY | ETF | 130.98 | 131.11 | 130.96 | 130.98 | 317000.0 |
| 2006-04-19 08:40:00 | SPY | ETF | 130.98 | 131.06 | 130.96 | 131.03 | 70500.0 |
| 2006-04-19 08:45:00 | SPY | ETF | 131.03 | 131.03 | 130.95 | 130.98 | 103900.0 |
| 2006-04-19 08:50:00 | SPY | ETF | 130.95 | 130.96 | 130.87 | 130.9 | 92000.0 |
| 2006-04-19 08:55:00 | SPY | ETF | 130.92 | 130.93 | 130.89 | 130.89 | 20700.0 |
| 2006-04-19 09:00:00 | SPY | ETF | 130.87 | 130.99 | 130.78 | 130.78 | 1489000.0 |
| 2006-04-19 09:05:00 | SPY | ETF | 130.76 | 130.81 | 130.75 | 130.8 | 181400.0 |
| 2006-04-19 09:10:00 | SPY | ETF | 130.8 | 130.8 | 130.75 | 130.75 | 117300.0 |
| 2006-04-19 09:15:00 | SPY | ETF | 130.73 | 130.81 | 130.73 | 130.8 | 212000.0 |
| 2006-04-19 09:20:00 | SPY | ETF | 130.8 | 130.81 | 130.74 | 130.77 | 69300.0 |
| 2006-04-19 09:25:00 | SPY | ETF | 130.77 | 130.82 | 130.71 | 130.74 | 108000.0 |
| 2006-04-19 09:30:00 | SPY | ETF | 130.72 | 130.78 | 130.64 | 130.7 | 2720200.0 |
| 2006-04-19 09:35:00 | SPY | ETF | 130.7 | 130.91 | 130.7 | 130.77 | 5318500.0 |
| 2006-04-19 09:40:00 | SPY | ETF | 130.78 | 130.85 | 130.76 | 130.77 | 1167900.0 |
| 2006-04-19 09:45:00 | SPY | ETF | 130.78 | 130.84 | 130.63 | 130.65 | 2244500.0 |
| 2006-04-19 09:50:00 | SPY | ETF | 130.65 | 130.83 | 130.62 | 130.79 | 754000.0 |
| 2006-04-19 09:55:00 | SPY | ETF | 130.83 | 130.91 | 130.79 | 130.83 | 1729400.0 |
| 2006-04-19 10:00:00 | SPY | ETF | 130.84 | 130.98 | 130.79 | 130.96 | 444900.0 |
| 2006-04-19 10:05:00 | SPY | ETF | 130.95 | 130.98 | 130.82 | 130.82 | 1146500.0 |
| 2006-04-19 10:10:00 | SPY | ETF | 130.82 | 130.82 | 130.51 | 130.52 | 3010600.0 |
| 2006-04-19 10:15:00 | SPY | ETF | 130.51 | 130.61 | 130.48 | 130.55 | 3841600.0 |
| 2006-04-19 10:20:00 | SPY | ETF | 130.55 | 130.55 | 130.4 | 130.5 | 2825400.0 |
| 2006-04-19 10:25:00 | SPY | ETF | 130.5 | 130.5 | 130.38 | 130.49 | 2245800.0 |
| 2006-04-19 10:30:00 | SPY | ETF | 130.49 | 130.82 | 130.24 | 130.38 | 3847700.0 |
| 2006-04-19 10:35:00 | SPY | ETF | 130.38 | 130.52 | 130.36 | 130.4 | 1845500.0 |
| 2006-04-19 10:40:00 | SPY | ETF | 130.39 | 130.61 | 130.32 | 130.59 | 4165800.0 |
| 2006-04-19 10:45:00 | SPY | ETF | 130.56 | 130.61 | 130.48 | 130.49 | 2118200.0 |
| 2006-04-19 10:50:00 | SPY | ETF | 130.4812 | 130.61 | 130.45 | 130.58 | 384000.0 |
| 2006-04-19 10:55:00 | SPY | ETF | 130.58 | 130.71 | 130.54 | 130.6 | 1556600.0 |
| 2006-04-19 11:00:00 | SPY | ETF | 130.6 | 130.76 | 130.58 | 130.76 | 398500.0 |
> showing 50 of 9,767 rows — these rows as CSV