PREVIEW / etf_5min / 2001-10-31
file: by_date/etf_5min/2001/2001-10-31.parquet size: 37 KB rows: 1,415
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-10-31 09:30:00 | SPY | ETF | 106.9 | 107.1 | 106.9 | 106.91 | 496500.0 |
| 2001-10-31 09:35:00 | SPY | ETF | 106.9 | 107.26 | 106.8 | 107.21 | 343200.0 |
| 2001-10-31 09:40:00 | SPY | ETF | 107.22 | 107.43 | 107.18 | 107.29 | 659800.0 |
| 2001-10-31 09:45:00 | SPY | ETF | 107.19 | 107.25 | 107.05 | 107.1 | 251700.0 |
| 2001-10-31 09:50:00 | SPY | ETF | 107.08 | 107.1 | 106.75 | 106.84 | 564100.0 |
| 2001-10-31 09:55:00 | SPY | ETF | 106.82 | 107.22 | 106.75 | 107.18 | 477300.0 |
| 2001-10-31 10:00:00 | SPY | ETF | 107.22 | 107.45 | 107.04 | 107.25 | 1330900.0 |
| 2001-10-31 10:05:00 | SPY | ETF | 107.27 | 107.55 | 107.23 | 107.48 | 1925300.0 |
| 2001-10-31 10:10:00 | SPY | ETF | 107.45 | 107.54 | 107.35 | 107.49 | 821700.0 |
| 2001-10-31 10:15:00 | SPY | ETF | 107.5 | 107.86 | 107.5 | 107.77 | 745900.0 |
| 2001-10-31 10:20:00 | SPY | ETF | 107.77 | 107.85 | 107.62 | 107.7 | 889700.0 |
| 2001-10-31 10:25:00 | SPY | ETF | 107.7 | 107.82 | 107.6 | 107.66 | 263100.0 |
| 2001-10-31 10:30:00 | SPY | ETF | 107.66 | 107.69 | 107.52 | 107.58 | 214500.0 |
| 2001-10-31 10:35:00 | SPY | ETF | 107.53 | 107.65 | 107.49 | 107.65 | 102800.0 |
| 2001-10-31 10:40:00 | SPY | ETF | 107.64 | 107.68 | 107.4 | 107.41 | 184500.0 |
| 2001-10-31 10:45:00 | SPY | ETF | 107.4 | 107.53 | 107.4 | 107.42 | 133900.0 |
| 2001-10-31 10:50:00 | SPY | ETF | 107.49 | 107.61 | 107.36 | 107.4 | 154300.0 |
| 2001-10-31 10:55:00 | SPY | ETF | 107.36 | 107.43 | 107.22 | 107.27 | 224100.0 |
| 2001-10-31 11:00:00 | SPY | ETF | 107.27 | 107.39 | 107.17 | 107.39 | 170500.0 |
| 2001-10-31 11:05:00 | SPY | ETF | 107.4 | 107.44 | 107.35 | 107.38 | 176900.0 |
| 2001-10-31 11:10:00 | SPY | ETF | 107.37 | 107.39 | 107.21 | 107.28 | 187100.0 |
| 2001-10-31 11:15:00 | SPY | ETF | 107.28 | 107.32 | 107.01 | 107.09 | 265400.0 |
| 2001-10-31 11:20:00 | SPY | ETF | 107.08 | 107.14 | 107.03 | 107.08 | 91400.0 |
| 2001-10-31 11:25:00 | SPY | ETF | 107.12 | 107.2 | 107.07 | 107.17 | 177200.0 |
| 2001-10-31 11:30:00 | SPY | ETF | 107.16 | 107.25 | 107.14 | 107.23 | 92000.0 |
| 2001-10-31 11:35:00 | SPY | ETF | 107.24 | 107.38 | 107.23 | 107.24 | 35000.0 |
| 2001-10-31 11:40:00 | SPY | ETF | 107.25 | 107.38 | 107.18 | 107.25 | 119900.0 |
| 2001-10-31 11:45:00 | SPY | ETF | 107.26 | 107.32 | 107.2 | 107.22 | 84800.0 |
| 2001-10-31 11:50:00 | SPY | ETF | 107.18 | 107.25 | 107.1 | 107.22 | 45600.0 |
| 2001-10-31 11:55:00 | SPY | ETF | 107.21 | 107.21 | 107.01 | 107.06 | 165400.0 |
| 2001-10-31 12:00:00 | SPY | ETF | 107.06 | 107.06 | 106.69 | 106.81 | 383000.0 |
| 2001-10-31 12:05:00 | SPY | ETF | 106.83 | 106.93 | 106.7 | 106.87 | 171800.0 |
| 2001-10-31 12:10:00 | SPY | ETF | 106.91 | 106.95 | 106.83 | 106.87 | 117000.0 |
| 2001-10-31 12:15:00 | SPY | ETF | 106.91 | 107.04 | 106.86 | 106.95 | 46400.0 |
| 2001-10-31 12:20:00 | SPY | ETF | 106.92 | 107.12 | 106.91 | 107.08 | 55600.0 |
| 2001-10-31 12:25:00 | SPY | ETF | 107.04 | 107.05 | 106.84 | 106.84 | 194200.0 |
| 2001-10-31 12:30:00 | SPY | ETF | 106.85 | 106.88 | 106.78 | 106.86 | 31400.0 |
| 2001-10-31 12:35:00 | SPY | ETF | 106.8 | 106.86 | 106.72 | 106.8 | 92600.0 |
| 2001-10-31 12:40:00 | SPY | ETF | 106.8 | 106.8 | 106.55 | 106.58 | 414700.0 |
| 2001-10-31 12:45:00 | SPY | ETF | 106.57 | 106.65 | 106.35 | 106.36 | 630800.0 |
| 2001-10-31 12:50:00 | SPY | ETF | 106.35 | 106.45 | 106.25 | 106.44 | 537200.0 |
| 2001-10-31 12:55:00 | SPY | ETF | 106.44 | 106.44 | 106.01 | 106.15 | 356600.0 |
| 2001-10-31 13:00:00 | SPY | ETF | 106.15 | 106.45 | 106.11 | 106.45 | 356600.0 |
| 2001-10-31 13:05:00 | SPY | ETF | 106.43 | 106.49 | 106.36 | 106.48 | 150400.0 |
| 2001-10-31 13:10:00 | SPY | ETF | 106.5 | 106.66 | 106.46 | 106.49 | 418000.0 |
| 2001-10-31 13:15:00 | SPY | ETF | 106.48 | 106.65 | 106.46 | 106.57 | 196700.0 |
| 2001-10-31 13:20:00 | SPY | ETF | 106.52 | 106.65 | 106.46 | 106.48 | 86400.0 |
| 2001-10-31 13:25:00 | SPY | ETF | 106.5 | 106.6 | 106.38 | 106.58 | 203000.0 |
| 2001-10-31 13:30:00 | SPY | ETF | 106.55 | 106.68 | 106.5 | 106.67 | 167400.0 |
| 2001-10-31 13:35:00 | SPY | ETF | 106.65 | 106.68 | 106.48 | 106.52 | 211400.0 |
> showing 50 of 1,415 rows — these rows as CSV