PREVIEW / etf_5min / 2008-11-24
file: by_date/etf_5min/2008/2008-11-24.parquet size: 592 KB rows: 28,509
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-24 04:05:00 | SPY | ETF | 79.88 | 79.88 | 79.88 | 79.88 | 4000.0 |
| 2008-11-24 04:10:00 | SPY | ETF | 79.93 | 80.06 | 79.93 | 80.01 | 5100.0 |
| 2008-11-24 04:15:00 | SPY | ETF | 80.1 | 80.1 | 80.09 | 80.09 | 1400.0 |
| 2008-11-24 04:25:00 | SPY | ETF | 80.23 | 80.28 | 80.23 | 80.28 | 1600.0 |
| 2008-11-24 04:30:00 | SPY | ETF | 80.45 | 80.45 | 80.45 | 80.45 | 300.0 |
| 2008-11-24 04:40:00 | SPY | ETF | 80.85 | 80.85 | 80.85 | 80.85 | 1000.0 |
| 2008-11-24 04:55:00 | SPY | ETF | 80.78 | 80.93 | 80.78 | 80.88 | 9800.0 |
| 2008-11-24 05:00:00 | SPY | ETF | 80.88 | 80.9 | 80.75 | 80.75 | 1300.0 |
| 2008-11-24 05:05:00 | SPY | ETF | 80.86 | 81.05 | 80.82 | 81.05 | 16226.0 |
| 2008-11-24 05:10:00 | SPY | ETF | 81.1 | 81.16 | 81.1 | 81.12 | 900.0 |
| 2008-11-24 05:15:00 | SPY | ETF | 81.15 | 81.19 | 81.15 | 81.19 | 800.0 |
| 2008-11-24 05:20:00 | SPY | ETF | 81.09 | 81.2 | 81.07 | 81.12 | 2000.0 |
| 2008-11-24 05:25:00 | SPY | ETF | 81.15 | 81.15 | 81.09 | 81.09 | 300.0 |
| 2008-11-24 05:30:00 | SPY | ETF | 81.15 | 81.19 | 81.12 | 81.12 | 4700.0 |
| 2008-11-24 05:35:00 | SPY | ETF | 81.09 | 81.09 | 80.95 | 80.97 | 1500.0 |
| 2008-11-24 05:40:00 | SPY | ETF | 80.87 | 80.87 | 80.87 | 80.87 | 500.0 |
| 2008-11-24 05:45:00 | SPY | ETF | 80.93 | 80.93 | 80.87 | 80.87 | 5100.0 |
| 2008-11-24 05:50:00 | SPY | ETF | 80.86 | 80.92 | 80.86 | 80.92 | 6217.0 |
| 2008-11-24 05:55:00 | SPY | ETF | 80.77 | 80.77 | 80.75 | 80.75 | 3000.0 |
| 2008-11-24 06:00:00 | SPY | ETF | 80.82 | 80.84 | 80.82 | 80.84 | 5500.0 |
| 2008-11-24 06:05:00 | SPY | ETF | 80.9 | 81.01 | 80.9 | 81.01 | 600.0 |
| 2008-11-24 06:10:00 | SPY | ETF | 81.07 | 81.07 | 81.07 | 81.07 | 100.0 |
| 2008-11-24 06:15:00 | SPY | ETF | 81.15 | 81.44 | 81.14 | 81.42 | 9900.0 |
| 2008-11-24 06:20:00 | SPY | ETF | 81.51 | 81.58 | 81.45 | 81.51 | 400.0 |
| 2008-11-24 06:25:00 | SPY | ETF | 81.6 | 81.78 | 81.6 | 81.78 | 3400.0 |
| 2008-11-24 06:30:00 | SPY | ETF | 81.74 | 81.96 | 81.74 | 81.87 | 80600.0 |
| 2008-11-24 06:35:00 | SPY | ETF | 81.89 | 81.96 | 81.89 | 81.96 | 14000.0 |
| 2008-11-24 06:40:00 | SPY | ETF | 81.96 | 82.01 | 81.72 | 81.73 | 70600.0 |
| 2008-11-24 06:45:00 | SPY | ETF | 81.69 | 81.91 | 81.69 | 81.91 | 15900.0 |
| 2008-11-24 06:50:00 | SPY | ETF | 81.92 | 81.95 | 81.8 | 81.95 | 18200.0 |
| 2008-11-24 06:55:00 | SPY | ETF | 81.93 | 81.95 | 81.76 | 81.9 | 48600.0 |
| 2008-11-24 07:00:00 | SPY | ETF | 81.88 | 81.99 | 81.8 | 81.88 | 122847.0 |
| 2008-11-24 07:05:00 | SPY | ETF | 81.86 | 82.09 | 81.86 | 82.08 | 74942.0 |
| 2008-11-24 07:10:00 | SPY | ETF | 82.08 | 82.13 | 82.02 | 82.13 | 119496.0 |
| 2008-11-24 07:15:00 | SPY | ETF | 82.09 | 82.15 | 81.9 | 81.93 | 189678.0 |
| 2008-11-24 07:20:00 | SPY | ETF | 81.95 | 82.07 | 81.87 | 81.87 | 93500.0 |
| 2008-11-24 07:25:00 | SPY | ETF | 81.9 | 82.08 | 81.75 | 81.77 | 374030.0 |
| 2008-11-24 07:30:00 | SPY | ETF | 81.77 | 81.98 | 81.77 | 81.9 | 114531.0 |
| 2008-11-24 07:35:00 | SPY | ETF | 81.89 | 82.06 | 81.85 | 81.95 | 118188.0 |
| 2008-11-24 07:40:00 | SPY | ETF | 81.97 | 82.13 | 81.92 | 82.11 | 242399.0 |
| 2008-11-24 07:45:00 | SPY | ETF | 82.06 | 82.06 | 81.78 | 81.81 | 639034.0 |
| 2008-11-24 07:50:00 | SPY | ETF | 81.81 | 81.81 | 81.72 | 81.75 | 169273.0 |
| 2008-11-24 07:55:00 | SPY | ETF | 81.76 | 81.85 | 81.73 | 81.76 | 212403.0 |
| 2008-11-24 08:00:00 | SPY | ETF | 81.76 | 81.78 | 79.35 | 81.65 | 1229475.0 |
| 2008-11-24 08:05:00 | SPY | ETF | 81.65 | 81.78 | 81.6 | 81.7 | 174448.0 |
| 2008-11-24 08:10:00 | SPY | ETF | 81.7 | 81.81 | 81.67 | 81.76 | 243509.0 |
| 2008-11-24 08:15:00 | SPY | ETF | 81.77 | 81.8 | 81.6 | 81.6 | 279303.0 |
| 2008-11-24 08:20:00 | SPY | ETF | 81.6 | 81.83 | 81.59 | 81.77 | 428173.0 |
| 2008-11-24 08:25:00 | SPY | ETF | 81.77 | 81.79 | 81.48 | 81.49 | 387414.0 |
| 2008-11-24 08:30:00 | SPY | ETF | 81.5 | 81.57 | 81.47 | 81.48 | 283026.0 |
> showing 50 of 28,509 rows — these rows as CSV