PREVIEW / etf_30min / 2004-12-02
file: by_date/etf_30min/2004/2004-12-02.parquet size: 41 KB rows: 1,370
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-12-02 08:00:00 | SPY | ETF | 119.4 | 119.48 | 119.4 | 119.4 | 50300.0 |
| 2004-12-02 08:30:00 | SPY | ETF | 119.38 | 119.44 | 119.1 | 119.14 | 276200.0 |
| 2004-12-02 09:00:00 | SPY | ETF | 119.12 | 119.19 | 119.11 | 119.11 | 210600.0 |
| 2004-12-02 09:30:00 | SPY | ETF | 119.1 | 119.34 | 119.01 | 119.23 | 6610500.0 |
| 2004-12-02 10:00:00 | SPY | ETF | 119.23 | 119.47 | 119.13 | 119.4 | 4257900.0 |
| 2004-12-02 10:30:00 | SPY | ETF | 119.39 | 119.74 | 119.38 | 119.63 | 6123600.0 |
| 2004-12-02 11:00:00 | SPY | ETF | 119.63 | 119.87 | 119.62 | 119.71 | 6346600.0 |
| 2004-12-02 11:30:00 | SPY | ETF | 119.71 | 119.79 | 119.58 | 119.7 | 3625600.0 |
| 2004-12-02 12:00:00 | SPY | ETF | 119.69 | 119.73 | 119.58 | 119.65 | 2322200.0 |
| 2004-12-02 12:30:00 | SPY | ETF | 119.65 | 119.66 | 119.29 | 119.35 | 5166800.0 |
| 2004-12-02 13:00:00 | SPY | ETF | 119.36 | 119.44 | 119.12 | 119.21 | 4608700.0 |
| 2004-12-02 13:30:00 | SPY | ETF | 119.2 | 119.42 | 119.11 | 119.26 | 3116300.0 |
| 2004-12-02 14:00:00 | SPY | ETF | 119.26 | 119.48 | 119.17 | 119.45 | 2495300.0 |
| 2004-12-02 14:30:00 | SPY | ETF | 119.45 | 119.57 | 119.38 | 119.48 | 2497000.0 |
| 2004-12-02 15:00:00 | SPY | ETF | 119.47 | 119.54 | 119.2 | 119.41 | 2964500.0 |
| 2004-12-02 15:30:00 | SPY | ETF | 119.43 | 119.48 | 119.32 | 119.39 | 4155500.0 |
| 2004-12-02 16:00:00 | SPY | ETF | 119.39 | 119.95 | 119.32 | 119.85 | 2877600.0 |
| 2004-12-02 16:30:00 | SPY | ETF | 119.8 | 119.9 | 119.7 | 119.89 | 477200.0 |
| 2004-12-02 17:00:00 | SPY | ETF | 119.89 | 119.91 | 119.83 | 119.9 | 55200.0 |
| 2004-12-02 17:30:00 | SPY | ETF | 119.9 | 119.91 | 119.39 | 119.9 | 5400.0 |
| 2004-12-02 18:00:00 | SPY | ETF | 119.86 | 119.93 | 119.86 | 119.9 | 40700.0 |
| 2004-12-02 18:30:00 | SPY | ETF | 119.86 | 119.92 | 119.86 | 119.9 | 2400.0 |
| 2004-12-02 19:00:00 | SPY | ETF | 119.92 | 119.92 | 119.87 | 119.87 | 5500.0 |
| 2004-12-02 19:30:00 | SPY | ETF | 119.85 | 119.85 | 119.84 | 119.84 | 7300.0 |
| 2004-12-02 08:00:00 | QQQ | ETF | 39.94 | 39.95 | 39.91 | 39.92 | 371083.0 |
| 2004-12-02 08:30:00 | QQQ | ETF | 39.93 | 39.93 | 39.73 | 39.78 | 1461088.0 |
| 2004-12-02 09:00:00 | QQQ | ETF | 39.78 | 39.85 | 39.77 | 39.817 | 773546.0 |
| 2004-12-02 09:30:00 | QQQ | ETF | 39.82 | 40.0 | 39.76 | 39.95 | 10945169.0 |
| 2004-12-02 10:00:00 | QQQ | ETF | 39.95 | 40.07 | 39.899 | 40.05 | 10830533.0 |
| 2004-12-02 10:30:00 | QQQ | ETF | 40.054 | 40.29 | 40.04 | 40.24 | 14957235.0 |
| 2004-12-02 11:00:00 | QQQ | ETF | 40.235 | 40.39 | 40.23 | 40.301 | 13217421.0 |
| 2004-12-02 11:30:00 | QQQ | ETF | 40.307 | 40.37 | 40.22 | 40.24 | 10316745.0 |
| 2004-12-02 12:00:00 | QQQ | ETF | 40.23 | 40.25 | 40.12 | 40.153 | 6620914.0 |
| 2004-12-02 12:30:00 | QQQ | ETF | 40.16 | 40.16 | 40.01 | 40.053 | 5829912.0 |
| 2004-12-02 13:00:00 | QQQ | ETF | 40.05 | 40.13 | 39.97 | 39.991 | 5247745.0 |
| 2004-12-02 13:30:00 | QQQ | ETF | 39.99 | 40.11 | 39.95 | 40.05 | 6482568.0 |
| 2004-12-02 14:00:00 | QQQ | ETF | 40.05 | 40.16 | 40.01 | 40.15 | 5216515.0 |
| 2004-12-02 14:30:00 | QQQ | ETF | 40.15 | 40.184 | 40.11 | 40.16 | 4293970.0 |
| 2004-12-02 15:00:00 | QQQ | ETF | 40.159 | 40.176 | 40.018 | 40.065 | 6898807.0 |
| 2004-12-02 15:30:00 | QQQ | ETF | 40.06 | 40.102 | 40.02 | 40.08 | 5056397.0 |
| 2004-12-02 16:00:00 | QQQ | ETF | 40.08 | 40.53 | 40.049 | 40.43 | 3715346.0 |
| 2004-12-02 16:30:00 | QQQ | ETF | 40.43 | 40.53 | 40.38 | 40.53 | 2765874.0 |
| 2004-12-02 17:00:00 | QQQ | ETF | 40.52 | 40.54 | 40.47 | 40.48 | 655787.0 |
| 2004-12-02 17:30:00 | QQQ | ETF | 40.49 | 40.54 | 40.35 | 40.51 | 82220.0 |
| 2004-12-02 18:00:00 | QQQ | ETF | 40.51 | 40.51 | 40.47 | 40.49 | 120443.0 |
| 2004-12-02 08:30:00 | IWM | ETF | 64.175 | 64.175 | 63.935 | 63.975 | 23800.0 |
| 2004-12-02 09:00:00 | IWM | ETF | 63.98 | 64.015 | 63.98 | 64.01 | 15000.0 |
| 2004-12-02 09:30:00 | IWM | ETF | 64.005 | 64.35 | 64.005 | 64.21 | 2424000.0 |
| 2004-12-02 10:00:00 | IWM | ETF | 64.235 | 64.335 | 64.065 | 64.17 | 1072000.0 |
| 2004-12-02 10:30:00 | IWM | ETF | 64.16 | 64.295 | 64.105 | 64.24 | 686600.0 |
> showing 50 of 1,370 rows — these rows as CSV