PREVIEW / etf_5min / 2008-10-22
file: by_date/etf_5min/2008/2008-10-22.parquet size: 544 KB rows: 25,971
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-22 04:15:00 | SPY | ETF | 95.2 | 95.36 | 95.2 | 95.33 | 11600.0 |
| 2008-10-22 04:25:00 | SPY | ETF | 95.3 | 95.3 | 94.99 | 94.99 | 300.0 |
| 2008-10-22 04:35:00 | SPY | ETF | 94.93 | 94.97 | 94.93 | 94.97 | 2000.0 |
| 2008-10-22 04:40:00 | SPY | ETF | 94.88 | 94.88 | 94.88 | 94.88 | 1000.0 |
| 2008-10-22 04:50:00 | SPY | ETF | 94.7 | 94.7 | 94.7 | 94.7 | 1000.0 |
| 2008-10-22 04:55:00 | SPY | ETF | 94.66 | 94.66 | 94.55 | 94.55 | 1100.0 |
| 2008-10-22 05:05:00 | SPY | ETF | 94.7 | 94.7 | 94.7 | 94.7 | 1000.0 |
| 2008-10-22 05:10:00 | SPY | ETF | 94.68 | 94.73 | 94.63 | 94.73 | 400.0 |
| 2008-10-22 05:20:00 | SPY | ETF | 94.7 | 94.7 | 94.57 | 94.57 | 200.0 |
| 2008-10-22 05:25:00 | SPY | ETF | 94.33 | 94.33 | 94.26 | 94.26 | 3000.0 |
| 2008-10-22 05:30:00 | SPY | ETF | 94.38 | 94.38 | 94.38 | 94.38 | 100.0 |
| 2008-10-22 05:35:00 | SPY | ETF | 94.22 | 94.22 | 94.0 | 94.0 | 1200.0 |
| 2008-10-22 05:40:00 | SPY | ETF | 93.9 | 94.03 | 93.9 | 94.03 | 200.0 |
| 2008-10-22 05:45:00 | SPY | ETF | 94.0 | 94.0 | 94.0 | 94.0 | 100.0 |
| 2008-10-22 05:50:00 | SPY | ETF | 94.17 | 94.17 | 94.1 | 94.1 | 200.0 |
| 2008-10-22 06:00:00 | SPY | ETF | 94.37 | 94.38 | 94.3 | 94.3 | 2300.0 |
| 2008-10-22 06:05:00 | SPY | ETF | 94.4 | 94.55 | 94.4 | 94.55 | 2700.0 |
| 2008-10-22 06:10:00 | SPY | ETF | 94.5 | 94.55 | 94.5 | 94.5 | 2000.0 |
| 2008-10-22 06:15:00 | SPY | ETF | 94.35 | 94.43 | 94.35 | 94.43 | 200.0 |
| 2008-10-22 06:20:00 | SPY | ETF | 94.43 | 94.43 | 94.43 | 94.43 | 100.0 |
| 2008-10-22 06:25:00 | SPY | ETF | 94.4 | 94.4 | 94.3 | 94.3 | 1100.0 |
| 2008-10-22 06:30:00 | SPY | ETF | 94.47 | 94.47 | 94.47 | 94.47 | 100.0 |
| 2008-10-22 06:35:00 | SPY | ETF | 94.3 | 94.3 | 94.22 | 94.23 | 72599.0 |
| 2008-10-22 06:40:00 | SPY | ETF | 94.23 | 94.23 | 94.15 | 94.15 | 5350.0 |
| 2008-10-22 06:45:00 | SPY | ETF | 94.15 | 94.15 | 94.0 | 94.0 | 4900.0 |
| 2008-10-22 06:50:00 | SPY | ETF | 93.97 | 94.15 | 93.88 | 94.0 | 17200.0 |
| 2008-10-22 06:55:00 | SPY | ETF | 94.0 | 94.0 | 93.7 | 93.7 | 92600.0 |
| 2008-10-22 07:00:00 | SPY | ETF | 93.7 | 93.8 | 93.5 | 93.54 | 154820.0 |
| 2008-10-22 07:05:00 | SPY | ETF | 93.53 | 93.68 | 93.53 | 93.58 | 58200.0 |
| 2008-10-22 07:10:00 | SPY | ETF | 93.6 | 93.6 | 93.5 | 93.5 | 20610.0 |
| 2008-10-22 07:15:00 | SPY | ETF | 93.51 | 93.57 | 93.21 | 93.26 | 78661.0 |
| 2008-10-22 07:20:00 | SPY | ETF | 93.2 | 93.2 | 92.8 | 92.85 | 210109.0 |
| 2008-10-22 07:25:00 | SPY | ETF | 92.9 | 93.09 | 92.79 | 93.05 | 101541.0 |
| 2008-10-22 07:30:00 | SPY | ETF | 93.05 | 93.21 | 93.04 | 93.2 | 43647.0 |
| 2008-10-22 07:35:00 | SPY | ETF | 93.1 | 93.3 | 93.1 | 93.28 | 127750.0 |
| 2008-10-22 07:40:00 | SPY | ETF | 93.32 | 93.55 | 93.3 | 93.5 | 259474.0 |
| 2008-10-22 07:45:00 | SPY | ETF | 93.53 | 93.55 | 93.42 | 93.44 | 182817.0 |
| 2008-10-22 07:50:00 | SPY | ETF | 93.42 | 93.48 | 93.4 | 93.44 | 156482.0 |
| 2008-10-22 07:55:00 | SPY | ETF | 93.44 | 93.76 | 93.44 | 93.7 | 378956.0 |
| 2008-10-22 08:00:00 | SPY | ETF | 93.68 | 96.85 | 93.38 | 93.41 | 1306766.0 |
| 2008-10-22 08:05:00 | SPY | ETF | 93.47 | 93.61 | 93.24 | 93.29 | 519376.0 |
| 2008-10-22 08:10:00 | SPY | ETF | 93.28 | 93.37 | 92.92 | 92.97 | 2056010.0 |
| 2008-10-22 08:15:00 | SPY | ETF | 92.98 | 93.33 | 92.96 | 93.18 | 586462.0 |
| 2008-10-22 08:20:00 | SPY | ETF | 93.18 | 94.8 | 93.1 | 93.2 | 379604.0 |
| 2008-10-22 08:25:00 | SPY | ETF | 93.2 | 93.6 | 93.15 | 93.22 | 228489.0 |
| 2008-10-22 08:30:00 | SPY | ETF | 93.22 | 93.51 | 92.94 | 93.45 | 466444.0 |
| 2008-10-22 08:35:00 | SPY | ETF | 93.45 | 93.48 | 93.32 | 93.39 | 553913.0 |
| 2008-10-22 08:40:00 | SPY | ETF | 93.4 | 93.41 | 93.31 | 93.36 | 650772.0 |
| 2008-10-22 08:45:00 | SPY | ETF | 93.34 | 93.34 | 92.95 | 93.14 | 466289.0 |
| 2008-10-22 08:50:00 | SPY | ETF | 93.12 | 93.13 | 92.61 | 92.66 | 676860.0 |
> showing 50 of 25,971 rows — these rows as CSV