PREVIEW / etf_5min / 2004-07-28
file: by_date/etf_5min/2004/2004-07-28.parquet size: 91 KB rows: 4,244
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-28 08:00:00 | SPY | ETF | 109.73 | 109.73 | 109.73 | 109.73 | 200.0 |
| 2004-07-28 08:05:00 | SPY | ETF | 109.72 | 109.72 | 109.72 | 109.72 | 200.0 |
| 2004-07-28 08:10:00 | SPY | ETF | 109.72 | 109.72 | 109.67 | 109.69 | 2300.0 |
| 2004-07-28 08:20:00 | SPY | ETF | 109.67 | 109.67 | 109.59 | 109.59 | 15300.0 |
| 2004-07-28 08:25:00 | SPY | ETF | 109.62 | 109.64 | 109.62 | 109.64 | 10200.0 |
| 2004-07-28 08:30:00 | SPY | ETF | 109.55 | 109.57 | 109.54 | 109.57 | 102900.0 |
| 2004-07-28 08:35:00 | SPY | ETF | 109.59 | 109.6 | 109.58 | 109.6 | 45100.0 |
| 2004-07-28 08:40:00 | SPY | ETF | 109.57 | 109.57 | 109.5 | 109.52 | 3800.0 |
| 2004-07-28 08:45:00 | SPY | ETF | 109.55 | 109.58 | 109.54 | 109.58 | 7000.0 |
| 2004-07-28 08:50:00 | SPY | ETF | 109.56 | 109.56 | 109.56 | 109.56 | 200.0 |
| 2004-07-28 08:55:00 | SPY | ETF | 109.59 | 109.59 | 109.56 | 109.56 | 8400.0 |
| 2004-07-28 09:05:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 200.0 |
| 2004-07-28 09:10:00 | SPY | ETF | 109.58 | 109.58 | 109.58 | 109.58 | 300.0 |
| 2004-07-28 09:15:00 | SPY | ETF | 109.58 | 109.58 | 109.58 | 109.58 | 600.0 |
| 2004-07-28 09:20:00 | SPY | ETF | 109.6 | 109.61 | 109.57 | 109.58 | 9300.0 |
| 2004-07-28 09:25:00 | SPY | ETF | 109.56 | 109.58 | 109.56 | 109.58 | 300.0 |
| 2004-07-28 09:30:00 | SPY | ETF | 109.55 | 109.63 | 109.54 | 109.55 | 904600.0 |
| 2004-07-28 09:35:00 | SPY | ETF | 109.56 | 109.69 | 109.55 | 109.59 | 767600.0 |
| 2004-07-28 09:40:00 | SPY | ETF | 109.58 | 109.75 | 109.58 | 109.7 | 614100.0 |
| 2004-07-28 09:45:00 | SPY | ETF | 109.72 | 109.77 | 109.68 | 109.74 | 736900.0 |
| 2004-07-28 09:50:00 | SPY | ETF | 109.73 | 109.87 | 109.73 | 109.78 | 1073700.0 |
| 2004-07-28 09:55:00 | SPY | ETF | 109.77 | 109.85 | 109.74 | 109.8 | 625600.0 |
| 2004-07-28 10:00:00 | SPY | ETF | 109.79 | 109.84 | 109.69 | 109.78 | 447000.0 |
| 2004-07-28 10:05:00 | SPY | ETF | 109.74 | 109.8 | 109.51 | 109.51 | 1818000.0 |
| 2004-07-28 10:10:00 | SPY | ETF | 109.52 | 109.54 | 109.32 | 109.34 | 1537900.0 |
| 2004-07-28 10:15:00 | SPY | ETF | 109.38 | 109.38 | 109.12 | 109.23 | 1808500.0 |
| 2004-07-28 10:20:00 | SPY | ETF | 109.23 | 109.27 | 109.16 | 109.24 | 611900.0 |
| 2004-07-28 10:25:00 | SPY | ETF | 109.24 | 109.27 | 109.14 | 109.24 | 1826400.0 |
| 2004-07-28 10:30:00 | SPY | ETF | 109.24 | 109.32 | 109.22 | 109.32 | 1124000.0 |
| 2004-07-28 10:35:00 | SPY | ETF | 109.33 | 109.33 | 109.16 | 109.21 | 875000.0 |
| 2004-07-28 10:40:00 | SPY | ETF | 109.23 | 109.25 | 108.92 | 108.98 | 2747900.0 |
| 2004-07-28 10:45:00 | SPY | ETF | 108.98 | 109.05 | 108.87 | 108.91 | 1799300.0 |
| 2004-07-28 10:50:00 | SPY | ETF | 108.9 | 108.98 | 108.86 | 108.97 | 521900.0 |
| 2004-07-28 10:55:00 | SPY | ETF | 108.97 | 109.02 | 108.95 | 108.99 | 346100.0 |
| 2004-07-28 11:00:00 | SPY | ETF | 108.96 | 109.01 | 108.82 | 108.83 | 1257500.0 |
| 2004-07-28 11:05:00 | SPY | ETF | 108.83 | 108.86 | 108.66 | 108.77 | 1359300.0 |
| 2004-07-28 11:10:00 | SPY | ETF | 108.78 | 108.91 | 108.76 | 108.9 | 885500.0 |
| 2004-07-28 11:15:00 | SPY | ETF | 108.89 | 108.97 | 108.87 | 108.94 | 948300.0 |
| 2004-07-28 11:20:00 | SPY | ETF | 108.94 | 108.99 | 108.91 | 108.96 | 357300.0 |
| 2004-07-28 11:25:00 | SPY | ETF | 108.96 | 109.07 | 108.95 | 109.0 | 466400.0 |
| 2004-07-28 11:30:00 | SPY | ETF | 109.01 | 109.04 | 108.87 | 108.93 | 338000.0 |
| 2004-07-28 11:35:00 | SPY | ETF | 108.93 | 108.99 | 108.88 | 108.94 | 240300.0 |
| 2004-07-28 11:40:00 | SPY | ETF | 108.99 | 109.02 | 108.9 | 108.91 | 266300.0 |
| 2004-07-28 11:45:00 | SPY | ETF | 108.92 | 108.96 | 108.83 | 108.88 | 592900.0 |
| 2004-07-28 11:50:00 | SPY | ETF | 108.86 | 108.9 | 108.81 | 108.87 | 361200.0 |
| 2004-07-28 11:55:00 | SPY | ETF | 108.88 | 109.01 | 108.88 | 108.99 | 390800.0 |
| 2004-07-28 12:00:00 | SPY | ETF | 108.99 | 108.99 | 108.79 | 108.88 | 528200.0 |
| 2004-07-28 12:05:00 | SPY | ETF | 108.86 | 108.87 | 108.74 | 108.86 | 420100.0 |
| 2004-07-28 12:10:00 | SPY | ETF | 108.86 | 108.9 | 108.74 | 108.83 | 359200.0 |
| 2004-07-28 12:15:00 | SPY | ETF | 108.84 | 108.87 | 108.75 | 108.76 | 353700.0 |
> showing 50 of 4,244 rows — these rows as CSV