PREVIEW / etf_5min / 2002-06-28
file: by_date/etf_5min/2002/2002-06-28.parquet size: 42 KB rows: 1,792
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-28 09:30:00 | SPY | ETF | 99.3 | 99.33 | 99.05 | 99.3 | 656900.0 |
| 2002-06-28 09:35:00 | SPY | ETF | 99.31 | 99.53 | 99.2 | 99.51 | 242700.0 |
| 2002-06-28 09:40:00 | SPY | ETF | 99.5 | 99.74 | 99.43 | 99.59 | 1226200.0 |
| 2002-06-28 09:45:00 | SPY | ETF | 99.59 | 99.95 | 99.55 | 99.9 | 564600.0 |
| 2002-06-28 09:50:00 | SPY | ETF | 99.89 | 100.0 | 99.6 | 99.74 | 631900.0 |
| 2002-06-28 09:55:00 | SPY | ETF | 99.63 | 99.83 | 99.53 | 99.64 | 247600.0 |
| 2002-06-28 10:00:00 | SPY | ETF | 99.7 | 99.95 | 99.45 | 99.95 | 280200.0 |
| 2002-06-28 10:05:00 | SPY | ETF | 99.86 | 100.01 | 99.7 | 99.83 | 273600.0 |
| 2002-06-28 10:10:00 | SPY | ETF | 99.85 | 100.13 | 99.73 | 100.12 | 357600.0 |
| 2002-06-28 10:15:00 | SPY | ETF | 100.16 | 100.4 | 100.07 | 100.39 | 694000.0 |
| 2002-06-28 10:20:00 | SPY | ETF | 100.4 | 100.5 | 100.25 | 100.39 | 468300.0 |
| 2002-06-28 10:25:00 | SPY | ETF | 100.4 | 100.44 | 100.11 | 100.11 | 419200.0 |
| 2002-06-28 10:30:00 | SPY | ETF | 100.11 | 100.32 | 100.1 | 100.17 | 173000.0 |
| 2002-06-28 10:35:00 | SPY | ETF | 100.13 | 100.33 | 100.07 | 100.14 | 158100.0 |
| 2002-06-28 10:40:00 | SPY | ETF | 100.15 | 100.3 | 100.05 | 100.16 | 126000.0 |
| 2002-06-28 10:45:00 | SPY | ETF | 100.16 | 100.16 | 99.9 | 99.98 | 238300.0 |
| 2002-06-28 10:50:00 | SPY | ETF | 99.97 | 100.1 | 99.88 | 100.02 | 260400.0 |
| 2002-06-28 10:55:00 | SPY | ETF | 99.99 | 100.15 | 99.98 | 100.11 | 147300.0 |
| 2002-06-28 11:00:00 | SPY | ETF | 100.14 | 100.25 | 100.06 | 100.14 | 152300.0 |
| 2002-06-28 11:05:00 | SPY | ETF | 100.15 | 100.22 | 100.1 | 100.17 | 49300.0 |
| 2002-06-28 11:10:00 | SPY | ETF | 100.12 | 100.24 | 99.9 | 99.94 | 87000.0 |
| 2002-06-28 11:15:00 | SPY | ETF | 100.0 | 100.1 | 99.91 | 100.1 | 89200.0 |
| 2002-06-28 11:20:00 | SPY | ETF | 100.14 | 100.24 | 100.03 | 100.18 | 108900.0 |
| 2002-06-28 11:25:00 | SPY | ETF | 100.18 | 100.24 | 100.1 | 100.11 | 106900.0 |
| 2002-06-28 11:30:00 | SPY | ETF | 100.13 | 100.24 | 100.1 | 100.17 | 227700.0 |
| 2002-06-28 11:35:00 | SPY | ETF | 100.17 | 100.2 | 99.95 | 100.0 | 75500.0 |
| 2002-06-28 11:40:00 | SPY | ETF | 99.98 | 100.1 | 99.9 | 100.04 | 70800.0 |
| 2002-06-28 11:45:00 | SPY | ETF | 100.01 | 100.18 | 100.01 | 100.17 | 95000.0 |
| 2002-06-28 11:50:00 | SPY | ETF | 100.16 | 100.24 | 100.12 | 100.21 | 93700.0 |
| 2002-06-28 11:55:00 | SPY | ETF | 100.24 | 100.25 | 100.15 | 100.19 | 195000.0 |
| 2002-06-28 12:00:00 | SPY | ETF | 100.2 | 100.24 | 100.08 | 100.15 | 88700.0 |
| 2002-06-28 12:05:00 | SPY | ETF | 100.16 | 100.24 | 100.1 | 100.23 | 111500.0 |
| 2002-06-28 12:10:00 | SPY | ETF | 100.24 | 100.37 | 100.21 | 100.32 | 129800.0 |
| 2002-06-28 12:15:00 | SPY | ETF | 100.33 | 100.44 | 100.3 | 100.37 | 260400.0 |
| 2002-06-28 12:20:00 | SPY | ETF | 100.36 | 100.41 | 100.29 | 100.36 | 109300.0 |
| 2002-06-28 12:25:00 | SPY | ETF | 100.37 | 100.37 | 100.26 | 100.31 | 62700.0 |
| 2002-06-28 12:30:00 | SPY | ETF | 100.32 | 100.36 | 100.29 | 100.34 | 123700.0 |
| 2002-06-28 12:35:00 | SPY | ETF | 100.34 | 100.4 | 100.26 | 100.34 | 168700.0 |
| 2002-06-28 12:40:00 | SPY | ETF | 100.34 | 100.37 | 100.26 | 100.29 | 113100.0 |
| 2002-06-28 12:45:00 | SPY | ETF | 100.25 | 100.31 | 100.08 | 100.08 | 65500.0 |
| 2002-06-28 12:50:00 | SPY | ETF | 100.09 | 100.15 | 99.96 | 100.01 | 106600.0 |
| 2002-06-28 12:55:00 | SPY | ETF | 100.05 | 100.2 | 100.05 | 100.07 | 65900.0 |
| 2002-06-28 13:00:00 | SPY | ETF | 100.13 | 100.29 | 100.12 | 100.25 | 68100.0 |
| 2002-06-28 13:05:00 | SPY | ETF | 100.22 | 100.29 | 100.18 | 100.27 | 38900.0 |
| 2002-06-28 13:10:00 | SPY | ETF | 100.27 | 100.32 | 100.21 | 100.24 | 113400.0 |
| 2002-06-28 13:15:00 | SPY | ETF | 100.2 | 100.25 | 100.11 | 100.17 | 90400.0 |
| 2002-06-28 13:20:00 | SPY | ETF | 100.19 | 100.25 | 100.13 | 100.14 | 57200.0 |
| 2002-06-28 13:25:00 | SPY | ETF | 100.14 | 100.18 | 100.06 | 100.15 | 146200.0 |
| 2002-06-28 13:30:00 | SPY | ETF | 100.15 | 100.19 | 100.06 | 100.07 | 77500.0 |
| 2002-06-28 13:35:00 | SPY | ETF | 100.07 | 100.17 | 100.0 | 100.08 | 145900.0 |
> showing 50 of 1,792 rows — these rows as CSV