PREVIEW / etf_5min / 2001-09-18
file: by_date/etf_5min/2001/2001-09-18.parquet size: 38 KB rows: 1,592
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-09-18 09:30:00 | SPY | ETF | 104.33 | 104.7 | 104.25 | 104.68 | 832300.0 |
| 2001-09-18 09:35:00 | SPY | ETF | 104.63 | 104.68 | 104.21 | 104.29 | 420200.0 |
| 2001-09-18 09:40:00 | SPY | ETF | 104.28 | 104.3 | 103.9 | 104.02 | 284300.0 |
| 2001-09-18 09:45:00 | SPY | ETF | 104.05 | 104.08 | 103.7 | 103.98 | 963900.0 |
| 2001-09-18 09:50:00 | SPY | ETF | 104.04 | 104.25 | 103.9 | 104.18 | 242400.0 |
| 2001-09-18 09:55:00 | SPY | ETF | 104.16 | 104.45 | 104.0 | 104.33 | 749300.0 |
| 2001-09-18 10:00:00 | SPY | ETF | 104.35 | 104.45 | 104.16 | 104.3 | 240300.0 |
| 2001-09-18 10:05:00 | SPY | ETF | 104.25 | 104.45 | 104.16 | 104.3 | 402000.0 |
| 2001-09-18 10:10:00 | SPY | ETF | 104.33 | 104.85 | 104.31 | 104.79 | 562700.0 |
| 2001-09-18 10:15:00 | SPY | ETF | 104.77 | 105.0 | 104.72 | 104.88 | 417900.0 |
| 2001-09-18 10:20:00 | SPY | ETF | 104.89 | 104.95 | 104.7 | 104.82 | 176800.0 |
| 2001-09-18 10:25:00 | SPY | ETF | 104.85 | 105.05 | 104.79 | 104.8 | 232600.0 |
| 2001-09-18 10:30:00 | SPY | ETF | 104.82 | 104.83 | 104.66 | 104.73 | 571700.0 |
| 2001-09-18 10:35:00 | SPY | ETF | 104.7 | 104.85 | 104.65 | 104.75 | 496900.0 |
| 2001-09-18 10:40:00 | SPY | ETF | 104.85 | 105.05 | 104.75 | 104.95 | 164600.0 |
| 2001-09-18 10:45:00 | SPY | ETF | 104.95 | 104.99 | 104.76 | 104.9 | 182800.0 |
| 2001-09-18 10:50:00 | SPY | ETF | 104.89 | 104.93 | 104.77 | 104.9 | 75200.0 |
| 2001-09-18 10:55:00 | SPY | ETF | 104.9 | 105.19 | 104.8 | 105.12 | 153500.0 |
| 2001-09-18 11:00:00 | SPY | ETF | 105.15 | 105.15 | 104.8 | 104.89 | 156800.0 |
| 2001-09-18 11:05:00 | SPY | ETF | 104.89 | 104.9 | 104.66 | 104.78 | 390000.0 |
| 2001-09-18 11:10:00 | SPY | ETF | 104.73 | 104.85 | 104.7 | 104.8 | 190100.0 |
| 2001-09-18 11:15:00 | SPY | ETF | 104.8 | 104.9 | 104.66 | 104.9 | 84200.0 |
| 2001-09-18 11:20:00 | SPY | ETF | 104.86 | 104.94 | 104.71 | 104.71 | 80500.0 |
| 2001-09-18 11:25:00 | SPY | ETF | 104.74 | 104.87 | 104.72 | 104.82 | 246700.0 |
| 2001-09-18 11:30:00 | SPY | ETF | 104.82 | 104.82 | 104.67 | 104.7 | 195300.0 |
| 2001-09-18 11:35:00 | SPY | ETF | 104.78 | 104.8 | 104.59 | 104.64 | 163200.0 |
| 2001-09-18 11:40:00 | SPY | ETF | 104.57 | 104.72 | 104.55 | 104.63 | 92900.0 |
| 2001-09-18 11:45:00 | SPY | ETF | 104.62 | 104.74 | 104.52 | 104.62 | 100000.0 |
| 2001-09-18 11:50:00 | SPY | ETF | 104.56 | 104.63 | 104.0 | 104.55 | 184600.0 |
| 2001-09-18 11:55:00 | SPY | ETF | 104.5 | 104.67 | 104.5 | 104.5 | 76000.0 |
| 2001-09-18 12:00:00 | SPY | ETF | 104.5 | 104.6 | 104.45 | 104.52 | 103700.0 |
| 2001-09-18 12:05:00 | SPY | ETF | 104.58 | 104.75 | 104.5 | 104.65 | 103900.0 |
| 2001-09-18 12:10:00 | SPY | ETF | 104.7 | 104.72 | 104.6 | 104.69 | 156500.0 |
| 2001-09-18 12:15:00 | SPY | ETF | 104.65 | 104.74 | 104.56 | 104.69 | 62400.0 |
| 2001-09-18 12:20:00 | SPY | ETF | 104.6 | 104.68 | 104.5 | 104.66 | 79200.0 |
| 2001-09-18 12:25:00 | SPY | ETF | 104.61 | 104.71 | 104.51 | 104.59 | 349500.0 |
| 2001-09-18 12:30:00 | SPY | ETF | 104.58 | 104.63 | 104.44 | 104.6 | 85900.0 |
| 2001-09-18 12:35:00 | SPY | ETF | 104.54 | 104.7 | 104.5 | 104.66 | 40200.0 |
| 2001-09-18 12:40:00 | SPY | ETF | 104.6 | 104.7 | 104.59 | 104.65 | 615600.0 |
| 2001-09-18 12:45:00 | SPY | ETF | 104.7 | 104.84 | 104.61 | 104.75 | 304300.0 |
| 2001-09-18 12:50:00 | SPY | ETF | 104.8 | 104.9 | 104.66 | 104.8 | 139500.0 |
| 2001-09-18 12:55:00 | SPY | ETF | 104.82 | 104.85 | 104.71 | 104.71 | 138800.0 |
| 2001-09-18 13:00:00 | SPY | ETF | 104.78 | 104.78 | 104.63 | 104.72 | 27600.0 |
| 2001-09-18 13:05:00 | SPY | ETF | 104.69 | 104.93 | 104.65 | 104.89 | 66200.0 |
| 2001-09-18 13:10:00 | SPY | ETF | 104.92 | 105.1 | 104.85 | 105.01 | 222300.0 |
| 2001-09-18 13:15:00 | SPY | ETF | 105.0 | 105.15 | 104.99 | 105.09 | 192500.0 |
| 2001-09-18 13:20:00 | SPY | ETF | 105.05 | 105.3 | 105.04 | 105.25 | 282500.0 |
| 2001-09-18 13:25:00 | SPY | ETF | 105.18 | 105.27 | 105.1 | 105.19 | 291000.0 |
| 2001-09-18 13:30:00 | SPY | ETF | 105.17 | 105.2 | 105.0 | 105.03 | 291900.0 |
| 2001-09-18 13:35:00 | SPY | ETF | 105.05 | 105.15 | 105.0 | 105.14 | 100200.0 |
> showing 50 of 1,592 rows — these rows as CSV