PREVIEW / etf_5min / 2001-11-09
file: by_date/etf_5min/2001/2001-11-09.parquet size: 34 KB rows: 1,453
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-11-09 09:30:00 | SPY | ETF | 112.25 | 112.33 | 112.05 | 112.1 | 360800.0 |
| 2001-11-09 09:35:00 | SPY | ETF | 112.1 | 112.28 | 112.02 | 112.22 | 704000.0 |
| 2001-11-09 09:40:00 | SPY | ETF | 112.22 | 112.25 | 111.96 | 111.96 | 235700.0 |
| 2001-11-09 09:45:00 | SPY | ETF | 111.95 | 112.44 | 111.94 | 112.27 | 402600.0 |
| 2001-11-09 09:50:00 | SPY | ETF | 112.44 | 112.59 | 112.14 | 112.32 | 1067100.0 |
| 2001-11-09 09:55:00 | SPY | ETF | 112.25 | 112.28 | 111.74 | 111.92 | 426500.0 |
| 2001-11-09 10:00:00 | SPY | ETF | 111.88 | 111.92 | 111.52 | 111.58 | 389100.0 |
| 2001-11-09 10:05:00 | SPY | ETF | 111.56 | 111.78 | 111.44 | 111.74 | 472300.0 |
| 2001-11-09 10:10:00 | SPY | ETF | 111.82 | 111.85 | 111.6 | 111.7 | 96200.0 |
| 2001-11-09 10:15:00 | SPY | ETF | 111.7 | 112.0 | 111.7 | 111.92 | 230100.0 |
| 2001-11-09 10:20:00 | SPY | ETF | 111.98 | 112.2 | 111.97 | 112.06 | 559800.0 |
| 2001-11-09 10:25:00 | SPY | ETF | 112.05 | 112.15 | 111.92 | 112.0 | 209400.0 |
| 2001-11-09 10:30:00 | SPY | ETF | 112.11 | 112.9 | 112.09 | 112.73 | 800000.0 |
| 2001-11-09 10:35:00 | SPY | ETF | 112.8 | 112.9 | 112.43 | 112.6 | 1768700.0 |
| 2001-11-09 10:40:00 | SPY | ETF | 112.55 | 112.6 | 112.23 | 112.27 | 246700.0 |
| 2001-11-09 10:45:00 | SPY | ETF | 112.23 | 112.4 | 112.14 | 112.28 | 177200.0 |
| 2001-11-09 10:50:00 | SPY | ETF | 112.25 | 112.36 | 112.14 | 112.28 | 76400.0 |
| 2001-11-09 10:55:00 | SPY | ETF | 112.38 | 112.44 | 112.26 | 112.31 | 270100.0 |
| 2001-11-09 11:00:00 | SPY | ETF | 112.32 | 112.38 | 112.0 | 112.01 | 184100.0 |
| 2001-11-09 11:05:00 | SPY | ETF | 112.06 | 112.1 | 111.86 | 111.9 | 107100.0 |
| 2001-11-09 11:10:00 | SPY | ETF | 111.9 | 112.15 | 111.9 | 112.15 | 158300.0 |
| 2001-11-09 11:15:00 | SPY | ETF | 112.1 | 112.3 | 112.07 | 112.13 | 430000.0 |
| 2001-11-09 11:20:00 | SPY | ETF | 112.1 | 112.28 | 112.07 | 112.2 | 169600.0 |
| 2001-11-09 11:25:00 | SPY | ETF | 112.2 | 112.2 | 111.96 | 112.12 | 152000.0 |
| 2001-11-09 11:30:00 | SPY | ETF | 112.12 | 112.27 | 112.07 | 112.26 | 33400.0 |
| 2001-11-09 11:35:00 | SPY | ETF | 112.26 | 112.26 | 112.06 | 112.2 | 27000.0 |
| 2001-11-09 11:40:00 | SPY | ETF | 112.26 | 112.4 | 112.25 | 112.4 | 160300.0 |
| 2001-11-09 11:45:00 | SPY | ETF | 112.42 | 112.43 | 112.31 | 112.39 | 121000.0 |
| 2001-11-09 11:50:00 | SPY | ETF | 112.39 | 112.44 | 112.3 | 112.34 | 23300.0 |
| 2001-11-09 11:55:00 | SPY | ETF | 112.34 | 112.35 | 112.19 | 112.23 | 73800.0 |
| 2001-11-09 12:00:00 | SPY | ETF | 112.21 | 112.32 | 112.15 | 112.15 | 128900.0 |
| 2001-11-09 12:05:00 | SPY | ETF | 112.11 | 112.22 | 112.11 | 112.22 | 379300.0 |
| 2001-11-09 12:10:00 | SPY | ETF | 112.19 | 112.3 | 112.13 | 112.14 | 53800.0 |
| 2001-11-09 12:15:00 | SPY | ETF | 112.13 | 112.2 | 112.1 | 112.18 | 107700.0 |
| 2001-11-09 12:20:00 | SPY | ETF | 112.15 | 112.15 | 112.02 | 112.15 | 27700.0 |
| 2001-11-09 12:25:00 | SPY | ETF | 112.11 | 112.17 | 112.04 | 112.13 | 143600.0 |
| 2001-11-09 12:30:00 | SPY | ETF | 112.09 | 112.28 | 112.08 | 112.22 | 53000.0 |
| 2001-11-09 12:35:00 | SPY | ETF | 112.23 | 112.28 | 112.05 | 112.1 | 27700.0 |
| 2001-11-09 12:40:00 | SPY | ETF | 112.1 | 112.24 | 112.05 | 112.22 | 147000.0 |
| 2001-11-09 12:45:00 | SPY | ETF | 112.18 | 112.25 | 112.12 | 112.22 | 65300.0 |
| 2001-11-09 12:50:00 | SPY | ETF | 112.18 | 112.36 | 112.18 | 112.33 | 68100.0 |
| 2001-11-09 12:55:00 | SPY | ETF | 112.38 | 112.48 | 112.33 | 112.43 | 105400.0 |
| 2001-11-09 13:00:00 | SPY | ETF | 112.43 | 112.62 | 112.42 | 112.55 | 84400.0 |
| 2001-11-09 13:05:00 | SPY | ETF | 112.53 | 112.58 | 112.44 | 112.56 | 301000.0 |
| 2001-11-09 13:10:00 | SPY | ETF | 112.58 | 112.71 | 112.5 | 112.62 | 147800.0 |
| 2001-11-09 13:15:00 | SPY | ETF | 112.6 | 112.75 | 112.6 | 112.75 | 92400.0 |
| 2001-11-09 13:20:00 | SPY | ETF | 112.79 | 112.79 | 112.54 | 112.59 | 71900.0 |
| 2001-11-09 13:25:00 | SPY | ETF | 112.57 | 112.68 | 112.53 | 112.64 | 75100.0 |
| 2001-11-09 13:30:00 | SPY | ETF | 112.61 | 112.74 | 112.54 | 112.54 | 28600.0 |
| 2001-11-09 13:35:00 | SPY | ETF | 112.5 | 112.62 | 112.47 | 112.55 | 132500.0 |
> showing 50 of 1,453 rows — these rows as CSV