PREVIEW / etf_5min / 2005-01-13
file: by_date/etf_5min/2005/2005-01-13.parquet size: 113 KB rows: 5,919
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-13 08:00:00 | SPY | ETF | 118.52 | 118.56 | 118.52 | 118.56 | 1700.0 |
| 2005-01-13 08:05:00 | SPY | ETF | 118.59 | 118.59 | 118.59 | 118.59 | 6600.0 |
| 2005-01-13 08:10:00 | SPY | ETF | 118.58 | 118.58 | 118.58 | 118.58 | 2000.0 |
| 2005-01-13 08:15:00 | SPY | ETF | 118.58 | 118.58 | 118.58 | 118.58 | 6500.0 |
| 2005-01-13 08:20:00 | SPY | ETF | 118.57 | 118.57 | 118.52 | 118.52 | 12200.0 |
| 2005-01-13 08:25:00 | SPY | ETF | 118.53 | 118.54 | 118.51 | 118.54 | 16400.0 |
| 2005-01-13 08:30:00 | SPY | ETF | 118.48 | 118.58 | 118.48 | 118.57 | 7900.0 |
| 2005-01-13 08:35:00 | SPY | ETF | 118.56 | 118.57 | 118.51 | 118.51 | 8600.0 |
| 2005-01-13 08:40:00 | SPY | ETF | 118.52 | 118.55 | 118.52 | 118.55 | 1500.0 |
| 2005-01-13 08:45:00 | SPY | ETF | 118.57 | 118.57 | 118.57 | 118.57 | 2000.0 |
| 2005-01-13 08:50:00 | SPY | ETF | 118.57 | 118.61 | 118.57 | 118.61 | 2900.0 |
| 2005-01-13 08:55:00 | SPY | ETF | 118.62 | 118.63 | 118.61 | 118.63 | 26200.0 |
| 2005-01-13 09:00:00 | SPY | ETF | 118.62 | 118.62 | 118.58 | 118.58 | 1600.0 |
| 2005-01-13 09:05:00 | SPY | ETF | 118.57 | 118.57 | 118.57 | 118.57 | 700.0 |
| 2005-01-13 09:10:00 | SPY | ETF | 118.61 | 118.61 | 118.59 | 118.59 | 1600.0 |
| 2005-01-13 09:15:00 | SPY | ETF | 118.58 | 118.68 | 118.58 | 118.68 | 14700.0 |
| 2005-01-13 09:20:00 | SPY | ETF | 118.7 | 118.7 | 118.67 | 118.67 | 12900.0 |
| 2005-01-13 09:25:00 | SPY | ETF | 118.64 | 118.67 | 118.62 | 118.63 | 4600.0 |
| 2005-01-13 09:30:00 | SPY | ETF | 118.64 | 118.73 | 118.58 | 118.61 | 747600.0 |
| 2005-01-13 09:35:00 | SPY | ETF | 118.59 | 118.63 | 118.52 | 118.55 | 817400.0 |
| 2005-01-13 09:40:00 | SPY | ETF | 118.55 | 118.66 | 118.52 | 118.58 | 754000.0 |
| 2005-01-13 09:45:00 | SPY | ETF | 118.59 | 118.59 | 118.38 | 118.44 | 1634300.0 |
| 2005-01-13 09:50:00 | SPY | ETF | 118.44 | 118.5 | 118.38 | 118.48 | 1050900.0 |
| 2005-01-13 09:55:00 | SPY | ETF | 118.48 | 118.59 | 118.44 | 118.57 | 807200.0 |
| 2005-01-13 10:00:00 | SPY | ETF | 118.57 | 118.65 | 118.42 | 118.64 | 935900.0 |
| 2005-01-13 10:05:00 | SPY | ETF | 118.64 | 118.67 | 118.53 | 118.53 | 646400.0 |
| 2005-01-13 10:10:00 | SPY | ETF | 118.54 | 118.67 | 118.53 | 118.62 | 888900.0 |
| 2005-01-13 10:15:00 | SPY | ETF | 118.62 | 118.71 | 118.59 | 118.63 | 447100.0 |
| 2005-01-13 10:20:00 | SPY | ETF | 118.62 | 118.73 | 118.54 | 118.57 | 658900.0 |
| 2005-01-13 10:25:00 | SPY | ETF | 118.57 | 118.68 | 118.54 | 118.64 | 680100.0 |
| 2005-01-13 10:30:00 | SPY | ETF | 118.64 | 118.69 | 118.57 | 118.67 | 855300.0 |
| 2005-01-13 10:35:00 | SPY | ETF | 118.67 | 118.73 | 118.57 | 118.59 | 492700.0 |
| 2005-01-13 10:40:00 | SPY | ETF | 118.59 | 118.6 | 118.47 | 118.55 | 488900.0 |
| 2005-01-13 10:45:00 | SPY | ETF | 118.57 | 118.6 | 118.5 | 118.54 | 583300.0 |
| 2005-01-13 10:50:00 | SPY | ETF | 118.54 | 118.61 | 118.42 | 118.46 | 1009100.0 |
| 2005-01-13 10:55:00 | SPY | ETF | 118.48 | 118.49 | 118.4 | 118.451 | 855200.0 |
| 2005-01-13 11:00:00 | SPY | ETF | 118.45 | 118.55 | 118.4 | 118.54 | 571100.0 |
| 2005-01-13 11:05:00 | SPY | ETF | 118.53 | 118.63 | 118.5 | 118.59 | 454800.0 |
| 2005-01-13 11:10:00 | SPY | ETF | 118.58 | 118.62 | 118.52 | 118.52 | 481300.0 |
| 2005-01-13 11:15:00 | SPY | ETF | 118.52 | 118.58 | 118.5 | 118.55 | 279400.0 |
| 2005-01-13 11:20:00 | SPY | ETF | 118.55 | 118.59 | 118.53 | 118.57 | 306300.0 |
| 2005-01-13 11:25:00 | SPY | ETF | 118.57 | 118.61 | 118.55 | 118.58 | 536800.0 |
| 2005-01-13 11:30:00 | SPY | ETF | 118.58 | 118.61 | 118.46 | 118.53 | 992900.0 |
| 2005-01-13 11:35:00 | SPY | ETF | 118.53 | 118.53 | 118.43 | 118.47 | 444500.0 |
| 2005-01-13 11:40:00 | SPY | ETF | 118.46 | 118.48 | 118.32 | 118.35 | 1090300.0 |
| 2005-01-13 11:45:00 | SPY | ETF | 118.34 | 118.37 | 118.25 | 118.34 | 1673000.0 |
| 2005-01-13 11:50:00 | SPY | ETF | 118.35 | 118.43 | 118.31 | 118.41 | 619500.0 |
| 2005-01-13 11:55:00 | SPY | ETF | 118.4 | 118.41 | 118.35 | 118.36 | 212200.0 |
| 2005-01-13 12:00:00 | SPY | ETF | 118.36 | 118.39 | 118.35 | 118.37 | 200800.0 |
| 2005-01-13 12:05:00 | SPY | ETF | 118.37 | 118.39 | 118.36 | 118.36 | 107700.0 |
> showing 50 of 5,919 rows — these rows as CSV