PREVIEW / etf_5min / 2001-02-27
file: by_date/etf_5min/2001/2001-02-27.parquet size: 30 KB rows: 1,139
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-02-27 09:30:00 | SPY | ETF | 126.8 | 127.05 | 126.75 | 127.0 | 479400.0 |
| 2001-02-27 09:35:00 | SPY | ETF | 127.1 | 127.1 | 126.82 | 126.95 | 103700.0 |
| 2001-02-27 09:40:00 | SPY | ETF | 126.9 | 127.05 | 126.78 | 126.8 | 373200.0 |
| 2001-02-27 09:45:00 | SPY | ETF | 126.93 | 127.05 | 126.75 | 126.85 | 156500.0 |
| 2001-02-27 09:50:00 | SPY | ETF | 126.9 | 127.09 | 126.83 | 126.99 | 119400.0 |
| 2001-02-27 09:55:00 | SPY | ETF | 126.89 | 127.25 | 126.81 | 127.17 | 182600.0 |
| 2001-02-27 10:00:00 | SPY | ETF | 127.05 | 127.6 | 126.91 | 126.91 | 543800.0 |
| 2001-02-27 10:05:00 | SPY | ETF | 127.0 | 127.4 | 126.2 | 126.25 | 391800.0 |
| 2001-02-27 10:10:00 | SPY | ETF | 126.25 | 126.55 | 126.0 | 126.48 | 171300.0 |
| 2001-02-27 10:15:00 | SPY | ETF | 126.48 | 126.58 | 126.32 | 126.57 | 102400.0 |
| 2001-02-27 10:20:00 | SPY | ETF | 126.5 | 126.5 | 126.1 | 126.48 | 197100.0 |
| 2001-02-27 10:25:00 | SPY | ETF | 126.31 | 126.85 | 126.3 | 126.6 | 81300.0 |
| 2001-02-27 10:30:00 | SPY | ETF | 126.58 | 126.67 | 126.4 | 126.51 | 148500.0 |
| 2001-02-27 10:35:00 | SPY | ETF | 126.59 | 126.65 | 126.2 | 126.2 | 138500.0 |
| 2001-02-27 10:40:00 | SPY | ETF | 126.16 | 126.26 | 126.01 | 126.25 | 80300.0 |
| 2001-02-27 10:45:00 | SPY | ETF | 126.3 | 126.59 | 126.2 | 126.59 | 384900.0 |
| 2001-02-27 10:50:00 | SPY | ETF | 126.55 | 126.59 | 126.25 | 126.55 | 106600.0 |
| 2001-02-27 10:55:00 | SPY | ETF | 126.6 | 126.79 | 126.56 | 126.61 | 139700.0 |
| 2001-02-27 11:00:00 | SPY | ETF | 126.6 | 126.76 | 126.5 | 126.65 | 36500.0 |
| 2001-02-27 11:05:00 | SPY | ETF | 126.55 | 126.74 | 126.41 | 126.7 | 17700.0 |
| 2001-02-27 11:10:00 | SPY | ETF | 126.68 | 127.09 | 126.64 | 127.09 | 46700.0 |
| 2001-02-27 11:15:00 | SPY | ETF | 127.0 | 127.09 | 126.82 | 126.94 | 38700.0 |
| 2001-02-27 11:20:00 | SPY | ETF | 126.85 | 127.19 | 126.81 | 127.1 | 152000.0 |
| 2001-02-27 11:25:00 | SPY | ETF | 127.0 | 127.19 | 126.95 | 127.19 | 156100.0 |
| 2001-02-27 11:30:00 | SPY | ETF | 127.19 | 127.61 | 127.11 | 127.6 | 392400.0 |
| 2001-02-27 11:35:00 | SPY | ETF | 127.62 | 127.84 | 127.55 | 127.7 | 695300.0 |
| 2001-02-27 11:40:00 | SPY | ETF | 127.69 | 127.69 | 127.4 | 127.55 | 443700.0 |
| 2001-02-27 11:45:00 | SPY | ETF | 127.5 | 127.66 | 127.4 | 127.6 | 104200.0 |
| 2001-02-27 11:50:00 | SPY | ETF | 127.61 | 127.75 | 127.4 | 127.6 | 163700.0 |
| 2001-02-27 11:55:00 | SPY | ETF | 127.55 | 127.74 | 127.54 | 127.55 | 78900.0 |
| 2001-02-27 12:00:00 | SPY | ETF | 127.66 | 127.73 | 127.52 | 127.7 | 221800.0 |
| 2001-02-27 12:05:00 | SPY | ETF | 127.52 | 127.64 | 127.32 | 127.32 | 32500.0 |
| 2001-02-27 12:10:00 | SPY | ETF | 127.33 | 127.55 | 127.33 | 127.45 | 20800.0 |
| 2001-02-27 12:15:00 | SPY | ETF | 127.5 | 127.5 | 127.27 | 127.41 | 27800.0 |
| 2001-02-27 12:20:00 | SPY | ETF | 127.38 | 127.45 | 127.28 | 127.43 | 34900.0 |
| 2001-02-27 12:25:00 | SPY | ETF | 127.43 | 127.43 | 127.26 | 127.35 | 30100.0 |
| 2001-02-27 12:30:00 | SPY | ETF | 127.3 | 127.4 | 127.22 | 127.4 | 32000.0 |
| 2001-02-27 12:35:00 | SPY | ETF | 127.4 | 127.55 | 127.38 | 127.55 | 49900.0 |
| 2001-02-27 12:40:00 | SPY | ETF | 127.55 | 127.57 | 127.35 | 127.45 | 92900.0 |
| 2001-02-27 12:45:00 | SPY | ETF | 127.44 | 127.49 | 127.01 | 127.12 | 60000.0 |
| 2001-02-27 12:50:00 | SPY | ETF | 127.0 | 127.13 | 126.89 | 127.13 | 202700.0 |
| 2001-02-27 12:55:00 | SPY | ETF | 127.05 | 127.25 | 127.02 | 127.18 | 42300.0 |
| 2001-02-27 13:00:00 | SPY | ETF | 127.15 | 127.15 | 127.0 | 127.08 | 93900.0 |
| 2001-02-27 13:05:00 | SPY | ETF | 127.15 | 127.2 | 127.01 | 127.15 | 11500.0 |
| 2001-02-27 13:10:00 | SPY | ETF | 127.13 | 127.21 | 126.85 | 126.85 | 75200.0 |
| 2001-02-27 13:15:00 | SPY | ETF | 126.85 | 126.87 | 126.48 | 126.5 | 173000.0 |
| 2001-02-27 13:20:00 | SPY | ETF | 126.62 | 126.74 | 126.55 | 126.58 | 68700.0 |
| 2001-02-27 13:25:00 | SPY | ETF | 126.55 | 126.73 | 126.45 | 126.51 | 145100.0 |
| 2001-02-27 13:30:00 | SPY | ETF | 126.51 | 126.72 | 126.31 | 126.6 | 70200.0 |
| 2001-02-27 13:35:00 | SPY | ETF | 126.4 | 126.7 | 126.4 | 126.65 | 75000.0 |
> showing 50 of 1,139 rows — these rows as CSV