PREVIEW / etf_5min / 2008-05-05
file: by_date/etf_5min/2008/2008-05-05.parquet size: 429 KB rows: 21,114
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-05 04:15:00 | SPY | ETF | 141.0 | 141.0 | 141.0 | 141.0 | 1000.0 |
| 2008-05-05 05:25:00 | SPY | ETF | 140.94 | 140.94 | 140.94 | 140.94 | 400.0 |
| 2008-05-05 05:45:00 | SPY | ETF | 140.97 | 140.97 | 140.97 | 140.97 | 100.0 |
| 2008-05-05 06:05:00 | SPY | ETF | 140.88 | 140.88 | 140.8 | 140.8 | 75000.0 |
| 2008-05-05 06:10:00 | SPY | ETF | 140.85 | 140.85 | 140.85 | 140.85 | 1000.0 |
| 2008-05-05 07:00:00 | SPY | ETF | 140.83 | 140.86 | 140.83 | 140.86 | 27300.0 |
| 2008-05-05 07:05:00 | SPY | ETF | 140.83 | 140.85 | 140.83 | 140.85 | 3500.0 |
| 2008-05-05 07:10:00 | SPY | ETF | 140.85 | 140.88 | 140.83 | 140.86 | 24300.0 |
| 2008-05-05 07:15:00 | SPY | ETF | 140.83 | 140.85 | 140.81 | 140.83 | 93500.0 |
| 2008-05-05 07:20:00 | SPY | ETF | 140.83 | 140.88 | 140.83 | 140.88 | 61199.0 |
| 2008-05-05 07:25:00 | SPY | ETF | 140.88 | 140.9 | 140.84 | 140.9 | 58000.0 |
| 2008-05-05 07:30:00 | SPY | ETF | 140.94 | 140.95 | 140.9 | 140.94 | 147800.0 |
| 2008-05-05 07:35:00 | SPY | ETF | 141.01 | 141.02 | 140.97 | 140.97 | 17000.0 |
| 2008-05-05 07:40:00 | SPY | ETF | 141.0 | 141.04 | 141.0 | 141.04 | 23000.0 |
| 2008-05-05 07:45:00 | SPY | ETF | 141.05 | 141.05 | 140.95 | 140.95 | 19600.0 |
| 2008-05-05 07:50:00 | SPY | ETF | 140.97 | 141.0 | 140.92 | 140.92 | 32900.0 |
| 2008-05-05 07:55:00 | SPY | ETF | 140.96 | 140.96 | 140.94 | 140.94 | 900.0 |
| 2008-05-05 08:00:00 | SPY | ETF | 141.2 | 141.2 | 140.88 | 140.93 | 204619.0 |
| 2008-05-05 08:05:00 | SPY | ETF | 140.92 | 140.95 | 140.87 | 140.9 | 54242.0 |
| 2008-05-05 08:10:00 | SPY | ETF | 140.9 | 140.93 | 140.89 | 140.93 | 54169.0 |
| 2008-05-05 08:15:00 | SPY | ETF | 140.93 | 140.93 | 140.82 | 140.84 | 38381.0 |
| 2008-05-05 08:20:00 | SPY | ETF | 140.84 | 140.94 | 140.84 | 140.86 | 122588.0 |
| 2008-05-05 08:25:00 | SPY | ETF | 140.86 | 140.86 | 140.75 | 140.77 | 184696.0 |
| 2008-05-05 08:30:00 | SPY | ETF | 140.76 | 140.81 | 140.74 | 140.81 | 73284.0 |
| 2008-05-05 08:35:00 | SPY | ETF | 140.82 | 140.85 | 140.8 | 140.84 | 9150.0 |
| 2008-05-05 08:40:00 | SPY | ETF | 140.84 | 140.9 | 140.84 | 140.87 | 13431.0 |
| 2008-05-05 08:45:00 | SPY | ETF | 140.89 | 140.9 | 140.88 | 140.9 | 7371.0 |
| 2008-05-05 08:50:00 | SPY | ETF | 140.9 | 140.92 | 140.89 | 140.92 | 40707.0 |
| 2008-05-05 08:55:00 | SPY | ETF | 140.93 | 140.98 | 140.9 | 140.9 | 224463.0 |
| 2008-05-05 09:00:00 | SPY | ETF | 140.92 | 140.95 | 140.9 | 140.95 | 22198.0 |
| 2008-05-05 09:05:00 | SPY | ETF | 140.93 | 140.96 | 140.88 | 140.93 | 219035.0 |
| 2008-05-05 09:10:00 | SPY | ETF | 140.93 | 140.95 | 140.9 | 140.95 | 10546.0 |
| 2008-05-05 09:15:00 | SPY | ETF | 140.91 | 141.0 | 140.91 | 140.99 | 104663.0 |
| 2008-05-05 09:20:00 | SPY | ETF | 140.99 | 140.99 | 140.95 | 140.98 | 63335.0 |
| 2008-05-05 09:25:00 | SPY | ETF | 140.99 | 141.06 | 140.97 | 141.06 | 335411.0 |
| 2008-05-05 09:30:00 | SPY | ETF | 141.05 | 141.12 | 140.85 | 140.86 | 1893678.0 |
| 2008-05-05 09:35:00 | SPY | ETF | 140.85 | 141.0301 | 140.84 | 140.87 | 1816956.0 |
| 2008-05-05 09:40:00 | SPY | ETF | 140.87 | 141.0 | 140.78 | 140.94 | 1886221.0 |
| 2008-05-05 09:45:00 | SPY | ETF | 140.94 | 141.13 | 140.91 | 141.08 | 1563717.0 |
| 2008-05-05 09:50:00 | SPY | ETF | 141.0898 | 141.24 | 141.07 | 141.18 | 2246964.0 |
| 2008-05-05 09:55:00 | SPY | ETF | 141.18 | 141.35 | 141.14 | 141.2 | 1948300.0 |
| 2008-05-05 10:00:00 | SPY | ETF | 141.2 | 141.61 | 141.06 | 141.18 | 6717529.0 |
| 2008-05-05 10:05:00 | SPY | ETF | 141.18 | 141.55 | 141.16 | 141.54 | 3684035.0 |
| 2008-05-05 10:10:00 | SPY | ETF | 141.54 | 141.54 | 141.4 | 141.41 | 2035400.0 |
| 2008-05-05 10:15:00 | SPY | ETF | 141.4 | 141.41 | 141.06 | 141.12 | 3944705.0 |
| 2008-05-05 10:20:00 | SPY | ETF | 141.12 | 141.2 | 141.0 | 141.03 | 1834281.0 |
| 2008-05-05 10:25:00 | SPY | ETF | 141.02 | 141.05 | 140.81 | 140.84 | 2210993.0 |
| 2008-05-05 10:30:00 | SPY | ETF | 140.84 | 140.94 | 140.78 | 140.91 | 1695742.0 |
| 2008-05-05 10:35:00 | SPY | ETF | 140.91 | 140.97 | 140.87 | 140.89 | 847421.0 |
| 2008-05-05 10:40:00 | SPY | ETF | 140.89 | 141.03 | 140.81 | 140.99 | 1396041.0 |
> showing 50 of 21,114 rows — these rows as CSV