PREVIEW / etf_5min / 2007-09-13
file: by_date/etf_5min/2007/2007-09-13.parquet size: 328 KB rows: 17,272
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-09-13 04:50:00 | SPY | ETF | 147.6 | 147.6 | 147.6 | 147.6 | 10000.0 |
| 2007-09-13 05:50:00 | SPY | ETF | 147.57 | 147.57 | 147.57 | 147.57 | 5000.0 |
| 2007-09-13 05:55:00 | SPY | ETF | 147.56 | 147.56 | 147.55 | 147.55 | 5000.0 |
| 2007-09-13 06:00:00 | SPY | ETF | 147.45 | 147.45 | 147.45 | 147.45 | 500.0 |
| 2007-09-13 06:05:00 | SPY | ETF | 147.44 | 147.45 | 147.44 | 147.45 | 400.0 |
| 2007-09-13 06:10:00 | SPY | ETF | 147.46 | 147.46 | 147.46 | 147.46 | 200.0 |
| 2007-09-13 06:15:00 | SPY | ETF | 147.46 | 147.46 | 147.46 | 147.46 | 100.0 |
| 2007-09-13 06:20:00 | SPY | ETF | 147.49 | 147.55 | 147.49 | 147.55 | 5100.0 |
| 2007-09-13 06:25:00 | SPY | ETF | 147.54 | 147.54 | 147.52 | 147.52 | 400.0 |
| 2007-09-13 06:30:00 | SPY | ETF | 147.58 | 147.59 | 147.58 | 147.59 | 300.0 |
| 2007-09-13 06:35:00 | SPY | ETF | 147.57 | 147.6 | 147.57 | 147.6 | 600.0 |
| 2007-09-13 06:40:00 | SPY | ETF | 147.54 | 147.56 | 147.54 | 147.55 | 600.0 |
| 2007-09-13 06:45:00 | SPY | ETF | 147.52 | 147.52 | 147.52 | 147.52 | 100.0 |
| 2007-09-13 06:50:00 | SPY | ETF | 147.55 | 147.55 | 147.51 | 147.55 | 2700.0 |
| 2007-09-13 06:55:00 | SPY | ETF | 147.52 | 147.52 | 147.47 | 147.47 | 6300.0 |
| 2007-09-13 07:00:00 | SPY | ETF | 147.47 | 147.54 | 147.47 | 147.52 | 4000.0 |
| 2007-09-13 07:05:00 | SPY | ETF | 147.5 | 147.52 | 147.5 | 147.52 | 5800.0 |
| 2007-09-13 07:10:00 | SPY | ETF | 147.52 | 147.57 | 147.49 | 147.57 | 33000.0 |
| 2007-09-13 07:15:00 | SPY | ETF | 147.6 | 147.74 | 147.6 | 147.72 | 28800.0 |
| 2007-09-13 07:20:00 | SPY | ETF | 147.75 | 147.75 | 147.7 | 147.7 | 52600.0 |
| 2007-09-13 07:25:00 | SPY | ETF | 147.72 | 147.82 | 147.7 | 147.82 | 54200.0 |
| 2007-09-13 07:30:00 | SPY | ETF | 147.8 | 147.88 | 147.8 | 147.88 | 21000.0 |
| 2007-09-13 07:35:00 | SPY | ETF | 147.86 | 147.94 | 147.85 | 147.89 | 64100.0 |
| 2007-09-13 07:40:00 | SPY | ETF | 147.88 | 147.95 | 147.87 | 147.92 | 16000.0 |
| 2007-09-13 07:45:00 | SPY | ETF | 147.95 | 147.95 | 147.92 | 147.94 | 57100.0 |
| 2007-09-13 07:50:00 | SPY | ETF | 147.94 | 148.18 | 147.93 | 148.16 | 560700.0 |
| 2007-09-13 07:55:00 | SPY | ETF | 148.13 | 148.17 | 148.11 | 148.16 | 174800.0 |
| 2007-09-13 08:00:00 | SPY | ETF | 148.12 | 148.17 | 147.88 | 148.05 | 52900.0 |
| 2007-09-13 08:05:00 | SPY | ETF | 148.05 | 148.39 | 148.05 | 148.27 | 41400.0 |
| 2007-09-13 08:10:00 | SPY | ETF | 148.29 | 148.32 | 148.09 | 148.24 | 1272200.0 |
| 2007-09-13 08:15:00 | SPY | ETF | 148.24 | 148.25 | 148.19 | 148.25 | 50300.0 |
| 2007-09-13 08:20:00 | SPY | ETF | 148.26 | 148.28 | 148.24 | 148.25 | 34000.0 |
| 2007-09-13 08:25:00 | SPY | ETF | 148.25 | 148.29 | 148.24 | 148.26 | 163600.0 |
| 2007-09-13 08:30:00 | SPY | ETF | 148.24 | 148.43 | 148.24 | 148.32 | 481600.0 |
| 2007-09-13 08:35:00 | SPY | ETF | 148.32 | 148.52 | 148.32 | 148.42 | 401700.0 |
| 2007-09-13 08:40:00 | SPY | ETF | 148.43 | 148.53 | 148.4 | 148.52 | 229500.0 |
| 2007-09-13 08:45:00 | SPY | ETF | 148.51 | 148.65 | 148.5 | 148.6 | 468200.0 |
| 2007-09-13 08:50:00 | SPY | ETF | 148.6 | 148.61 | 148.5 | 148.56 | 306800.0 |
| 2007-09-13 08:55:00 | SPY | ETF | 148.57 | 148.57 | 148.47 | 148.48 | 117100.0 |
| 2007-09-13 09:00:00 | SPY | ETF | 148.49 | 148.51 | 148.44 | 148.47 | 82900.0 |
| 2007-09-13 09:05:00 | SPY | ETF | 148.49 | 148.56 | 148.45 | 148.55 | 124100.0 |
| 2007-09-13 09:10:00 | SPY | ETF | 148.54 | 148.59 | 148.48 | 148.57 | 173600.0 |
| 2007-09-13 09:15:00 | SPY | ETF | 148.56 | 148.6 | 148.54 | 148.6 | 131700.0 |
| 2007-09-13 09:20:00 | SPY | ETF | 148.6 | 148.7 | 148.59 | 148.63 | 182000.0 |
| 2007-09-13 09:25:00 | SPY | ETF | 148.63 | 148.66 | 148.58 | 148.58 | 142700.0 |
| 2007-09-13 09:30:00 | SPY | ETF | 148.55 | 148.69 | 148.45 | 148.45 | 2290718.0 |
| 2007-09-13 09:35:00 | SPY | ETF | 148.45 | 148.52 | 148.36 | 148.43 | 3643824.0 |
| 2007-09-13 09:40:00 | SPY | ETF | 148.43 | 148.5 | 148.37 | 148.4 | 1750600.0 |
| 2007-09-13 09:45:00 | SPY | ETF | 148.4 | 148.4 | 148.2 | 148.28 | 2886600.0 |
| 2007-09-13 09:50:00 | SPY | ETF | 148.28 | 148.52 | 148.27 | 148.48 | 2706900.0 |
> showing 50 of 17,272 rows — these rows as CSV