PREVIEW / etf_5min / 2005-12-28
file: by_date/etf_5min/2005/2005-12-28.parquet size: 149 KB rows: 8,126
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-12-28 05:45:00 | SPY | ETF | 125.85 | 125.85 | 125.85 | 125.85 | 600.0 |
| 2005-12-28 07:00:00 | SPY | ETF | 125.89 | 125.89 | 125.89 | 125.89 | 7000.0 |
| 2005-12-28 07:10:00 | SPY | ETF | 125.89 | 125.92 | 125.89 | 125.91 | 19600.0 |
| 2005-12-28 07:15:00 | SPY | ETF | 125.92 | 125.92 | 125.9 | 125.9 | 12500.0 |
| 2005-12-28 07:20:00 | SPY | ETF | 125.89 | 125.89 | 125.89 | 125.89 | 25000.0 |
| 2005-12-28 07:25:00 | SPY | ETF | 125.89 | 125.89 | 125.89 | 125.89 | 600.0 |
| 2005-12-28 07:30:00 | SPY | ETF | 125.9 | 125.9 | 125.9 | 125.9 | 300.0 |
| 2005-12-28 07:40:00 | SPY | ETF | 125.88 | 125.88 | 125.88 | 125.88 | 200.0 |
| 2005-12-28 07:45:00 | SPY | ETF | 125.86 | 125.86 | 125.86 | 125.86 | 300.0 |
| 2005-12-28 07:50:00 | SPY | ETF | 125.86 | 125.87 | 125.86 | 125.87 | 5300.0 |
| 2005-12-28 08:00:00 | SPY | ETF | 125.84 | 125.91 | 125.84 | 125.86 | 13200.0 |
| 2005-12-28 08:05:00 | SPY | ETF | 125.86 | 125.87 | 125.86 | 125.87 | 7100.0 |
| 2005-12-28 08:10:00 | SPY | ETF | 125.84 | 125.85 | 125.84 | 125.85 | 5300.0 |
| 2005-12-28 08:15:00 | SPY | ETF | 125.86 | 125.89 | 125.81 | 125.81 | 209200.0 |
| 2005-12-28 08:20:00 | SPY | ETF | 125.83 | 125.84 | 125.83 | 125.84 | 3400.0 |
| 2005-12-28 08:25:00 | SPY | ETF | 125.84 | 125.84 | 125.82 | 125.82 | 1300.0 |
| 2005-12-28 08:30:00 | SPY | ETF | 125.82 | 125.84 | 125.82 | 125.84 | 9700.0 |
| 2005-12-28 08:35:00 | SPY | ETF | 125.84 | 125.85 | 125.84 | 125.84 | 700.0 |
| 2005-12-28 08:40:00 | SPY | ETF | 125.84 | 125.84 | 125.83 | 125.83 | 6200.0 |
| 2005-12-28 08:45:00 | SPY | ETF | 125.84 | 125.84 | 125.84 | 125.84 | 100.0 |
| 2005-12-28 08:50:00 | SPY | ETF | 125.82 | 125.84 | 125.77 | 125.82 | 61900.0 |
| 2005-12-28 08:55:00 | SPY | ETF | 125.79 | 125.82 | 125.79 | 125.8 | 101500.0 |
| 2005-12-28 09:00:00 | SPY | ETF | 125.79 | 125.8 | 125.78 | 125.78 | 2500.0 |
| 2005-12-28 09:05:00 | SPY | ETF | 125.78 | 125.78 | 125.75 | 125.75 | 85000.0 |
| 2005-12-28 09:10:00 | SPY | ETF | 125.76 | 125.77 | 125.76 | 125.77 | 11100.0 |
| 2005-12-28 09:15:00 | SPY | ETF | 125.76 | 125.8 | 125.76 | 125.78 | 71500.0 |
| 2005-12-28 09:20:00 | SPY | ETF | 125.77 | 125.77 | 125.77 | 125.77 | 500.0 |
| 2005-12-28 09:25:00 | SPY | ETF | 125.77 | 125.79 | 125.73 | 125.74 | 39900.0 |
| 2005-12-28 09:30:00 | SPY | ETF | 125.74 | 125.84 | 125.72 | 125.82 | 1002000.0 |
| 2005-12-28 09:35:00 | SPY | ETF | 125.79 | 125.85 | 125.77 | 125.81 | 487500.0 |
| 2005-12-28 09:40:00 | SPY | ETF | 125.8 | 125.85 | 125.74 | 125.79 | 370900.0 |
| 2005-12-28 09:45:00 | SPY | ETF | 125.79 | 125.79 | 125.63 | 125.68 | 553300.0 |
| 2005-12-28 09:50:00 | SPY | ETF | 125.68 | 125.76 | 125.65 | 125.76 | 371300.0 |
| 2005-12-28 09:55:00 | SPY | ETF | 125.77 | 125.8 | 125.73 | 125.77 | 345300.0 |
| 2005-12-28 10:00:00 | SPY | ETF | 125.77 | 125.95 | 125.76 | 125.87 | 786400.0 |
| 2005-12-28 10:05:00 | SPY | ETF | 125.87 | 125.93 | 125.83 | 125.84 | 421400.0 |
| 2005-12-28 10:10:00 | SPY | ETF | 125.84 | 125.86 | 125.75 | 125.83 | 390200.0 |
| 2005-12-28 10:15:00 | SPY | ETF | 125.83 | 125.89 | 125.8 | 125.82 | 696400.0 |
| 2005-12-28 10:20:00 | SPY | ETF | 125.79 | 125.85 | 125.79 | 125.82 | 259800.0 |
| 2005-12-28 10:25:00 | SPY | ETF | 125.82 | 125.82 | 125.69 | 125.73 | 572300.0 |
| 2005-12-28 10:30:00 | SPY | ETF | 125.73 | 125.79 | 125.67 | 125.69 | 282600.0 |
| 2005-12-28 10:35:00 | SPY | ETF | 125.69 | 125.72 | 125.58 | 125.59 | 587300.0 |
| 2005-12-28 10:40:00 | SPY | ETF | 125.59 | 125.65 | 125.53 | 125.54 | 738400.0 |
| 2005-12-28 10:45:00 | SPY | ETF | 125.54 | 125.59 | 125.5 | 125.53 | 884400.0 |
| 2005-12-28 10:50:00 | SPY | ETF | 125.53 | 125.63 | 125.52 | 125.62 | 416300.0 |
| 2005-12-28 10:55:00 | SPY | ETF | 125.61 | 125.64 | 125.6 | 125.62 | 712900.0 |
| 2005-12-28 11:00:00 | SPY | ETF | 125.62 | 125.75 | 125.62 | 125.72 | 323700.0 |
| 2005-12-28 11:05:00 | SPY | ETF | 125.72 | 125.76 | 125.68 | 125.7 | 268500.0 |
| 2005-12-28 11:10:00 | SPY | ETF | 125.68 | 125.72 | 125.65 | 125.7 | 136100.0 |
| 2005-12-28 11:15:00 | SPY | ETF | 125.71 | 125.71 | 125.65 | 125.7 | 271700.0 |
> showing 50 of 8,126 rows — these rows as CSV