PREVIEW / etf_5min / 2009-01-12
file: by_date/etf_5min/2009/2009-01-12.parquet size: 635 KB rows: 26,554
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-01-12 04:20:00 | SPY | ETF | 88.85 | 88.85 | 88.85 | 88.85 | 1000.0 |
| 2009-01-12 05:00:00 | SPY | ETF | 88.67 | 88.67 | 88.67 | 88.67 | 1000.0 |
| 2009-01-12 05:10:00 | SPY | ETF | 88.76 | 88.76 | 88.76 | 88.76 | 1000.0 |
| 2009-01-12 05:20:00 | SPY | ETF | 88.74 | 88.74 | 88.74 | 88.74 | 100.0 |
| 2009-01-12 05:25:00 | SPY | ETF | 88.78 | 88.78 | 88.78 | 88.78 | 100.0 |
| 2009-01-12 05:40:00 | SPY | ETF | 88.61 | 88.61 | 88.61 | 88.61 | 100.0 |
| 2009-01-12 05:50:00 | SPY | ETF | 88.79 | 88.79 | 88.79 | 88.79 | 100.0 |
| 2009-01-12 06:05:00 | SPY | ETF | 88.74 | 88.74 | 88.74 | 88.74 | 10000.0 |
| 2009-01-12 06:10:00 | SPY | ETF | 88.85 | 88.85 | 88.85 | 88.85 | 500.0 |
| 2009-01-12 06:20:00 | SPY | ETF | 88.77 | 88.77 | 88.75 | 88.77 | 2000.0 |
| 2009-01-12 06:25:00 | SPY | ETF | 88.74 | 88.74 | 88.69 | 88.69 | 5000.0 |
| 2009-01-12 06:30:00 | SPY | ETF | 88.69 | 88.69 | 88.69 | 88.69 | 4000.0 |
| 2009-01-12 06:40:00 | SPY | ETF | 88.67 | 88.72 | 88.65 | 88.72 | 10000.0 |
| 2009-01-12 06:45:00 | SPY | ETF | 88.69 | 88.71 | 88.66 | 88.66 | 11200.0 |
| 2009-01-12 06:50:00 | SPY | ETF | 88.72 | 88.73 | 88.72 | 88.73 | 5500.0 |
| 2009-01-12 06:55:00 | SPY | ETF | 88.78 | 88.78 | 88.78 | 88.78 | 1000.0 |
| 2009-01-12 07:00:00 | SPY | ETF | 88.8 | 88.81 | 88.8 | 88.81 | 1499.0 |
| 2009-01-12 07:05:00 | SPY | ETF | 88.84 | 88.84 | 88.81 | 88.81 | 200.0 |
| 2009-01-12 07:10:00 | SPY | ETF | 88.84 | 88.85 | 88.83 | 88.85 | 2517.0 |
| 2009-01-12 07:15:00 | SPY | ETF | 88.86 | 88.88 | 88.86 | 88.87 | 5100.0 |
| 2009-01-12 07:20:00 | SPY | ETF | 88.88 | 88.92 | 88.88 | 88.91 | 5200.0 |
| 2009-01-12 07:25:00 | SPY | ETF | 88.92 | 88.92 | 88.79 | 88.92 | 66318.0 |
| 2009-01-12 07:30:00 | SPY | ETF | 88.87 | 88.87 | 88.82 | 88.82 | 1098.0 |
| 2009-01-12 07:35:00 | SPY | ETF | 88.79 | 88.8 | 88.76 | 88.76 | 12600.0 |
| 2009-01-12 07:40:00 | SPY | ETF | 88.76 | 88.81 | 88.76 | 88.78 | 11071.0 |
| 2009-01-12 07:45:00 | SPY | ETF | 88.75 | 88.78 | 88.74 | 88.78 | 17649.0 |
| 2009-01-12 07:50:00 | SPY | ETF | 88.8 | 88.82 | 88.77 | 88.77 | 8750.0 |
| 2009-01-12 07:55:00 | SPY | ETF | 88.76 | 88.8 | 88.67 | 88.67 | 65857.0 |
| 2009-01-12 08:00:00 | SPY | ETF | 88.69 | 88.7 | 88.64 | 88.65 | 98833.0 |
| 2009-01-12 08:05:00 | SPY | ETF | 88.67 | 88.67 | 88.56 | 88.59 | 134646.0 |
| 2009-01-12 08:10:00 | SPY | ETF | 88.59 | 88.65 | 88.59 | 88.62 | 60516.0 |
| 2009-01-12 08:15:00 | SPY | ETF | 88.62 | 88.65 | 88.6 | 88.65 | 7800.0 |
| 2009-01-12 08:20:00 | SPY | ETF | 88.66 | 88.69 | 88.64 | 88.65 | 20315.0 |
| 2009-01-12 08:25:00 | SPY | ETF | 88.65 | 88.7 | 88.6 | 88.69 | 75302.0 |
| 2009-01-12 08:30:00 | SPY | ETF | 88.68 | 88.75 | 88.67 | 88.72 | 95543.0 |
| 2009-01-12 08:35:00 | SPY | ETF | 88.72 | 88.86 | 88.7 | 88.72 | 78335.0 |
| 2009-01-12 08:40:00 | SPY | ETF | 88.72 | 88.77 | 88.7 | 88.74 | 137834.0 |
| 2009-01-12 08:45:00 | SPY | ETF | 88.73 | 88.85 | 88.73 | 88.82 | 110783.0 |
| 2009-01-12 08:50:00 | SPY | ETF | 88.83 | 88.84 | 88.72 | 88.72 | 79012.0 |
| 2009-01-12 08:55:00 | SPY | ETF | 88.71 | 88.75 | 88.66 | 88.75 | 129795.0 |
| 2009-01-12 09:00:00 | SPY | ETF | 88.75 | 88.77 | 88.64 | 88.69 | 106345.0 |
| 2009-01-12 09:05:00 | SPY | ETF | 88.7 | 88.75 | 88.69 | 88.71 | 92525.0 |
| 2009-01-12 09:10:00 | SPY | ETF | 88.7 | 88.78 | 88.68 | 88.78 | 95142.0 |
| 2009-01-12 09:15:00 | SPY | ETF | 88.77 | 88.85 | 88.77 | 88.8 | 151697.0 |
| 2009-01-12 09:20:00 | SPY | ETF | 88.8 | 88.83 | 88.77 | 88.83 | 62524.0 |
| 2009-01-12 09:25:00 | SPY | ETF | 88.82 | 88.86 | 88.8 | 88.81 | 278884.0 |
| 2009-01-12 09:30:00 | SPY | ETF | 88.84 | 88.91 | 88.58 | 88.62 | 4527767.0 |
| 2009-01-12 09:35:00 | SPY | ETF | 88.63 | 88.82 | 88.54 | 88.58 | 3647318.0 |
| 2009-01-12 09:40:00 | SPY | ETF | 88.58 | 88.67 | 88.16 | 88.21 | 6598819.0 |
| 2009-01-12 09:45:00 | SPY | ETF | 88.21 | 88.31 | 88.11 | 88.31 | 3919469.0 |
> showing 50 of 26,554 rows — these rows as CSV