PREVIEW / etf_5min / 2001-04-04
file: by_date/etf_5min/2001/2001-04-04.parquet size: 33 KB rows: 1,174
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-04-04 09:30:00 | SPY | ETF | 110.57 | 110.57 | 110.16 | 110.4 | 385100.0 |
| 2001-04-04 09:35:00 | SPY | ETF | 110.57 | 111.03 | 110.43 | 111.0 | 437500.0 |
| 2001-04-04 09:40:00 | SPY | ETF | 110.95 | 111.16 | 110.81 | 110.9 | 428900.0 |
| 2001-04-04 09:45:00 | SPY | ETF | 110.9 | 110.99 | 110.65 | 110.82 | 246300.0 |
| 2001-04-04 09:50:00 | SPY | ETF | 110.86 | 111.0 | 110.62 | 110.65 | 157500.0 |
| 2001-04-04 09:55:00 | SPY | ETF | 110.74 | 110.74 | 110.36 | 110.45 | 167800.0 |
| 2001-04-04 10:00:00 | SPY | ETF | 110.56 | 110.56 | 110.01 | 110.05 | 673900.0 |
| 2001-04-04 10:05:00 | SPY | ETF | 110.06 | 110.24 | 109.76 | 109.98 | 432100.0 |
| 2001-04-04 10:10:00 | SPY | ETF | 109.89 | 110.3 | 109.6 | 110.18 | 331100.0 |
| 2001-04-04 10:15:00 | SPY | ETF | 110.27 | 110.43 | 109.9 | 109.9 | 173400.0 |
| 2001-04-04 10:20:00 | SPY | ETF | 109.92 | 110.05 | 109.3 | 109.52 | 232200.0 |
| 2001-04-04 10:25:00 | SPY | ETF | 109.55 | 109.7 | 109.35 | 109.68 | 151200.0 |
| 2001-04-04 10:30:00 | SPY | ETF | 109.78 | 109.93 | 109.6 | 109.93 | 228200.0 |
| 2001-04-04 10:35:00 | SPY | ETF | 109.93 | 110.06 | 109.67 | 109.92 | 153500.0 |
| 2001-04-04 10:40:00 | SPY | ETF | 109.81 | 110.08 | 109.65 | 110.01 | 100300.0 |
| 2001-04-04 10:45:00 | SPY | ETF | 110.05 | 110.95 | 109.95 | 110.76 | 250600.0 |
| 2001-04-04 10:50:00 | SPY | ETF | 110.83 | 111.14 | 110.7 | 110.76 | 495800.0 |
| 2001-04-04 10:55:00 | SPY | ETF | 110.78 | 110.93 | 110.6 | 110.8 | 312100.0 |
| 2001-04-04 11:00:00 | SPY | ETF | 110.72 | 110.94 | 110.69 | 110.72 | 91700.0 |
| 2001-04-04 11:05:00 | SPY | ETF | 110.71 | 111.4 | 110.71 | 111.21 | 208800.0 |
| 2001-04-04 11:10:00 | SPY | ETF | 111.2 | 111.7 | 111.1 | 111.66 | 157800.0 |
| 2001-04-04 11:15:00 | SPY | ETF | 111.8 | 111.98 | 111.54 | 111.85 | 199900.0 |
| 2001-04-04 11:20:00 | SPY | ETF | 111.89 | 112.05 | 111.67 | 111.7 | 323900.0 |
| 2001-04-04 11:25:00 | SPY | ETF | 111.62 | 111.75 | 111.28 | 111.28 | 251200.0 |
| 2001-04-04 11:30:00 | SPY | ETF | 111.28 | 111.6 | 111.25 | 111.6 | 48900.0 |
| 2001-04-04 11:35:00 | SPY | ETF | 111.62 | 111.75 | 111.21 | 111.29 | 159200.0 |
| 2001-04-04 11:40:00 | SPY | ETF | 111.35 | 111.39 | 111.1 | 111.15 | 130800.0 |
| 2001-04-04 11:45:00 | SPY | ETF | 111.21 | 111.55 | 111.18 | 111.44 | 83900.0 |
| 2001-04-04 11:50:00 | SPY | ETF | 111.37 | 111.68 | 111.37 | 111.41 | 43900.0 |
| 2001-04-04 11:55:00 | SPY | ETF | 111.49 | 111.89 | 111.45 | 111.89 | 438100.0 |
| 2001-04-04 12:00:00 | SPY | ETF | 111.88 | 111.9 | 111.72 | 111.89 | 165500.0 |
| 2001-04-04 12:05:00 | SPY | ETF | 111.82 | 111.88 | 111.5 | 111.6 | 78600.0 |
| 2001-04-04 12:10:00 | SPY | ETF | 111.66 | 112.08 | 111.51 | 112.0 | 171000.0 |
| 2001-04-04 12:15:00 | SPY | ETF | 111.99 | 112.0 | 111.74 | 111.77 | 257600.0 |
| 2001-04-04 12:20:00 | SPY | ETF | 111.79 | 111.87 | 111.62 | 111.87 | 82400.0 |
| 2001-04-04 12:25:00 | SPY | ETF | 111.79 | 112.1 | 111.75 | 111.76 | 73700.0 |
| 2001-04-04 12:30:00 | SPY | ETF | 111.74 | 111.85 | 111.57 | 111.67 | 123200.0 |
| 2001-04-04 12:35:00 | SPY | ETF | 111.76 | 111.84 | 111.58 | 111.84 | 85500.0 |
| 2001-04-04 12:40:00 | SPY | ETF | 111.76 | 111.83 | 111.4 | 111.51 | 85000.0 |
| 2001-04-04 12:45:00 | SPY | ETF | 111.5 | 111.65 | 111.42 | 111.6 | 91700.0 |
| 2001-04-04 12:50:00 | SPY | ETF | 111.56 | 111.65 | 111.4 | 111.43 | 67600.0 |
| 2001-04-04 12:55:00 | SPY | ETF | 111.43 | 111.48 | 111.3 | 111.31 | 150900.0 |
| 2001-04-04 13:00:00 | SPY | ETF | 111.45 | 111.45 | 111.28 | 111.43 | 46900.0 |
| 2001-04-04 13:05:00 | SPY | ETF | 111.43 | 111.43 | 111.28 | 111.28 | 22300.0 |
| 2001-04-04 13:10:00 | SPY | ETF | 111.28 | 111.34 | 111.19 | 111.19 | 230200.0 |
| 2001-04-04 13:15:00 | SPY | ETF | 111.14 | 111.45 | 111.14 | 111.33 | 153000.0 |
| 2001-04-04 13:20:00 | SPY | ETF | 111.31 | 111.43 | 111.06 | 111.06 | 126000.0 |
| 2001-04-04 13:25:00 | SPY | ETF | 111.13 | 111.2 | 110.91 | 111.01 | 180400.0 |
| 2001-04-04 13:30:00 | SPY | ETF | 111.04 | 111.2 | 110.82 | 110.95 | 160500.0 |
| 2001-04-04 13:35:00 | SPY | ETF | 111.0 | 111.05 | 110.71 | 110.9 | 112000.0 |
> showing 50 of 1,174 rows — these rows as CSV