PREVIEW / etf_5min / 2008-10-28
file: by_date/etf_5min/2008/2008-10-28.parquet size: 557 KB rows: 26,348
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-28 04:15:00 | SPY | ETF | 87.71 | 87.96 | 87.61 | 87.61 | 3000.0 |
| 2008-10-28 04:20:00 | SPY | ETF | 87.66 | 87.66 | 87.55 | 87.55 | 500.0 |
| 2008-10-28 04:30:00 | SPY | ETF | 87.71 | 87.71 | 87.71 | 87.71 | 1000.0 |
| 2008-10-28 04:40:00 | SPY | ETF | 87.93 | 87.93 | 87.35 | 87.35 | 300.0 |
| 2008-10-28 04:50:00 | SPY | ETF | 87.01 | 87.01 | 87.0 | 87.0 | 600.0 |
| 2008-10-28 04:55:00 | SPY | ETF | 86.93 | 87.0 | 86.5 | 86.5 | 3200.0 |
| 2008-10-28 05:00:00 | SPY | ETF | 86.7 | 86.7 | 86.7 | 86.7 | 300.0 |
| 2008-10-28 05:05:00 | SPY | ETF | 86.83 | 86.83 | 86.83 | 86.83 | 100.0 |
| 2008-10-28 05:10:00 | SPY | ETF | 86.93 | 86.93 | 86.75 | 86.75 | 2100.0 |
| 2008-10-28 05:15:00 | SPY | ETF | 86.71 | 87.0 | 86.71 | 87.0 | 10200.0 |
| 2008-10-28 05:20:00 | SPY | ETF | 87.0 | 87.13 | 87.0 | 87.0 | 18800.0 |
| 2008-10-28 05:25:00 | SPY | ETF | 87.25 | 87.25 | 87.25 | 87.25 | 1000.0 |
| 2008-10-28 05:30:00 | SPY | ETF | 86.97 | 86.97 | 86.97 | 86.97 | 100.0 |
| 2008-10-28 05:35:00 | SPY | ETF | 86.71 | 86.78 | 86.71 | 86.78 | 200.0 |
| 2008-10-28 05:40:00 | SPY | ETF | 87.12 | 87.27 | 87.12 | 87.22 | 400.0 |
| 2008-10-28 05:45:00 | SPY | ETF | 87.3 | 87.3 | 87.3 | 87.3 | 37500.0 |
| 2008-10-28 05:50:00 | SPY | ETF | 87.03 | 87.15 | 87.03 | 87.15 | 4700.0 |
| 2008-10-28 05:55:00 | SPY | ETF | 87.15 | 87.15 | 87.01 | 87.15 | 23200.0 |
| 2008-10-28 06:00:00 | SPY | ETF | 87.09 | 87.2 | 86.95 | 87.2 | 34800.0 |
| 2008-10-28 06:05:00 | SPY | ETF | 87.2 | 87.3 | 87.14 | 87.14 | 35900.0 |
| 2008-10-28 06:10:00 | SPY | ETF | 87.14 | 87.25 | 87.0 | 87.05 | 169500.0 |
| 2008-10-28 06:15:00 | SPY | ETF | 87.05 | 87.15 | 87.0 | 87.15 | 15400.0 |
| 2008-10-28 06:20:00 | SPY | ETF | 87.17 | 87.19 | 87.0 | 87.04 | 95600.0 |
| 2008-10-28 06:25:00 | SPY | ETF | 87.12 | 87.15 | 87.08 | 87.15 | 15000.0 |
| 2008-10-28 06:30:00 | SPY | ETF | 87.05 | 87.08 | 87.05 | 87.06 | 5800.0 |
| 2008-10-28 06:35:00 | SPY | ETF | 87.1 | 87.1 | 86.73 | 86.73 | 20200.0 |
| 2008-10-28 06:40:00 | SPY | ETF | 86.86 | 86.86 | 86.7 | 86.7 | 9500.0 |
| 2008-10-28 06:45:00 | SPY | ETF | 86.7 | 86.77 | 86.7 | 86.75 | 6300.0 |
| 2008-10-28 06:50:00 | SPY | ETF | 86.8 | 86.88 | 86.74 | 86.88 | 20000.0 |
| 2008-10-28 06:55:00 | SPY | ETF | 87.0 | 87.08 | 86.75 | 86.95 | 46100.0 |
| 2008-10-28 07:00:00 | SPY | ETF | 86.88 | 87.26 | 86.84 | 87.09 | 142015.0 |
| 2008-10-28 07:05:00 | SPY | ETF | 87.1 | 87.3 | 87.09 | 87.29 | 192700.0 |
| 2008-10-28 07:10:00 | SPY | ETF | 87.24 | 87.5 | 87.22 | 87.3 | 172569.0 |
| 2008-10-28 07:15:00 | SPY | ETF | 87.29 | 87.6 | 87.23 | 87.6 | 139188.0 |
| 2008-10-28 07:20:00 | SPY | ETF | 87.55 | 87.64 | 87.25 | 87.6 | 148728.0 |
| 2008-10-28 07:25:00 | SPY | ETF | 87.55 | 87.6 | 87.29 | 87.31 | 83792.0 |
| 2008-10-28 07:30:00 | SPY | ETF | 87.3 | 87.38 | 87.1 | 87.26 | 59961.0 |
| 2008-10-28 07:35:00 | SPY | ETF | 87.3 | 87.5 | 87.22 | 87.49 | 221063.0 |
| 2008-10-28 07:40:00 | SPY | ETF | 87.49 | 88.0 | 87.49 | 87.95 | 386837.0 |
| 2008-10-28 07:45:00 | SPY | ETF | 87.91 | 88.04 | 87.9 | 87.99 | 476686.0 |
| 2008-10-28 07:50:00 | SPY | ETF | 87.95 | 87.99 | 87.64 | 87.67 | 153113.0 |
| 2008-10-28 07:55:00 | SPY | ETF | 87.7 | 87.87 | 87.66 | 87.78 | 161663.0 |
| 2008-10-28 08:00:00 | SPY | ETF | 87.78 | 87.81 | 84.0 | 87.69 | 420472.0 |
| 2008-10-28 08:05:00 | SPY | ETF | 87.7 | 87.91 | 87.25 | 87.28 | 362260.0 |
| 2008-10-28 08:10:00 | SPY | ETF | 87.28 | 87.67 | 87.18 | 87.63 | 327260.0 |
| 2008-10-28 08:15:00 | SPY | ETF | 87.65 | 87.71 | 87.52 | 87.62 | 305789.0 |
| 2008-10-28 08:20:00 | SPY | ETF | 87.64 | 87.64 | 87.55 | 87.61 | 230785.0 |
| 2008-10-28 08:25:00 | SPY | ETF | 87.58 | 87.6 | 87.39 | 87.54 | 184634.0 |
| 2008-10-28 08:30:00 | SPY | ETF | 87.5 | 87.57 | 87.23 | 87.25 | 428647.0 |
| 2008-10-28 08:35:00 | SPY | ETF | 87.24 | 87.33 | 87.06 | 87.07 | 284377.0 |
> showing 50 of 26,348 rows — these rows as CSV