PREVIEW / etf_5min / 2007-05-25
file: by_date/etf_5min/2007/2007-05-25.parquet size: 285 KB rows: 15,437
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-05-25 04:05:00 | SPY | ETF | 151.54 | 151.54 | 151.54 | 151.54 | 2000.0 |
| 2007-05-25 04:10:00 | SPY | ETF | 151.51 | 151.51 | 151.51 | 151.51 | 1000.0 |
| 2007-05-25 04:15:00 | SPY | ETF | 151.53 | 151.53 | 151.53 | 151.53 | 100.0 |
| 2007-05-25 04:30:00 | SPY | ETF | 151.48 | 151.48 | 151.48 | 151.48 | 1000.0 |
| 2007-05-25 04:45:00 | SPY | ETF | 151.41 | 151.41 | 151.41 | 151.41 | 1000.0 |
| 2007-05-25 04:50:00 | SPY | ETF | 151.3 | 151.3 | 151.3 | 151.3 | 1000.0 |
| 2007-05-25 06:30:00 | SPY | ETF | 151.55 | 151.55 | 151.55 | 151.55 | 10000.0 |
| 2007-05-25 06:35:00 | SPY | ETF | 151.55 | 151.55 | 151.55 | 151.55 | 15000.0 |
| 2007-05-25 06:55:00 | SPY | ETF | 151.44 | 151.45 | 151.44 | 151.45 | 5000.0 |
| 2007-05-25 07:00:00 | SPY | ETF | 151.43 | 151.45 | 151.41 | 151.41 | 7900.0 |
| 2007-05-25 07:05:00 | SPY | ETF | 151.41 | 151.44 | 151.41 | 151.41 | 7200.0 |
| 2007-05-25 07:10:00 | SPY | ETF | 151.42 | 151.44 | 151.42 | 151.44 | 7000.0 |
| 2007-05-25 07:15:00 | SPY | ETF | 151.45 | 151.45 | 151.41 | 151.41 | 5400.0 |
| 2007-05-25 07:20:00 | SPY | ETF | 151.44 | 151.48 | 151.44 | 151.48 | 3800.0 |
| 2007-05-25 07:25:00 | SPY | ETF | 151.5 | 151.54 | 151.5 | 151.53 | 7200.0 |
| 2007-05-25 07:30:00 | SPY | ETF | 151.53 | 151.6 | 151.53 | 151.6 | 23400.0 |
| 2007-05-25 07:35:00 | SPY | ETF | 151.55 | 151.58 | 151.55 | 151.58 | 25700.0 |
| 2007-05-25 07:40:00 | SPY | ETF | 151.58 | 151.58 | 151.55 | 151.57 | 17000.0 |
| 2007-05-25 07:45:00 | SPY | ETF | 151.57 | 151.61 | 151.56 | 151.56 | 24300.0 |
| 2007-05-25 07:50:00 | SPY | ETF | 151.52 | 151.57 | 151.52 | 151.57 | 21000.0 |
| 2007-05-25 07:55:00 | SPY | ETF | 151.59 | 151.6 | 151.59 | 151.6 | 7000.0 |
| 2007-05-25 08:00:00 | SPY | ETF | 151.55 | 151.64 | 151.55 | 151.64 | 1484500.0 |
| 2007-05-25 08:05:00 | SPY | ETF | 151.66 | 151.66 | 151.55 | 151.55 | 19300.0 |
| 2007-05-25 08:10:00 | SPY | ETF | 151.58 | 151.59 | 151.56 | 151.58 | 6900.0 |
| 2007-05-25 08:15:00 | SPY | ETF | 151.56 | 151.58 | 151.56 | 151.58 | 11900.0 |
| 2007-05-25 08:20:00 | SPY | ETF | 151.56 | 151.57 | 151.56 | 151.56 | 3300.0 |
| 2007-05-25 08:25:00 | SPY | ETF | 151.56 | 151.57 | 151.55 | 151.57 | 18800.0 |
| 2007-05-25 08:30:00 | SPY | ETF | 151.58 | 151.62 | 151.56 | 151.58 | 38500.0 |
| 2007-05-25 08:35:00 | SPY | ETF | 151.59 | 151.6 | 151.2 | 151.57 | 291100.0 |
| 2007-05-25 08:40:00 | SPY | ETF | 151.59 | 151.6 | 151.57 | 151.58 | 6500.0 |
| 2007-05-25 08:45:00 | SPY | ETF | 151.57 | 151.61 | 151.57 | 151.59 | 55000.0 |
| 2007-05-25 08:50:00 | SPY | ETF | 151.62 | 151.62 | 151.57 | 151.57 | 13200.0 |
| 2007-05-25 08:55:00 | SPY | ETF | 151.56 | 151.56 | 151.54 | 151.55 | 9700.0 |
| 2007-05-25 09:00:00 | SPY | ETF | 151.54 | 151.56 | 151.52 | 151.53 | 694000.0 |
| 2007-05-25 09:05:00 | SPY | ETF | 151.53 | 151.53 | 151.52 | 151.52 | 28700.0 |
| 2007-05-25 09:10:00 | SPY | ETF | 151.52 | 151.54 | 151.5 | 151.5 | 75300.0 |
| 2007-05-25 09:15:00 | SPY | ETF | 151.51 | 151.51 | 151.42 | 151.48 | 328700.0 |
| 2007-05-25 09:20:00 | SPY | ETF | 151.5 | 151.5 | 151.47 | 151.47 | 45900.0 |
| 2007-05-25 09:25:00 | SPY | ETF | 151.46 | 151.49 | 151.45 | 151.48 | 232200.0 |
| 2007-05-25 09:30:00 | SPY | ETF | 151.49 | 151.59 | 151.38 | 151.54 | 2284565.0 |
| 2007-05-25 09:35:00 | SPY | ETF | 151.53 | 151.56 | 151.35 | 151.425 | 2769000.0 |
| 2007-05-25 09:40:00 | SPY | ETF | 151.43 | 151.57 | 151.39 | 151.46 | 1327400.0 |
| 2007-05-25 09:45:00 | SPY | ETF | 151.46 | 151.53 | 151.43 | 151.51 | 1160889.0 |
| 2007-05-25 09:50:00 | SPY | ETF | 151.51 | 151.64 | 151.42 | 151.48 | 1792300.0 |
| 2007-05-25 09:55:00 | SPY | ETF | 151.48 | 151.57 | 151.45 | 151.49 | 1185500.0 |
| 2007-05-25 10:00:00 | SPY | ETF | 151.48 | 151.6 | 151.29 | 151.44 | 3910294.0 |
| 2007-05-25 10:05:00 | SPY | ETF | 151.44 | 151.53 | 151.36 | 151.51 | 3138700.0 |
| 2007-05-25 10:10:00 | SPY | ETF | 151.51 | 151.72 | 151.51 | 151.62 | 2789150.0 |
| 2007-05-25 10:15:00 | SPY | ETF | 151.6285 | 151.77 | 151.62 | 151.64 | 1683001.0 |
| 2007-05-25 10:20:00 | SPY | ETF | 151.65 | 151.67 | 151.52 | 151.55 | 1430100.0 |
> showing 50 of 15,437 rows — these rows as CSV