PREVIEW / etf_5min / 2005-09-08
file: by_date/etf_5min/2005/2005-09-08.parquet size: 114 KB rows: 6,567
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-09-08 07:00:00 | SPY | ETF | 123.67 | 123.67 | 123.67 | 123.67 | 300.0 |
| 2005-09-08 07:05:00 | SPY | ETF | 123.68 | 123.68 | 123.67 | 123.67 | 200.0 |
| 2005-09-08 07:10:00 | SPY | ETF | 123.63 | 123.63 | 123.62 | 123.63 | 1300.0 |
| 2005-09-08 07:15:00 | SPY | ETF | 123.63 | 123.63 | 123.63 | 123.63 | 500.0 |
| 2005-09-08 07:20:00 | SPY | ETF | 123.64 | 123.64 | 123.6 | 123.6 | 700.0 |
| 2005-09-08 07:25:00 | SPY | ETF | 123.61 | 123.62 | 123.57 | 123.57 | 26200.0 |
| 2005-09-08 07:30:00 | SPY | ETF | 123.55 | 123.55 | 123.55 | 123.55 | 4900.0 |
| 2005-09-08 07:35:00 | SPY | ETF | 123.55 | 123.59 | 123.55 | 123.55 | 22300.0 |
| 2005-09-08 07:40:00 | SPY | ETF | 123.55 | 123.55 | 123.55 | 123.55 | 500.0 |
| 2005-09-08 07:50:00 | SPY | ETF | 123.55 | 123.55 | 123.55 | 123.55 | 800.0 |
| 2005-09-08 07:55:00 | SPY | ETF | 123.59 | 123.59 | 123.55 | 123.55 | 1800.0 |
| 2005-09-08 08:00:00 | SPY | ETF | 123.54 | 123.65 | 123.54 | 123.61 | 105900.0 |
| 2005-09-08 08:05:00 | SPY | ETF | 123.61 | 123.61 | 123.57 | 123.57 | 36500.0 |
| 2005-09-08 08:10:00 | SPY | ETF | 123.58 | 123.59 | 123.56 | 123.58 | 3800.0 |
| 2005-09-08 08:15:00 | SPY | ETF | 123.56 | 123.61 | 123.56 | 123.61 | 29300.0 |
| 2005-09-08 08:20:00 | SPY | ETF | 123.61 | 123.62 | 123.6 | 123.6 | 215000.0 |
| 2005-09-08 08:25:00 | SPY | ETF | 123.61 | 123.61 | 123.6 | 123.6 | 4500.0 |
| 2005-09-08 08:30:00 | SPY | ETF | 123.65 | 123.65 | 123.65 | 123.65 | 1500.0 |
| 2005-09-08 08:35:00 | SPY | ETF | 123.61 | 123.61 | 123.58 | 123.6 | 185300.0 |
| 2005-09-08 08:40:00 | SPY | ETF | 123.59 | 123.62 | 123.59 | 123.6 | 12600.0 |
| 2005-09-08 08:45:00 | SPY | ETF | 123.59 | 123.59 | 123.55 | 123.57 | 14900.0 |
| 2005-09-08 08:50:00 | SPY | ETF | 123.57 | 123.57 | 123.56 | 123.56 | 9800.0 |
| 2005-09-08 08:55:00 | SPY | ETF | 123.58 | 123.58 | 123.58 | 123.58 | 1000.0 |
| 2005-09-08 09:00:00 | SPY | ETF | 123.58 | 123.58 | 123.53 | 123.53 | 19700.0 |
| 2005-09-08 09:05:00 | SPY | ETF | 123.53 | 123.56 | 123.53 | 123.55 | 19100.0 |
| 2005-09-08 09:10:00 | SPY | ETF | 123.55 | 123.6 | 123.55 | 123.57 | 27000.0 |
| 2005-09-08 09:15:00 | SPY | ETF | 123.58 | 123.59 | 123.57 | 123.59 | 4900.0 |
| 2005-09-08 09:20:00 | SPY | ETF | 123.59 | 123.59 | 123.58 | 123.59 | 39700.0 |
| 2005-09-08 09:25:00 | SPY | ETF | 123.59 | 123.65 | 123.58 | 123.65 | 56100.0 |
| 2005-09-08 09:30:00 | SPY | ETF | 123.66 | 123.7 | 123.55 | 123.6 | 753200.0 |
| 2005-09-08 09:35:00 | SPY | ETF | 123.59 | 123.64 | 123.52 | 123.57 | 523500.0 |
| 2005-09-08 09:40:00 | SPY | ETF | 123.57 | 123.6 | 123.51 | 123.52 | 439800.0 |
| 2005-09-08 09:45:00 | SPY | ETF | 123.52 | 123.65 | 123.49 | 123.57 | 406900.0 |
| 2005-09-08 09:50:00 | SPY | ETF | 123.56 | 123.57 | 123.46 | 123.54 | 529800.0 |
| 2005-09-08 09:55:00 | SPY | ETF | 123.54 | 123.6 | 123.48 | 123.59 | 618200.0 |
| 2005-09-08 10:00:00 | SPY | ETF | 123.59 | 123.67 | 123.57 | 123.65 | 644100.0 |
| 2005-09-08 10:05:00 | SPY | ETF | 123.65 | 123.74 | 123.55 | 123.73 | 1174300.0 |
| 2005-09-08 10:10:00 | SPY | ETF | 123.73 | 123.77 | 123.66 | 123.75 | 580500.0 |
| 2005-09-08 10:15:00 | SPY | ETF | 123.75 | 123.79 | 123.67 | 123.69 | 464800.0 |
| 2005-09-08 10:20:00 | SPY | ETF | 123.68 | 123.72 | 123.61 | 123.66 | 597400.0 |
| 2005-09-08 10:25:00 | SPY | ETF | 123.66 | 123.7 | 123.63 | 123.68 | 473900.0 |
| 2005-09-08 10:30:00 | SPY | ETF | 123.68 | 123.87 | 123.64 | 123.81 | 1664400.0 |
| 2005-09-08 10:35:00 | SPY | ETF | 123.79 | 123.97 | 123.77 | 123.93 | 958100.0 |
| 2005-09-08 10:40:00 | SPY | ETF | 123.92 | 124.0 | 123.83 | 123.85 | 1357100.0 |
| 2005-09-08 10:45:00 | SPY | ETF | 123.85 | 123.85 | 123.72 | 123.75 | 497900.0 |
| 2005-09-08 10:50:00 | SPY | ETF | 123.73 | 123.77 | 123.6 | 123.65 | 894200.0 |
| 2005-09-08 10:55:00 | SPY | ETF | 123.65 | 123.7 | 123.58 | 123.68 | 602100.0 |
| 2005-09-08 11:00:00 | SPY | ETF | 123.68 | 123.75 | 123.62 | 123.67 | 264000.0 |
| 2005-09-08 11:05:00 | SPY | ETF | 123.67 | 123.78 | 123.66 | 123.7 | 215800.0 |
| 2005-09-08 11:10:00 | SPY | ETF | 123.7 | 123.77 | 123.63 | 123.66 | 466300.0 |
> showing 50 of 6,567 rows — these rows as CSV