PREVIEW / etf_5min / 2001-11-01
file: by_date/etf_5min/2001/2001-11-01.parquet size: 37 KB rows: 1,368
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-11-01 09:30:00 | SPY | ETF | 106.6 | 106.86 | 106.59 | 106.61 | 831000.0 |
| 2001-11-01 09:35:00 | SPY | ETF | 106.66 | 106.88 | 106.57 | 106.83 | 179800.0 |
| 2001-11-01 09:40:00 | SPY | ETF | 106.85 | 106.88 | 106.34 | 106.4 | 625100.0 |
| 2001-11-01 09:45:00 | SPY | ETF | 106.39 | 106.6 | 106.34 | 106.44 | 426300.0 |
| 2001-11-01 09:50:00 | SPY | ETF | 106.45 | 106.55 | 106.29 | 106.35 | 285400.0 |
| 2001-11-01 09:55:00 | SPY | ETF | 106.35 | 106.65 | 106.35 | 106.58 | 601800.0 |
| 2001-11-01 10:00:00 | SPY | ETF | 106.64 | 107.0 | 105.75 | 106.1 | 1098600.0 |
| 2001-11-01 10:05:00 | SPY | ETF | 106.13 | 106.55 | 106.0 | 106.15 | 717000.0 |
| 2001-11-01 10:10:00 | SPY | ETF | 106.12 | 106.28 | 105.8 | 105.89 | 714000.0 |
| 2001-11-01 10:15:00 | SPY | ETF | 105.99 | 105.99 | 105.69 | 105.9 | 810200.0 |
| 2001-11-01 10:20:00 | SPY | ETF | 105.98 | 106.1 | 105.9 | 105.99 | 357000.0 |
| 2001-11-01 10:25:00 | SPY | ETF | 106.0 | 106.48 | 105.96 | 106.35 | 250300.0 |
| 2001-11-01 10:30:00 | SPY | ETF | 106.38 | 107.12 | 106.34 | 107.06 | 664300.0 |
| 2001-11-01 10:35:00 | SPY | ETF | 107.09 | 107.11 | 106.8 | 106.95 | 774600.0 |
| 2001-11-01 10:40:00 | SPY | ETF | 106.95 | 107.2 | 106.91 | 106.95 | 524000.0 |
| 2001-11-01 10:45:00 | SPY | ETF | 106.91 | 107.18 | 106.81 | 106.98 | 188100.0 |
| 2001-11-01 10:50:00 | SPY | ETF | 106.92 | 107.08 | 106.88 | 106.92 | 166600.0 |
| 2001-11-01 10:55:00 | SPY | ETF | 106.87 | 107.5 | 106.8 | 107.44 | 380800.0 |
| 2001-11-01 11:00:00 | SPY | ETF | 107.45 | 107.55 | 107.34 | 107.34 | 474100.0 |
| 2001-11-01 11:05:00 | SPY | ETF | 107.34 | 107.4 | 107.16 | 107.4 | 154300.0 |
| 2001-11-01 11:10:00 | SPY | ETF | 107.39 | 107.47 | 107.06 | 107.21 | 836000.0 |
| 2001-11-01 11:15:00 | SPY | ETF | 107.2 | 107.36 | 107.11 | 107.25 | 583300.0 |
| 2001-11-01 11:20:00 | SPY | ETF | 107.23 | 107.46 | 107.14 | 107.38 | 384300.0 |
| 2001-11-01 11:25:00 | SPY | ETF | 107.41 | 107.59 | 107.26 | 107.3 | 305600.0 |
| 2001-11-01 11:30:00 | SPY | ETF | 107.27 | 107.47 | 107.23 | 107.27 | 378500.0 |
| 2001-11-01 11:35:00 | SPY | ETF | 107.25 | 107.27 | 107.08 | 107.25 | 119000.0 |
| 2001-11-01 11:40:00 | SPY | ETF | 107.25 | 107.31 | 107.1 | 107.22 | 96000.0 |
| 2001-11-01 11:45:00 | SPY | ETF | 107.23 | 107.42 | 107.17 | 107.42 | 382600.0 |
| 2001-11-01 11:50:00 | SPY | ETF | 107.43 | 107.44 | 107.14 | 107.15 | 167800.0 |
| 2001-11-01 11:55:00 | SPY | ETF | 107.19 | 107.34 | 107.08 | 107.25 | 77000.0 |
| 2001-11-01 12:00:00 | SPY | ETF | 107.28 | 107.38 | 107.26 | 107.3 | 20000.0 |
| 2001-11-01 12:05:00 | SPY | ETF | 107.31 | 107.48 | 107.3 | 107.4 | 84700.0 |
| 2001-11-01 12:10:00 | SPY | ETF | 107.32 | 107.69 | 107.32 | 107.62 | 289700.0 |
| 2001-11-01 12:15:00 | SPY | ETF | 107.63 | 107.65 | 107.45 | 107.5 | 92900.0 |
| 2001-11-01 12:20:00 | SPY | ETF | 107.52 | 107.52 | 107.18 | 107.33 | 111400.0 |
| 2001-11-01 12:25:00 | SPY | ETF | 107.35 | 107.38 | 107.28 | 107.28 | 113400.0 |
| 2001-11-01 12:30:00 | SPY | ETF | 107.32 | 107.61 | 107.32 | 107.51 | 38700.0 |
| 2001-11-01 12:35:00 | SPY | ETF | 107.56 | 107.62 | 107.42 | 107.61 | 145400.0 |
| 2001-11-01 12:40:00 | SPY | ETF | 107.58 | 107.7 | 107.5 | 107.6 | 328100.0 |
| 2001-11-01 12:45:00 | SPY | ETF | 107.59 | 107.82 | 107.52 | 107.77 | 305400.0 |
| 2001-11-01 12:50:00 | SPY | ETF | 107.72 | 107.78 | 107.57 | 107.6 | 288500.0 |
| 2001-11-01 12:55:00 | SPY | ETF | 107.59 | 107.69 | 107.5 | 107.69 | 56500.0 |
| 2001-11-01 13:00:00 | SPY | ETF | 107.69 | 108.0 | 107.68 | 107.93 | 636500.0 |
| 2001-11-01 13:05:00 | SPY | ETF | 107.95 | 108.14 | 107.89 | 108.03 | 812600.0 |
| 2001-11-01 13:10:00 | SPY | ETF | 108.02 | 108.15 | 108.0 | 108.1 | 184500.0 |
| 2001-11-01 13:15:00 | SPY | ETF | 108.11 | 108.45 | 108.1 | 108.34 | 566800.0 |
| 2001-11-01 13:20:00 | SPY | ETF | 108.33 | 108.39 | 108.17 | 108.27 | 527300.0 |
| 2001-11-01 13:25:00 | SPY | ETF | 108.27 | 108.41 | 108.18 | 108.36 | 115300.0 |
| 2001-11-01 13:30:00 | SPY | ETF | 108.37 | 108.64 | 108.35 | 108.56 | 270200.0 |
| 2001-11-01 13:35:00 | SPY | ETF | 108.6 | 108.6 | 108.43 | 108.5 | 93300.0 |
> showing 50 of 1,368 rows — these rows as CSV