PREVIEW / etf_30min / 2004-11-02
file: by_date/etf_30min/2004/2004-11-02.parquet size: 39 KB rows: 1,318
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-02 08:00:00 | SPY | ETF | 113.78 | 113.8 | 113.74 | 113.76 | 77300.0 |
| 2004-11-02 08:30:00 | SPY | ETF | 113.76 | 113.76 | 113.72 | 113.72 | 3500.0 |
| 2004-11-02 09:00:00 | SPY | ETF | 113.76 | 113.8 | 113.68 | 113.71 | 47900.0 |
| 2004-11-02 09:30:00 | SPY | ETF | 113.67 | 113.91 | 113.57 | 113.88 | 3980500.0 |
| 2004-11-02 10:00:00 | SPY | ETF | 113.9 | 114.42 | 113.83 | 114.31 | 5829900.0 |
| 2004-11-02 10:30:00 | SPY | ETF | 114.31 | 114.4 | 114.2 | 114.26 | 4116500.0 |
| 2004-11-02 11:00:00 | SPY | ETF | 114.26 | 114.44 | 114.25 | 114.41 | 2748400.0 |
| 2004-11-02 11:30:00 | SPY | ETF | 114.41 | 114.48 | 114.27 | 114.43 | 1922000.0 |
| 2004-11-02 12:00:00 | SPY | ETF | 114.41 | 114.48 | 114.33 | 114.46 | 1237800.0 |
| 2004-11-02 12:30:00 | SPY | ETF | 114.46 | 114.55 | 114.36 | 114.43 | 1683000.0 |
| 2004-11-02 13:00:00 | SPY | ETF | 114.41 | 114.57 | 114.38 | 114.53 | 1279000.0 |
| 2004-11-02 13:30:00 | SPY | ETF | 114.52 | 114.55 | 114.29 | 114.37 | 1692200.0 |
| 2004-11-02 14:00:00 | SPY | ETF | 114.37 | 114.54 | 114.33 | 114.49 | 1886400.0 |
| 2004-11-02 14:30:00 | SPY | ETF | 114.49 | 114.5 | 113.57 | 113.97 | 7511000.0 |
| 2004-11-02 15:00:00 | SPY | ETF | 113.97 | 113.98 | 113.37 | 113.47 | 8415100.0 |
| 2004-11-02 15:30:00 | SPY | ETF | 113.44 | 113.63 | 113.22 | 113.5 | 8111400.0 |
| 2004-11-02 16:00:00 | SPY | ETF | 113.5 | 113.61 | 113.43 | 113.53 | 3065000.0 |
| 2004-11-02 16:30:00 | SPY | ETF | 113.53 | 113.55 | 113.36 | 113.46 | 780400.0 |
| 2004-11-02 17:00:00 | SPY | ETF | 113.45 | 113.49 | 113.4 | 113.4 | 68300.0 |
| 2004-11-02 17:30:00 | SPY | ETF | 113.43 | 113.44 | 113.4 | 113.44 | 2600.0 |
| 2004-11-02 18:00:00 | SPY | ETF | 113.4 | 113.46 | 113.31 | 113.42 | 17400.0 |
| 2004-11-02 18:30:00 | SPY | ETF | 113.42 | 113.52 | 113.41 | 113.41 | 5100.0 |
| 2004-11-02 19:00:00 | SPY | ETF | 113.41 | 113.52 | 113.41 | 113.47 | 2800.0 |
| 2004-11-02 19:30:00 | SPY | ETF | 113.44 | 113.44 | 113.4 | 113.4 | 2100.0 |
| 2004-11-02 08:00:00 | QQQ | ETF | 37.12 | 37.12 | 37.07 | 37.11 | 78200.0 |
| 2004-11-02 08:30:00 | QQQ | ETF | 37.1 | 37.11 | 37.09 | 37.11 | 58600.0 |
| 2004-11-02 09:00:00 | QQQ | ETF | 37.11 | 37.12 | 37.08 | 37.09 | 93100.0 |
| 2004-11-02 09:30:00 | QQQ | ETF | 37.09 | 37.19 | 37.02 | 37.16 | 9040300.0 |
| 2004-11-02 10:00:00 | QQQ | ETF | 37.17 | 37.45 | 37.16 | 37.4 | 12931300.0 |
| 2004-11-02 10:30:00 | QQQ | ETF | 37.4 | 37.45 | 37.35 | 37.387 | 9898200.0 |
| 2004-11-02 11:00:00 | QQQ | ETF | 37.386 | 37.51 | 37.38 | 37.476 | 8958300.0 |
| 2004-11-02 11:30:00 | QQQ | ETF | 37.48 | 37.51 | 37.41 | 37.45 | 3839800.0 |
| 2004-11-02 12:00:00 | QQQ | ETF | 37.45 | 37.5 | 37.43 | 37.47 | 3898600.0 |
| 2004-11-02 12:30:00 | QQQ | ETF | 37.46 | 37.5 | 37.42 | 37.45 | 2816700.0 |
| 2004-11-02 13:00:00 | QQQ | ETF | 37.45 | 37.55 | 37.446 | 37.54 | 4146400.0 |
| 2004-11-02 13:30:00 | QQQ | ETF | 37.53 | 37.54 | 37.44 | 37.46 | 3327500.0 |
| 2004-11-02 14:00:00 | QQQ | ETF | 37.46 | 37.55 | 37.459 | 37.52 | 4705300.0 |
| 2004-11-02 14:30:00 | QQQ | ETF | 37.526 | 37.54 | 37.16 | 37.32 | 10860400.0 |
| 2004-11-02 15:00:00 | QQQ | ETF | 37.327 | 37.34 | 37.03 | 37.089 | 14953600.0 |
| 2004-11-02 15:30:00 | QQQ | ETF | 37.089 | 37.19 | 37.02 | 37.155 | 14060200.0 |
| 2004-11-02 16:00:00 | QQQ | ETF | 37.155 | 37.24 | 37.13 | 37.17 | 2636900.0 |
| 2004-11-02 16:30:00 | QQQ | ETF | 37.18 | 37.19 | 37.14 | 37.17 | 131500.0 |
| 2004-11-02 17:00:00 | QQQ | ETF | 37.17 | 37.173 | 37.14 | 37.14 | 962600.0 |
| 2004-11-02 17:30:00 | QQQ | ETF | 37.16 | 37.22 | 37.15 | 37.2 | 49600.0 |
| 2004-11-02 18:00:00 | QQQ | ETF | 37.2 | 37.21 | 37.16 | 37.18 | 126500.0 |
| 2004-11-02 18:30:00 | QQQ | ETF | 37.19 | 37.22 | 37.18 | 37.2 | 13900.0 |
| 2004-11-02 19:00:00 | QQQ | ETF | 37.2 | 37.2 | 37.2 | 37.2 | 2600.0 |
| 2004-11-02 19:30:00 | QQQ | ETF | 37.2 | 37.2 | 37.17 | 37.2 | 45800.0 |
| 2004-11-02 08:00:00 | IWM | ETF | 58.7 | 58.7 | 58.67 | 58.67 | 2400.0 |
| 2004-11-02 08:30:00 | IWM | ETF | 58.65 | 58.65 | 58.65 | 58.65 | 12000.0 |
> showing 50 of 1,318 rows — these rows as CSV