PREVIEW / etf_30min / 2002-10-07
file: by_date/etf_30min/2002/2002-10-07.parquet size: 21 KB rows: 596
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-10-07 08:00:00 | SPY | ETF | 80.09 | 80.12 | 80.06 | 80.12 | 2500.0 |
| 2002-10-07 08:30:00 | SPY | ETF | 80.22 | 80.52 | 80.22 | 80.52 | 800.0 |
| 2002-10-07 09:00:00 | SPY | ETF | 80.6 | 80.6 | 79.99 | 79.99 | 2600.0 |
| 2002-10-07 09:30:00 | SPY | ETF | 80.06 | 80.95 | 79.75 | 80.05 | 6926400.0 |
| 2002-10-07 10:00:00 | SPY | ETF | 80.14 | 80.75 | 79.88 | 80.25 | 3771000.0 |
| 2002-10-07 10:30:00 | SPY | ETF | 80.24 | 80.54 | 79.75 | 80.03 | 3373800.0 |
| 2002-10-07 11:00:00 | SPY | ETF | 80.01 | 80.25 | 79.4 | 79.82 | 2886000.0 |
| 2002-10-07 11:30:00 | SPY | ETF | 79.81 | 80.52 | 79.79 | 80.3 | 4008100.0 |
| 2002-10-07 12:00:00 | SPY | ETF | 80.3 | 80.99 | 80.2 | 80.9 | 2744600.0 |
| 2002-10-07 12:30:00 | SPY | ETF | 80.9 | 81.2 | 80.1 | 80.2 | 3745200.0 |
| 2002-10-07 13:00:00 | SPY | ETF | 80.2 | 80.5 | 79.92 | 80.04 | 1921100.0 |
| 2002-10-07 13:30:00 | SPY | ETF | 80.05 | 80.35 | 79.83 | 80.17 | 2594400.0 |
| 2002-10-07 14:00:00 | SPY | ETF | 80.17 | 80.23 | 79.6 | 79.75 | 2600600.0 |
| 2002-10-07 14:30:00 | SPY | ETF | 79.75 | 79.95 | 79.46 | 79.64 | 2157200.0 |
| 2002-10-07 15:00:00 | SPY | ETF | 79.68 | 79.68 | 79.02 | 79.05 | 4753100.0 |
| 2002-10-07 15:30:00 | SPY | ETF | 79.06 | 79.23 | 78.55 | 78.82 | 5404400.0 |
| 2002-10-07 16:00:00 | SPY | ETF | 78.89 | 79.24 | 78.79 | 78.79 | 3315500.0 |
| 2002-10-07 16:30:00 | SPY | ETF | 79.07 | 79.19 | 79.06 | 79.14 | 26800.0 |
| 2002-10-07 17:00:00 | SPY | ETF | 79.16 | 79.19 | 79.08 | 79.16 | 37200.0 |
| 2002-10-07 17:30:00 | SPY | ETF | 79.13 | 81.0 | 78.65 | 79.13 | 21400.0 |
| 2002-10-07 18:00:00 | SPY | ETF | 79.13 | 79.19 | 79.11 | 79.16 | 7200.0 |
| 2002-10-07 08:00:00 | QQQ | ETF | 20.15 | 20.2 | 20.15 | 20.2 | 1100.0 |
| 2002-10-07 08:30:00 | QQQ | ETF | 20.21 | 20.23 | 20.18 | 20.23 | 4900.0 |
| 2002-10-07 09:00:00 | QQQ | ETF | 20.25 | 20.29 | 20.22 | 20.22 | 2900.0 |
| 2002-10-07 09:30:00 | QQQ | ETF | 20.26 | 20.47 | 20.08 | 20.24 | 8450800.0 |
| 2002-10-07 10:00:00 | QQQ | ETF | 20.23 | 20.4 | 20.11 | 20.23 | 5477500.0 |
| 2002-10-07 10:30:00 | QQQ | ETF | 20.24 | 20.32 | 20.09 | 20.23 | 7218100.0 |
| 2002-10-07 11:00:00 | QQQ | ETF | 20.23 | 20.29 | 20.03 | 20.16 | 6953600.0 |
| 2002-10-07 11:30:00 | QQQ | ETF | 20.16 | 20.33 | 20.15 | 20.27 | 3139100.0 |
| 2002-10-07 12:00:00 | QQQ | ETF | 20.25 | 20.55 | 20.22 | 20.51 | 8123500.0 |
| 2002-10-07 12:30:00 | QQQ | ETF | 20.52 | 20.59 | 20.33 | 20.33 | 5290000.0 |
| 2002-10-07 13:00:00 | QQQ | ETF | 20.33 | 20.44 | 20.24 | 20.27 | 2693600.0 |
| 2002-10-07 13:30:00 | QQQ | ETF | 20.28 | 20.39 | 20.23 | 20.36 | 1946100.0 |
| 2002-10-07 14:00:00 | QQQ | ETF | 20.35 | 20.39 | 20.18 | 20.21 | 4681200.0 |
| 2002-10-07 14:30:00 | QQQ | ETF | 20.21 | 20.26 | 20.11 | 20.17 | 3556900.0 |
| 2002-10-07 15:00:00 | QQQ | ETF | 20.17 | 20.19 | 20.0 | 20.04 | 5708200.0 |
| 2002-10-07 15:30:00 | QQQ | ETF | 20.05 | 20.1 | 19.85 | 19.99 | 11010800.0 |
| 2002-10-07 16:00:00 | QQQ | ETF | 20.01 | 20.26 | 19.9 | 20.13 | 3802200.0 |
| 2002-10-07 16:30:00 | QQQ | ETF | 20.14 | 20.15 | 19.97 | 20.13 | 126100.0 |
| 2002-10-07 17:00:00 | QQQ | ETF | 20.12 | 20.22 | 20.12 | 20.17 | 121200.0 |
| 2002-10-07 17:30:00 | QQQ | ETF | 20.16 | 20.19 | 20.15 | 20.18 | 43000.0 |
| 2002-10-07 18:00:00 | QQQ | ETF | 20.18 | 20.2 | 20.11 | 20.15 | 16300.0 |
| 2002-10-07 19:00:00 | QQQ | ETF | 20.18 | 20.2 | 20.16 | 20.2 | 9900.0 |
| 2002-10-07 09:30:00 | IWM | ETF | 34.475 | 34.8 | 34.4 | 34.435 | 412000.0 |
| 2002-10-07 10:00:00 | IWM | ETF | 34.45 | 34.485 | 34.31 | 34.34 | 499200.0 |
| 2002-10-07 10:30:00 | IWM | ETF | 34.34 | 34.395 | 34.14 | 34.185 | 290000.0 |
| 2002-10-07 11:00:00 | IWM | ETF | 34.195 | 34.24 | 34.0 | 34.085 | 149800.0 |
| 2002-10-07 11:30:00 | IWM | ETF | 34.08 | 34.265 | 34.08 | 34.255 | 138800.0 |
| 2002-10-07 12:00:00 | IWM | ETF | 34.265 | 34.345 | 34.205 | 34.345 | 59800.0 |
| 2002-10-07 12:30:00 | IWM | ETF | 34.345 | 34.385 | 34.175 | 34.175 | 163000.0 |
> showing 50 of 596 rows — these rows as CSV