PREVIEW / etf_5min / 2001-06-28
file: by_date/etf_5min/2001/2001-06-28.parquet size: 33 KB rows: 1,327
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-06-28 09:30:00 | SPY | ETF | 122.0 | 122.19 | 121.93 | 122.17 | 203000.0 |
| 2001-06-28 09:35:00 | SPY | ETF | 122.15 | 122.39 | 122.04 | 122.31 | 591500.0 |
| 2001-06-28 09:40:00 | SPY | ETF | 122.34 | 122.45 | 122.26 | 122.3 | 211000.0 |
| 2001-06-28 09:45:00 | SPY | ETF | 122.38 | 122.44 | 122.22 | 122.39 | 370000.0 |
| 2001-06-28 09:50:00 | SPY | ETF | 122.31 | 122.61 | 122.29 | 122.56 | 237400.0 |
| 2001-06-28 09:55:00 | SPY | ETF | 122.55 | 122.85 | 122.55 | 122.75 | 211100.0 |
| 2001-06-28 10:00:00 | SPY | ETF | 122.69 | 122.8 | 122.6 | 122.7 | 129900.0 |
| 2001-06-28 10:05:00 | SPY | ETF | 122.69 | 123.0 | 122.61 | 123.0 | 242000.0 |
| 2001-06-28 10:10:00 | SPY | ETF | 123.0 | 123.08 | 122.92 | 122.98 | 437700.0 |
| 2001-06-28 10:15:00 | SPY | ETF | 123.05 | 123.05 | 122.92 | 122.96 | 34600.0 |
| 2001-06-28 10:20:00 | SPY | ETF | 123.01 | 123.27 | 122.96 | 123.27 | 165100.0 |
| 2001-06-28 10:25:00 | SPY | ETF | 123.15 | 123.22 | 122.93 | 122.95 | 111200.0 |
| 2001-06-28 10:30:00 | SPY | ETF | 122.91 | 122.99 | 122.84 | 122.92 | 101900.0 |
| 2001-06-28 10:35:00 | SPY | ETF | 122.9 | 122.95 | 122.71 | 122.83 | 172700.0 |
| 2001-06-28 10:40:00 | SPY | ETF | 122.85 | 123.1 | 122.77 | 123.04 | 59900.0 |
| 2001-06-28 10:45:00 | SPY | ETF | 123.06 | 123.08 | 122.97 | 123.0 | 61300.0 |
| 2001-06-28 10:50:00 | SPY | ETF | 123.05 | 123.09 | 122.86 | 122.86 | 32200.0 |
| 2001-06-28 10:55:00 | SPY | ETF | 122.86 | 122.92 | 122.77 | 122.87 | 67100.0 |
| 2001-06-28 11:00:00 | SPY | ETF | 122.87 | 122.99 | 122.84 | 122.98 | 68000.0 |
| 2001-06-28 11:05:00 | SPY | ETF | 122.93 | 123.1 | 122.86 | 122.87 | 119900.0 |
| 2001-06-28 11:10:00 | SPY | ETF | 122.95 | 122.95 | 122.78 | 122.87 | 64300.0 |
| 2001-06-28 11:15:00 | SPY | ETF | 122.81 | 122.88 | 122.73 | 122.88 | 46800.0 |
| 2001-06-28 11:20:00 | SPY | ETF | 122.91 | 123.18 | 122.85 | 123.15 | 91200.0 |
| 2001-06-28 11:25:00 | SPY | ETF | 123.18 | 123.18 | 123.01 | 123.02 | 109800.0 |
| 2001-06-28 11:30:00 | SPY | ETF | 123.1 | 123.79 | 123.1 | 123.73 | 313300.0 |
| 2001-06-28 11:35:00 | SPY | ETF | 123.73 | 123.77 | 123.4 | 123.56 | 255300.0 |
| 2001-06-28 11:40:00 | SPY | ETF | 123.59 | 123.59 | 123.4 | 123.47 | 111800.0 |
| 2001-06-28 11:45:00 | SPY | ETF | 123.55 | 123.69 | 123.41 | 123.6 | 96100.0 |
| 2001-06-28 11:50:00 | SPY | ETF | 123.55 | 123.68 | 123.52 | 123.57 | 78500.0 |
| 2001-06-28 11:55:00 | SPY | ETF | 123.56 | 123.8 | 123.56 | 123.62 | 65300.0 |
| 2001-06-28 12:00:00 | SPY | ETF | 123.72 | 123.88 | 123.61 | 123.61 | 123700.0 |
| 2001-06-28 12:05:00 | SPY | ETF | 123.63 | 123.63 | 123.35 | 123.36 | 117600.0 |
| 2001-06-28 12:10:00 | SPY | ETF | 123.49 | 123.64 | 123.41 | 123.57 | 90900.0 |
| 2001-06-28 12:15:00 | SPY | ETF | 123.64 | 123.81 | 123.55 | 123.59 | 41700.0 |
| 2001-06-28 12:20:00 | SPY | ETF | 123.58 | 123.71 | 123.52 | 123.53 | 20200.0 |
| 2001-06-28 12:25:00 | SPY | ETF | 123.68 | 123.72 | 123.58 | 123.62 | 18800.0 |
| 2001-06-28 12:30:00 | SPY | ETF | 123.64 | 123.73 | 123.6 | 123.65 | 13700.0 |
| 2001-06-28 12:35:00 | SPY | ETF | 123.63 | 123.67 | 123.52 | 123.62 | 18000.0 |
| 2001-06-28 12:40:00 | SPY | ETF | 123.58 | 123.78 | 123.58 | 123.7 | 78400.0 |
| 2001-06-28 12:45:00 | SPY | ETF | 123.75 | 123.75 | 123.67 | 123.67 | 12800.0 |
| 2001-06-28 12:50:00 | SPY | ETF | 123.65 | 123.71 | 123.51 | 123.63 | 30400.0 |
| 2001-06-28 12:55:00 | SPY | ETF | 123.64 | 123.65 | 123.62 | 123.65 | 17900.0 |
| 2001-06-28 13:00:00 | SPY | ETF | 123.68 | 123.68 | 123.46 | 123.47 | 13400.0 |
| 2001-06-28 13:05:00 | SPY | ETF | 123.5 | 123.61 | 123.45 | 123.52 | 23300.0 |
| 2001-06-28 13:10:00 | SPY | ETF | 123.62 | 123.62 | 123.47 | 123.58 | 63400.0 |
| 2001-06-28 13:15:00 | SPY | ETF | 123.6 | 123.68 | 123.54 | 123.6 | 28400.0 |
| 2001-06-28 13:20:00 | SPY | ETF | 123.66 | 123.94 | 123.61 | 123.81 | 73100.0 |
| 2001-06-28 13:25:00 | SPY | ETF | 123.89 | 123.89 | 123.71 | 123.74 | 159500.0 |
| 2001-06-28 13:30:00 | SPY | ETF | 123.7 | 123.79 | 123.7 | 123.78 | 172500.0 |
| 2001-06-28 13:35:00 | SPY | ETF | 123.8 | 123.89 | 123.7 | 123.7 | 178200.0 |
> showing 50 of 1,327 rows — these rows as CSV