PREVIEW / etf_5min / 2001-05-23
file: by_date/etf_5min/2001/2001-05-23.parquet size: 32 KB rows: 1,342
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-23 09:30:00 | SPY | ETF | 131.05 | 131.05 | 130.8 | 130.8 | 457600.0 |
| 2001-05-23 09:35:00 | SPY | ETF | 130.88 | 130.99 | 130.75 | 130.85 | 200800.0 |
| 2001-05-23 09:40:00 | SPY | ETF | 130.81 | 130.98 | 130.76 | 130.91 | 157200.0 |
| 2001-05-23 09:45:00 | SPY | ETF | 130.93 | 130.96 | 130.61 | 130.61 | 226700.0 |
| 2001-05-23 09:50:00 | SPY | ETF | 130.6 | 130.68 | 130.41 | 130.63 | 115700.0 |
| 2001-05-23 09:55:00 | SPY | ETF | 130.63 | 130.74 | 130.31 | 130.4 | 225100.0 |
| 2001-05-23 10:00:00 | SPY | ETF | 130.38 | 130.47 | 130.19 | 130.21 | 207300.0 |
| 2001-05-23 10:05:00 | SPY | ETF | 130.29 | 130.48 | 130.21 | 130.48 | 82300.0 |
| 2001-05-23 10:10:00 | SPY | ETF | 130.47 | 130.47 | 130.25 | 130.36 | 165600.0 |
| 2001-05-23 10:15:00 | SPY | ETF | 130.38 | 130.44 | 130.0 | 130.06 | 247700.0 |
| 2001-05-23 10:20:00 | SPY | ETF | 130.06 | 130.12 | 129.95 | 129.96 | 372900.0 |
| 2001-05-23 10:25:00 | SPY | ETF | 129.99 | 130.14 | 129.99 | 130.11 | 75100.0 |
| 2001-05-23 10:30:00 | SPY | ETF | 130.11 | 130.15 | 129.82 | 129.92 | 117400.0 |
| 2001-05-23 10:35:00 | SPY | ETF | 129.9 | 130.0 | 129.8 | 129.84 | 78400.0 |
| 2001-05-23 10:40:00 | SPY | ETF | 129.87 | 130.08 | 129.81 | 130.06 | 64700.0 |
| 2001-05-23 10:45:00 | SPY | ETF | 130.06 | 130.15 | 129.93 | 130.13 | 136800.0 |
| 2001-05-23 10:50:00 | SPY | ETF | 130.13 | 130.22 | 130.06 | 130.11 | 101000.0 |
| 2001-05-23 10:55:00 | SPY | ETF | 130.15 | 130.18 | 129.96 | 130.18 | 232500.0 |
| 2001-05-23 11:00:00 | SPY | ETF | 130.17 | 130.19 | 130.05 | 130.16 | 74800.0 |
| 2001-05-23 11:05:00 | SPY | ETF | 130.1 | 130.13 | 129.81 | 129.81 | 66500.0 |
| 2001-05-23 11:10:00 | SPY | ETF | 129.86 | 129.86 | 129.59 | 129.7 | 168200.0 |
| 2001-05-23 11:15:00 | SPY | ETF | 129.65 | 129.75 | 129.65 | 129.68 | 83300.0 |
| 2001-05-23 11:20:00 | SPY | ETF | 129.68 | 129.81 | 129.6 | 129.6 | 122000.0 |
| 2001-05-23 11:25:00 | SPY | ETF | 129.59 | 129.61 | 129.45 | 129.48 | 265800.0 |
| 2001-05-23 11:30:00 | SPY | ETF | 129.54 | 129.7 | 129.47 | 129.6 | 97300.0 |
| 2001-05-23 11:35:00 | SPY | ETF | 129.69 | 129.69 | 129.52 | 129.6 | 335600.0 |
| 2001-05-23 11:40:00 | SPY | ETF | 129.63 | 129.76 | 129.61 | 129.74 | 288300.0 |
| 2001-05-23 11:45:00 | SPY | ETF | 129.76 | 129.81 | 129.66 | 129.8 | 17000.0 |
| 2001-05-23 11:50:00 | SPY | ETF | 129.81 | 129.9 | 129.77 | 129.84 | 28900.0 |
| 2001-05-23 11:55:00 | SPY | ETF | 129.84 | 129.91 | 129.77 | 129.86 | 72400.0 |
| 2001-05-23 12:00:00 | SPY | ETF | 129.9 | 130.07 | 129.84 | 130.07 | 129100.0 |
| 2001-05-23 12:05:00 | SPY | ETF | 130.05 | 130.09 | 129.97 | 129.97 | 306100.0 |
| 2001-05-23 12:10:00 | SPY | ETF | 129.99 | 129.99 | 129.87 | 129.98 | 73300.0 |
| 2001-05-23 12:15:00 | SPY | ETF | 129.95 | 130.0 | 129.9 | 130.0 | 28900.0 |
| 2001-05-23 12:20:00 | SPY | ETF | 130.01 | 130.14 | 129.97 | 130.08 | 119400.0 |
| 2001-05-23 12:25:00 | SPY | ETF | 130.07 | 130.09 | 129.81 | 129.85 | 42100.0 |
| 2001-05-23 12:30:00 | SPY | ETF | 129.83 | 129.89 | 129.77 | 129.86 | 143600.0 |
| 2001-05-23 12:35:00 | SPY | ETF | 129.85 | 129.92 | 129.85 | 129.91 | 14700.0 |
| 2001-05-23 12:40:00 | SPY | ETF | 129.82 | 130.09 | 129.82 | 130.01 | 63600.0 |
| 2001-05-23 12:45:00 | SPY | ETF | 130.0 | 130.07 | 129.95 | 130.06 | 9800.0 |
| 2001-05-23 12:50:00 | SPY | ETF | 130.07 | 130.2 | 130.01 | 130.01 | 57400.0 |
| 2001-05-23 12:55:00 | SPY | ETF | 130.0 | 130.1 | 129.93 | 129.96 | 29900.0 |
| 2001-05-23 13:00:00 | SPY | ETF | 129.98 | 130.1 | 129.86 | 129.86 | 33000.0 |
| 2001-05-23 13:05:00 | SPY | ETF | 129.88 | 129.99 | 129.75 | 129.99 | 54500.0 |
| 2001-05-23 13:10:00 | SPY | ETF | 129.86 | 129.91 | 129.75 | 129.86 | 24500.0 |
| 2001-05-23 13:15:00 | SPY | ETF | 129.82 | 129.92 | 129.61 | 129.61 | 55800.0 |
| 2001-05-23 13:20:00 | SPY | ETF | 129.65 | 129.75 | 129.61 | 129.66 | 53300.0 |
| 2001-05-23 13:25:00 | SPY | ETF | 129.75 | 129.82 | 129.68 | 129.76 | 101600.0 |
| 2001-05-23 13:30:00 | SPY | ETF | 129.77 | 129.77 | 129.62 | 129.64 | 19400.0 |
| 2001-05-23 13:35:00 | SPY | ETF | 129.55 | 129.63 | 129.47 | 129.54 | 242100.0 |
> showing 50 of 1,342 rows — these rows as CSV