PREVIEW / etf_5min / 2005-04-20
file: by_date/etf_5min/2005/2005-04-20.parquet size: 132 KB rows: 6,229
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-04-20 07:00:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 4900.0 |
| 2005-04-20 07:05:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 5000.0 |
| 2005-04-20 07:20:00 | SPY | ETF | 115.75 | 115.8 | 115.75 | 115.8 | 28900.0 |
| 2005-04-20 07:25:00 | SPY | ETF | 115.78 | 115.78 | 115.78 | 115.78 | 5000.0 |
| 2005-04-20 07:30:00 | SPY | ETF | 115.76 | 115.76 | 115.76 | 115.76 | 2400.0 |
| 2005-04-20 07:35:00 | SPY | ETF | 115.75 | 115.75 | 115.75 | 115.75 | 5000.0 |
| 2005-04-20 07:40:00 | SPY | ETF | 115.76 | 115.78 | 115.76 | 115.78 | 2600.0 |
| 2005-04-20 07:45:00 | SPY | ETF | 115.77 | 115.77 | 115.75 | 115.75 | 3500.0 |
| 2005-04-20 07:50:00 | SPY | ETF | 115.75 | 115.77 | 115.71 | 115.71 | 79300.0 |
| 2005-04-20 07:55:00 | SPY | ETF | 115.73 | 115.73 | 115.7 | 115.7 | 62600.0 |
| 2005-04-20 08:00:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 11200.0 |
| 2005-04-20 08:05:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 1500.0 |
| 2005-04-20 08:10:00 | SPY | ETF | 115.7 | 115.71 | 115.67 | 115.7 | 20300.0 |
| 2005-04-20 08:15:00 | SPY | ETF | 115.68 | 115.69 | 115.68 | 115.69 | 9500.0 |
| 2005-04-20 08:20:00 | SPY | ETF | 115.69 | 115.71 | 115.68 | 115.71 | 4700.0 |
| 2005-04-20 08:25:00 | SPY | ETF | 115.72 | 115.77 | 115.7 | 115.73 | 61800.0 |
| 2005-04-20 08:30:00 | SPY | ETF | 115.6 | 115.6 | 115.08 | 115.23 | 956700.0 |
| 2005-04-20 08:35:00 | SPY | ETF | 115.22 | 115.28 | 115.18 | 115.25 | 311000.0 |
| 2005-04-20 08:40:00 | SPY | ETF | 115.28 | 115.42 | 115.27 | 115.42 | 94800.0 |
| 2005-04-20 08:45:00 | SPY | ETF | 115.44 | 115.67 | 115.44 | 115.52 | 134200.0 |
| 2005-04-20 08:50:00 | SPY | ETF | 115.55 | 115.65 | 115.53 | 115.64 | 29000.0 |
| 2005-04-20 08:55:00 | SPY | ETF | 115.64 | 115.64 | 115.55 | 115.59 | 49700.0 |
| 2005-04-20 09:00:00 | SPY | ETF | 115.57 | 115.58 | 115.51 | 115.53 | 29800.0 |
| 2005-04-20 09:05:00 | SPY | ETF | 115.53 | 115.54 | 115.41 | 115.41 | 59800.0 |
| 2005-04-20 09:10:00 | SPY | ETF | 115.42 | 115.45 | 115.27 | 115.32 | 211100.0 |
| 2005-04-20 09:15:00 | SPY | ETF | 115.33 | 115.34 | 115.29 | 115.29 | 399800.0 |
| 2005-04-20 09:20:00 | SPY | ETF | 115.29 | 115.39 | 115.28 | 115.36 | 58000.0 |
| 2005-04-20 09:25:00 | SPY | ETF | 115.36 | 115.41 | 115.36 | 115.41 | 10300.0 |
| 2005-04-20 09:30:00 | SPY | ETF | 115.4 | 115.41 | 115.25 | 115.28 | 2543700.0 |
| 2005-04-20 09:35:00 | SPY | ETF | 115.28 | 115.3 | 115.1 | 115.11 | 1938100.0 |
| 2005-04-20 09:40:00 | SPY | ETF | 115.12 | 115.24 | 114.9 | 114.95 | 2705500.0 |
| 2005-04-20 09:45:00 | SPY | ETF | 114.94 | 115.28 | 114.86 | 115.04 | 3883900.0 |
| 2005-04-20 09:50:00 | SPY | ETF | 115.04 | 115.13 | 114.91 | 115.0 | 1415300.0 |
| 2005-04-20 09:55:00 | SPY | ETF | 115.0 | 115.05 | 114.75 | 114.88 | 2634900.0 |
| 2005-04-20 10:00:00 | SPY | ETF | 114.82 | 114.95 | 114.76 | 114.92 | 1646200.0 |
| 2005-04-20 10:05:00 | SPY | ETF | 114.93 | 115.1 | 114.93 | 115.1 | 1280700.0 |
| 2005-04-20 10:10:00 | SPY | ETF | 115.1 | 115.1 | 114.84 | 115.05 | 949300.0 |
| 2005-04-20 10:15:00 | SPY | ETF | 115.1 | 115.24 | 115.06 | 115.2 | 2938100.0 |
| 2005-04-20 10:20:00 | SPY | ETF | 115.19 | 115.28 | 115.13 | 115.17 | 1005300.0 |
| 2005-04-20 10:25:00 | SPY | ETF | 115.14 | 115.32 | 115.11 | 115.29 | 700900.0 |
| 2005-04-20 10:30:00 | SPY | ETF | 115.3 | 115.34 | 115.02 | 115.19 | 1993600.0 |
| 2005-04-20 10:35:00 | SPY | ETF | 115.17 | 115.24 | 115.04 | 115.18 | 715900.0 |
| 2005-04-20 10:40:00 | SPY | ETF | 115.17 | 115.19 | 114.94 | 114.97 | 669900.0 |
| 2005-04-20 10:45:00 | SPY | ETF | 114.97 | 115.11 | 114.9 | 114.93 | 436300.0 |
| 2005-04-20 10:50:00 | SPY | ETF | 114.93 | 115.1 | 114.9 | 115.09 | 563100.0 |
| 2005-04-20 10:55:00 | SPY | ETF | 115.08 | 115.35 | 115.06 | 115.3 | 809600.0 |
| 2005-04-20 11:00:00 | SPY | ETF | 115.3 | 115.56 | 115.28 | 115.55 | 2597200.0 |
| 2005-04-20 11:05:00 | SPY | ETF | 115.54 | 115.63 | 115.47 | 115.48 | 2402300.0 |
| 2005-04-20 11:10:00 | SPY | ETF | 115.47 | 115.53 | 115.36 | 115.38 | 1395500.0 |
| 2005-04-20 11:15:00 | SPY | ETF | 115.38 | 115.41 | 115.26 | 115.34 | 882000.0 |
> showing 50 of 6,229 rows — these rows as CSV