PREVIEW / etf_5min / 2009-09-21
file: by_date/etf_5min/2009/2009-09-21.parquet size: 676 KB rows: 29,650
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-21 04:15:00 | SPY | ETF | 105.92 | 105.94 | 105.89 | 105.94 | 9470.0 |
| 2009-09-21 04:30:00 | SPY | ETF | 106.07 | 106.09 | 106.07 | 106.07 | 600.0 |
| 2009-09-21 04:35:00 | SPY | ETF | 106.12 | 106.12 | 106.06 | 106.09 | 1150.0 |
| 2009-09-21 04:45:00 | SPY | ETF | 105.98 | 105.98 | 105.98 | 105.98 | 200.0 |
| 2009-09-21 04:50:00 | SPY | ETF | 105.9 | 105.9 | 105.88 | 105.88 | 800.0 |
| 2009-09-21 04:55:00 | SPY | ETF | 105.85 | 105.85 | 105.85 | 105.85 | 200.0 |
| 2009-09-21 05:00:00 | SPY | ETF | 105.85 | 105.85 | 105.82 | 105.82 | 768.0 |
| 2009-09-21 05:05:00 | SPY | ETF | 105.83 | 105.83 | 105.81 | 105.81 | 649.0 |
| 2009-09-21 05:15:00 | SPY | ETF | 105.87 | 105.87 | 105.87 | 105.87 | 500.0 |
| 2009-09-21 05:20:00 | SPY | ETF | 105.8 | 105.8 | 105.8 | 105.8 | 725.0 |
| 2009-09-21 05:30:00 | SPY | ETF | 105.79 | 105.79 | 105.77 | 105.77 | 1700.0 |
| 2009-09-21 05:35:00 | SPY | ETF | 105.75 | 105.75 | 105.73 | 105.73 | 600.0 |
| 2009-09-21 05:45:00 | SPY | ETF | 105.72 | 105.72 | 105.72 | 105.72 | 100.0 |
| 2009-09-21 05:50:00 | SPY | ETF | 105.75 | 105.75 | 105.75 | 105.75 | 4200.0 |
| 2009-09-21 06:05:00 | SPY | ETF | 105.82 | 105.88 | 105.82 | 105.88 | 1200.0 |
| 2009-09-21 06:10:00 | SPY | ETF | 105.8 | 105.81 | 105.8 | 105.81 | 600.0 |
| 2009-09-21 06:15:00 | SPY | ETF | 105.8 | 105.8 | 105.79 | 105.79 | 2700.0 |
| 2009-09-21 06:20:00 | SPY | ETF | 105.74 | 105.74 | 105.74 | 105.74 | 10000.0 |
| 2009-09-21 06:35:00 | SPY | ETF | 105.78 | 105.78 | 105.78 | 105.78 | 2500.0 |
| 2009-09-21 06:40:00 | SPY | ETF | 105.84 | 105.85 | 105.84 | 105.85 | 500.0 |
| 2009-09-21 06:45:00 | SPY | ETF | 105.94 | 105.94 | 105.94 | 105.94 | 2000.0 |
| 2009-09-21 06:50:00 | SPY | ETF | 105.95 | 105.95 | 105.91 | 105.91 | 8600.0 |
| 2009-09-21 06:55:00 | SPY | ETF | 105.91 | 105.93 | 105.91 | 105.91 | 1300.0 |
| 2009-09-21 07:00:00 | SPY | ETF | 105.9 | 106.01 | 105.9 | 105.98 | 153210.0 |
| 2009-09-21 07:05:00 | SPY | ETF | 106.03 | 106.03 | 105.97 | 105.99 | 10208.0 |
| 2009-09-21 07:10:00 | SPY | ETF | 105.99 | 105.99 | 105.92 | 105.93 | 18378.0 |
| 2009-09-21 07:15:00 | SPY | ETF | 105.96 | 105.96 | 105.91 | 105.91 | 28253.0 |
| 2009-09-21 07:20:00 | SPY | ETF | 105.85 | 105.87 | 105.84 | 105.87 | 34150.0 |
| 2009-09-21 07:25:00 | SPY | ETF | 105.87 | 105.91 | 105.84 | 105.91 | 34672.0 |
| 2009-09-21 07:30:00 | SPY | ETF | 105.9 | 106.0 | 105.9 | 105.97 | 3803.0 |
| 2009-09-21 07:35:00 | SPY | ETF | 105.98 | 106.01 | 105.98 | 105.98 | 8353.0 |
| 2009-09-21 07:40:00 | SPY | ETF | 105.96 | 106.0 | 105.96 | 106.0 | 9847.0 |
| 2009-09-21 07:45:00 | SPY | ETF | 106.03 | 106.05 | 106.01 | 106.02 | 63600.0 |
| 2009-09-21 07:50:00 | SPY | ETF | 106.03 | 106.03 | 105.97 | 105.97 | 49342.0 |
| 2009-09-21 07:55:00 | SPY | ETF | 105.97 | 105.97 | 105.88 | 105.88 | 66866.0 |
| 2009-09-21 08:00:00 | SPY | ETF | 105.9 | 106.85 | 105.85 | 105.89 | 99320.0 |
| 2009-09-21 08:05:00 | SPY | ETF | 105.91 | 105.98 | 105.9 | 105.94 | 197840.0 |
| 2009-09-21 08:10:00 | SPY | ETF | 105.94 | 105.97 | 105.94 | 105.94 | 42017.0 |
| 2009-09-21 08:15:00 | SPY | ETF | 105.93 | 105.97 | 105.76 | 105.77 | 356763.0 |
| 2009-09-21 08:20:00 | SPY | ETF | 105.78 | 105.78 | 105.63 | 105.64 | 278519.0 |
| 2009-09-21 08:25:00 | SPY | ETF | 105.65 | 105.8 | 105.65 | 105.8 | 445394.0 |
| 2009-09-21 08:30:00 | SPY | ETF | 105.8 | 105.8 | 105.69 | 105.77 | 175582.0 |
| 2009-09-21 08:35:00 | SPY | ETF | 105.77 | 105.85 | 105.75 | 105.85 | 123031.0 |
| 2009-09-21 08:40:00 | SPY | ETF | 105.85 | 106.25 | 105.83 | 105.85 | 317416.0 |
| 2009-09-21 08:45:00 | SPY | ETF | 105.85 | 105.88 | 105.78 | 105.85 | 486875.0 |
| 2009-09-21 08:50:00 | SPY | ETF | 105.86 | 105.89 | 105.81 | 105.86 | 144453.0 |
| 2009-09-21 08:55:00 | SPY | ETF | 105.86 | 105.88 | 105.84 | 105.87 | 43481.0 |
| 2009-09-21 09:00:00 | SPY | ETF | 105.87 | 105.87 | 105.79 | 105.8 | 130296.0 |
| 2009-09-21 09:05:00 | SPY | ETF | 105.8 | 105.8 | 105.72 | 105.78 | 169605.0 |
| 2009-09-21 09:10:00 | SPY | ETF | 105.78 | 105.82 | 105.78 | 105.79 | 75280.0 |
> showing 50 of 29,650 rows — these rows as CSV