PREVIEW / etf_5min / 2003-07-09
file: by_date/etf_5min/2003/2003-07-09.parquet size: 58 KB rows: 2,844
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-09 08:00:00 | SPY | ETF | 100.77 | 100.77 | 100.77 | 100.77 | 300.0 |
| 2003-07-09 08:05:00 | SPY | ETF | 100.85 | 100.85 | 100.85 | 100.85 | 300.0 |
| 2003-07-09 08:10:00 | SPY | ETF | 100.84 | 100.84 | 100.84 | 100.84 | 200.0 |
| 2003-07-09 08:25:00 | SPY | ETF | 100.85 | 100.85 | 100.85 | 100.85 | 1000.0 |
| 2003-07-09 08:30:00 | SPY | ETF | 100.83 | 100.83 | 100.8 | 100.82 | 5700.0 |
| 2003-07-09 08:35:00 | SPY | ETF | 100.78 | 100.82 | 100.77 | 100.82 | 4100.0 |
| 2003-07-09 08:40:00 | SPY | ETF | 100.82 | 100.86 | 100.82 | 100.85 | 900.0 |
| 2003-07-09 08:45:00 | SPY | ETF | 100.84 | 100.85 | 100.83 | 100.84 | 15600.0 |
| 2003-07-09 08:50:00 | SPY | ETF | 100.84 | 100.9 | 100.84 | 100.87 | 4400.0 |
| 2003-07-09 08:55:00 | SPY | ETF | 100.89 | 100.89 | 100.89 | 100.89 | 100.0 |
| 2003-07-09 09:00:00 | SPY | ETF | 100.88 | 100.88 | 100.88 | 100.88 | 2000.0 |
| 2003-07-09 09:05:00 | SPY | ETF | 100.9 | 100.94 | 100.89 | 100.94 | 7900.0 |
| 2003-07-09 09:10:00 | SPY | ETF | 100.94 | 100.97 | 100.94 | 100.97 | 6000.0 |
| 2003-07-09 09:15:00 | SPY | ETF | 100.97 | 100.97 | 100.94 | 100.94 | 2900.0 |
| 2003-07-09 09:25:00 | SPY | ETF | 100.91 | 100.91 | 100.91 | 100.91 | 400.0 |
| 2003-07-09 09:30:00 | SPY | ETF | 100.92 | 101.05 | 100.858 | 100.95 | 739900.0 |
| 2003-07-09 09:35:00 | SPY | ETF | 100.98 | 101.17 | 100.96 | 101.04 | 425800.0 |
| 2003-07-09 09:40:00 | SPY | ETF | 101.03 | 101.07 | 100.77 | 100.8 | 827200.0 |
| 2003-07-09 09:45:00 | SPY | ETF | 100.81 | 100.88 | 100.69 | 100.86 | 856100.0 |
| 2003-07-09 09:50:00 | SPY | ETF | 100.86 | 101.03 | 100.73 | 100.953 | 436600.0 |
| 2003-07-09 09:55:00 | SPY | ETF | 100.96 | 101.01 | 100.84 | 100.91 | 257900.0 |
| 2003-07-09 10:00:00 | SPY | ETF | 100.9 | 101.057 | 100.7 | 100.83 | 704200.0 |
| 2003-07-09 10:05:00 | SPY | ETF | 100.79 | 101.21 | 100.79 | 101.07 | 351800.0 |
| 2003-07-09 10:10:00 | SPY | ETF | 101.13 | 101.15 | 100.97 | 101.11 | 502600.0 |
| 2003-07-09 10:15:00 | SPY | ETF | 101.05 | 101.38 | 101.01 | 101.28 | 402000.0 |
| 2003-07-09 10:20:00 | SPY | ETF | 101.261 | 101.4 | 101.26 | 101.29 | 459900.0 |
| 2003-07-09 10:25:00 | SPY | ETF | 101.3 | 101.37 | 101.21 | 101.31 | 430600.0 |
| 2003-07-09 10:30:00 | SPY | ETF | 101.35 | 101.35 | 101.09 | 101.14 | 312300.0 |
| 2003-07-09 10:35:00 | SPY | ETF | 101.13 | 101.2 | 100.97 | 100.98 | 611400.0 |
| 2003-07-09 10:40:00 | SPY | ETF | 100.99 | 101.12 | 100.95 | 100.98 | 461700.0 |
| 2003-07-09 10:45:00 | SPY | ETF | 101.0 | 101.12 | 100.82 | 100.9 | 319800.0 |
| 2003-07-09 10:50:00 | SPY | ETF | 100.86 | 100.9 | 100.67 | 100.72 | 735500.0 |
| 2003-07-09 10:55:00 | SPY | ETF | 100.729 | 100.8 | 100.391 | 100.47 | 1202400.0 |
| 2003-07-09 11:00:00 | SPY | ETF | 100.45 | 100.57 | 100.418 | 100.52 | 510300.0 |
| 2003-07-09 11:05:00 | SPY | ETF | 100.52 | 100.53 | 100.34 | 100.48 | 380900.0 |
| 2003-07-09 11:10:00 | SPY | ETF | 100.46 | 100.6 | 100.4 | 100.6 | 342500.0 |
| 2003-07-09 11:15:00 | SPY | ETF | 100.59 | 100.69 | 100.48 | 100.6 | 1288400.0 |
| 2003-07-09 11:20:00 | SPY | ETF | 100.64 | 100.69 | 100.54 | 100.6 | 277400.0 |
| 2003-07-09 11:25:00 | SPY | ETF | 100.6 | 100.66 | 100.579 | 100.62 | 211300.0 |
| 2003-07-09 11:30:00 | SPY | ETF | 100.61 | 100.71 | 100.6 | 100.63 | 227600.0 |
| 2003-07-09 11:35:00 | SPY | ETF | 100.63 | 100.67 | 100.51 | 100.53 | 317600.0 |
| 2003-07-09 11:40:00 | SPY | ETF | 100.56 | 100.59 | 100.5 | 100.56 | 62800.0 |
| 2003-07-09 11:45:00 | SPY | ETF | 100.55 | 100.56 | 100.44 | 100.481 | 211900.0 |
| 2003-07-09 11:50:00 | SPY | ETF | 100.48 | 100.56 | 100.45 | 100.48 | 387300.0 |
| 2003-07-09 11:55:00 | SPY | ETF | 100.48 | 100.53 | 100.38 | 100.4 | 369300.0 |
| 2003-07-09 12:00:00 | SPY | ETF | 100.38 | 100.44 | 100.03 | 100.15 | 1355500.0 |
| 2003-07-09 12:05:00 | SPY | ETF | 100.16 | 100.28 | 100.13 | 100.23 | 1083800.0 |
| 2003-07-09 12:10:00 | SPY | ETF | 100.23 | 100.27 | 100.21 | 100.25 | 219200.0 |
| 2003-07-09 12:15:00 | SPY | ETF | 100.27 | 100.28 | 100.17 | 100.17 | 114900.0 |
| 2003-07-09 12:20:00 | SPY | ETF | 100.18 | 100.31 | 100.167 | 100.29 | 335900.0 |
> showing 50 of 2,844 rows — these rows as CSV