PREVIEW / etf_5min / 2001-12-24
file: by_date/etf_5min/2001/2001-12-24.parquet size: 22 KB rows: 853
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-12-24 09:30:00 | SPY | ETF | 114.83 | 114.99 | 114.8 | 114.95 | 517300.0 |
| 2001-12-24 09:35:00 | SPY | ETF | 114.95 | 115.0 | 114.87 | 114.91 | 256600.0 |
| 2001-12-24 09:40:00 | SPY | ETF | 114.94 | 115.02 | 114.9 | 114.93 | 327500.0 |
| 2001-12-24 09:45:00 | SPY | ETF | 114.93 | 114.97 | 114.9 | 114.93 | 178400.0 |
| 2001-12-24 09:50:00 | SPY | ETF | 114.95 | 115.04 | 114.93 | 114.96 | 172900.0 |
| 2001-12-24 09:55:00 | SPY | ETF | 114.95 | 115.0 | 114.86 | 114.87 | 100900.0 |
| 2001-12-24 10:00:00 | SPY | ETF | 114.85 | 114.92 | 114.78 | 114.78 | 129800.0 |
| 2001-12-24 10:05:00 | SPY | ETF | 114.8 | 114.86 | 114.8 | 114.86 | 44200.0 |
| 2001-12-24 10:10:00 | SPY | ETF | 114.86 | 114.93 | 114.84 | 114.91 | 155300.0 |
| 2001-12-24 10:15:00 | SPY | ETF | 114.91 | 114.91 | 114.85 | 114.9 | 127100.0 |
| 2001-12-24 10:20:00 | SPY | ETF | 114.85 | 114.97 | 114.85 | 114.9 | 80900.0 |
| 2001-12-24 10:25:00 | SPY | ETF | 114.94 | 115.02 | 114.9 | 114.93 | 130600.0 |
| 2001-12-24 10:30:00 | SPY | ETF | 114.92 | 114.98 | 114.92 | 114.94 | 34500.0 |
| 2001-12-24 10:35:00 | SPY | ETF | 114.92 | 114.97 | 114.92 | 114.94 | 24800.0 |
| 2001-12-24 10:40:00 | SPY | ETF | 114.99 | 115.0 | 114.95 | 114.95 | 157600.0 |
| 2001-12-24 10:45:00 | SPY | ETF | 114.96 | 114.97 | 114.9 | 114.9 | 22300.0 |
| 2001-12-24 10:50:00 | SPY | ETF | 114.94 | 114.95 | 114.88 | 114.9 | 39600.0 |
| 2001-12-24 10:55:00 | SPY | ETF | 114.9 | 114.95 | 114.88 | 114.9 | 69500.0 |
| 2001-12-24 11:00:00 | SPY | ETF | 114.9 | 114.94 | 114.88 | 114.91 | 23200.0 |
| 2001-12-24 11:05:00 | SPY | ETF | 114.94 | 114.94 | 114.89 | 114.89 | 48200.0 |
| 2001-12-24 11:10:00 | SPY | ETF | 114.89 | 114.94 | 114.89 | 114.9 | 30500.0 |
| 2001-12-24 11:15:00 | SPY | ETF | 114.93 | 114.94 | 114.9 | 114.93 | 51500.0 |
| 2001-12-24 11:20:00 | SPY | ETF | 114.95 | 114.98 | 114.86 | 114.91 | 41400.0 |
| 2001-12-24 11:25:00 | SPY | ETF | 114.87 | 114.95 | 114.87 | 114.94 | 56400.0 |
| 2001-12-24 11:30:00 | SPY | ETF | 114.94 | 114.99 | 114.92 | 114.98 | 54700.0 |
| 2001-12-24 11:35:00 | SPY | ETF | 114.93 | 114.95 | 114.84 | 114.84 | 50900.0 |
| 2001-12-24 11:40:00 | SPY | ETF | 114.85 | 114.88 | 114.81 | 114.82 | 37000.0 |
| 2001-12-24 11:45:00 | SPY | ETF | 114.83 | 114.86 | 114.79 | 114.84 | 68800.0 |
| 2001-12-24 11:50:00 | SPY | ETF | 114.84 | 114.85 | 114.75 | 114.78 | 23400.0 |
| 2001-12-24 11:55:00 | SPY | ETF | 114.77 | 114.85 | 114.77 | 114.84 | 27300.0 |
| 2001-12-24 12:00:00 | SPY | ETF | 114.81 | 114.84 | 114.77 | 114.79 | 36900.0 |
| 2001-12-24 12:05:00 | SPY | ETF | 114.82 | 114.85 | 114.8 | 114.85 | 130300.0 |
| 2001-12-24 12:10:00 | SPY | ETF | 114.82 | 114.85 | 114.8 | 114.82 | 35600.0 |
| 2001-12-24 12:15:00 | SPY | ETF | 114.84 | 114.89 | 114.82 | 114.89 | 93600.0 |
| 2001-12-24 12:20:00 | SPY | ETF | 114.87 | 114.91 | 114.85 | 114.85 | 114600.0 |
| 2001-12-24 12:25:00 | SPY | ETF | 114.85 | 114.93 | 114.84 | 114.93 | 99700.0 |
| 2001-12-24 12:30:00 | SPY | ETF | 114.9 | 114.9 | 114.86 | 114.86 | 102700.0 |
| 2001-12-24 12:35:00 | SPY | ETF | 114.86 | 114.89 | 114.85 | 114.87 | 138500.0 |
| 2001-12-24 12:40:00 | SPY | ETF | 114.88 | 114.9 | 114.85 | 114.86 | 82600.0 |
| 2001-12-24 12:45:00 | SPY | ETF | 114.9 | 114.9 | 114.79 | 114.82 | 49500.0 |
| 2001-12-24 12:50:00 | SPY | ETF | 114.79 | 114.84 | 114.73 | 114.8 | 260500.0 |
| 2001-12-24 12:55:00 | SPY | ETF | 114.8 | 114.83 | 114.72 | 114.77 | 196500.0 |
| 2001-12-24 13:00:00 | SPY | ETF | 114.72 | 114.74 | 114.61 | 114.67 | 1104500.0 |
| 2001-12-24 13:05:00 | SPY | ETF | 114.68 | 114.7 | 114.62 | 114.7 | 56000.0 |
| 2001-12-24 13:10:00 | SPY | ETF | 114.7 | 114.77 | 114.68 | 114.76 | 38000.0 |
| 2001-12-24 13:15:00 | SPY | ETF | 114.76 | 114.76 | 114.73 | 114.73 | 23000.0 |
| 2001-12-24 09:30:00 | QQQ | ETF | 39.54 | 39.63 | 39.45 | 39.59 | 835300.0 |
| 2001-12-24 09:35:00 | QQQ | ETF | 39.61 | 39.63 | 39.5 | 39.53 | 530600.0 |
| 2001-12-24 09:40:00 | QQQ | ETF | 39.51 | 39.56 | 39.49 | 39.5 | 356700.0 |
| 2001-12-24 09:45:00 | QQQ | ETF | 39.5 | 39.54 | 39.48 | 39.54 | 301300.0 |
> showing 50 of 853 rows — these rows as CSV