PREVIEW / etf_5min / 2001-05-29
file: by_date/etf_5min/2001/2001-05-29.parquet size: 30 KB rows: 1,216
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 |
|---|---|---|---|---|---|---|---|
| 2001-05-29 09:30:00 | SPY | ETF | 128.22 | 128.33 | 128.11 | 128.21 | 331100.0 |
| 2001-05-29 09:35:00 | SPY | ETF | 128.3 | 128.34 | 128.04 | 128.08 | 164500.0 |
| 2001-05-29 09:40:00 | SPY | ETF | 128.15 | 128.15 | 127.92 | 127.95 | 77600.0 |
| 2001-05-29 09:45:00 | SPY | ETF | 127.96 | 128.08 | 127.9 | 127.9 | 362500.0 |
| 2001-05-29 09:50:00 | SPY | ETF | 128.0 | 128.04 | 127.85 | 127.88 | 302100.0 |
| 2001-05-29 09:55:00 | SPY | ETF | 127.9 | 128.0 | 127.84 | 127.99 | 120300.0 |
| 2001-05-29 10:00:00 | SPY | ETF | 127.99 | 128.3 | 127.99 | 128.15 | 353900.0 |
| 2001-05-29 10:05:00 | SPY | ETF | 128.2 | 128.28 | 127.69 | 127.77 | 162200.0 |
| 2001-05-29 10:10:00 | SPY | ETF | 127.6 | 127.84 | 127.5 | 127.82 | 163300.0 |
| 2001-05-29 10:15:00 | SPY | ETF | 127.82 | 127.86 | 127.71 | 127.8 | 146400.0 |
| 2001-05-29 10:20:00 | SPY | ETF | 127.8 | 127.82 | 127.61 | 127.78 | 76700.0 |
| 2001-05-29 10:25:00 | SPY | ETF | 127.71 | 127.72 | 127.41 | 127.45 | 87200.0 |
| 2001-05-29 10:30:00 | SPY | ETF | 127.44 | 127.61 | 127.41 | 127.5 | 52900.0 |
| 2001-05-29 10:35:00 | SPY | ETF | 127.57 | 127.6 | 127.31 | 127.52 | 206500.0 |
| 2001-05-29 10:40:00 | SPY | ETF | 127.47 | 127.62 | 127.44 | 127.62 | 57200.0 |
| 2001-05-29 10:45:00 | SPY | ETF | 127.62 | 127.73 | 127.56 | 127.62 | 349000.0 |
| 2001-05-29 10:50:00 | SPY | ETF | 127.6 | 127.72 | 127.56 | 127.66 | 65000.0 |
| 2001-05-29 10:55:00 | SPY | ETF | 127.66 | 127.74 | 127.57 | 127.73 | 42700.0 |
| 2001-05-29 11:00:00 | SPY | ETF | 127.74 | 127.89 | 127.67 | 127.77 | 114800.0 |
| 2001-05-29 11:05:00 | SPY | ETF | 127.87 | 127.88 | 127.72 | 127.72 | 67900.0 |
| 2001-05-29 11:10:00 | SPY | ETF | 127.7 | 127.81 | 127.7 | 127.81 | 68600.0 |
| 2001-05-29 11:15:00 | SPY | ETF | 127.78 | 127.81 | 127.64 | 127.73 | 13800.0 |
| 2001-05-29 11:20:00 | SPY | ETF | 127.71 | 127.75 | 127.48 | 127.54 | 178000.0 |
| 2001-05-29 11:25:00 | SPY | ETF | 127.55 | 127.64 | 127.48 | 127.64 | 51100.0 |
| 2001-05-29 11:30:00 | SPY | ETF | 127.64 | 127.72 | 127.58 | 127.7 | 156000.0 |
| 2001-05-29 11:35:00 | SPY | ETF | 127.7 | 127.76 | 127.64 | 127.64 | 14200.0 |
| 2001-05-29 11:40:00 | SPY | ETF | 127.75 | 127.78 | 127.65 | 127.72 | 120600.0 |
| 2001-05-29 11:45:00 | SPY | ETF | 127.72 | 127.72 | 127.59 | 127.7 | 28900.0 |
| 2001-05-29 11:50:00 | SPY | ETF | 127.75 | 127.75 | 127.6 | 127.68 | 21900.0 |
| 2001-05-29 11:55:00 | SPY | ETF | 127.6 | 127.68 | 127.55 | 127.59 | 20000.0 |
| 2001-05-29 12:00:00 | SPY | ETF | 127.69 | 127.79 | 127.65 | 127.79 | 46400.0 |
| 2001-05-29 12:05:00 | SPY | ETF | 127.73 | 127.76 | 127.64 | 127.64 | 17100.0 |
| 2001-05-29 12:10:00 | SPY | ETF | 127.65 | 127.68 | 127.52 | 127.55 | 35800.0 |
| 2001-05-29 12:15:00 | SPY | ETF | 127.51 | 127.55 | 127.15 | 127.45 | 19300.0 |
| 2001-05-29 12:20:00 | SPY | ETF | 127.51 | 127.57 | 127.46 | 127.48 | 34900.0 |
| 2001-05-29 12:25:00 | SPY | ETF | 127.59 | 127.59 | 127.41 | 127.54 | 58100.0 |
| 2001-05-29 12:30:00 | SPY | ETF | 127.49 | 127.51 | 127.38 | 127.38 | 13700.0 |
| 2001-05-29 12:35:00 | SPY | ETF | 127.31 | 127.44 | 127.3 | 127.39 | 118100.0 |
| 2001-05-29 12:40:00 | SPY | ETF | 127.36 | 127.49 | 127.36 | 127.41 | 51200.0 |
| 2001-05-29 12:45:00 | SPY | ETF | 127.44 | 127.58 | 127.38 | 127.58 | 13900.0 |
| 2001-05-29 12:50:00 | SPY | ETF | 127.52 | 127.63 | 127.52 | 127.61 | 20200.0 |
| 2001-05-29 12:55:00 | SPY | ETF | 127.55 | 127.58 | 127.43 | 127.51 | 29000.0 |
| 2001-05-29 13:00:00 | SPY | ETF | 127.53 | 127.63 | 127.4 | 127.41 | 30700.0 |
| 2001-05-29 13:05:00 | SPY | ETF | 127.41 | 127.54 | 127.41 | 127.41 | 25200.0 |
| 2001-05-29 13:10:00 | SPY | ETF | 127.37 | 127.41 | 127.22 | 127.34 | 117000.0 |
| 2001-05-29 13:15:00 | SPY | ETF | 127.3 | 127.35 | 127.23 | 127.24 | 138100.0 |
| 2001-05-29 13:20:00 | SPY | ETF | 127.24 | 127.34 | 127.22 | 127.34 | 128700.0 |
| 2001-05-29 13:25:00 | SPY | ETF | 127.34 | 127.34 | 127.25 | 127.32 | 9200.0 |
| 2001-05-29 13:30:00 | SPY | ETF | 127.28 | 127.34 | 127.22 | 127.22 | 320800.0 |
| 2001-05-29 13:35:00 | SPY | ETF | 127.22 | 127.23 | 126.9 | 127.03 | 177000.0 |
> showing 50 of 1,216 rows — these rows as CSV