PREVIEW / etf_5min / 2001-09-25
file: by_date/etf_5min/2001/2001-09-25.parquet size: 37 KB rows: 1,563
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-09-25 09:30:00 | SPY | ETF | 100.75 | 100.92 | 100.5 | 100.5 | 750200.0 |
| 2001-09-25 09:35:00 | SPY | ETF | 100.5 | 100.55 | 100.42 | 100.54 | 706900.0 |
| 2001-09-25 09:40:00 | SPY | ETF | 100.5 | 100.95 | 100.45 | 100.89 | 598100.0 |
| 2001-09-25 09:45:00 | SPY | ETF | 100.89 | 101.02 | 100.8 | 101.0 | 320400.0 |
| 2001-09-25 09:50:00 | SPY | ETF | 100.98 | 101.08 | 100.82 | 100.9 | 392600.0 |
| 2001-09-25 09:55:00 | SPY | ETF | 100.91 | 101.34 | 100.88 | 101.3 | 523400.0 |
| 2001-09-25 10:00:00 | SPY | ETF | 101.2 | 101.55 | 100.2 | 101.5 | 1322000.0 |
| 2001-09-25 10:05:00 | SPY | ETF | 101.45 | 101.84 | 101.45 | 101.55 | 832100.0 |
| 2001-09-25 10:10:00 | SPY | ETF | 101.55 | 101.9 | 101.51 | 101.85 | 575200.0 |
| 2001-09-25 10:15:00 | SPY | ETF | 101.9 | 102.0 | 101.64 | 101.65 | 412800.0 |
| 2001-09-25 10:20:00 | SPY | ETF | 101.63 | 101.75 | 101.49 | 101.5 | 358800.0 |
| 2001-09-25 10:25:00 | SPY | ETF | 101.51 | 101.65 | 101.36 | 101.6 | 373300.0 |
| 2001-09-25 10:30:00 | SPY | ETF | 101.55 | 101.75 | 101.48 | 101.55 | 198000.0 |
| 2001-09-25 10:35:00 | SPY | ETF | 101.55 | 101.59 | 101.32 | 101.48 | 577800.0 |
| 2001-09-25 10:40:00 | SPY | ETF | 101.5 | 101.79 | 101.45 | 101.64 | 208900.0 |
| 2001-09-25 10:45:00 | SPY | ETF | 101.65 | 101.87 | 101.55 | 101.69 | 204700.0 |
| 2001-09-25 10:50:00 | SPY | ETF | 101.69 | 101.7 | 101.41 | 101.55 | 319400.0 |
| 2001-09-25 10:55:00 | SPY | ETF | 101.55 | 101.66 | 101.35 | 101.37 | 226000.0 |
| 2001-09-25 11:00:00 | SPY | ETF | 101.41 | 101.45 | 101.2 | 101.42 | 403900.0 |
| 2001-09-25 11:05:00 | SPY | ETF | 101.45 | 101.53 | 101.34 | 101.4 | 362600.0 |
| 2001-09-25 11:10:00 | SPY | ETF | 101.44 | 101.83 | 101.42 | 101.77 | 371900.0 |
| 2001-09-25 11:15:00 | SPY | ETF | 101.72 | 101.79 | 101.57 | 101.64 | 290400.0 |
| 2001-09-25 11:20:00 | SPY | ETF | 101.64 | 101.79 | 101.58 | 101.65 | 124400.0 |
| 2001-09-25 11:25:00 | SPY | ETF | 101.74 | 101.8 | 101.61 | 101.62 | 197000.0 |
| 2001-09-25 11:30:00 | SPY | ETF | 101.68 | 101.74 | 101.55 | 101.69 | 304000.0 |
| 2001-09-25 11:35:00 | SPY | ETF | 101.75 | 101.95 | 101.7 | 101.95 | 643300.0 |
| 2001-09-25 11:40:00 | SPY | ETF | 101.91 | 101.98 | 101.68 | 101.78 | 313800.0 |
| 2001-09-25 11:45:00 | SPY | ETF | 101.71 | 101.9 | 101.68 | 101.78 | 284900.0 |
| 2001-09-25 11:50:00 | SPY | ETF | 101.8 | 101.8 | 101.55 | 101.65 | 108300.0 |
| 2001-09-25 11:55:00 | SPY | ETF | 101.65 | 101.74 | 101.54 | 101.54 | 109500.0 |
| 2001-09-25 12:00:00 | SPY | ETF | 101.51 | 101.55 | 101.35 | 101.49 | 213700.0 |
| 2001-09-25 12:05:00 | SPY | ETF | 101.45 | 101.46 | 101.01 | 101.1 | 298400.0 |
| 2001-09-25 12:10:00 | SPY | ETF | 101.13 | 101.23 | 101.07 | 101.14 | 353200.0 |
| 2001-09-25 12:15:00 | SPY | ETF | 101.11 | 101.35 | 101.11 | 101.21 | 146500.0 |
| 2001-09-25 12:20:00 | SPY | ETF | 101.24 | 101.24 | 100.78 | 100.86 | 128700.0 |
| 2001-09-25 12:25:00 | SPY | ETF | 100.9 | 100.95 | 100.69 | 100.9 | 293800.0 |
| 2001-09-25 12:30:00 | SPY | ETF | 100.82 | 100.95 | 100.51 | 100.67 | 222500.0 |
| 2001-09-25 12:35:00 | SPY | ETF | 100.59 | 100.78 | 100.5 | 100.77 | 156600.0 |
| 2001-09-25 12:40:00 | SPY | ETF | 100.75 | 100.85 | 100.6 | 100.67 | 160200.0 |
| 2001-09-25 12:45:00 | SPY | ETF | 100.75 | 100.82 | 100.56 | 100.56 | 101700.0 |
| 2001-09-25 12:50:00 | SPY | ETF | 100.6 | 100.7 | 100.5 | 100.65 | 181500.0 |
| 2001-09-25 12:55:00 | SPY | ETF | 100.67 | 100.84 | 100.64 | 100.79 | 200200.0 |
| 2001-09-25 13:00:00 | SPY | ETF | 100.79 | 100.9 | 100.7 | 100.9 | 180600.0 |
| 2001-09-25 13:05:00 | SPY | ETF | 100.91 | 100.98 | 100.76 | 100.8 | 168300.0 |
| 2001-09-25 13:10:00 | SPY | ETF | 100.85 | 100.92 | 100.72 | 100.84 | 147100.0 |
| 2001-09-25 13:15:00 | SPY | ETF | 100.85 | 100.92 | 100.76 | 100.8 | 182600.0 |
| 2001-09-25 13:20:00 | SPY | ETF | 100.75 | 100.78 | 100.51 | 100.52 | 115500.0 |
| 2001-09-25 13:25:00 | SPY | ETF | 100.48 | 100.59 | 100.36 | 100.48 | 175400.0 |
| 2001-09-25 13:30:00 | SPY | ETF | 100.55 | 100.6 | 100.15 | 100.25 | 258800.0 |
| 2001-09-25 13:35:00 | SPY | ETF | 100.29 | 100.38 | 100.11 | 100.12 | 177600.0 |
> showing 50 of 1,563 rows — these rows as CSV