PREVIEW / etf_5min / 2006-09-29
file: by_date/etf_5min/2006/2006-09-29.parquet size: 217 KB rows: 10,899
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-29 07:35:00 | SPY | ETF | 133.93 | 133.93 | 133.93 | 133.93 | 1500.0 |
| 2006-09-29 07:45:00 | SPY | ETF | 133.92 | 133.92 | 133.9 | 133.9 | 1000.0 |
| 2006-09-29 07:50:00 | SPY | ETF | 133.91 | 133.91 | 133.91 | 133.91 | 2400.0 |
| 2006-09-29 07:55:00 | SPY | ETF | 133.92 | 133.92 | 133.92 | 133.92 | 1000.0 |
| 2006-09-29 08:00:00 | SPY | ETF | 133.93 | 133.96 | 133.87 | 133.95 | 70400.0 |
| 2006-09-29 08:05:00 | SPY | ETF | 133.94 | 133.98 | 133.94 | 133.95 | 59200.0 |
| 2006-09-29 08:10:00 | SPY | ETF | 133.96 | 133.96 | 133.93 | 133.93 | 22700.0 |
| 2006-09-29 08:15:00 | SPY | ETF | 133.93 | 133.97 | 133.93 | 133.97 | 3800.0 |
| 2006-09-29 08:20:00 | SPY | ETF | 133.96 | 133.96 | 133.94 | 133.94 | 56700.0 |
| 2006-09-29 08:25:00 | SPY | ETF | 133.95 | 133.97 | 133.92 | 133.93 | 142300.0 |
| 2006-09-29 08:30:00 | SPY | ETF | 133.92 | 133.95 | 133.79 | 133.91 | 605400.0 |
| 2006-09-29 08:35:00 | SPY | ETF | 133.89 | 133.9 | 133.82 | 133.89 | 14300.0 |
| 2006-09-29 08:40:00 | SPY | ETF | 133.9 | 133.94 | 133.89 | 133.94 | 18100.0 |
| 2006-09-29 08:45:00 | SPY | ETF | 133.94 | 134.06 | 133.94 | 133.99 | 41800.0 |
| 2006-09-29 08:50:00 | SPY | ETF | 133.96 | 134.0 | 133.96 | 134.0 | 33500.0 |
| 2006-09-29 08:55:00 | SPY | ETF | 133.98 | 134.0 | 133.97 | 133.98 | 54500.0 |
| 2006-09-29 09:00:00 | SPY | ETF | 133.96 | 134.0 | 133.96 | 134.0 | 65700.0 |
| 2006-09-29 09:05:00 | SPY | ETF | 134.0 | 134.02 | 133.97 | 133.98 | 53300.0 |
| 2006-09-29 09:10:00 | SPY | ETF | 133.98 | 133.98 | 133.92 | 133.92 | 294200.0 |
| 2006-09-29 09:15:00 | SPY | ETF | 133.92 | 133.92 | 133.88 | 133.88 | 901200.0 |
| 2006-09-29 09:20:00 | SPY | ETF | 133.87 | 133.88 | 133.85 | 133.85 | 3200.0 |
| 2006-09-29 09:25:00 | SPY | ETF | 133.85 | 133.88 | 133.79 | 133.79 | 32500.0 |
| 2006-09-29 09:30:00 | SPY | ETF | 133.8 | 133.88 | 133.77 | 133.83 | 768900.0 |
| 2006-09-29 09:35:00 | SPY | ETF | 133.83 | 133.85 | 133.75 | 133.85 | 337800.0 |
| 2006-09-29 09:40:00 | SPY | ETF | 133.86 | 133.9 | 133.75 | 133.77 | 618400.0 |
| 2006-09-29 09:45:00 | SPY | ETF | 133.78 | 133.79 | 133.67 | 133.7 | 493300.0 |
| 2006-09-29 09:50:00 | SPY | ETF | 133.7 | 133.75 | 133.6 | 133.66 | 940400.0 |
| 2006-09-29 09:55:00 | SPY | ETF | 133.65 | 133.81 | 133.62 | 133.7 | 967200.0 |
| 2006-09-29 10:00:00 | SPY | ETF | 133.71 | 133.93 | 133.7 | 133.85 | 2366700.0 |
| 2006-09-29 10:05:00 | SPY | ETF | 133.85 | 133.94 | 133.82 | 133.84 | 1224400.0 |
| 2006-09-29 10:10:00 | SPY | ETF | 133.82 | 133.83 | 133.7 | 133.82 | 879000.0 |
| 2006-09-29 10:15:00 | SPY | ETF | 133.82 | 133.88 | 133.77 | 133.86 | 731300.0 |
| 2006-09-29 10:20:00 | SPY | ETF | 133.86 | 133.87 | 133.71 | 133.73 | 615400.0 |
| 2006-09-29 10:25:00 | SPY | ETF | 133.74 | 133.81 | 133.72 | 133.78 | 410200.0 |
| 2006-09-29 10:30:00 | SPY | ETF | 133.77 | 133.82 | 133.71 | 133.79 | 424200.0 |
| 2006-09-29 10:35:00 | SPY | ETF | 133.78 | 133.84 | 133.68 | 133.69 | 576100.0 |
| 2006-09-29 10:40:00 | SPY | ETF | 133.69 | 133.77 | 133.67 | 133.73 | 604400.0 |
| 2006-09-29 10:45:00 | SPY | ETF | 133.72 | 133.78 | 133.71 | 133.73 | 331000.0 |
| 2006-09-29 10:50:00 | SPY | ETF | 133.73 | 133.73 | 133.65 | 133.72 | 614900.0 |
| 2006-09-29 10:55:00 | SPY | ETF | 133.72 | 133.79 | 133.72 | 133.77 | 1115800.0 |
| 2006-09-29 11:00:00 | SPY | ETF | 133.77 | 133.81 | 133.74 | 133.75 | 989000.0 |
| 2006-09-29 11:05:00 | SPY | ETF | 133.75 | 133.78 | 133.72 | 133.76 | 176600.0 |
| 2006-09-29 11:10:00 | SPY | ETF | 133.78 | 133.81 | 133.72 | 133.73 | 206500.0 |
| 2006-09-29 11:15:00 | SPY | ETF | 133.72 | 133.75 | 133.71 | 133.73 | 225400.0 |
| 2006-09-29 11:20:00 | SPY | ETF | 133.73 | 133.74 | 133.65 | 133.65 | 707700.0 |
| 2006-09-29 11:25:00 | SPY | ETF | 133.65 | 133.68 | 133.59 | 133.64 | 559000.0 |
| 2006-09-29 11:30:00 | SPY | ETF | 133.63 | 133.7 | 133.62 | 133.69 | 865800.0 |
| 2006-09-29 11:35:00 | SPY | ETF | 133.67 | 133.94 | 133.67 | 133.78 | 511100.0 |
| 2006-09-29 11:40:00 | SPY | ETF | 133.78 | 133.81 | 133.77 | 133.81 | 223200.0 |
| 2006-09-29 11:45:00 | SPY | ETF | 133.81 | 133.87 | 133.8 | 133.87 | 1265400.0 |
> showing 50 of 10,899 rows — these rows as CSV