PREVIEW / etf_5min / 2005-05-26
file: by_date/etf_5min/2005/2005-05-26.parquet size: 106 KB rows: 5,978
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-05-26 06:50:00 | SPY | ETF | 119.8 | 119.8 | 119.8 | 119.8 | 500.0 |
| 2005-05-26 07:00:00 | SPY | ETF | 119.72 | 119.72 | 119.72 | 119.72 | 5000.0 |
| 2005-05-26 07:05:00 | SPY | ETF | 119.72 | 119.72 | 119.72 | 119.72 | 100.0 |
| 2005-05-26 07:15:00 | SPY | ETF | 119.78 | 119.78 | 119.77 | 119.77 | 5100.0 |
| 2005-05-26 07:55:00 | SPY | ETF | 119.78 | 119.78 | 119.78 | 119.78 | 500.0 |
| 2005-05-26 08:00:00 | SPY | ETF | 119.75 | 119.78 | 119.75 | 119.75 | 9900.0 |
| 2005-05-26 08:05:00 | SPY | ETF | 119.75 | 119.78 | 119.75 | 119.78 | 20200.0 |
| 2005-05-26 08:10:00 | SPY | ETF | 119.75 | 119.75 | 119.75 | 119.75 | 1100.0 |
| 2005-05-26 08:15:00 | SPY | ETF | 119.72 | 119.72 | 119.72 | 119.72 | 2000.0 |
| 2005-05-26 08:20:00 | SPY | ETF | 119.76 | 119.84 | 119.76 | 119.84 | 11000.0 |
| 2005-05-26 08:25:00 | SPY | ETF | 119.88 | 119.92 | 119.86 | 119.9 | 67400.0 |
| 2005-05-26 08:30:00 | SPY | ETF | 119.85 | 119.92 | 119.83 | 119.9 | 122300.0 |
| 2005-05-26 08:35:00 | SPY | ETF | 119.9 | 119.92 | 119.82 | 119.82 | 42900.0 |
| 2005-05-26 08:40:00 | SPY | ETF | 119.82 | 119.91 | 119.8 | 119.91 | 39800.0 |
| 2005-05-26 08:45:00 | SPY | ETF | 119.88 | 119.89 | 119.86 | 119.86 | 9400.0 |
| 2005-05-26 08:50:00 | SPY | ETF | 119.88 | 119.88 | 119.88 | 119.88 | 1000.0 |
| 2005-05-26 08:55:00 | SPY | ETF | 119.86 | 119.86 | 119.83 | 119.83 | 11900.0 |
| 2005-05-26 09:00:00 | SPY | ETF | 119.87 | 119.9 | 119.87 | 119.88 | 12900.0 |
| 2005-05-26 09:05:00 | SPY | ETF | 119.88 | 119.89 | 119.87 | 119.88 | 6800.0 |
| 2005-05-26 09:10:00 | SPY | ETF | 119.87 | 119.89 | 119.86 | 119.86 | 34100.0 |
| 2005-05-26 09:15:00 | SPY | ETF | 119.84 | 119.85 | 119.83 | 119.85 | 9100.0 |
| 2005-05-26 09:20:00 | SPY | ETF | 119.85 | 119.85 | 119.83 | 119.85 | 2600.0 |
| 2005-05-26 09:25:00 | SPY | ETF | 119.84 | 119.84 | 119.78 | 119.78 | 14300.0 |
| 2005-05-26 09:30:00 | SPY | ETF | 119.79 | 119.79 | 119.68 | 119.73 | 1269200.0 |
| 2005-05-26 09:35:00 | SPY | ETF | 119.73 | 119.83 | 119.7 | 119.81 | 1527100.0 |
| 2005-05-26 09:40:00 | SPY | ETF | 119.82 | 119.87 | 119.73 | 119.75 | 1134200.0 |
| 2005-05-26 09:45:00 | SPY | ETF | 119.73 | 119.78 | 119.68 | 119.73 | 587900.0 |
| 2005-05-26 09:50:00 | SPY | ETF | 119.73 | 119.75 | 119.65 | 119.69 | 423700.0 |
| 2005-05-26 09:55:00 | SPY | ETF | 119.69 | 119.7 | 119.62 | 119.67 | 612500.0 |
| 2005-05-26 10:00:00 | SPY | ETF | 119.67 | 119.77 | 119.62 | 119.76 | 1005000.0 |
| 2005-05-26 10:05:00 | SPY | ETF | 119.75 | 119.85 | 119.7 | 119.85 | 663400.0 |
| 2005-05-26 10:10:00 | SPY | ETF | 119.84 | 119.89 | 119.8 | 119.83 | 890700.0 |
| 2005-05-26 10:15:00 | SPY | ETF | 119.83 | 120.04 | 119.82 | 120.01 | 2322100.0 |
| 2005-05-26 10:20:00 | SPY | ETF | 120.01 | 120.06 | 119.95 | 119.97 | 1181200.0 |
| 2005-05-26 10:25:00 | SPY | ETF | 119.97 | 120.06 | 119.97 | 120.01 | 612900.0 |
| 2005-05-26 10:30:00 | SPY | ETF | 120.0 | 120.1 | 119.98 | 120.06 | 1583900.0 |
| 2005-05-26 10:35:00 | SPY | ETF | 120.05 | 120.09 | 119.95 | 120.0 | 842700.0 |
| 2005-05-26 10:40:00 | SPY | ETF | 120.0 | 120.03 | 119.95 | 119.95 | 622600.0 |
| 2005-05-26 10:45:00 | SPY | ETF | 119.96 | 120.04 | 119.92 | 119.96 | 707700.0 |
| 2005-05-26 10:50:00 | SPY | ETF | 119.94 | 119.98 | 119.87 | 119.89 | 303000.0 |
| 2005-05-26 10:55:00 | SPY | ETF | 119.9 | 120.0 | 119.9 | 119.98 | 617900.0 |
| 2005-05-26 11:00:00 | SPY | ETF | 119.98 | 119.99 | 119.92 | 119.94 | 481400.0 |
| 2005-05-26 11:05:00 | SPY | ETF | 119.96 | 119.99 | 119.92 | 119.96 | 178700.0 |
| 2005-05-26 11:10:00 | SPY | ETF | 119.96 | 120.0 | 119.85 | 119.97 | 378200.0 |
| 2005-05-26 11:15:00 | SPY | ETF | 119.96 | 120.03 | 119.93 | 120.01 | 500800.0 |
| 2005-05-26 11:20:00 | SPY | ETF | 120.02 | 120.04 | 119.95 | 119.97 | 806500.0 |
| 2005-05-26 11:25:00 | SPY | ETF | 119.95 | 120.0 | 119.94 | 120.0 | 299200.0 |
| 2005-05-26 11:30:00 | SPY | ETF | 120.0 | 120.02 | 119.92 | 119.93 | 243300.0 |
| 2005-05-26 11:35:00 | SPY | ETF | 119.93 | 120.02 | 119.92 | 120.02 | 325300.0 |
| 2005-05-26 11:40:00 | SPY | ETF | 120.02 | 120.04 | 119.9 | 119.91 | 338200.0 |
> showing 50 of 5,978 rows — these rows as CSV