PREVIEW / etf_5min / 2001-08-21
file: by_date/etf_5min/2001/2001-08-21.parquet size: 32 KB rows: 1,228
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-08-21 09:30:00 | SPY | ETF | 117.8 | 117.84 | 117.73 | 117.73 | 246300.0 |
| 2001-08-21 09:35:00 | SPY | ETF | 117.76 | 117.82 | 117.68 | 117.69 | 48400.0 |
| 2001-08-21 09:40:00 | SPY | ETF | 117.7 | 117.83 | 117.65 | 117.78 | 62700.0 |
| 2001-08-21 09:45:00 | SPY | ETF | 117.78 | 117.8 | 117.7 | 117.79 | 66300.0 |
| 2001-08-21 09:50:00 | SPY | ETF | 117.82 | 117.83 | 117.7 | 117.7 | 114500.0 |
| 2001-08-21 09:55:00 | SPY | ETF | 117.77 | 117.78 | 117.69 | 117.78 | 92900.0 |
| 2001-08-21 10:00:00 | SPY | ETF | 117.78 | 117.9 | 117.78 | 117.86 | 98000.0 |
| 2001-08-21 10:05:00 | SPY | ETF | 117.89 | 118.02 | 117.82 | 117.94 | 108900.0 |
| 2001-08-21 10:10:00 | SPY | ETF | 117.99 | 118.01 | 117.93 | 118.0 | 203500.0 |
| 2001-08-21 10:15:00 | SPY | ETF | 118.03 | 118.05 | 117.92 | 117.95 | 128300.0 |
| 2001-08-21 10:20:00 | SPY | ETF | 117.9 | 117.99 | 117.88 | 117.96 | 38300.0 |
| 2001-08-21 10:25:00 | SPY | ETF | 117.97 | 118.07 | 117.95 | 118.05 | 114500.0 |
| 2001-08-21 10:30:00 | SPY | ETF | 118.06 | 118.13 | 118.03 | 118.09 | 94500.0 |
| 2001-08-21 10:35:00 | SPY | ETF | 118.1 | 118.1 | 118.05 | 118.05 | 49100.0 |
| 2001-08-21 10:40:00 | SPY | ETF | 118.05 | 118.06 | 118.0 | 118.02 | 76000.0 |
| 2001-08-21 10:45:00 | SPY | ETF | 118.01 | 118.1 | 118.01 | 118.06 | 30800.0 |
| 2001-08-21 10:50:00 | SPY | ETF | 118.06 | 118.08 | 117.97 | 118.02 | 51200.0 |
| 2001-08-21 10:55:00 | SPY | ETF | 118.01 | 118.14 | 118.0 | 118.14 | 119300.0 |
| 2001-08-21 11:00:00 | SPY | ETF | 118.15 | 118.24 | 118.15 | 118.17 | 166700.0 |
| 2001-08-21 11:05:00 | SPY | ETF | 118.15 | 118.2 | 118.15 | 118.19 | 87100.0 |
| 2001-08-21 11:10:00 | SPY | ETF | 118.2 | 118.27 | 118.18 | 118.18 | 241300.0 |
| 2001-08-21 11:15:00 | SPY | ETF | 118.22 | 118.35 | 118.21 | 118.33 | 252800.0 |
| 2001-08-21 11:20:00 | SPY | ETF | 118.36 | 118.37 | 118.28 | 118.28 | 268200.0 |
| 2001-08-21 11:25:00 | SPY | ETF | 118.29 | 118.3 | 118.22 | 118.22 | 82900.0 |
| 2001-08-21 11:30:00 | SPY | ETF | 118.26 | 118.35 | 118.25 | 118.35 | 121500.0 |
| 2001-08-21 11:35:00 | SPY | ETF | 118.37 | 118.39 | 118.27 | 118.32 | 76100.0 |
| 2001-08-21 11:40:00 | SPY | ETF | 118.3 | 118.31 | 118.21 | 118.21 | 30600.0 |
| 2001-08-21 11:45:00 | SPY | ETF | 118.23 | 118.33 | 118.23 | 118.31 | 12800.0 |
| 2001-08-21 11:50:00 | SPY | ETF | 118.31 | 118.34 | 118.25 | 118.26 | 81700.0 |
| 2001-08-21 11:55:00 | SPY | ETF | 118.25 | 118.25 | 118.15 | 118.19 | 135400.0 |
| 2001-08-21 12:00:00 | SPY | ETF | 118.17 | 118.24 | 118.17 | 118.22 | 61800.0 |
| 2001-08-21 12:05:00 | SPY | ETF | 118.2 | 118.25 | 118.18 | 118.25 | 64100.0 |
| 2001-08-21 12:10:00 | SPY | ETF | 118.25 | 118.27 | 118.21 | 118.23 | 42700.0 |
| 2001-08-21 12:15:00 | SPY | ETF | 118.22 | 118.26 | 118.22 | 118.22 | 14100.0 |
| 2001-08-21 12:20:00 | SPY | ETF | 118.23 | 118.25 | 118.2 | 118.2 | 23300.0 |
| 2001-08-21 12:25:00 | SPY | ETF | 118.19 | 118.22 | 118.18 | 118.2 | 21700.0 |
| 2001-08-21 12:30:00 | SPY | ETF | 118.22 | 118.34 | 118.22 | 118.31 | 178300.0 |
| 2001-08-21 12:35:00 | SPY | ETF | 118.28 | 118.28 | 118.25 | 118.28 | 52300.0 |
| 2001-08-21 12:40:00 | SPY | ETF | 118.26 | 118.32 | 118.25 | 118.3 | 18800.0 |
| 2001-08-21 12:45:00 | SPY | ETF | 118.27 | 118.27 | 118.2 | 118.24 | 42500.0 |
| 2001-08-21 12:50:00 | SPY | ETF | 118.23 | 118.26 | 118.19 | 118.26 | 76600.0 |
| 2001-08-21 12:55:00 | SPY | ETF | 118.27 | 118.28 | 118.23 | 118.26 | 102200.0 |
| 2001-08-21 13:00:00 | SPY | ETF | 118.26 | 118.32 | 118.25 | 118.32 | 90500.0 |
| 2001-08-21 13:05:00 | SPY | ETF | 118.33 | 118.33 | 118.23 | 118.25 | 36300.0 |
| 2001-08-21 13:10:00 | SPY | ETF | 118.24 | 118.32 | 118.23 | 118.28 | 186500.0 |
| 2001-08-21 13:15:00 | SPY | ETF | 118.33 | 118.33 | 118.26 | 118.29 | 27700.0 |
| 2001-08-21 13:20:00 | SPY | ETF | 118.29 | 118.35 | 118.29 | 118.34 | 31200.0 |
| 2001-08-21 13:25:00 | SPY | ETF | 118.44 | 118.44 | 118.36 | 118.38 | 108300.0 |
| 2001-08-21 13:30:00 | SPY | ETF | 118.36 | 118.4 | 118.35 | 118.37 | 51000.0 |
| 2001-08-21 13:35:00 | SPY | ETF | 118.35 | 118.37 | 118.3 | 118.37 | 97000.0 |
> showing 50 of 1,228 rows — these rows as CSV