PREVIEW / etf_5min / 2009-05-11
file: by_date/etf_5min/2009/2009-05-11.parquet size: 687 KB rows: 30,548
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-05-11 04:15:00 | SPY | ETF | 91.89 | 91.96 | 91.89 | 91.96 | 3900.0 |
| 2009-05-11 04:20:00 | SPY | ETF | 91.86 | 91.86 | 91.86 | 91.86 | 300.0 |
| 2009-05-11 04:25:00 | SPY | ETF | 91.83 | 91.83 | 91.83 | 91.83 | 300.0 |
| 2009-05-11 04:35:00 | SPY | ETF | 91.7 | 91.7 | 91.66 | 91.66 | 500.0 |
| 2009-05-11 04:40:00 | SPY | ETF | 91.63 | 91.63 | 91.63 | 91.63 | 500.0 |
| 2009-05-11 04:45:00 | SPY | ETF | 91.69 | 91.69 | 91.69 | 91.69 | 200.0 |
| 2009-05-11 04:50:00 | SPY | ETF | 91.71 | 91.71 | 91.62 | 91.62 | 1400.0 |
| 2009-05-11 04:55:00 | SPY | ETF | 91.71 | 91.79 | 91.71 | 91.79 | 400.0 |
| 2009-05-11 05:00:00 | SPY | ETF | 91.9 | 91.9 | 91.9 | 91.9 | 300.0 |
| 2009-05-11 05:05:00 | SPY | ETF | 91.82 | 91.82 | 91.82 | 91.82 | 200.0 |
| 2009-05-11 05:15:00 | SPY | ETF | 91.85 | 91.85 | 91.85 | 91.85 | 100.0 |
| 2009-05-11 05:20:00 | SPY | ETF | 91.88 | 91.89 | 91.88 | 91.89 | 18000.0 |
| 2009-05-11 05:25:00 | SPY | ETF | 91.76 | 91.76 | 91.76 | 91.76 | 400.0 |
| 2009-05-11 05:30:00 | SPY | ETF | 91.72 | 91.72 | 91.72 | 91.72 | 200.0 |
| 2009-05-11 05:35:00 | SPY | ETF | 91.66 | 91.66 | 91.6 | 91.6 | 600.0 |
| 2009-05-11 05:50:00 | SPY | ETF | 91.74 | 91.75 | 91.74 | 91.75 | 2100.0 |
| 2009-05-11 05:55:00 | SPY | ETF | 91.72 | 91.72 | 91.72 | 91.72 | 1000.0 |
| 2009-05-11 06:00:00 | SPY | ETF | 91.63 | 91.64 | 91.63 | 91.64 | 1200.0 |
| 2009-05-11 06:05:00 | SPY | ETF | 91.73 | 91.78 | 91.7 | 91.75 | 9500.0 |
| 2009-05-11 06:10:00 | SPY | ETF | 91.8 | 91.83 | 91.8 | 91.81 | 11700.0 |
| 2009-05-11 06:15:00 | SPY | ETF | 91.85 | 91.85 | 91.85 | 91.85 | 100.0 |
| 2009-05-11 06:20:00 | SPY | ETF | 91.87 | 91.93 | 91.87 | 91.92 | 1200.0 |
| 2009-05-11 06:25:00 | SPY | ETF | 91.97 | 91.97 | 91.95 | 91.95 | 3500.0 |
| 2009-05-11 06:30:00 | SPY | ETF | 91.99 | 91.99 | 91.99 | 91.99 | 1000.0 |
| 2009-05-11 06:35:00 | SPY | ETF | 92.05 | 92.05 | 92.05 | 92.05 | 300.0 |
| 2009-05-11 06:40:00 | SPY | ETF | 91.95 | 91.95 | 91.9 | 91.9 | 5100.0 |
| 2009-05-11 06:45:00 | SPY | ETF | 91.84 | 92.03 | 91.84 | 92.03 | 5500.0 |
| 2009-05-11 06:50:00 | SPY | ETF | 92.0 | 92.0 | 91.99 | 91.99 | 6100.0 |
| 2009-05-11 06:55:00 | SPY | ETF | 91.99 | 92.03 | 91.99 | 92.0 | 7500.0 |
| 2009-05-11 07:00:00 | SPY | ETF | 91.97 | 92.04 | 91.87 | 92.02 | 174365.0 |
| 2009-05-11 07:05:00 | SPY | ETF | 92.02 | 92.02 | 91.89 | 91.89 | 10400.0 |
| 2009-05-11 07:10:00 | SPY | ETF | 91.89 | 91.9 | 91.86 | 91.86 | 6550.0 |
| 2009-05-11 07:15:00 | SPY | ETF | 91.86 | 91.92 | 91.85 | 91.9 | 9000.0 |
| 2009-05-11 07:20:00 | SPY | ETF | 91.9 | 91.95 | 91.88 | 91.95 | 5096.0 |
| 2009-05-11 07:25:00 | SPY | ETF | 91.9 | 91.9 | 91.84 | 91.87 | 12097.0 |
| 2009-05-11 07:30:00 | SPY | ETF | 91.86 | 91.88 | 91.84 | 91.85 | 39256.0 |
| 2009-05-11 07:35:00 | SPY | ETF | 91.87 | 91.91 | 91.85 | 91.91 | 56200.0 |
| 2009-05-11 07:40:00 | SPY | ETF | 91.91 | 91.94 | 91.82 | 91.85 | 66150.0 |
| 2009-05-11 07:45:00 | SPY | ETF | 91.86 | 92.03 | 91.86 | 92.0 | 80740.0 |
| 2009-05-11 07:50:00 | SPY | ETF | 91.99 | 91.99 | 91.8 | 91.81 | 169448.0 |
| 2009-05-11 07:55:00 | SPY | ETF | 91.8 | 91.82 | 91.73 | 91.77 | 132088.0 |
| 2009-05-11 08:00:00 | SPY | ETF | 91.78 | 91.85 | 91.77 | 91.85 | 59417.0 |
| 2009-05-11 08:05:00 | SPY | ETF | 91.85 | 91.9 | 91.83 | 91.86 | 27869.0 |
| 2009-05-11 08:10:00 | SPY | ETF | 91.86 | 91.88 | 91.69 | 91.72 | 172614.0 |
| 2009-05-11 08:15:00 | SPY | ETF | 91.72 | 91.72 | 91.56 | 91.59 | 275345.0 |
| 2009-05-11 08:20:00 | SPY | ETF | 91.58 | 91.65 | 91.55 | 91.6 | 408467.0 |
| 2009-05-11 08:25:00 | SPY | ETF | 91.6 | 91.66 | 91.51 | 91.62 | 152887.0 |
| 2009-05-11 08:30:00 | SPY | ETF | 91.61 | 91.67 | 91.58 | 91.67 | 151944.0 |
| 2009-05-11 08:35:00 | SPY | ETF | 91.68 | 91.75 | 91.63 | 91.7 | 320161.0 |
| 2009-05-11 08:40:00 | SPY | ETF | 91.71 | 91.79 | 91.7 | 91.79 | 99893.0 |
> showing 50 of 30,548 rows — these rows as CSV