PREVIEW / etf_5min / 2006-09-28
file: by_date/etf_5min/2006/2006-09-28.parquet size: 223 KB rows: 10,873
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-09-28 04:35:00 | SPY | ETF | 133.79 | 133.79 | 133.79 | 133.79 | 200.0 |
| 2006-09-28 06:40:00 | SPY | ETF | 133.89 | 133.89 | 133.89 | 133.89 | 300.0 |
| 2006-09-28 07:00:00 | SPY | ETF | 133.89 | 133.92 | 133.89 | 133.91 | 900.0 |
| 2006-09-28 07:30:00 | SPY | ETF | 133.86 | 133.86 | 133.86 | 133.86 | 4300.0 |
| 2006-09-28 07:50:00 | SPY | ETF | 133.85 | 133.87 | 133.83 | 133.87 | 10600.0 |
| 2006-09-28 07:55:00 | SPY | ETF | 133.87 | 133.88 | 133.87 | 133.87 | 8300.0 |
| 2006-09-28 08:00:00 | SPY | ETF | 133.85 | 133.87 | 133.81 | 133.86 | 106800.0 |
| 2006-09-28 08:05:00 | SPY | ETF | 133.85 | 133.85 | 133.82 | 133.85 | 23800.0 |
| 2006-09-28 08:10:00 | SPY | ETF | 133.85 | 133.87 | 133.83 | 133.83 | 166500.0 |
| 2006-09-28 08:15:00 | SPY | ETF | 133.83 | 133.86 | 133.83 | 133.86 | 10700.0 |
| 2006-09-28 08:20:00 | SPY | ETF | 133.86 | 133.87 | 133.86 | 133.87 | 13400.0 |
| 2006-09-28 08:25:00 | SPY | ETF | 133.86 | 133.87 | 133.85 | 133.86 | 16400.0 |
| 2006-09-28 08:30:00 | SPY | ETF | 133.83 | 133.85 | 133.52 | 133.7 | 463700.0 |
| 2006-09-28 08:35:00 | SPY | ETF | 133.73 | 133.81 | 133.73 | 133.74 | 74300.0 |
| 2006-09-28 08:40:00 | SPY | ETF | 133.73 | 133.75 | 133.72 | 133.74 | 9700.0 |
| 2006-09-28 08:45:00 | SPY | ETF | 133.76 | 133.78 | 133.76 | 133.76 | 10500.0 |
| 2006-09-28 08:50:00 | SPY | ETF | 133.75 | 133.75 | 133.73 | 133.73 | 10100.0 |
| 2006-09-28 08:55:00 | SPY | ETF | 133.73 | 133.75 | 133.73 | 133.75 | 10100.0 |
| 2006-09-28 09:00:00 | SPY | ETF | 133.76 | 133.81 | 133.75 | 133.81 | 47600.0 |
| 2006-09-28 09:05:00 | SPY | ETF | 133.81 | 133.81 | 133.75 | 133.75 | 2300.0 |
| 2006-09-28 09:10:00 | SPY | ETF | 133.76 | 133.77 | 133.76 | 133.77 | 17300.0 |
| 2006-09-28 09:15:00 | SPY | ETF | 133.76 | 133.76 | 133.74 | 133.74 | 24600.0 |
| 2006-09-28 09:20:00 | SPY | ETF | 133.74 | 133.78 | 133.73 | 133.73 | 23200.0 |
| 2006-09-28 09:25:00 | SPY | ETF | 133.72 | 133.78 | 133.72 | 133.77 | 16400.0 |
| 2006-09-28 09:30:00 | SPY | ETF | 133.74 | 133.88 | 133.72 | 133.85 | 1058500.0 |
| 2006-09-28 09:35:00 | SPY | ETF | 133.84 | 133.97 | 133.8 | 133.89 | 1810900.0 |
| 2006-09-28 09:40:00 | SPY | ETF | 133.89 | 133.94 | 133.74 | 133.76 | 1433500.0 |
| 2006-09-28 09:45:00 | SPY | ETF | 133.77 | 133.77 | 133.64 | 133.66 | 1586700.0 |
| 2006-09-28 09:50:00 | SPY | ETF | 133.66 | 133.66 | 133.5 | 133.64 | 1416700.0 |
| 2006-09-28 09:55:00 | SPY | ETF | 133.64 | 133.66 | 133.53 | 133.57 | 761600.0 |
| 2006-09-28 10:00:00 | SPY | ETF | 133.58 | 133.69 | 133.49 | 133.68 | 572000.0 |
| 2006-09-28 10:05:00 | SPY | ETF | 133.68 | 133.68 | 133.55 | 133.6 | 422300.0 |
| 2006-09-28 10:10:00 | SPY | ETF | 133.6 | 133.72 | 133.56 | 133.68 | 313300.0 |
| 2006-09-28 10:15:00 | SPY | ETF | 133.67 | 133.75 | 133.62 | 133.67 | 752200.0 |
| 2006-09-28 10:20:00 | SPY | ETF | 133.67 | 133.77 | 133.6 | 133.77 | 565500.0 |
| 2006-09-28 10:25:00 | SPY | ETF | 133.77 | 133.78 | 133.64 | 133.65 | 565400.0 |
| 2006-09-28 10:30:00 | SPY | ETF | 133.67 | 133.77 | 133.66 | 133.74 | 468600.0 |
| 2006-09-28 10:35:00 | SPY | ETF | 133.75 | 133.94 | 133.6 | 133.62 | 1309400.0 |
| 2006-09-28 10:40:00 | SPY | ETF | 133.63 | 133.75 | 133.53 | 133.55 | 825500.0 |
| 2006-09-28 10:45:00 | SPY | ETF | 133.56 | 133.57 | 133.45 | 133.46 | 741500.0 |
| 2006-09-28 10:50:00 | SPY | ETF | 133.46 | 133.48 | 133.4 | 133.44 | 2650600.0 |
| 2006-09-28 10:55:00 | SPY | ETF | 133.44 | 133.54 | 133.44 | 133.51 | 1433000.0 |
| 2006-09-28 11:00:00 | SPY | ETF | 133.5 | 133.95 | 133.45 | 133.55 | 715300.0 |
| 2006-09-28 11:05:00 | SPY | ETF | 133.56 | 133.62 | 133.54 | 133.59 | 1094100.0 |
| 2006-09-28 11:10:00 | SPY | ETF | 133.59 | 133.63 | 133.54 | 133.61 | 1554200.0 |
| 2006-09-28 11:15:00 | SPY | ETF | 133.62 | 133.65 | 133.59 | 133.63 | 791100.0 |
| 2006-09-28 11:20:00 | SPY | ETF | 133.63 | 133.69 | 133.63 | 133.67 | 563100.0 |
| 2006-09-28 11:25:00 | SPY | ETF | 133.66 | 133.66 | 133.58 | 133.63 | 345000.0 |
| 2006-09-28 11:30:00 | SPY | ETF | 133.62 | 133.65 | 133.59 | 133.62 | 269400.0 |
| 2006-09-28 11:35:00 | SPY | ETF | 133.63 | 133.67 | 133.6 | 133.61 | 1546000.0 |
> showing 50 of 10,873 rows — these rows as CSV