PREVIEW / etf_30min / 2002-10-02
file: by_date/etf_30min/2002/2002-10-02.parquet size: 21 KB rows: 595
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-02 08:00:00 | SPY | ETF | 85.18 | 85.18 | 84.75 | 84.75 | 14900.0 |
| 2002-10-02 08:30:00 | SPY | ETF | 84.82 | 84.89 | 84.79 | 84.87 | 7300.0 |
| 2002-10-02 09:00:00 | SPY | ETF | 84.9 | 84.95 | 84.7 | 84.72 | 10200.0 |
| 2002-10-02 09:30:00 | SPY | ETF | 84.69 | 85.24 | 84.09 | 84.11 | 6417600.0 |
| 2002-10-02 10:00:00 | SPY | ETF | 84.11 | 84.3 | 83.8 | 84.25 | 4144400.0 |
| 2002-10-02 10:30:00 | SPY | ETF | 84.17 | 84.71 | 84.04 | 84.3 | 4722200.0 |
| 2002-10-02 11:00:00 | SPY | ETF | 84.31 | 84.6 | 84.1 | 84.57 | 2609800.0 |
| 2002-10-02 11:30:00 | SPY | ETF | 84.57 | 85.19 | 84.48 | 85.09 | 3373100.0 |
| 2002-10-02 12:00:00 | SPY | ETF | 85.09 | 85.16 | 84.75 | 84.84 | 1809100.0 |
| 2002-10-02 12:30:00 | SPY | ETF | 84.83 | 85.53 | 84.82 | 85.1 | 3919800.0 |
| 2002-10-02 13:00:00 | SPY | ETF | 85.08 | 85.36 | 84.77 | 85.04 | 1977500.0 |
| 2002-10-02 13:30:00 | SPY | ETF | 85.02 | 85.07 | 84.35 | 84.58 | 2349200.0 |
| 2002-10-02 14:00:00 | SPY | ETF | 84.55 | 84.67 | 84.04 | 84.15 | 2905100.0 |
| 2002-10-02 14:30:00 | SPY | ETF | 84.14 | 84.48 | 83.95 | 84.13 | 2315500.0 |
| 2002-10-02 15:00:00 | SPY | ETF | 84.13 | 84.45 | 83.16 | 83.2 | 3994800.0 |
| 2002-10-02 15:30:00 | SPY | ETF | 83.2 | 83.31 | 82.6 | 83.05 | 10651900.0 |
| 2002-10-02 16:00:00 | SPY | ETF | 83.05 | 83.59 | 83.02 | 83.2 | 2708700.0 |
| 2002-10-02 16:30:00 | SPY | ETF | 83.2 | 83.2 | 83.01 | 83.05 | 385400.0 |
| 2002-10-02 17:00:00 | SPY | ETF | 83.05 | 83.92 | 83.01 | 83.08 | 74800.0 |
| 2002-10-02 17:30:00 | SPY | ETF | 83.05 | 83.09 | 83.0 | 83.02 | 102600.0 |
| 2002-10-02 18:00:00 | SPY | ETF | 83.06 | 83.07 | 82.92 | 83.07 | 4100.0 |
| 2002-10-02 08:00:00 | QQQ | ETF | 21.8 | 21.8 | 21.6 | 21.61 | 10600.0 |
| 2002-10-02 08:30:00 | QQQ | ETF | 21.6 | 21.62 | 21.58 | 21.58 | 27200.0 |
| 2002-10-02 09:00:00 | QQQ | ETF | 21.6 | 21.62 | 21.52 | 21.52 | 72200.0 |
| 2002-10-02 09:30:00 | QQQ | ETF | 21.51 | 21.74 | 21.41 | 21.42 | 9785100.0 |
| 2002-10-02 10:00:00 | QQQ | ETF | 21.42 | 21.5 | 21.26 | 21.48 | 9541800.0 |
| 2002-10-02 10:30:00 | QQQ | ETF | 21.47 | 21.59 | 21.38 | 21.41 | 7555800.0 |
| 2002-10-02 11:00:00 | QQQ | ETF | 21.39 | 21.53 | 21.35 | 21.53 | 3783400.0 |
| 2002-10-02 11:30:00 | QQQ | ETF | 21.54 | 21.74 | 21.45 | 21.7 | 6557000.0 |
| 2002-10-02 12:00:00 | QQQ | ETF | 21.7 | 21.75 | 21.6 | 21.66 | 3493500.0 |
| 2002-10-02 12:30:00 | QQQ | ETF | 21.67 | 21.97 | 21.65 | 21.84 | 7321100.0 |
| 2002-10-02 13:00:00 | QQQ | ETF | 21.85 | 21.92 | 21.7 | 21.82 | 4147800.0 |
| 2002-10-02 13:30:00 | QQQ | ETF | 21.79 | 21.84 | 21.53 | 21.56 | 4112200.0 |
| 2002-10-02 14:00:00 | QQQ | ETF | 21.56 | 21.58 | 21.29 | 21.31 | 10413600.0 |
| 2002-10-02 14:30:00 | QQQ | ETF | 21.33 | 21.49 | 21.24 | 21.43 | 5439700.0 |
| 2002-10-02 15:00:00 | QQQ | ETF | 21.42 | 21.49 | 21.05 | 21.06 | 7288100.0 |
| 2002-10-02 15:30:00 | QQQ | ETF | 21.06 | 21.24 | 20.97 | 21.16 | 10049200.0 |
| 2002-10-02 16:00:00 | QQQ | ETF | 21.16 | 21.27 | 20.9 | 21.05 | 3298800.0 |
| 2002-10-02 16:30:00 | QQQ | ETF | 21.07 | 21.17 | 21.05 | 21.1 | 423600.0 |
| 2002-10-02 17:00:00 | QQQ | ETF | 21.13 | 21.15 | 21.08 | 21.12 | 323900.0 |
| 2002-10-02 17:30:00 | QQQ | ETF | 21.1 | 21.25 | 21.08 | 21.11 | 53400.0 |
| 2002-10-02 18:00:00 | QQQ | ETF | 21.11 | 21.16 | 21.1 | 21.11 | 31200.0 |
| 2002-10-02 18:30:00 | QQQ | ETF | 21.11 | 21.11 | 21.11 | 21.11 | 500.0 |
| 2002-10-02 19:00:00 | QQQ | ETF | 21.11 | 21.11 | 21.11 | 21.11 | 1500.0 |
| 2002-10-02 19:30:00 | QQQ | ETF | 21.11 | 21.16 | 21.11 | 21.16 | 1200.0 |
| 2002-10-02 09:30:00 | IWM | ETF | 36.575 | 36.62 | 36.4 | 36.485 | 67600.0 |
| 2002-10-02 10:00:00 | IWM | ETF | 36.465 | 36.465 | 36.225 | 36.385 | 180000.0 |
| 2002-10-02 10:30:00 | IWM | ETF | 36.395 | 36.605 | 36.35 | 36.46 | 132400.0 |
| 2002-10-02 11:00:00 | IWM | ETF | 36.45 | 36.47 | 36.37 | 36.47 | 83000.0 |
| 2002-10-02 11:30:00 | IWM | ETF | 36.47 | 36.725 | 36.47 | 36.725 | 84800.0 |
> showing 50 of 595 rows — these rows as CSV