PREVIEW / etf_5min / 2001-05-01
file: by_date/etf_5min/2001/2001-05-01.parquet size: 31 KB rows: 1,213
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-01 09:30:00 | SPY | ETF | 125.07 | 125.07 | 124.75 | 124.76 | 340100.0 |
| 2001-05-01 09:35:00 | SPY | ETF | 124.7 | 125.06 | 124.6 | 125.06 | 272200.0 |
| 2001-05-01 09:40:00 | SPY | ETF | 125.08 | 125.11 | 124.8 | 125.05 | 335300.0 |
| 2001-05-01 09:45:00 | SPY | ETF | 125.0 | 125.09 | 124.72 | 124.85 | 243500.0 |
| 2001-05-01 09:50:00 | SPY | ETF | 124.9 | 124.95 | 124.78 | 124.9 | 189800.0 |
| 2001-05-01 09:55:00 | SPY | ETF | 124.9 | 125.34 | 124.8 | 125.27 | 169300.0 |
| 2001-05-01 10:00:00 | SPY | ETF | 125.25 | 125.45 | 124.97 | 125.39 | 208400.0 |
| 2001-05-01 10:05:00 | SPY | ETF | 125.33 | 125.39 | 124.91 | 124.91 | 150500.0 |
| 2001-05-01 10:10:00 | SPY | ETF | 125.08 | 125.08 | 124.61 | 124.82 | 304800.0 |
| 2001-05-01 10:15:00 | SPY | ETF | 124.8 | 125.0 | 124.73 | 124.97 | 227500.0 |
| 2001-05-01 10:20:00 | SPY | ETF | 124.97 | 125.0 | 124.76 | 124.76 | 146300.0 |
| 2001-05-01 10:25:00 | SPY | ETF | 124.83 | 124.86 | 124.6 | 124.7 | 279400.0 |
| 2001-05-01 10:30:00 | SPY | ETF | 124.72 | 124.88 | 124.68 | 124.81 | 32900.0 |
| 2001-05-01 10:35:00 | SPY | ETF | 124.87 | 125.15 | 124.75 | 125.09 | 159400.0 |
| 2001-05-01 10:40:00 | SPY | ETF | 125.09 | 125.23 | 124.96 | 125.12 | 110000.0 |
| 2001-05-01 10:45:00 | SPY | ETF | 125.1 | 125.4 | 125.07 | 125.28 | 66600.0 |
| 2001-05-01 10:50:00 | SPY | ETF | 125.35 | 125.64 | 125.27 | 125.49 | 73600.0 |
| 2001-05-01 10:55:00 | SPY | ETF | 125.43 | 125.5 | 125.31 | 125.4 | 63900.0 |
| 2001-05-01 11:00:00 | SPY | ETF | 125.4 | 125.4 | 125.12 | 125.26 | 62200.0 |
| 2001-05-01 11:05:00 | SPY | ETF | 125.27 | 125.39 | 125.25 | 125.3 | 95900.0 |
| 2001-05-01 11:10:00 | SPY | ETF | 125.37 | 125.5 | 125.22 | 125.22 | 69600.0 |
| 2001-05-01 11:15:00 | SPY | ETF | 125.25 | 125.25 | 124.86 | 124.99 | 108000.0 |
| 2001-05-01 11:20:00 | SPY | ETF | 124.96 | 125.14 | 124.86 | 124.95 | 92300.0 |
| 2001-05-01 11:25:00 | SPY | ETF | 125.04 | 125.13 | 124.92 | 125.13 | 16100.0 |
| 2001-05-01 11:30:00 | SPY | ETF | 125.1 | 125.24 | 124.97 | 125.24 | 52100.0 |
| 2001-05-01 11:35:00 | SPY | ETF | 125.25 | 125.29 | 125.19 | 125.26 | 12200.0 |
| 2001-05-01 11:40:00 | SPY | ETF | 125.2 | 125.3 | 125.08 | 125.08 | 28400.0 |
| 2001-05-01 11:45:00 | SPY | ETF | 125.02 | 125.26 | 125.0 | 125.14 | 127600.0 |
| 2001-05-01 11:50:00 | SPY | ETF | 125.26 | 125.4 | 125.16 | 125.36 | 117200.0 |
| 2001-05-01 11:55:00 | SPY | ETF | 125.37 | 125.42 | 125.26 | 125.39 | 9800.0 |
| 2001-05-01 12:00:00 | SPY | ETF | 125.39 | 125.48 | 125.24 | 125.24 | 32800.0 |
| 2001-05-01 12:05:00 | SPY | ETF | 125.29 | 125.35 | 125.13 | 125.19 | 87000.0 |
| 2001-05-01 12:10:00 | SPY | ETF | 125.2 | 125.38 | 125.11 | 125.3 | 117100.0 |
| 2001-05-01 12:15:00 | SPY | ETF | 125.35 | 125.36 | 125.14 | 125.2 | 13300.0 |
| 2001-05-01 12:20:00 | SPY | ETF | 125.15 | 125.29 | 125.02 | 125.1 | 22400.0 |
| 2001-05-01 12:25:00 | SPY | ETF | 125.2 | 125.28 | 125.01 | 125.01 | 13900.0 |
| 2001-05-01 12:30:00 | SPY | ETF | 125.02 | 125.21 | 125.01 | 125.05 | 38600.0 |
| 2001-05-01 12:35:00 | SPY | ETF | 125.01 | 125.08 | 124.87 | 125.01 | 68800.0 |
| 2001-05-01 12:40:00 | SPY | ETF | 125.15 | 125.22 | 125.05 | 125.05 | 13300.0 |
| 2001-05-01 12:45:00 | SPY | ETF | 125.15 | 125.25 | 125.11 | 125.16 | 112800.0 |
| 2001-05-01 12:50:00 | SPY | ETF | 125.28 | 125.28 | 125.14 | 125.26 | 3100.0 |
| 2001-05-01 12:55:00 | SPY | ETF | 125.26 | 125.4 | 125.21 | 125.3 | 13600.0 |
| 2001-05-01 13:00:00 | SPY | ETF | 125.44 | 125.49 | 125.3 | 125.35 | 96300.0 |
| 2001-05-01 13:05:00 | SPY | ETF | 125.39 | 125.47 | 125.3 | 125.46 | 81400.0 |
| 2001-05-01 13:10:00 | SPY | ETF | 125.47 | 125.55 | 125.43 | 125.43 | 65100.0 |
| 2001-05-01 13:15:00 | SPY | ETF | 125.5 | 125.53 | 125.31 | 125.42 | 51100.0 |
| 2001-05-01 13:20:00 | SPY | ETF | 125.43 | 125.53 | 125.32 | 125.5 | 20300.0 |
| 2001-05-01 13:25:00 | SPY | ETF | 125.55 | 125.73 | 125.54 | 125.7 | 132800.0 |
| 2001-05-01 13:30:00 | SPY | ETF | 125.7 | 125.82 | 125.61 | 125.68 | 263500.0 |
| 2001-05-01 13:35:00 | SPY | ETF | 125.6 | 125.69 | 125.57 | 125.6 | 17100.0 |
> showing 50 of 1,213 rows — these rows as CSV