PREVIEW / etf_5min / 2001-05-04
file: by_date/etf_5min/2001/2001-05-04.parquet size: 31 KB rows: 1,161
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-04 09:40:00 | SPY | ETF | 123.65 | 123.98 | 123.56 | 123.86 | 189700.0 |
| 2001-05-04 09:45:00 | SPY | ETF | 123.98 | 123.98 | 123.61 | 123.61 | 257100.0 |
| 2001-05-04 09:50:00 | SPY | ETF | 123.57 | 123.72 | 123.44 | 123.54 | 114700.0 |
| 2001-05-04 09:55:00 | SPY | ETF | 123.56 | 124.09 | 123.51 | 124.01 | 191700.0 |
| 2001-05-04 10:00:00 | SPY | ETF | 124.05 | 124.14 | 123.79 | 123.79 | 154600.0 |
| 2001-05-04 10:05:00 | SPY | ETF | 123.77 | 124.14 | 123.71 | 124.14 | 102200.0 |
| 2001-05-04 10:10:00 | SPY | ETF | 124.06 | 124.14 | 123.9 | 123.96 | 69400.0 |
| 2001-05-04 10:15:00 | SPY | ETF | 123.99 | 124.36 | 123.85 | 124.36 | 169000.0 |
| 2001-05-04 10:20:00 | SPY | ETF | 124.38 | 124.9 | 124.35 | 124.86 | 330300.0 |
| 2001-05-04 10:25:00 | SPY | ETF | 124.81 | 124.92 | 124.61 | 124.82 | 293900.0 |
| 2001-05-04 10:30:00 | SPY | ETF | 124.77 | 125.2 | 124.75 | 124.9 | 285900.0 |
| 2001-05-04 10:35:00 | SPY | ETF | 124.89 | 124.99 | 124.75 | 124.8 | 148400.0 |
| 2001-05-04 10:40:00 | SPY | ETF | 124.81 | 125.2 | 124.73 | 125.2 | 430000.0 |
| 2001-05-04 10:45:00 | SPY | ETF | 125.2 | 125.42 | 125.17 | 125.3 | 429400.0 |
| 2001-05-04 10:50:00 | SPY | ETF | 125.31 | 125.34 | 125.05 | 125.07 | 210800.0 |
| 2001-05-04 10:55:00 | SPY | ETF | 125.03 | 125.3 | 125.01 | 125.19 | 187400.0 |
| 2001-05-04 11:00:00 | SPY | ETF | 125.3 | 125.96 | 125.3 | 125.93 | 380700.0 |
| 2001-05-04 11:05:00 | SPY | ETF | 125.94 | 125.94 | 125.63 | 125.64 | 233900.0 |
| 2001-05-04 11:10:00 | SPY | ETF | 125.62 | 125.72 | 125.53 | 125.6 | 110200.0 |
| 2001-05-04 11:15:00 | SPY | ETF | 125.62 | 125.63 | 125.33 | 125.49 | 58300.0 |
| 2001-05-04 11:20:00 | SPY | ETF | 125.49 | 125.64 | 125.27 | 125.5 | 47900.0 |
| 2001-05-04 11:25:00 | SPY | ETF | 125.49 | 125.49 | 125.3 | 125.31 | 42700.0 |
| 2001-05-04 11:30:00 | SPY | ETF | 125.39 | 125.51 | 125.11 | 125.13 | 62200.0 |
| 2001-05-04 11:35:00 | SPY | ETF | 125.29 | 125.46 | 125.21 | 125.35 | 14000.0 |
| 2001-05-04 11:40:00 | SPY | ETF | 125.44 | 125.64 | 125.44 | 125.62 | 89300.0 |
| 2001-05-04 11:45:00 | SPY | ETF | 125.55 | 125.79 | 125.55 | 125.65 | 131200.0 |
| 2001-05-04 11:50:00 | SPY | ETF | 125.73 | 125.73 | 125.58 | 125.66 | 20400.0 |
| 2001-05-04 11:55:00 | SPY | ETF | 125.6 | 125.84 | 125.6 | 125.69 | 104100.0 |
| 2001-05-04 12:00:00 | SPY | ETF | 125.75 | 125.75 | 125.52 | 125.6 | 31600.0 |
| 2001-05-04 12:05:00 | SPY | ETF | 125.54 | 126.05 | 125.54 | 125.96 | 181700.0 |
| 2001-05-04 12:10:00 | SPY | ETF | 126.01 | 126.23 | 125.92 | 126.17 | 172600.0 |
| 2001-05-04 12:15:00 | SPY | ETF | 126.16 | 126.48 | 126.16 | 126.28 | 102000.0 |
| 2001-05-04 12:20:00 | SPY | ETF | 126.34 | 126.44 | 126.16 | 126.16 | 135900.0 |
| 2001-05-04 12:25:00 | SPY | ETF | 126.19 | 126.48 | 126.17 | 126.33 | 78500.0 |
| 2001-05-04 12:30:00 | SPY | ETF | 126.31 | 126.37 | 126.1 | 126.2 | 54800.0 |
| 2001-05-04 12:35:00 | SPY | ETF | 126.2 | 126.3 | 126.15 | 126.25 | 95100.0 |
| 2001-05-04 12:40:00 | SPY | ETF | 126.23 | 126.31 | 126.2 | 126.28 | 36700.0 |
| 2001-05-04 12:45:00 | SPY | ETF | 126.16 | 126.48 | 126.15 | 126.48 | 40900.0 |
| 2001-05-04 12:50:00 | SPY | ETF | 126.45 | 126.61 | 126.43 | 126.43 | 240900.0 |
| 2001-05-04 12:55:00 | SPY | ETF | 126.41 | 126.53 | 126.28 | 126.37 | 77300.0 |
| 2001-05-04 13:00:00 | SPY | ETF | 126.4 | 126.49 | 126.3 | 126.3 | 30300.0 |
| 2001-05-04 13:05:00 | SPY | ETF | 126.3 | 126.3 | 126.16 | 126.25 | 79600.0 |
| 2001-05-04 13:10:00 | SPY | ETF | 126.34 | 126.34 | 126.1 | 126.18 | 124100.0 |
| 2001-05-04 13:15:00 | SPY | ETF | 126.18 | 126.29 | 126.03 | 126.1 | 77700.0 |
| 2001-05-04 13:20:00 | SPY | ETF | 126.05 | 126.19 | 126.03 | 126.1 | 210100.0 |
| 2001-05-04 13:25:00 | SPY | ETF | 126.02 | 126.19 | 125.94 | 126.11 | 94200.0 |
| 2001-05-04 13:30:00 | SPY | ETF | 126.15 | 126.3 | 126.02 | 126.3 | 137400.0 |
| 2001-05-04 13:35:00 | SPY | ETF | 126.3 | 126.39 | 126.2 | 126.35 | 75100.0 |
| 2001-05-04 13:40:00 | SPY | ETF | 126.29 | 126.49 | 126.27 | 126.41 | 24900.0 |
| 2001-05-04 13:45:00 | SPY | ETF | 126.42 | 126.54 | 126.21 | 126.21 | 25100.0 |
> showing 50 of 1,161 rows — these rows as CSV