PREVIEW / etf_5min / 2005-01-04
file: by_date/etf_5min/2005/2005-01-04.parquet size: 137 KB rows: 6,476
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-04 08:00:00 | SPY | ETF | 120.53 | 120.54 | 120.51 | 120.51 | 3700.0 |
| 2005-01-04 08:05:00 | SPY | ETF | 120.48 | 120.5 | 120.48 | 120.48 | 6800.0 |
| 2005-01-04 08:10:00 | SPY | ETF | 120.45 | 120.47 | 120.45 | 120.47 | 900.0 |
| 2005-01-04 08:20:00 | SPY | ETF | 120.48 | 120.48 | 120.48 | 120.48 | 400.0 |
| 2005-01-04 08:25:00 | SPY | ETF | 120.49 | 120.52 | 120.48 | 120.52 | 8100.0 |
| 2005-01-04 08:30:00 | SPY | ETF | 120.51 | 120.54 | 120.48 | 120.54 | 29100.0 |
| 2005-01-04 08:35:00 | SPY | ETF | 120.54 | 120.55 | 120.51 | 120.54 | 44500.0 |
| 2005-01-04 08:40:00 | SPY | ETF | 120.52 | 120.52 | 120.52 | 120.52 | 200.0 |
| 2005-01-04 08:45:00 | SPY | ETF | 120.5 | 120.5 | 120.48 | 120.48 | 3000.0 |
| 2005-01-04 08:50:00 | SPY | ETF | 120.48 | 120.48 | 120.45 | 120.46 | 9800.0 |
| 2005-01-04 08:55:00 | SPY | ETF | 120.49 | 120.51 | 120.49 | 120.5 | 3100.0 |
| 2005-01-04 09:00:00 | SPY | ETF | 120.5 | 120.5 | 120.48 | 120.48 | 3300.0 |
| 2005-01-04 09:05:00 | SPY | ETF | 120.48 | 120.5 | 120.45 | 120.49 | 14300.0 |
| 2005-01-04 09:10:00 | SPY | ETF | 120.5 | 120.51 | 120.48 | 120.49 | 8000.0 |
| 2005-01-04 09:15:00 | SPY | ETF | 120.49 | 120.49 | 120.46 | 120.46 | 5000.0 |
| 2005-01-04 09:20:00 | SPY | ETF | 120.45 | 120.45 | 120.38 | 120.38 | 21400.0 |
| 2005-01-04 09:25:00 | SPY | ETF | 120.39 | 120.45 | 120.39 | 120.45 | 2500.0 |
| 2005-01-04 09:30:00 | SPY | ETF | 120.46 | 120.48 | 120.41 | 120.46 | 759100.0 |
| 2005-01-04 09:35:00 | SPY | ETF | 120.45 | 120.5 | 120.38 | 120.4 | 961900.0 |
| 2005-01-04 09:40:00 | SPY | ETF | 120.41 | 120.42 | 120.3 | 120.33 | 834300.0 |
| 2005-01-04 09:45:00 | SPY | ETF | 120.32 | 120.42 | 120.31 | 120.38 | 679800.0 |
| 2005-01-04 09:50:00 | SPY | ETF | 120.37 | 120.41 | 120.32 | 120.34 | 599500.0 |
| 2005-01-04 09:55:00 | SPY | ETF | 120.33 | 120.36 | 120.21 | 120.21 | 696200.0 |
| 2005-01-04 10:00:00 | SPY | ETF | 120.22 | 120.35 | 120.19 | 120.34 | 1852800.0 |
| 2005-01-04 10:05:00 | SPY | ETF | 120.34 | 120.54 | 120.33 | 120.51 | 1156700.0 |
| 2005-01-04 10:10:00 | SPY | ETF | 120.5 | 120.54 | 120.42 | 120.43 | 782300.0 |
| 2005-01-04 10:15:00 | SPY | ETF | 120.44 | 120.51 | 120.31 | 120.39 | 412600.0 |
| 2005-01-04 10:20:00 | SPY | ETF | 120.39 | 120.4 | 120.12 | 120.12 | 437400.0 |
| 2005-01-04 10:25:00 | SPY | ETF | 120.13 | 120.26 | 119.98 | 120.1 | 1559000.0 |
| 2005-01-04 10:30:00 | SPY | ETF | 120.1 | 120.15 | 119.96 | 120.04 | 501000.0 |
| 2005-01-04 10:35:00 | SPY | ETF | 120.03 | 120.15 | 119.99 | 120.06 | 739100.0 |
| 2005-01-04 10:40:00 | SPY | ETF | 120.06 | 120.14 | 119.98 | 120.02 | 390800.0 |
| 2005-01-04 10:45:00 | SPY | ETF | 120.02 | 120.07 | 119.89 | 119.99 | 1099700.0 |
| 2005-01-04 10:50:00 | SPY | ETF | 119.98 | 120.01 | 119.92 | 119.98 | 763500.0 |
| 2005-01-04 10:55:00 | SPY | ETF | 119.98 | 120.0 | 119.87 | 119.96 | 484900.0 |
| 2005-01-04 11:00:00 | SPY | ETF | 119.97 | 119.98 | 119.82 | 119.9 | 885800.0 |
| 2005-01-04 11:05:00 | SPY | ETF | 119.91 | 119.95 | 119.79 | 119.86 | 1122200.0 |
| 2005-01-04 11:10:00 | SPY | ETF | 119.86 | 119.96 | 119.8 | 119.94 | 921800.0 |
| 2005-01-04 11:15:00 | SPY | ETF | 119.94 | 120.03 | 119.92 | 120.03 | 1156000.0 |
| 2005-01-04 11:20:00 | SPY | ETF | 120.02 | 120.06 | 119.97 | 119.99 | 926400.0 |
| 2005-01-04 11:25:00 | SPY | ETF | 119.98 | 120.03 | 119.96 | 120.0 | 330900.0 |
| 2005-01-04 11:30:00 | SPY | ETF | 120.0 | 120.02 | 119.98 | 120.02 | 162800.0 |
| 2005-01-04 11:35:00 | SPY | ETF | 120.01 | 120.1 | 120.0 | 120.08 | 764600.0 |
| 2005-01-04 11:40:00 | SPY | ETF | 120.07 | 120.09 | 120.0 | 120.01 | 244700.0 |
| 2005-01-04 11:45:00 | SPY | ETF | 120.01 | 120.01 | 119.91 | 119.94 | 301400.0 |
| 2005-01-04 11:50:00 | SPY | ETF | 119.94 | 119.95 | 119.9 | 119.94 | 223800.0 |
| 2005-01-04 11:55:00 | SPY | ETF | 119.95 | 119.95 | 119.92 | 119.93 | 207600.0 |
| 2005-01-04 12:00:00 | SPY | ETF | 119.93 | 119.95 | 119.76 | 119.8 | 414300.0 |
| 2005-01-04 12:05:00 | SPY | ETF | 119.79 | 119.84 | 119.76 | 119.7899 | 479800.0 |
| 2005-01-04 12:10:00 | SPY | ETF | 119.79 | 119.97 | 119.55 | 119.56 | 1310200.0 |
> showing 50 of 6,476 rows — these rows as CSV