PREVIEW / etf_5min / 2003-07-11
file: by_date/etf_5min/2003/2003-07-11.parquet size: 54 KB rows: 2,706
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-11 08:00:00 | SPY | ETF | 99.2 | 99.2 | 99.18 | 99.18 | 3500.0 |
| 2003-07-11 08:05:00 | SPY | ETF | 99.15 | 99.15 | 99.15 | 99.15 | 2000.0 |
| 2003-07-11 08:15:00 | SPY | ETF | 99.3 | 99.36 | 99.3 | 99.36 | 27300.0 |
| 2003-07-11 08:20:00 | SPY | ETF | 99.36 | 99.36 | 99.36 | 99.36 | 1400.0 |
| 2003-07-11 08:25:00 | SPY | ETF | 99.4 | 99.41 | 99.28 | 99.34 | 10300.0 |
| 2003-07-11 08:30:00 | SPY | ETF | 99.35 | 99.35 | 99.17 | 99.17 | 12900.0 |
| 2003-07-11 08:35:00 | SPY | ETF | 99.19 | 99.27 | 99.19 | 99.27 | 900.0 |
| 2003-07-11 08:40:00 | SPY | ETF | 99.23 | 99.23 | 99.23 | 99.23 | 300.0 |
| 2003-07-11 08:45:00 | SPY | ETF | 99.25 | 99.29 | 99.25 | 99.25 | 4400.0 |
| 2003-07-11 08:50:00 | SPY | ETF | 99.33 | 99.34 | 99.31 | 99.32 | 24500.0 |
| 2003-07-11 08:55:00 | SPY | ETF | 99.36 | 99.45 | 99.36 | 99.45 | 29000.0 |
| 2003-07-11 09:00:00 | SPY | ETF | 99.47 | 99.56 | 99.47 | 99.55 | 31000.0 |
| 2003-07-11 09:05:00 | SPY | ETF | 99.5 | 99.5 | 99.45 | 99.46 | 8600.0 |
| 2003-07-11 09:10:00 | SPY | ETF | 99.46 | 99.47 | 99.46 | 99.46 | 1500.0 |
| 2003-07-11 09:15:00 | SPY | ETF | 99.48 | 99.49 | 99.45 | 99.45 | 1000.0 |
| 2003-07-11 09:20:00 | SPY | ETF | 99.46 | 99.48 | 99.41 | 99.42 | 56600.0 |
| 2003-07-11 09:25:00 | SPY | ETF | 99.41 | 99.45 | 99.38 | 99.41 | 77700.0 |
| 2003-07-11 09:30:00 | SPY | ETF | 99.39 | 99.63 | 99.39 | 99.61 | 771200.0 |
| 2003-07-11 09:35:00 | SPY | ETF | 99.56 | 99.7 | 99.52 | 99.63 | 926300.0 |
| 2003-07-11 09:40:00 | SPY | ETF | 99.6 | 99.684 | 99.46 | 99.65 | 1096900.0 |
| 2003-07-11 09:45:00 | SPY | ETF | 99.693 | 99.8 | 99.628 | 99.77 | 670600.0 |
| 2003-07-11 09:50:00 | SPY | ETF | 99.81 | 99.99 | 99.77 | 99.88 | 988800.0 |
| 2003-07-11 09:55:00 | SPY | ETF | 99.88 | 99.93 | 99.78 | 99.84 | 906700.0 |
| 2003-07-11 10:00:00 | SPY | ETF | 99.86 | 99.942 | 99.74 | 99.75 | 840500.0 |
| 2003-07-11 10:05:00 | SPY | ETF | 99.82 | 99.85 | 99.56 | 99.68 | 835000.0 |
| 2003-07-11 10:10:00 | SPY | ETF | 99.68 | 99.807 | 99.65 | 99.807 | 380300.0 |
| 2003-07-11 10:15:00 | SPY | ETF | 99.78 | 99.88 | 99.68 | 99.81 | 413300.0 |
| 2003-07-11 10:20:00 | SPY | ETF | 99.808 | 99.95 | 99.78 | 99.85 | 699600.0 |
| 2003-07-11 10:25:00 | SPY | ETF | 99.81 | 100.19 | 99.81 | 100.14 | 947200.0 |
| 2003-07-11 10:30:00 | SPY | ETF | 100.15 | 100.3 | 100.14 | 100.21 | 1177800.0 |
| 2003-07-11 10:35:00 | SPY | ETF | 100.19 | 100.25 | 100.05 | 100.143 | 927600.0 |
| 2003-07-11 10:40:00 | SPY | ETF | 100.136 | 100.2 | 100.06 | 100.18 | 655600.0 |
| 2003-07-11 10:45:00 | SPY | ETF | 100.18 | 100.24 | 100.07 | 100.1 | 538300.0 |
| 2003-07-11 10:50:00 | SPY | ETF | 100.13 | 100.26 | 100.05 | 100.08 | 394600.0 |
| 2003-07-11 10:55:00 | SPY | ETF | 100.1 | 100.1 | 100.0 | 100.02 | 348000.0 |
| 2003-07-11 11:00:00 | SPY | ETF | 100.04 | 100.17 | 100.0 | 100.1 | 366600.0 |
| 2003-07-11 11:05:00 | SPY | ETF | 100.09 | 100.2 | 99.81 | 99.89 | 324400.0 |
| 2003-07-11 11:10:00 | SPY | ETF | 99.87 | 99.98 | 99.83 | 99.95 | 384800.0 |
| 2003-07-11 11:15:00 | SPY | ETF | 99.95 | 99.97 | 99.84 | 99.94 | 320200.0 |
| 2003-07-11 11:20:00 | SPY | ETF | 99.96 | 100.04 | 99.91 | 100.01 | 363400.0 |
| 2003-07-11 11:25:00 | SPY | ETF | 100.03 | 100.14 | 100.01 | 100.09 | 274500.0 |
| 2003-07-11 11:30:00 | SPY | ETF | 100.1 | 100.19 | 100.08 | 100.1 | 140700.0 |
| 2003-07-11 11:35:00 | SPY | ETF | 100.097 | 100.19 | 100.05 | 100.15 | 65800.0 |
| 2003-07-11 11:40:00 | SPY | ETF | 100.13 | 100.17 | 100.06 | 100.1 | 127000.0 |
| 2003-07-11 11:45:00 | SPY | ETF | 100.12 | 100.2 | 100.09 | 100.18 | 178500.0 |
| 2003-07-11 11:50:00 | SPY | ETF | 100.19 | 100.28 | 100.17 | 100.27 | 370400.0 |
| 2003-07-11 11:55:00 | SPY | ETF | 100.27 | 100.35 | 100.26 | 100.33 | 394000.0 |
| 2003-07-11 12:00:00 | SPY | ETF | 100.32 | 100.38 | 100.2 | 100.25 | 376700.0 |
| 2003-07-11 12:05:00 | SPY | ETF | 100.25 | 100.31 | 100.15 | 100.23 | 199600.0 |
| 2003-07-11 12:10:00 | SPY | ETF | 100.25 | 100.29 | 100.21 | 100.29 | 56400.0 |
> showing 50 of 2,706 rows — these rows as CSV