PREVIEW / etf_5min / 2008-11-07
file: by_date/etf_5min/2008/2008-11-07.parquet size: 514 KB rows: 24,814
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-11-07 04:15:00 | SPY | ETF | 92.56 | 92.59 | 92.5 | 92.5 | 4300.0 |
| 2008-11-07 04:20:00 | SPY | ETF | 92.52 | 92.52 | 92.52 | 92.52 | 1000.0 |
| 2008-11-07 04:25:00 | SPY | ETF | 92.42 | 92.42 | 92.35 | 92.35 | 4800.0 |
| 2008-11-07 04:30:00 | SPY | ETF | 92.4 | 92.4 | 92.4 | 92.4 | 300.0 |
| 2008-11-07 04:35:00 | SPY | ETF | 92.29 | 92.29 | 92.29 | 92.29 | 100.0 |
| 2008-11-07 04:40:00 | SPY | ETF | 92.21 | 92.21 | 92.21 | 92.21 | 1000.0 |
| 2008-11-07 05:00:00 | SPY | ETF | 92.26 | 92.26 | 92.26 | 92.26 | 500.0 |
| 2008-11-07 05:05:00 | SPY | ETF | 92.23 | 92.23 | 92.23 | 92.23 | 100.0 |
| 2008-11-07 05:10:00 | SPY | ETF | 92.4 | 92.4 | 92.4 | 92.4 | 3000.0 |
| 2008-11-07 05:15:00 | SPY | ETF | 92.36 | 92.45 | 92.36 | 92.39 | 1600.0 |
| 2008-11-07 05:20:00 | SPY | ETF | 92.43 | 92.43 | 92.43 | 92.43 | 100.0 |
| 2008-11-07 05:35:00 | SPY | ETF | 92.51 | 92.58 | 92.51 | 92.58 | 300.0 |
| 2008-11-07 05:45:00 | SPY | ETF | 92.39 | 92.69 | 92.39 | 92.69 | 300.0 |
| 2008-11-07 05:50:00 | SPY | ETF | 92.66 | 92.66 | 92.58 | 92.64 | 3400.0 |
| 2008-11-07 06:00:00 | SPY | ETF | 92.6 | 92.6 | 92.6 | 92.6 | 200.0 |
| 2008-11-07 06:10:00 | SPY | ETF | 92.46 | 92.46 | 92.31 | 92.35 | 14300.0 |
| 2008-11-07 06:15:00 | SPY | ETF | 92.39 | 92.39 | 92.36 | 92.38 | 11500.0 |
| 2008-11-07 06:20:00 | SPY | ETF | 92.33 | 92.33 | 92.1 | 92.1 | 62700.0 |
| 2008-11-07 06:25:00 | SPY | ETF | 92.18 | 92.25 | 92.15 | 92.24 | 24900.0 |
| 2008-11-07 06:30:00 | SPY | ETF | 92.37 | 92.37 | 92.37 | 92.37 | 1000.0 |
| 2008-11-07 06:35:00 | SPY | ETF | 92.34 | 92.4 | 92.33 | 92.33 | 57000.0 |
| 2008-11-07 06:40:00 | SPY | ETF | 92.29 | 92.35 | 92.27 | 92.35 | 11210.0 |
| 2008-11-07 06:45:00 | SPY | ETF | 92.19 | 92.19 | 92.12 | 92.12 | 33997.0 |
| 2008-11-07 06:50:00 | SPY | ETF | 92.14 | 92.15 | 92.06 | 92.06 | 7100.0 |
| 2008-11-07 06:55:00 | SPY | ETF | 92.06 | 92.06 | 91.73 | 91.91 | 74000.0 |
| 2008-11-07 07:00:00 | SPY | ETF | 91.91 | 91.91 | 91.59 | 91.64 | 282618.0 |
| 2008-11-07 07:05:00 | SPY | ETF | 91.64 | 91.74 | 91.57 | 91.61 | 215299.0 |
| 2008-11-07 07:10:00 | SPY | ETF | 91.62 | 91.64 | 91.45 | 91.45 | 123445.0 |
| 2008-11-07 07:15:00 | SPY | ETF | 91.45 | 91.75 | 91.45 | 91.75 | 43519.0 |
| 2008-11-07 07:20:00 | SPY | ETF | 91.71 | 91.92 | 91.71 | 91.84 | 67910.0 |
| 2008-11-07 07:25:00 | SPY | ETF | 91.83 | 91.83 | 91.55 | 91.72 | 38480.0 |
| 2008-11-07 07:30:00 | SPY | ETF | 91.79 | 91.87 | 91.67 | 91.79 | 63712.0 |
| 2008-11-07 07:35:00 | SPY | ETF | 91.75 | 91.81 | 91.69 | 91.75 | 42100.0 |
| 2008-11-07 07:40:00 | SPY | ETF | 91.7 | 91.8 | 91.68 | 91.8 | 35300.0 |
| 2008-11-07 07:45:00 | SPY | ETF | 91.79 | 92.05 | 91.77 | 91.82 | 109288.0 |
| 2008-11-07 07:50:00 | SPY | ETF | 91.8 | 91.8 | 91.64 | 91.7 | 383677.0 |
| 2008-11-07 07:55:00 | SPY | ETF | 91.7 | 91.7 | 91.56 | 91.65 | 101850.0 |
| 2008-11-07 08:00:00 | SPY | ETF | 91.76 | 91.85 | 91.45 | 91.5 | 575988.0 |
| 2008-11-07 08:05:00 | SPY | ETF | 91.51 | 91.73 | 91.49 | 91.65 | 294828.0 |
| 2008-11-07 08:10:00 | SPY | ETF | 91.67 | 91.67 | 91.46 | 91.48 | 294945.0 |
| 2008-11-07 08:15:00 | SPY | ETF | 91.49 | 91.8 | 91.46 | 91.8 | 574133.0 |
| 2008-11-07 08:20:00 | SPY | ETF | 91.8 | 91.92 | 91.71 | 91.73 | 1173788.0 |
| 2008-11-07 08:25:00 | SPY | ETF | 91.74 | 92.75 | 91.67 | 91.93 | 675899.0 |
| 2008-11-07 08:30:00 | SPY | ETF | 91.68 | 91.83 | 90.81 | 91.16 | 5410968.0 |
| 2008-11-07 08:35:00 | SPY | ETF | 91.17 | 91.49 | 90.96 | 91.35 | 1868899.0 |
| 2008-11-07 08:40:00 | SPY | ETF | 91.32 | 91.83 | 91.22 | 91.76 | 1333567.0 |
| 2008-11-07 08:45:00 | SPY | ETF | 91.78 | 91.78 | 91.32 | 91.35 | 1172195.0 |
| 2008-11-07 08:50:00 | SPY | ETF | 91.35 | 91.4 | 90.87 | 91.0 | 1366473.0 |
| 2008-11-07 08:55:00 | SPY | ETF | 90.99 | 91.0 | 90.6 | 90.68 | 2357473.0 |
| 2008-11-07 09:00:00 | SPY | ETF | 90.69 | 90.86 | 90.5 | 90.77 | 1691785.0 |
> showing 50 of 24,814 rows — these rows as CSV