PREVIEW / etf_5min / 2001-05-24
file: by_date/etf_5min/2001/2001-05-24.parquet size: 31 KB rows: 1,250
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-05-24 09:30:00 | SPY | ETF | 129.47 | 129.58 | 129.36 | 129.43 | 183000.0 |
| 2001-05-24 09:35:00 | SPY | ETF | 129.36 | 129.49 | 129.18 | 129.18 | 148100.0 |
| 2001-05-24 09:40:00 | SPY | ETF | 129.24 | 129.59 | 129.17 | 129.5 | 239700.0 |
| 2001-05-24 09:45:00 | SPY | ETF | 129.46 | 129.75 | 129.46 | 129.6 | 346100.0 |
| 2001-05-24 09:50:00 | SPY | ETF | 129.67 | 129.97 | 129.57 | 129.83 | 142000.0 |
| 2001-05-24 09:55:00 | SPY | ETF | 129.83 | 130.0 | 129.77 | 129.84 | 305100.0 |
| 2001-05-24 10:00:00 | SPY | ETF | 129.84 | 129.84 | 129.66 | 129.77 | 122400.0 |
| 2001-05-24 10:05:00 | SPY | ETF | 129.77 | 129.93 | 129.62 | 129.62 | 88700.0 |
| 2001-05-24 10:10:00 | SPY | ETF | 129.61 | 129.61 | 129.36 | 129.54 | 166700.0 |
| 2001-05-24 10:15:00 | SPY | ETF | 129.58 | 129.59 | 129.41 | 129.5 | 44100.0 |
| 2001-05-24 10:20:00 | SPY | ETF | 129.49 | 129.54 | 129.18 | 129.18 | 199600.0 |
| 2001-05-24 10:25:00 | SPY | ETF | 129.18 | 129.22 | 128.98 | 129.0 | 278000.0 |
| 2001-05-24 10:30:00 | SPY | ETF | 128.96 | 129.09 | 128.91 | 129.06 | 177200.0 |
| 2001-05-24 10:35:00 | SPY | ETF | 129.06 | 129.06 | 128.83 | 129.04 | 124500.0 |
| 2001-05-24 10:40:00 | SPY | ETF | 129.08 | 129.1 | 128.95 | 128.95 | 53900.0 |
| 2001-05-24 10:45:00 | SPY | ETF | 128.98 | 129.16 | 128.92 | 129.13 | 74400.0 |
| 2001-05-24 10:50:00 | SPY | ETF | 129.11 | 129.14 | 128.89 | 128.89 | 102600.0 |
| 2001-05-24 10:55:00 | SPY | ETF | 128.88 | 128.97 | 128.68 | 128.75 | 158600.0 |
| 2001-05-24 11:00:00 | SPY | ETF | 128.75 | 128.8 | 128.68 | 128.68 | 80300.0 |
| 2001-05-24 11:05:00 | SPY | ETF | 128.67 | 128.79 | 128.62 | 128.78 | 100700.0 |
| 2001-05-24 11:10:00 | SPY | ETF | 128.75 | 128.84 | 128.62 | 128.65 | 63800.0 |
| 2001-05-24 11:15:00 | SPY | ETF | 128.64 | 128.86 | 128.64 | 128.86 | 35800.0 |
| 2001-05-24 11:20:00 | SPY | ETF | 128.81 | 128.96 | 128.79 | 128.96 | 31500.0 |
| 2001-05-24 11:25:00 | SPY | ETF | 129.03 | 129.03 | 128.85 | 128.85 | 151800.0 |
| 2001-05-24 11:30:00 | SPY | ETF | 128.85 | 128.99 | 128.69 | 128.79 | 24200.0 |
| 2001-05-24 11:35:00 | SPY | ETF | 128.79 | 128.85 | 128.72 | 128.79 | 25500.0 |
| 2001-05-24 11:40:00 | SPY | ETF | 128.89 | 128.96 | 128.8 | 128.8 | 76900.0 |
| 2001-05-24 11:45:00 | SPY | ETF | 128.8 | 128.93 | 128.72 | 128.83 | 92900.0 |
| 2001-05-24 11:50:00 | SPY | ETF | 128.79 | 129.08 | 128.78 | 128.97 | 49400.0 |
| 2001-05-24 11:55:00 | SPY | ETF | 128.96 | 129.06 | 128.94 | 129.0 | 58100.0 |
| 2001-05-24 12:00:00 | SPY | ETF | 129.06 | 129.09 | 128.99 | 129.04 | 105100.0 |
| 2001-05-24 12:05:00 | SPY | ETF | 128.99 | 129.03 | 128.92 | 129.01 | 25600.0 |
| 2001-05-24 12:10:00 | SPY | ETF | 129.04 | 129.07 | 128.9 | 129.0 | 25300.0 |
| 2001-05-24 12:15:00 | SPY | ETF | 129.04 | 129.06 | 128.98 | 129.05 | 29400.0 |
| 2001-05-24 12:20:00 | SPY | ETF | 129.0 | 129.03 | 128.78 | 128.85 | 82100.0 |
| 2001-05-24 12:25:00 | SPY | ETF | 128.8 | 128.96 | 128.8 | 128.96 | 50000.0 |
| 2001-05-24 12:30:00 | SPY | ETF | 128.96 | 129.04 | 128.84 | 128.84 | 19800.0 |
| 2001-05-24 12:35:00 | SPY | ETF | 128.86 | 128.86 | 128.72 | 128.83 | 47000.0 |
| 2001-05-24 12:40:00 | SPY | ETF | 128.81 | 128.94 | 128.75 | 128.89 | 14100.0 |
| 2001-05-24 12:45:00 | SPY | ETF | 128.89 | 128.94 | 128.7 | 128.71 | 28400.0 |
| 2001-05-24 12:50:00 | SPY | ETF | 128.7 | 128.8 | 128.68 | 128.8 | 8800.0 |
| 2001-05-24 12:55:00 | SPY | ETF | 128.83 | 128.83 | 128.67 | 128.67 | 28300.0 |
| 2001-05-24 13:00:00 | SPY | ETF | 128.65 | 128.85 | 128.63 | 128.83 | 140400.0 |
| 2001-05-24 13:05:00 | SPY | ETF | 128.8 | 128.81 | 128.71 | 128.79 | 20300.0 |
| 2001-05-24 13:10:00 | SPY | ETF | 128.8 | 128.94 | 128.76 | 128.9 | 25900.0 |
| 2001-05-24 13:15:00 | SPY | ETF | 128.95 | 129.02 | 128.87 | 129.02 | 24000.0 |
| 2001-05-24 13:20:00 | SPY | ETF | 128.97 | 128.97 | 128.82 | 128.87 | 34000.0 |
| 2001-05-24 13:25:00 | SPY | ETF | 128.83 | 128.87 | 128.65 | 128.65 | 49900.0 |
| 2001-05-24 13:30:00 | SPY | ETF | 128.73 | 128.74 | 128.61 | 128.64 | 49200.0 |
| 2001-05-24 13:35:00 | SPY | ETF | 128.6 | 128.78 | 128.6 | 128.64 | 53300.0 |
> showing 50 of 1,250 rows — these rows as CSV