PREVIEW / etf_5min / 2003-07-16
file: by_date/etf_5min/2003/2003-07-16.parquet size: 57 KB rows: 2,742
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-16 08:00:00 | SPY | ETF | 101.08 | 101.08 | 101.05 | 101.07 | 1800.0 |
| 2003-07-16 08:05:00 | SPY | ETF | 101.1 | 101.1 | 101.08 | 101.08 | 1100.0 |
| 2003-07-16 08:10:00 | SPY | ETF | 101.05 | 101.05 | 101.05 | 101.05 | 1000.0 |
| 2003-07-16 08:15:00 | SPY | ETF | 101.05 | 101.05 | 101.05 | 101.05 | 10000.0 |
| 2003-07-16 08:20:00 | SPY | ETF | 101.05 | 101.05 | 101.05 | 101.05 | 30500.0 |
| 2003-07-16 08:25:00 | SPY | ETF | 101.05 | 101.05 | 100.99 | 100.99 | 11300.0 |
| 2003-07-16 08:30:00 | SPY | ETF | 101.04 | 101.07 | 101.0 | 101.0 | 7700.0 |
| 2003-07-16 08:35:00 | SPY | ETF | 101.0 | 101.04 | 100.94 | 100.99 | 14400.0 |
| 2003-07-16 08:40:00 | SPY | ETF | 100.94 | 100.95 | 100.94 | 100.95 | 4800.0 |
| 2003-07-16 08:45:00 | SPY | ETF | 100.87 | 100.87 | 100.87 | 100.87 | 1000.0 |
| 2003-07-16 08:50:00 | SPY | ETF | 100.86 | 100.87 | 100.86 | 100.87 | 1000.0 |
| 2003-07-16 08:55:00 | SPY | ETF | 100.9 | 100.9 | 100.86 | 100.86 | 1800.0 |
| 2003-07-16 09:00:00 | SPY | ETF | 100.87 | 100.89 | 100.87 | 100.89 | 300.0 |
| 2003-07-16 09:05:00 | SPY | ETF | 100.81 | 100.84 | 100.8 | 100.84 | 3700.0 |
| 2003-07-16 09:10:00 | SPY | ETF | 100.84 | 100.85 | 100.84 | 100.85 | 6000.0 |
| 2003-07-16 09:15:00 | SPY | ETF | 100.87 | 100.9 | 100.85 | 100.9 | 8100.0 |
| 2003-07-16 09:20:00 | SPY | ETF | 100.88 | 100.9 | 100.86 | 100.9 | 10500.0 |
| 2003-07-16 09:25:00 | SPY | ETF | 100.88 | 100.88 | 100.78 | 100.78 | 13900.0 |
| 2003-07-16 09:30:00 | SPY | ETF | 100.81 | 100.87 | 100.61 | 100.659 | 1411000.0 |
| 2003-07-16 09:35:00 | SPY | ETF | 100.67 | 100.75 | 100.55 | 100.69 | 828300.0 |
| 2003-07-16 09:40:00 | SPY | ETF | 100.65 | 100.65 | 100.5 | 100.61 | 317600.0 |
| 2003-07-16 09:45:00 | SPY | ETF | 100.6 | 100.73 | 100.33 | 100.35 | 976600.0 |
| 2003-07-16 09:50:00 | SPY | ETF | 100.35 | 100.43 | 100.17 | 100.25 | 1503900.0 |
| 2003-07-16 09:55:00 | SPY | ETF | 100.32 | 100.4 | 100.25 | 100.36 | 536800.0 |
| 2003-07-16 10:00:00 | SPY | ETF | 100.35 | 100.36 | 100.1 | 100.24 | 440400.0 |
| 2003-07-16 10:05:00 | SPY | ETF | 100.23 | 100.35 | 100.14 | 100.16 | 552500.0 |
| 2003-07-16 10:10:00 | SPY | ETF | 100.16 | 100.16 | 99.68 | 99.775 | 1283200.0 |
| 2003-07-16 10:15:00 | SPY | ETF | 99.78 | 99.87 | 99.68 | 99.7 | 907700.0 |
| 2003-07-16 10:20:00 | SPY | ETF | 99.7 | 99.83 | 99.68 | 99.74 | 1638900.0 |
| 2003-07-16 10:25:00 | SPY | ETF | 99.75 | 99.77 | 99.41 | 99.43 | 955700.0 |
| 2003-07-16 10:30:00 | SPY | ETF | 99.45 | 99.59 | 99.36 | 99.59 | 1976500.0 |
| 2003-07-16 10:35:00 | SPY | ETF | 99.56 | 99.67 | 99.52 | 99.65 | 1066300.0 |
| 2003-07-16 10:40:00 | SPY | ETF | 99.65 | 99.66 | 99.54 | 99.55 | 552400.0 |
| 2003-07-16 10:45:00 | SPY | ETF | 99.52 | 99.62 | 99.43 | 99.609 | 499700.0 |
| 2003-07-16 10:50:00 | SPY | ETF | 99.6 | 99.62 | 99.52 | 99.55 | 375400.0 |
| 2003-07-16 10:55:00 | SPY | ETF | 99.55 | 99.69 | 99.54 | 99.64 | 241800.0 |
| 2003-07-16 11:00:00 | SPY | ETF | 99.64 | 99.65 | 99.54 | 99.56 | 372100.0 |
| 2003-07-16 11:05:00 | SPY | ETF | 99.56 | 99.62 | 99.45 | 99.49 | 183600.0 |
| 2003-07-16 11:10:00 | SPY | ETF | 99.49 | 99.49 | 99.23 | 99.3 | 776100.0 |
| 2003-07-16 11:15:00 | SPY | ETF | 99.29 | 99.35 | 99.27 | 99.32 | 215900.0 |
| 2003-07-16 11:20:00 | SPY | ETF | 99.33 | 99.44 | 99.32 | 99.36 | 331800.0 |
| 2003-07-16 11:25:00 | SPY | ETF | 99.38 | 99.509 | 99.35 | 99.48 | 153600.0 |
| 2003-07-16 11:30:00 | SPY | ETF | 99.48 | 99.52 | 99.42 | 99.47 | 194100.0 |
| 2003-07-16 11:35:00 | SPY | ETF | 99.47 | 99.55 | 99.43 | 99.53 | 202200.0 |
| 2003-07-16 11:40:00 | SPY | ETF | 99.53 | 99.57 | 99.47 | 99.53 | 173500.0 |
| 2003-07-16 11:45:00 | SPY | ETF | 99.53 | 99.55 | 99.43 | 99.48 | 531900.0 |
| 2003-07-16 11:50:00 | SPY | ETF | 99.48 | 99.48 | 99.4 | 99.44 | 181600.0 |
| 2003-07-16 11:55:00 | SPY | ETF | 99.44 | 99.52 | 99.38 | 99.42 | 105900.0 |
| 2003-07-16 12:00:00 | SPY | ETF | 99.4 | 99.48 | 99.396 | 99.46 | 102700.0 |
| 2003-07-16 12:05:00 | SPY | ETF | 99.46 | 99.51 | 99.36 | 99.49 | 147600.0 |
> showing 50 of 2,742 rows — these rows as CSV