PREVIEW / etf_5min / 2001-02-01
file: by_date/etf_5min/2001/2001-02-01.parquet size: 27 KB rows: 1,098
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-01 09:30:00 | SPY | ETF | 137.1 | 137.1 | 136.81 | 136.94 | 551300.0 |
| 2001-02-01 09:35:00 | SPY | ETF | 136.94 | 137.1 | 136.75 | 137.09 | 94200.0 |
| 2001-02-01 09:40:00 | SPY | ETF | 137.1 | 137.15 | 136.85 | 136.85 | 144800.0 |
| 2001-02-01 09:45:00 | SPY | ETF | 136.95 | 137.18 | 136.81 | 137.0 | 332800.0 |
| 2001-02-01 09:50:00 | SPY | ETF | 137.12 | 137.12 | 136.85 | 137.04 | 195300.0 |
| 2001-02-01 09:55:00 | SPY | ETF | 136.9 | 137.0 | 136.9 | 136.95 | 54400.0 |
| 2001-02-01 10:00:00 | SPY | ETF | 136.98 | 137.05 | 136.6 | 136.65 | 278100.0 |
| 2001-02-01 10:05:00 | SPY | ETF | 136.52 | 136.75 | 136.35 | 136.35 | 286500.0 |
| 2001-02-01 10:10:00 | SPY | ETF | 136.36 | 136.6 | 136.35 | 136.59 | 97800.0 |
| 2001-02-01 10:15:00 | SPY | ETF | 136.59 | 136.6 | 136.38 | 136.53 | 106400.0 |
| 2001-02-01 10:20:00 | SPY | ETF | 136.4 | 136.58 | 136.28 | 136.38 | 83000.0 |
| 2001-02-01 10:25:00 | SPY | ETF | 136.26 | 136.5 | 136.26 | 136.45 | 19500.0 |
| 2001-02-01 10:30:00 | SPY | ETF | 136.45 | 136.7 | 136.3 | 136.69 | 32100.0 |
| 2001-02-01 10:35:00 | SPY | ETF | 136.55 | 136.79 | 136.55 | 136.7 | 57900.0 |
| 2001-02-01 10:40:00 | SPY | ETF | 136.74 | 136.99 | 136.74 | 136.89 | 251900.0 |
| 2001-02-01 10:45:00 | SPY | ETF | 136.9 | 136.95 | 136.75 | 136.75 | 71400.0 |
| 2001-02-01 10:50:00 | SPY | ETF | 136.7 | 136.8 | 136.6 | 136.62 | 116000.0 |
| 2001-02-01 10:55:00 | SPY | ETF | 136.74 | 136.8 | 136.59 | 136.59 | 23200.0 |
| 2001-02-01 11:00:00 | SPY | ETF | 136.59 | 136.89 | 136.59 | 136.83 | 21400.0 |
| 2001-02-01 11:05:00 | SPY | ETF | 136.89 | 137.1 | 136.82 | 137.1 | 48100.0 |
| 2001-02-01 11:10:00 | SPY | ETF | 137.01 | 137.24 | 137.0 | 137.11 | 202600.0 |
| 2001-02-01 11:15:00 | SPY | ETF | 137.18 | 137.18 | 136.93 | 137.07 | 92900.0 |
| 2001-02-01 11:20:00 | SPY | ETF | 137.06 | 137.17 | 137.01 | 137.17 | 120100.0 |
| 2001-02-01 11:25:00 | SPY | ETF | 137.18 | 137.4 | 137.12 | 137.34 | 78500.0 |
| 2001-02-01 11:30:00 | SPY | ETF | 137.34 | 137.47 | 137.3 | 137.43 | 115200.0 |
| 2001-02-01 11:35:00 | SPY | ETF | 137.43 | 137.45 | 137.31 | 137.35 | 34600.0 |
| 2001-02-01 11:40:00 | SPY | ETF | 137.43 | 137.43 | 137.31 | 137.31 | 17400.0 |
| 2001-02-01 11:45:00 | SPY | ETF | 137.33 | 137.34 | 137.15 | 137.26 | 320600.0 |
| 2001-02-01 11:50:00 | SPY | ETF | 137.25 | 137.46 | 137.19 | 137.46 | 315700.0 |
| 2001-02-01 11:55:00 | SPY | ETF | 137.49 | 137.5 | 137.4 | 137.48 | 276800.0 |
| 2001-02-01 12:00:00 | SPY | ETF | 137.48 | 137.48 | 137.25 | 137.3 | 18300.0 |
| 2001-02-01 12:05:00 | SPY | ETF | 137.33 | 137.35 | 137.17 | 137.2 | 36000.0 |
| 2001-02-01 12:10:00 | SPY | ETF | 137.15 | 137.25 | 137.1 | 137.22 | 96600.0 |
| 2001-02-01 12:15:00 | SPY | ETF | 137.27 | 137.28 | 137.16 | 137.18 | 2900.0 |
| 2001-02-01 12:20:00 | SPY | ETF | 137.2 | 137.27 | 137.11 | 137.24 | 12600.0 |
| 2001-02-01 12:25:00 | SPY | ETF | 137.23 | 137.24 | 137.11 | 137.15 | 8600.0 |
| 2001-02-01 12:30:00 | SPY | ETF | 137.15 | 137.15 | 136.9 | 136.9 | 76100.0 |
| 2001-02-01 12:35:00 | SPY | ETF | 136.95 | 137.06 | 136.9 | 136.92 | 37100.0 |
| 2001-02-01 12:40:00 | SPY | ETF | 136.93 | 137.1 | 136.93 | 137.0 | 9400.0 |
| 2001-02-01 12:45:00 | SPY | ETF | 137.0 | 137.04 | 136.88 | 136.88 | 82200.0 |
| 2001-02-01 12:50:00 | SPY | ETF | 136.95 | 136.97 | 136.73 | 136.95 | 18100.0 |
| 2001-02-01 12:55:00 | SPY | ETF | 136.94 | 136.95 | 136.8 | 136.92 | 23200.0 |
| 2001-02-01 13:00:00 | SPY | ETF | 136.94 | 137.07 | 136.91 | 136.96 | 31800.0 |
| 2001-02-01 13:05:00 | SPY | ETF | 136.97 | 137.13 | 136.97 | 137.08 | 8000.0 |
| 2001-02-01 13:10:00 | SPY | ETF | 137.07 | 137.07 | 136.85 | 136.85 | 8500.0 |
| 2001-02-01 13:15:00 | SPY | ETF | 136.89 | 136.94 | 136.71 | 136.71 | 70400.0 |
| 2001-02-01 13:20:00 | SPY | ETF | 136.71 | 136.85 | 136.64 | 136.84 | 10100.0 |
| 2001-02-01 13:25:00 | SPY | ETF | 136.8 | 136.86 | 136.65 | 136.69 | 24900.0 |
| 2001-02-01 13:30:00 | SPY | ETF | 136.68 | 136.73 | 136.5 | 136.5 | 11000.0 |
| 2001-02-01 13:35:00 | SPY | ETF | 136.5 | 136.64 | 136.41 | 136.55 | 16700.0 |
> showing 50 of 1,098 rows — these rows as CSV