PREVIEW / etf_30min / 2009-02-24
file: by_date/etf_30min/2009/2009-02-24.parquet size: 215 KB rows: 7,043
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-24 04:00:00 | SPY | ETF | 75.68 | 75.8 | 75.6 | 75.6 | 3700.0 |
| 2009-02-24 04:30:00 | SPY | ETF | 75.42 | 75.42 | 75.2 | 75.2 | 10600.0 |
| 2009-02-24 05:00:00 | SPY | ETF | 75.3 | 75.3 | 75.25 | 75.27 | 400.0 |
| 2009-02-24 05:30:00 | SPY | ETF | 75.43 | 75.59 | 75.43 | 75.5 | 2700.0 |
| 2009-02-24 06:00:00 | SPY | ETF | 75.51 | 75.86 | 75.5 | 75.7 | 27600.0 |
| 2009-02-24 06:30:00 | SPY | ETF | 75.57 | 75.6 | 75.36 | 75.36 | 9200.0 |
| 2009-02-24 07:00:00 | SPY | ETF | 75.38 | 75.68 | 75.35 | 75.54 | 295474.0 |
| 2009-02-24 07:30:00 | SPY | ETF | 75.55 | 75.75 | 75.38 | 75.65 | 397628.0 |
| 2009-02-24 08:00:00 | SPY | ETF | 75.65 | 75.76 | 75.42 | 75.46 | 1352711.0 |
| 2009-02-24 08:30:00 | SPY | ETF | 75.46 | 75.47 | 75.01 | 75.1 | 2123935.0 |
| 2009-02-24 09:00:00 | SPY | ETF | 75.11 | 75.63 | 75.1 | 75.3 | 2173649.0 |
| 2009-02-24 09:30:00 | SPY | ETF | 75.29 | 75.84 | 75.15 | 75.38 | 38745303.0 |
| 2009-02-24 10:00:00 | SPY | ETF | 75.38 | 75.51 | 74.84 | 75.452 | 42326749.0 |
| 2009-02-24 10:30:00 | SPY | ETF | 75.43 | 76.24 | 75.4 | 75.85 | 34722981.0 |
| 2009-02-24 11:00:00 | SPY | ETF | 75.84 | 76.01 | 75.66 | 75.82 | 22131451.0 |
| 2009-02-24 11:30:00 | SPY | ETF | 75.82 | 75.86 | 75.26 | 75.37 | 17728206.0 |
| 2009-02-24 12:00:00 | SPY | ETF | 75.38 | 75.67 | 75.09 | 75.4 | 19207853.0 |
| 2009-02-24 12:30:00 | SPY | ETF | 75.41 | 75.96 | 75.39 | 75.84 | 19804550.0 |
| 2009-02-24 13:00:00 | SPY | ETF | 75.84 | 76.59 | 75.55 | 76.56 | 24689505.0 |
| 2009-02-24 13:30:00 | SPY | ETF | 76.56 | 77.0 | 76.52 | 76.918 | 37463441.0 |
| 2009-02-24 14:00:00 | SPY | ETF | 76.92 | 77.35 | 76.67 | 77.22 | 33979543.0 |
| 2009-02-24 14:30:00 | SPY | ETF | 77.22 | 77.4 | 76.92 | 77.27 | 24454958.0 |
| 2009-02-24 15:00:00 | SPY | ETF | 77.26 | 77.95 | 77.25 | 77.66 | 33349575.0 |
| 2009-02-24 15:30:00 | SPY | ETF | 77.67 | 77.82 | 76.56 | 77.57 | 46674543.0 |
| 2009-02-24 16:00:00 | SPY | ETF | 77.58 | 77.75 | 74.7003 | 77.35 | 16509204.0 |
| 2009-02-24 16:30:00 | SPY | ETF | 77.35 | 77.47 | 77.35 | 77.41 | 2081692.0 |
| 2009-02-24 17:00:00 | SPY | ETF | 77.4 | 77.57 | 77.36 | 77.56 | 560947.0 |
| 2009-02-24 17:30:00 | SPY | ETF | 77.54 | 77.62 | 77.5 | 77.6 | 32653.0 |
| 2009-02-24 18:00:00 | SPY | ETF | 77.57 | 77.64 | 77.51 | 77.64 | 88605.0 |
| 2009-02-24 18:30:00 | SPY | ETF | 77.65 | 77.69 | 77.53 | 77.59 | 86325.0 |
| 2009-02-24 19:00:00 | SPY | ETF | 77.64 | 77.66 | 77.53 | 77.53 | 15540.0 |
| 2009-02-24 19:30:00 | SPY | ETF | 77.56 | 77.56 | 77.39 | 77.4 | 52043.0 |
| 2009-02-24 04:00:00 | QQQ | ETF | 28.09 | 28.1 | 28.09 | 28.1 | 1400.0 |
| 2009-02-24 04:30:00 | QQQ | ETF | 28.0 | 28.0 | 28.0 | 28.0 | 720.0 |
| 2009-02-24 06:00:00 | QQQ | ETF | 28.04 | 28.19 | 28.03 | 28.19 | 20100.0 |
| 2009-02-24 07:00:00 | QQQ | ETF | 28.09 | 28.16 | 28.06 | 28.13 | 19200.0 |
| 2009-02-24 07:30:00 | QQQ | ETF | 28.09 | 28.14 | 28.07 | 28.1 | 13775.0 |
| 2009-02-24 08:00:00 | QQQ | ETF | 28.11 | 28.11 | 28.02 | 28.05 | 170912.0 |
| 2009-02-24 08:30:00 | QQQ | ETF | 28.05 | 28.05 | 27.98 | 28.01 | 271604.0 |
| 2009-02-24 09:00:00 | QQQ | ETF | 28.05 | 28.12 | 28.01 | 28.01 | 783945.0 |
| 2009-02-24 09:30:00 | QQQ | ETF | 28.0 | 28.35 | 27.96 | 28.15 | 23117566.0 |
| 2009-02-24 10:00:00 | QQQ | ETF | 28.15 | 28.24 | 27.97 | 28.21 | 15324785.0 |
| 2009-02-24 10:30:00 | QQQ | ETF | 28.21 | 28.53 | 28.2 | 28.33 | 12629690.0 |
| 2009-02-24 11:00:00 | QQQ | ETF | 28.3205 | 28.4 | 28.23 | 28.28 | 7328767.0 |
| 2009-02-24 11:30:00 | QQQ | ETF | 28.2899 | 28.32 | 28.05 | 28.131 | 6435054.0 |
| 2009-02-24 12:00:00 | QQQ | ETF | 28.13 | 28.21 | 28.02 | 28.16 | 8102956.0 |
| 2009-02-24 12:30:00 | QQQ | ETF | 28.16 | 28.28 | 28.16 | 28.19 | 6850040.0 |
| 2009-02-24 13:00:00 | QQQ | ETF | 28.2 | 28.4 | 28.05 | 28.4 | 10996786.0 |
| 2009-02-24 13:30:00 | QQQ | ETF | 28.4 | 28.54 | 28.38 | 28.5 | 13755118.0 |
| 2009-02-24 14:00:00 | QQQ | ETF | 28.5 | 28.75 | 28.43 | 28.68 | 13347363.0 |
> showing 50 of 7,043 rows — these rows as CSV