PREVIEW / etf_5min / 2008-10-02
file: by_date/etf_5min/2008/2008-10-02.parquet size: 548 KB rows: 25,217
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-10-02 05:15:00 | SPY | ETF | 115.8 | 115.8 | 115.8 | 115.8 | 200.0 |
| 2008-10-02 05:20:00 | SPY | ETF | 115.76 | 115.76 | 115.76 | 115.76 | 2000.0 |
| 2008-10-02 05:45:00 | SPY | ETF | 115.88 | 115.98 | 115.88 | 115.98 | 970.0 |
| 2008-10-02 06:00:00 | SPY | ETF | 115.88 | 115.88 | 115.88 | 115.88 | 400.0 |
| 2008-10-02 06:05:00 | SPY | ETF | 115.84 | 115.84 | 115.84 | 115.84 | 1000.0 |
| 2008-10-02 06:10:00 | SPY | ETF | 115.91 | 115.96 | 115.91 | 115.96 | 2100.0 |
| 2008-10-02 06:20:00 | SPY | ETF | 115.91 | 115.91 | 115.91 | 115.91 | 900.0 |
| 2008-10-02 06:25:00 | SPY | ETF | 115.9 | 116.1 | 115.9 | 115.95 | 26000.0 |
| 2008-10-02 06:35:00 | SPY | ETF | 115.77 | 115.77 | 115.77 | 115.77 | 100.0 |
| 2008-10-02 06:40:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 2600.0 |
| 2008-10-02 06:45:00 | SPY | ETF | 115.75 | 115.75 | 115.72 | 115.72 | 600.0 |
| 2008-10-02 06:50:00 | SPY | ETF | 115.72 | 115.72 | 115.65 | 115.65 | 3200.0 |
| 2008-10-02 06:55:00 | SPY | ETF | 115.74 | 115.87 | 115.74 | 115.87 | 5700.0 |
| 2008-10-02 07:00:00 | SPY | ETF | 115.84 | 115.87 | 115.8 | 115.8 | 15500.0 |
| 2008-10-02 07:05:00 | SPY | ETF | 115.79 | 115.88 | 115.79 | 115.88 | 15736.0 |
| 2008-10-02 07:10:00 | SPY | ETF | 115.8 | 115.8 | 115.7 | 115.7 | 13100.0 |
| 2008-10-02 07:15:00 | SPY | ETF | 115.65 | 115.66 | 115.6 | 115.6 | 44600.0 |
| 2008-10-02 07:20:00 | SPY | ETF | 115.57 | 115.57 | 115.48 | 115.55 | 45400.0 |
| 2008-10-02 07:25:00 | SPY | ETF | 115.58 | 115.58 | 115.53 | 115.58 | 21600.0 |
| 2008-10-02 07:30:00 | SPY | ETF | 115.56 | 115.71 | 115.56 | 115.65 | 67700.0 |
| 2008-10-02 07:35:00 | SPY | ETF | 115.69 | 115.71 | 115.62 | 115.7 | 179203.0 |
| 2008-10-02 07:40:00 | SPY | ETF | 115.7 | 115.78 | 115.66 | 115.75 | 75149.0 |
| 2008-10-02 07:45:00 | SPY | ETF | 115.7 | 115.7 | 115.18 | 115.26 | 176425.0 |
| 2008-10-02 07:50:00 | SPY | ETF | 115.25 | 115.25 | 115.05 | 115.16 | 177210.0 |
| 2008-10-02 07:55:00 | SPY | ETF | 115.16 | 115.19 | 115.09 | 115.09 | 135707.0 |
| 2008-10-02 08:00:00 | SPY | ETF | 115.12 | 115.77 | 115.09 | 115.24 | 783559.0 |
| 2008-10-02 08:05:00 | SPY | ETF | 115.25 | 115.39 | 115.25 | 115.31 | 71800.0 |
| 2008-10-02 08:10:00 | SPY | ETF | 115.15 | 116.45 | 115.15 | 115.32 | 554465.0 |
| 2008-10-02 08:15:00 | SPY | ETF | 115.32 | 115.36 | 114.74 | 115.26 | 400234.0 |
| 2008-10-02 08:20:00 | SPY | ETF | 115.27 | 115.35 | 115.14 | 115.16 | 97457.0 |
| 2008-10-02 08:25:00 | SPY | ETF | 115.15 | 115.16 | 115.04 | 115.04 | 177905.0 |
| 2008-10-02 08:30:00 | SPY | ETF | 115.05 | 115.15 | 114.63 | 114.76 | 906447.0 |
| 2008-10-02 08:35:00 | SPY | ETF | 114.76 | 115.04 | 114.74 | 115.0 | 524992.0 |
| 2008-10-02 08:40:00 | SPY | ETF | 114.98 | 115.17 | 114.97 | 115.11 | 255484.0 |
| 2008-10-02 08:45:00 | SPY | ETF | 115.12 | 115.17 | 114.88 | 115.14 | 251481.0 |
| 2008-10-02 08:50:00 | SPY | ETF | 115.11 | 115.18 | 114.92 | 114.95 | 636405.0 |
| 2008-10-02 08:55:00 | SPY | ETF | 114.96 | 114.97 | 114.91 | 114.95 | 322473.0 |
| 2008-10-02 09:00:00 | SPY | ETF | 114.95 | 115.18 | 114.91 | 115.16 | 162543.0 |
| 2008-10-02 09:05:00 | SPY | ETF | 115.16 | 115.22 | 115.07 | 115.09 | 121961.0 |
| 2008-10-02 09:10:00 | SPY | ETF | 115.1 | 115.11 | 114.98 | 115.09 | 119754.0 |
| 2008-10-02 09:15:00 | SPY | ETF | 115.08 | 115.22 | 115.05 | 115.2 | 157668.0 |
| 2008-10-02 09:20:00 | SPY | ETF | 115.18 | 115.26 | 114.89 | 114.96 | 413713.0 |
| 2008-10-02 09:25:00 | SPY | ETF | 114.95 | 115.1821 | 114.89 | 114.96 | 728100.0 |
| 2008-10-02 09:30:00 | SPY | ETF | 114.95 | 115.11 | 114.78 | 114.89 | 6002053.0 |
| 2008-10-02 09:35:00 | SPY | ETF | 114.889 | 114.89 | 114.54 | 114.54 | 4567236.0 |
| 2008-10-02 09:40:00 | SPY | ETF | 114.55 | 114.59 | 114.12 | 114.14 | 5649259.0 |
| 2008-10-02 09:45:00 | SPY | ETF | 114.14 | 114.33 | 113.97 | 114.25 | 9432791.0 |
| 2008-10-02 09:50:00 | SPY | ETF | 114.26 | 114.33 | 113.86 | 114.04 | 5501433.0 |
| 2008-10-02 09:55:00 | SPY | ETF | 114.0499 | 114.16 | 113.73 | 113.84 | 4226296.0 |
| 2008-10-02 10:00:00 | SPY | ETF | 113.84 | 113.84 | 113.55 | 113.6 | 5531422.0 |
> showing 50 of 25,217 rows — these rows as CSV