PREVIEW / etf_5min / 2008-11-19
file: by_date/etf_5min/2008/2008-11-19.parquet size: 559 KB rows: 25,934
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-19 04:15:00 | SPY | ETF | 85.52 | 85.52 | 85.32 | 85.32 | 1400.0 |
| 2008-11-19 04:20:00 | SPY | ETF | 86.28 | 86.28 | 86.28 | 86.28 | 100.0 |
| 2008-11-19 04:25:00 | SPY | ETF | 86.24 | 86.24 | 86.24 | 86.24 | 100.0 |
| 2008-11-19 04:35:00 | SPY | ETF | 85.25 | 85.25 | 85.25 | 85.25 | 100.0 |
| 2008-11-19 05:00:00 | SPY | ETF | 85.66 | 85.66 | 85.66 | 85.66 | 600.0 |
| 2008-11-19 05:40:00 | SPY | ETF | 86.31 | 86.31 | 86.31 | 86.31 | 100.0 |
| 2008-11-19 05:45:00 | SPY | ETF | 85.62 | 85.62 | 85.62 | 85.62 | 100.0 |
| 2008-11-19 05:50:00 | SPY | ETF | 86.25 | 86.25 | 86.25 | 86.25 | 100.0 |
| 2008-11-19 06:10:00 | SPY | ETF | 85.99 | 85.99 | 85.99 | 85.99 | 100.0 |
| 2008-11-19 06:20:00 | SPY | ETF | 86.02 | 86.02 | 85.87 | 85.87 | 2900.0 |
| 2008-11-19 06:25:00 | SPY | ETF | 85.84 | 85.84 | 85.81 | 85.81 | 5100.0 |
| 2008-11-19 06:35:00 | SPY | ETF | 85.67 | 85.67 | 85.63 | 85.63 | 5100.0 |
| 2008-11-19 06:50:00 | SPY | ETF | 85.87 | 85.87 | 85.87 | 85.87 | 2500.0 |
| 2008-11-19 06:55:00 | SPY | ETF | 85.97 | 86.0 | 85.97 | 86.0 | 26000.0 |
| 2008-11-19 07:00:00 | SPY | ETF | 86.01 | 86.01 | 85.84 | 85.92 | 117150.0 |
| 2008-11-19 07:05:00 | SPY | ETF | 85.95 | 86.1 | 85.95 | 86.07 | 262342.0 |
| 2008-11-19 07:10:00 | SPY | ETF | 86.07 | 86.21 | 86.02 | 86.09 | 166758.0 |
| 2008-11-19 07:15:00 | SPY | ETF | 86.07 | 86.24 | 85.86 | 85.89 | 238125.0 |
| 2008-11-19 07:20:00 | SPY | ETF | 85.87 | 85.9 | 85.75 | 85.83 | 198272.0 |
| 2008-11-19 07:25:00 | SPY | ETF | 85.83 | 85.83 | 85.69 | 85.73 | 12421.0 |
| 2008-11-19 07:30:00 | SPY | ETF | 85.75 | 85.9 | 85.74 | 85.88 | 178269.0 |
| 2008-11-19 07:35:00 | SPY | ETF | 85.83 | 86.0 | 85.8 | 85.9 | 570294.0 |
| 2008-11-19 07:40:00 | SPY | ETF | 85.85 | 85.97 | 85.8 | 85.9 | 147677.0 |
| 2008-11-19 07:45:00 | SPY | ETF | 85.86 | 85.86 | 85.57 | 85.73 | 317086.0 |
| 2008-11-19 07:50:00 | SPY | ETF | 85.7 | 85.78 | 85.65 | 85.74 | 85548.0 |
| 2008-11-19 07:55:00 | SPY | ETF | 85.71 | 85.74 | 85.43 | 85.43 | 326233.0 |
| 2008-11-19 08:00:00 | SPY | ETF | 85.43 | 86.21 | 85.35 | 85.46 | 1276108.0 |
| 2008-11-19 08:05:00 | SPY | ETF | 85.48 | 85.7 | 85.46 | 85.62 | 137878.0 |
| 2008-11-19 08:10:00 | SPY | ETF | 85.63 | 85.72 | 85.52 | 85.58 | 104137.0 |
| 2008-11-19 08:15:00 | SPY | ETF | 85.58 | 85.58 | 85.21 | 85.4 | 470397.0 |
| 2008-11-19 08:20:00 | SPY | ETF | 85.4 | 87.08 | 85.33 | 85.51 | 170878.0 |
| 2008-11-19 08:25:00 | SPY | ETF | 85.5 | 85.68 | 85.49 | 85.61 | 435618.0 |
| 2008-11-19 08:30:00 | SPY | ETF | 85.7 | 85.98 | 85.56 | 85.73 | 842899.0 |
| 2008-11-19 08:35:00 | SPY | ETF | 85.74 | 85.74 | 85.47 | 85.49 | 296410.0 |
| 2008-11-19 08:40:00 | SPY | ETF | 85.47 | 85.66 | 85.4 | 85.6 | 387576.0 |
| 2008-11-19 08:45:00 | SPY | ETF | 85.61 | 85.65 | 85.07 | 85.09 | 456283.0 |
| 2008-11-19 08:50:00 | SPY | ETF | 85.08 | 85.24 | 84.93 | 85.24 | 1553757.0 |
| 2008-11-19 08:55:00 | SPY | ETF | 85.23 | 85.23 | 85.05 | 85.16 | 529519.0 |
| 2008-11-19 09:00:00 | SPY | ETF | 85.17 | 85.34 | 85.09 | 85.31 | 426534.0 |
| 2008-11-19 09:05:00 | SPY | ETF | 85.3 | 85.43 | 85.3 | 85.34 | 1252340.0 |
| 2008-11-19 09:10:00 | SPY | ETF | 85.34 | 85.87 | 85.34 | 85.84 | 621578.0 |
| 2008-11-19 09:15:00 | SPY | ETF | 85.84 | 85.85 | 85.63 | 85.8 | 602461.0 |
| 2008-11-19 09:20:00 | SPY | ETF | 85.82 | 86.07 | 85.7 | 85.87 | 1027062.0 |
| 2008-11-19 09:25:00 | SPY | ETF | 85.87 | 86.06 | 85.81 | 85.92 | 713079.0 |
| 2008-11-19 09:30:00 | SPY | ETF | 85.91 | 86.34 | 85.87 | 86.05 | 9562297.0 |
| 2008-11-19 09:35:00 | SPY | ETF | 86.05 | 86.71 | 85.83 | 86.61 | 9567589.0 |
| 2008-11-19 09:40:00 | SPY | ETF | 86.61 | 86.78 | 85.89 | 85.99 | 9143414.0 |
| 2008-11-19 09:45:00 | SPY | ETF | 85.99 | 86.19 | 85.66 | 85.97 | 6464623.0 |
| 2008-11-19 09:50:00 | SPY | ETF | 85.95 | 86.01 | 85.28 | 85.44 | 5858115.0 |
| 2008-11-19 09:55:00 | SPY | ETF | 85.44 | 85.63 | 85.25 | 85.59 | 6342980.0 |
> showing 50 of 25,934 rows — these rows as CSV