PREVIEW / etf_5min / 2008-10-23
file: by_date/etf_5min/2008/2008-10-23.parquet size: 564 KB rows: 26,691
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-23 04:10:00 | SPY | ETF | 92.3 | 92.3 | 92.3 | 92.3 | 100.0 |
| 2008-10-23 04:15:00 | SPY | ETF | 92.33 | 92.4 | 92.12 | 92.12 | 7600.0 |
| 2008-10-23 04:20:00 | SPY | ETF | 92.2 | 92.2 | 92.2 | 92.2 | 300.0 |
| 2008-10-23 04:25:00 | SPY | ETF | 92.3 | 92.3 | 92.3 | 92.3 | 185.0 |
| 2008-10-23 04:30:00 | SPY | ETF | 92.31 | 92.31 | 92.14 | 92.14 | 600.0 |
| 2008-10-23 04:35:00 | SPY | ETF | 92.07 | 92.07 | 91.95 | 91.95 | 700.0 |
| 2008-10-23 04:45:00 | SPY | ETF | 91.48 | 91.48 | 91.48 | 91.48 | 1000.0 |
| 2008-10-23 04:50:00 | SPY | ETF | 91.42 | 91.42 | 91.32 | 91.32 | 5100.0 |
| 2008-10-23 04:55:00 | SPY | ETF | 91.12 | 91.12 | 91.12 | 91.12 | 5000.0 |
| 2008-10-23 05:15:00 | SPY | ETF | 91.0 | 91.0 | 91.0 | 91.0 | 200.0 |
| 2008-10-23 05:20:00 | SPY | ETF | 90.8 | 90.8 | 90.8 | 90.8 | 160.0 |
| 2008-10-23 05:25:00 | SPY | ETF | 90.73 | 90.73 | 90.58 | 90.58 | 488.0 |
| 2008-10-23 05:30:00 | SPY | ETF | 90.42 | 90.43 | 90.41 | 90.43 | 3250.0 |
| 2008-10-23 05:35:00 | SPY | ETF | 90.29 | 90.29 | 89.95 | 89.95 | 864.0 |
| 2008-10-23 05:40:00 | SPY | ETF | 90.3 | 90.39 | 90.07 | 90.37 | 1740.0 |
| 2008-10-23 05:45:00 | SPY | ETF | 90.3 | 90.45 | 90.3 | 90.35 | 7800.0 |
| 2008-10-23 05:50:00 | SPY | ETF | 90.55 | 90.55 | 90.33 | 90.33 | 3600.0 |
| 2008-10-23 05:55:00 | SPY | ETF | 90.3 | 90.3 | 90.19 | 90.19 | 1800.0 |
| 2008-10-23 06:05:00 | SPY | ETF | 90.45 | 90.45 | 90.45 | 90.45 | 100.0 |
| 2008-10-23 06:10:00 | SPY | ETF | 90.57 | 90.59 | 90.52 | 90.55 | 15000.0 |
| 2008-10-23 06:15:00 | SPY | ETF | 90.55 | 90.62 | 90.47 | 90.6 | 13000.0 |
| 2008-10-23 06:20:00 | SPY | ETF | 90.98 | 91.06 | 90.98 | 91.06 | 2500.0 |
| 2008-10-23 06:25:00 | SPY | ETF | 90.89 | 90.89 | 90.75 | 90.75 | 5600.0 |
| 2008-10-23 06:30:00 | SPY | ETF | 90.67 | 90.85 | 90.67 | 90.85 | 200.0 |
| 2008-10-23 06:35:00 | SPY | ETF | 90.72 | 90.72 | 90.19 | 90.19 | 34000.0 |
| 2008-10-23 06:40:00 | SPY | ETF | 90.27 | 90.38 | 90.18 | 90.18 | 7700.0 |
| 2008-10-23 06:45:00 | SPY | ETF | 90.12 | 90.22 | 90.09 | 90.2 | 13100.0 |
| 2008-10-23 06:50:00 | SPY | ETF | 90.2 | 90.2 | 89.8 | 89.8 | 10606.0 |
| 2008-10-23 06:55:00 | SPY | ETF | 89.8 | 89.8 | 89.75 | 89.75 | 7200.0 |
| 2008-10-23 07:00:00 | SPY | ETF | 89.9 | 90.0 | 89.61 | 89.86 | 53700.0 |
| 2008-10-23 07:05:00 | SPY | ETF | 89.85 | 90.42 | 89.78 | 90.08 | 65413.0 |
| 2008-10-23 07:10:00 | SPY | ETF | 90.12 | 90.36 | 90.09 | 90.34 | 22300.0 |
| 2008-10-23 07:15:00 | SPY | ETF | 90.02 | 90.2 | 90.02 | 90.16 | 9231.0 |
| 2008-10-23 07:20:00 | SPY | ETF | 90.18 | 90.2 | 89.97 | 90.0 | 16231.0 |
| 2008-10-23 07:25:00 | SPY | ETF | 89.96 | 90.0 | 89.78 | 89.86 | 99659.0 |
| 2008-10-23 07:30:00 | SPY | ETF | 89.89 | 89.96 | 89.79 | 89.9 | 148170.0 |
| 2008-10-23 07:35:00 | SPY | ETF | 89.9 | 90.0 | 89.44 | 89.6 | 119526.0 |
| 2008-10-23 07:40:00 | SPY | ETF | 89.6 | 89.6 | 89.08 | 89.2 | 111904.0 |
| 2008-10-23 07:45:00 | SPY | ETF | 89.2 | 89.41 | 88.81 | 88.81 | 190500.0 |
| 2008-10-23 07:50:00 | SPY | ETF | 88.82 | 89.01 | 88.55 | 89.01 | 244235.0 |
| 2008-10-23 07:55:00 | SPY | ETF | 89.03 | 89.1 | 88.5 | 88.67 | 197381.0 |
| 2008-10-23 08:00:00 | SPY | ETF | 88.64 | 91.25 | 88.58 | 88.94 | 538134.0 |
| 2008-10-23 08:05:00 | SPY | ETF | 88.93 | 92.25 | 88.93 | 89.25 | 321920.0 |
| 2008-10-23 08:10:00 | SPY | ETF | 89.25 | 89.59 | 89.24 | 89.42 | 483869.0 |
| 2008-10-23 08:15:00 | SPY | ETF | 89.43 | 89.55 | 89.33 | 89.55 | 156778.0 |
| 2008-10-23 08:20:00 | SPY | ETF | 89.48 | 89.53 | 89.08 | 89.1 | 394796.0 |
| 2008-10-23 08:25:00 | SPY | ETF | 89.1 | 89.13 | 88.9 | 89.07 | 303059.0 |
| 2008-10-23 08:30:00 | SPY | ETF | 89.04 | 89.3 | 88.74 | 88.9 | 992448.0 |
| 2008-10-23 08:35:00 | SPY | ETF | 88.89 | 88.95 | 88.68 | 88.87 | 873841.0 |
| 2008-10-23 08:40:00 | SPY | ETF | 88.87 | 90.64 | 88.72 | 88.96 | 515462.0 |
> showing 50 of 26,691 rows — these rows as CSV