PREVIEW / etf_5min / 2007-03-26
file: by_date/etf_5min/2007/2007-03-26.parquet size: 321 KB rows: 14,577
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-26 05:25:00 | SPY | ETF | 143.33 | 143.33 | 143.33 | 143.33 | 2200.0 |
| 2007-03-26 06:30:00 | SPY | ETF | 143.41 | 143.41 | 143.41 | 143.41 | 3000.0 |
| 2007-03-26 07:00:00 | SPY | ETF | 143.41 | 143.41 | 143.41 | 143.41 | 700.0 |
| 2007-03-26 07:05:00 | SPY | ETF | 143.35 | 143.41 | 143.35 | 143.4 | 5100.0 |
| 2007-03-26 07:10:00 | SPY | ETF | 143.46 | 143.46 | 143.46 | 143.46 | 1500.0 |
| 2007-03-26 07:15:00 | SPY | ETF | 143.46 | 143.48 | 143.46 | 143.48 | 25000.0 |
| 2007-03-26 07:20:00 | SPY | ETF | 143.5 | 143.51 | 143.48 | 143.48 | 12500.0 |
| 2007-03-26 07:25:00 | SPY | ETF | 143.48 | 143.48 | 143.48 | 143.48 | 2500.0 |
| 2007-03-26 07:30:00 | SPY | ETF | 143.46 | 143.51 | 143.46 | 143.51 | 16200.0 |
| 2007-03-26 07:35:00 | SPY | ETF | 143.51 | 143.55 | 143.5 | 143.55 | 17500.0 |
| 2007-03-26 07:40:00 | SPY | ETF | 143.47 | 143.47 | 143.47 | 143.47 | 7500.0 |
| 2007-03-26 07:45:00 | SPY | ETF | 143.48 | 143.5 | 143.48 | 143.5 | 2700.0 |
| 2007-03-26 07:55:00 | SPY | ETF | 143.47 | 143.48 | 143.45 | 143.45 | 4000.0 |
| 2007-03-26 08:00:00 | SPY | ETF | 143.45 | 143.46 | 143.43 | 143.46 | 1800.0 |
| 2007-03-26 08:05:00 | SPY | ETF | 143.46 | 143.46 | 143.42 | 143.44 | 8000.0 |
| 2007-03-26 08:10:00 | SPY | ETF | 143.42 | 143.42 | 143.42 | 143.42 | 700.0 |
| 2007-03-26 08:15:00 | SPY | ETF | 143.42 | 143.42 | 143.42 | 143.42 | 2000.0 |
| 2007-03-26 08:20:00 | SPY | ETF | 143.42 | 143.42 | 143.42 | 143.42 | 200.0 |
| 2007-03-26 08:25:00 | SPY | ETF | 143.43 | 143.43 | 143.43 | 143.43 | 26000.0 |
| 2007-03-26 08:30:00 | SPY | ETF | 143.43 | 143.44 | 143.43 | 143.43 | 24200.0 |
| 2007-03-26 08:35:00 | SPY | ETF | 143.43 | 143.43 | 143.41 | 143.41 | 15100.0 |
| 2007-03-26 08:40:00 | SPY | ETF | 143.42 | 143.42 | 143.4 | 143.4 | 3200.0 |
| 2007-03-26 08:45:00 | SPY | ETF | 143.4 | 143.43 | 143.4 | 143.42 | 46200.0 |
| 2007-03-26 08:50:00 | SPY | ETF | 143.43 | 143.43 | 143.42 | 143.43 | 4900.0 |
| 2007-03-26 08:55:00 | SPY | ETF | 143.43 | 143.45 | 143.43 | 143.45 | 7200.0 |
| 2007-03-26 09:00:00 | SPY | ETF | 143.46 | 143.5 | 143.46 | 143.5 | 42600.0 |
| 2007-03-26 09:05:00 | SPY | ETF | 143.49 | 143.49 | 143.47 | 143.47 | 8300.0 |
| 2007-03-26 09:10:00 | SPY | ETF | 143.47 | 143.48 | 143.46 | 143.46 | 17400.0 |
| 2007-03-26 09:15:00 | SPY | ETF | 143.44 | 143.44 | 143.39 | 143.4 | 21100.0 |
| 2007-03-26 09:20:00 | SPY | ETF | 143.42 | 143.46 | 143.42 | 143.46 | 59900.0 |
| 2007-03-26 09:25:00 | SPY | ETF | 143.45 | 143.52 | 143.45 | 143.51 | 188800.0 |
| 2007-03-26 09:30:00 | SPY | ETF | 143.5 | 143.53 | 143.29 | 143.33 | 1299600.0 |
| 2007-03-26 09:35:00 | SPY | ETF | 143.34 | 143.42 | 143.3 | 143.39 | 1105901.0 |
| 2007-03-26 09:40:00 | SPY | ETF | 143.38 | 143.42 | 143.25 | 143.35 | 1271900.0 |
| 2007-03-26 09:45:00 | SPY | ETF | 143.35 | 143.43 | 143.32 | 143.41 | 1256000.0 |
| 2007-03-26 09:50:00 | SPY | ETF | 143.42 | 143.46 | 143.36 | 143.41 | 709000.0 |
| 2007-03-26 09:55:00 | SPY | ETF | 143.41 | 143.5 | 143.4 | 143.49 | 625400.0 |
| 2007-03-26 10:00:00 | SPY | ETF | 143.48 | 143.49 | 142.8 | 142.94 | 8280877.0 |
| 2007-03-26 10:05:00 | SPY | ETF | 142.93 | 143.46 | 142.36 | 142.59 | 8738200.0 |
| 2007-03-26 10:10:00 | SPY | ETF | 142.58 | 143.49 | 142.43 | 142.65 | 7096711.0 |
| 2007-03-26 10:15:00 | SPY | ETF | 142.65 | 142.99 | 142.45 | 142.61 | 2815100.0 |
| 2007-03-26 10:20:00 | SPY | ETF | 142.6199 | 142.94 | 142.27 | 142.27 | 3413400.0 |
| 2007-03-26 10:25:00 | SPY | ETF | 142.27 | 142.55 | 142.18 | 142.18 | 4014075.0 |
| 2007-03-26 10:30:00 | SPY | ETF | 142.2 | 142.7 | 142.12 | 142.25 | 2994000.0 |
| 2007-03-26 10:35:00 | SPY | ETF | 142.24 | 142.69 | 142.24 | 142.36 | 1167820.0 |
| 2007-03-26 10:40:00 | SPY | ETF | 142.37 | 142.61 | 142.35 | 142.43 | 2675400.0 |
| 2007-03-26 10:45:00 | SPY | ETF | 142.43 | 142.59 | 142.36 | 142.47 | 2148913.0 |
| 2007-03-26 10:50:00 | SPY | ETF | 142.47 | 142.57 | 142.44 | 142.57 | 1577024.0 |
| 2007-03-26 10:55:00 | SPY | ETF | 142.57 | 142.57 | 142.47 | 142.5 | 792100.0 |
| 2007-03-26 11:00:00 | SPY | ETF | 142.5 | 142.53 | 142.09 | 142.25 | 1680300.0 |
> showing 50 of 14,577 rows — these rows as CSV