PREVIEW / etf_5min / 2001-03-23
file: by_date/etf_5min/2001/2001-03-23.parquet size: 30 KB rows: 1,149
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-03-23 09:30:00 | SPY | ETF | 113.25 | 113.25 | 112.7 | 112.72 | 687400.0 |
| 2001-03-23 09:35:00 | SPY | ETF | 112.8 | 113.04 | 112.5 | 112.99 | 433000.0 |
| 2001-03-23 09:40:00 | SPY | ETF | 112.9 | 113.0 | 112.55 | 112.79 | 308400.0 |
| 2001-03-23 09:45:00 | SPY | ETF | 112.7 | 112.7 | 112.22 | 112.4 | 281900.0 |
| 2001-03-23 09:50:00 | SPY | ETF | 112.28 | 112.45 | 111.83 | 111.85 | 215000.0 |
| 2001-03-23 09:55:00 | SPY | ETF | 111.99 | 112.37 | 111.86 | 112.19 | 567500.0 |
| 2001-03-23 10:00:00 | SPY | ETF | 112.14 | 112.8 | 111.92 | 112.8 | 306200.0 |
| 2001-03-23 10:05:00 | SPY | ETF | 112.8 | 113.12 | 112.8 | 112.92 | 204600.0 |
| 2001-03-23 10:10:00 | SPY | ETF | 112.9 | 112.96 | 112.52 | 112.9 | 143000.0 |
| 2001-03-23 10:15:00 | SPY | ETF | 113.0 | 113.0 | 112.5 | 112.53 | 283000.0 |
| 2001-03-23 10:20:00 | SPY | ETF | 112.52 | 112.55 | 112.0 | 112.16 | 131900.0 |
| 2001-03-23 10:25:00 | SPY | ETF | 112.14 | 112.54 | 112.04 | 112.54 | 81400.0 |
| 2001-03-23 10:30:00 | SPY | ETF | 112.42 | 112.75 | 112.4 | 112.5 | 148800.0 |
| 2001-03-23 10:35:00 | SPY | ETF | 112.61 | 112.97 | 112.61 | 112.89 | 45300.0 |
| 2001-03-23 10:40:00 | SPY | ETF | 112.78 | 113.35 | 112.78 | 113.2 | 258100.0 |
| 2001-03-23 10:45:00 | SPY | ETF | 113.25 | 113.3 | 113.0 | 113.16 | 456100.0 |
| 2001-03-23 10:50:00 | SPY | ETF | 113.3 | 113.3 | 112.94 | 113.13 | 236700.0 |
| 2001-03-23 10:55:00 | SPY | ETF | 113.14 | 113.3 | 112.92 | 113.15 | 157500.0 |
| 2001-03-23 11:00:00 | SPY | ETF | 113.15 | 113.55 | 113.15 | 113.48 | 253100.0 |
| 2001-03-23 11:05:00 | SPY | ETF | 113.5 | 113.88 | 113.42 | 113.7 | 216600.0 |
| 2001-03-23 11:10:00 | SPY | ETF | 113.75 | 113.95 | 113.62 | 113.7 | 314600.0 |
| 2001-03-23 11:15:00 | SPY | ETF | 113.73 | 113.77 | 113.61 | 113.7 | 71600.0 |
| 2001-03-23 11:20:00 | SPY | ETF | 113.67 | 113.75 | 113.38 | 113.5 | 77200.0 |
| 2001-03-23 11:25:00 | SPY | ETF | 113.43 | 113.56 | 113.26 | 113.5 | 104600.0 |
| 2001-03-23 11:30:00 | SPY | ETF | 113.55 | 113.89 | 113.5 | 113.73 | 31600.0 |
| 2001-03-23 11:35:00 | SPY | ETF | 113.82 | 113.85 | 113.28 | 113.28 | 35600.0 |
| 2001-03-23 11:40:00 | SPY | ETF | 113.37 | 113.45 | 113.2 | 113.26 | 171100.0 |
| 2001-03-23 11:45:00 | SPY | ETF | 113.16 | 113.53 | 113.05 | 113.53 | 117700.0 |
| 2001-03-23 11:50:00 | SPY | ETF | 113.55 | 113.64 | 113.3 | 113.38 | 125500.0 |
| 2001-03-23 11:55:00 | SPY | ETF | 113.31 | 113.35 | 113.1 | 113.25 | 18500.0 |
| 2001-03-23 12:00:00 | SPY | ETF | 113.3 | 113.3 | 112.88 | 113.01 | 112800.0 |
| 2001-03-23 12:05:00 | SPY | ETF | 113.0 | 113.16 | 112.85 | 113.16 | 65600.0 |
| 2001-03-23 12:10:00 | SPY | ETF | 113.01 | 113.22 | 112.87 | 113.0 | 60100.0 |
| 2001-03-23 12:15:00 | SPY | ETF | 112.92 | 113.25 | 112.86 | 113.15 | 198400.0 |
| 2001-03-23 12:20:00 | SPY | ETF | 113.15 | 113.45 | 113.15 | 113.3 | 46900.0 |
| 2001-03-23 12:25:00 | SPY | ETF | 113.28 | 113.39 | 113.06 | 113.06 | 24500.0 |
| 2001-03-23 12:30:00 | SPY | ETF | 113.16 | 113.16 | 112.75 | 112.75 | 58100.0 |
| 2001-03-23 12:35:00 | SPY | ETF | 112.75 | 112.9 | 112.51 | 112.65 | 99700.0 |
| 2001-03-23 12:40:00 | SPY | ETF | 112.7 | 112.77 | 112.4 | 112.65 | 124400.0 |
| 2001-03-23 12:45:00 | SPY | ETF | 112.7 | 112.96 | 112.56 | 112.96 | 47000.0 |
| 2001-03-23 12:50:00 | SPY | ETF | 112.82 | 113.05 | 112.82 | 112.91 | 53900.0 |
| 2001-03-23 12:55:00 | SPY | ETF | 112.91 | 112.91 | 112.5 | 112.68 | 82400.0 |
| 2001-03-23 13:00:00 | SPY | ETF | 112.8 | 113.1 | 112.78 | 113.09 | 72800.0 |
| 2001-03-23 13:05:00 | SPY | ETF | 113.1 | 113.46 | 113.1 | 113.42 | 40300.0 |
| 2001-03-23 13:10:00 | SPY | ETF | 113.41 | 113.42 | 113.03 | 113.1 | 46700.0 |
| 2001-03-23 13:15:00 | SPY | ETF | 113.08 | 113.55 | 113.03 | 113.34 | 73400.0 |
| 2001-03-23 13:20:00 | SPY | ETF | 113.32 | 113.53 | 113.26 | 113.53 | 36100.0 |
| 2001-03-23 13:25:00 | SPY | ETF | 113.54 | 113.7 | 113.35 | 113.47 | 78200.0 |
| 2001-03-23 13:30:00 | SPY | ETF | 113.36 | 113.69 | 113.35 | 113.55 | 13000.0 |
| 2001-03-23 13:35:00 | SPY | ETF | 113.51 | 113.77 | 113.51 | 113.71 | 56900.0 |
> showing 50 of 1,149 rows — these rows as CSV