PREVIEW / etf_30min / 2004-03-19
file: by_date/etf_30min/2004/2004-03-19.parquet size: 35 KB rows: 1,154
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-03-19 08:00:00 | SPY | ETF | 112.8 | 112.8 | 112.71 | 112.71 | 22100.0 |
| 2004-03-19 08:30:00 | SPY | ETF | 112.76 | 112.8 | 112.72 | 112.75 | 55100.0 |
| 2004-03-19 09:00:00 | SPY | ETF | 112.79 | 112.8 | 112.4 | 112.4 | 100700.0 |
| 2004-03-19 09:30:00 | SPY | ETF | 112.41 | 112.49 | 111.94 | 112.15 | 6164400.0 |
| 2004-03-19 10:00:00 | SPY | ETF | 112.15 | 112.24 | 111.93 | 112.06 | 2768800.0 |
| 2004-03-19 10:30:00 | SPY | ETF | 112.06 | 112.4 | 112.01 | 112.27 | 4262100.0 |
| 2004-03-19 11:00:00 | SPY | ETF | 112.27 | 112.31 | 112.14 | 112.21 | 1043800.0 |
| 2004-03-19 11:30:00 | SPY | ETF | 112.21 | 112.57 | 112.19 | 112.26 | 2736700.0 |
| 2004-03-19 12:00:00 | SPY | ETF | 112.26 | 112.38 | 112.22 | 112.3 | 1074900.0 |
| 2004-03-19 12:30:00 | SPY | ETF | 112.3 | 112.34 | 112.1 | 112.19 | 1220000.0 |
| 2004-03-19 13:00:00 | SPY | ETF | 112.2 | 112.29 | 111.9 | 111.96 | 1662600.0 |
| 2004-03-19 13:30:00 | SPY | ETF | 111.95 | 112.09 | 111.9 | 112.07 | 1941400.0 |
| 2004-03-19 14:00:00 | SPY | ETF | 112.07 | 112.19 | 111.99 | 112.17 | 1037000.0 |
| 2004-03-19 14:30:00 | SPY | ETF | 112.17 | 112.21 | 111.76 | 111.79 | 1370200.0 |
| 2004-03-19 15:00:00 | SPY | ETF | 111.78 | 111.9 | 111.51 | 111.68 | 4026700.0 |
| 2004-03-19 15:30:00 | SPY | ETF | 111.67 | 111.72 | 111.16 | 111.28 | 6432600.0 |
| 2004-03-19 16:00:00 | SPY | ETF | 111.29 | 111.31 | 110.92 | 111.04 | 6280300.0 |
| 2004-03-19 16:30:00 | SPY | ETF | 111.03 | 111.12 | 110.95 | 111.0 | 101300.0 |
| 2004-03-19 17:00:00 | SPY | ETF | 111.0 | 111.08 | 111.0 | 111.08 | 106700.0 |
| 2004-03-19 17:30:00 | SPY | ETF | 111.08 | 111.08 | 111.06 | 111.06 | 2000.0 |
| 2004-03-19 18:00:00 | SPY | ETF | 111.08 | 111.1 | 111.07 | 111.07 | 5100.0 |
| 2004-03-19 18:30:00 | SPY | ETF | 111.1 | 111.13 | 111.1 | 111.13 | 1900.0 |
| 2004-03-19 19:00:00 | SPY | ETF | 111.12 | 111.12 | 111.12 | 111.12 | 500.0 |
| 2004-03-19 19:30:00 | SPY | ETF | 111.13 | 111.13 | 111.13 | 111.13 | 400.0 |
| 2004-03-19 08:00:00 | QQQ | ETF | 35.43 | 35.45 | 35.37 | 35.39 | 64200.0 |
| 2004-03-19 08:30:00 | QQQ | ETF | 35.39 | 35.41 | 35.37 | 35.38 | 52900.0 |
| 2004-03-19 09:00:00 | QQQ | ETF | 35.4 | 35.43 | 35.28 | 35.28 | 328800.0 |
| 2004-03-19 09:30:00 | QQQ | ETF | 35.275 | 35.31 | 35.05 | 35.15 | 10501000.0 |
| 2004-03-19 10:00:00 | QQQ | ETF | 35.13 | 35.18 | 35.04 | 35.145 | 8265300.0 |
| 2004-03-19 10:30:00 | QQQ | ETF | 35.144 | 35.28 | 35.08 | 35.25 | 7774100.0 |
| 2004-03-19 11:00:00 | QQQ | ETF | 35.26 | 35.328 | 35.22 | 35.29 | 3548400.0 |
| 2004-03-19 11:30:00 | QQQ | ETF | 35.284 | 35.456 | 35.28 | 35.329 | 5902800.0 |
| 2004-03-19 12:00:00 | QQQ | ETF | 35.33 | 35.39 | 35.28 | 35.32 | 3227800.0 |
| 2004-03-19 12:30:00 | QQQ | ETF | 35.32 | 35.34 | 35.25 | 35.276 | 2669100.0 |
| 2004-03-19 13:00:00 | QQQ | ETF | 35.276 | 35.34 | 35.1 | 35.154 | 5962500.0 |
| 2004-03-19 13:30:00 | QQQ | ETF | 35.16 | 35.18 | 35.102 | 35.171 | 5287100.0 |
| 2004-03-19 14:00:00 | QQQ | ETF | 35.17 | 35.192 | 35.13 | 35.18 | 3306800.0 |
| 2004-03-19 14:30:00 | QQQ | ETF | 35.18 | 35.23 | 34.987 | 34.988 | 5179800.0 |
| 2004-03-19 15:00:00 | QQQ | ETF | 34.99 | 35.03 | 34.91 | 35.0 | 10964300.0 |
| 2004-03-19 15:30:00 | QQQ | ETF | 34.99 | 35.02 | 34.82 | 34.827 | 15333000.0 |
| 2004-03-19 16:00:00 | QQQ | ETF | 34.827 | 34.85 | 34.725 | 34.77 | 3959400.0 |
| 2004-03-19 16:30:00 | QQQ | ETF | 34.77 | 34.77 | 34.69 | 34.73 | 262300.0 |
| 2004-03-19 17:00:00 | QQQ | ETF | 34.72 | 34.79 | 34.68 | 34.68 | 879200.0 |
| 2004-03-19 17:30:00 | QQQ | ETF | 34.71 | 34.72 | 34.68 | 34.69 | 130800.0 |
| 2004-03-19 18:00:00 | QQQ | ETF | 34.69 | 34.7 | 34.68 | 34.69 | 27800.0 |
| 2004-03-19 18:30:00 | QQQ | ETF | 34.69 | 34.69 | 34.68 | 34.69 | 9500.0 |
| 2004-03-19 19:00:00 | QQQ | ETF | 34.69 | 34.69 | 34.68 | 34.68 | 22000.0 |
| 2004-03-19 19:30:00 | QQQ | ETF | 34.69 | 34.69 | 34.68 | 34.68 | 6500.0 |
| 2004-03-19 08:30:00 | IWM | ETF | 57.415 | 57.415 | 57.35 | 57.38 | 2600.0 |
| 2004-03-19 09:00:00 | IWM | ETF | 57.435 | 57.435 | 57.32 | 57.32 | 1400.0 |
> showing 50 of 1,154 rows — these rows as CSV