PREVIEW / etf_5min / 2008-10-13
file: by_date/etf_5min/2008/2008-10-13.parquet size: 590 KB rows: 27,883
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-13 04:10:00 | SPY | ETF | 94.13 | 94.13 | 94.13 | 94.13 | 100.0 |
| 2008-10-13 04:15:00 | SPY | ETF | 94.13 | 94.34 | 94.08 | 94.32 | 13570.0 |
| 2008-10-13 04:20:00 | SPY | ETF | 94.4 | 94.4 | 94.35 | 94.36 | 800.0 |
| 2008-10-13 04:25:00 | SPY | ETF | 94.48 | 94.48 | 94.33 | 94.33 | 300.0 |
| 2008-10-13 04:30:00 | SPY | ETF | 94.25 | 94.25 | 94.11 | 94.11 | 300.0 |
| 2008-10-13 04:35:00 | SPY | ETF | 94.11 | 94.11 | 93.97 | 93.97 | 600.0 |
| 2008-10-13 04:45:00 | SPY | ETF | 93.98 | 94.0 | 93.98 | 94.0 | 200.0 |
| 2008-10-13 04:50:00 | SPY | ETF | 94.05 | 94.05 | 94.05 | 94.05 | 100.0 |
| 2008-10-13 05:00:00 | SPY | ETF | 93.88 | 93.88 | 93.71 | 93.71 | 3100.0 |
| 2008-10-13 05:05:00 | SPY | ETF | 93.7 | 93.7 | 93.46 | 93.46 | 700.0 |
| 2008-10-13 05:10:00 | SPY | ETF | 93.4 | 93.4 | 93.4 | 93.4 | 100.0 |
| 2008-10-13 05:20:00 | SPY | ETF | 93.33 | 93.33 | 93.33 | 93.33 | 100.0 |
| 2008-10-13 05:25:00 | SPY | ETF | 93.2 | 93.2 | 93.2 | 93.2 | 200.0 |
| 2008-10-13 05:30:00 | SPY | ETF | 93.2 | 93.2 | 93.2 | 93.2 | 100.0 |
| 2008-10-13 05:35:00 | SPY | ETF | 93.35 | 93.35 | 93.35 | 93.35 | 1500.0 |
| 2008-10-13 05:40:00 | SPY | ETF | 93.38 | 93.38 | 93.38 | 93.38 | 100.0 |
| 2008-10-13 05:50:00 | SPY | ETF | 93.25 | 93.45 | 93.25 | 93.45 | 3500.0 |
| 2008-10-13 06:10:00 | SPY | ETF | 93.6 | 93.69 | 93.55 | 93.69 | 4600.0 |
| 2008-10-13 06:15:00 | SPY | ETF | 93.8 | 93.93 | 93.8 | 93.9 | 15700.0 |
| 2008-10-13 06:20:00 | SPY | ETF | 93.85 | 93.85 | 93.75 | 93.75 | 1400.0 |
| 2008-10-13 06:25:00 | SPY | ETF | 93.95 | 93.95 | 93.95 | 93.95 | 10000.0 |
| 2008-10-13 06:30:00 | SPY | ETF | 93.71 | 93.85 | 93.71 | 93.8 | 86100.0 |
| 2008-10-13 06:35:00 | SPY | ETF | 93.8 | 93.8 | 93.79 | 93.8 | 17000.0 |
| 2008-10-13 06:40:00 | SPY | ETF | 93.8 | 93.8 | 93.69 | 93.69 | 28000.0 |
| 2008-10-13 06:45:00 | SPY | ETF | 93.71 | 93.71 | 93.71 | 93.71 | 1500.0 |
| 2008-10-13 06:50:00 | SPY | ETF | 93.64 | 93.72 | 93.4 | 93.64 | 86600.0 |
| 2008-10-13 06:55:00 | SPY | ETF | 93.61 | 93.61 | 93.25 | 93.3 | 105300.0 |
| 2008-10-13 07:00:00 | SPY | ETF | 93.31 | 93.4 | 93.0 | 93.17 | 208845.0 |
| 2008-10-13 07:05:00 | SPY | ETF | 93.25 | 93.3 | 92.95 | 93.1 | 47494.0 |
| 2008-10-13 07:10:00 | SPY | ETF | 93.0 | 93.2 | 92.77 | 92.85 | 77026.0 |
| 2008-10-13 07:15:00 | SPY | ETF | 92.75 | 92.9 | 92.65 | 92.9 | 208100.0 |
| 2008-10-13 07:20:00 | SPY | ETF | 92.9 | 92.98 | 92.81 | 92.98 | 8500.0 |
| 2008-10-13 07:25:00 | SPY | ETF | 92.88 | 92.97 | 92.87 | 92.9 | 101250.0 |
| 2008-10-13 07:30:00 | SPY | ETF | 92.95 | 93.31 | 92.93 | 93.26 | 189524.0 |
| 2008-10-13 07:35:00 | SPY | ETF | 93.25 | 93.35 | 93.19 | 93.33 | 56724.0 |
| 2008-10-13 07:40:00 | SPY | ETF | 93.35 | 93.39 | 93.15 | 93.21 | 170022.0 |
| 2008-10-13 07:45:00 | SPY | ETF | 93.21 | 93.3 | 92.85 | 92.9 | 404788.0 |
| 2008-10-13 07:50:00 | SPY | ETF | 92.9 | 93.17 | 92.9 | 93.03 | 266483.0 |
| 2008-10-13 07:55:00 | SPY | ETF | 93.03 | 93.09 | 92.86 | 92.93 | 53278.0 |
| 2008-10-13 08:00:00 | SPY | ETF | 93.75 | 93.75 | 92.73 | 92.8 | 794070.0 |
| 2008-10-13 08:05:00 | SPY | ETF | 92.78 | 92.79 | 92.3 | 92.35 | 693783.0 |
| 2008-10-13 08:10:00 | SPY | ETF | 92.39 | 93.8 | 92.32 | 92.59 | 396814.0 |
| 2008-10-13 08:15:00 | SPY | ETF | 92.61 | 93.02 | 92.57 | 92.7 | 302781.0 |
| 2008-10-13 08:20:00 | SPY | ETF | 92.72 | 92.83 | 92.58 | 92.76 | 289219.0 |
| 2008-10-13 08:25:00 | SPY | ETF | 92.78 | 92.99 | 92.63 | 92.95 | 294849.0 |
| 2008-10-13 08:30:00 | SPY | ETF | 92.96 | 93.15 | 92.89 | 92.9 | 237589.0 |
| 2008-10-13 08:35:00 | SPY | ETF | 92.91 | 93.22 | 92.84 | 93.19 | 457970.0 |
| 2008-10-13 08:40:00 | SPY | ETF | 93.16 | 93.3 | 93.07 | 93.29 | 277178.0 |
| 2008-10-13 08:45:00 | SPY | ETF | 93.3 | 93.49 | 92.0 | 93.47 | 370426.0 |
| 2008-10-13 08:50:00 | SPY | ETF | 93.48 | 93.5 | 93.13 | 93.34 | 488005.0 |
> showing 50 of 27,883 rows — these rows as CSV