PREVIEW / etf_30min / 2005-04-19
file: by_date/etf_30min/2005/2005-04-19.parquet size: 44 KB rows: 1,531
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-19 04:30:00 | SPY | ETF | 114.72 | 114.72 | 114.71 | 114.71 | 2000.0 |
| 2005-04-19 07:00:00 | SPY | ETF | 114.84 | 114.9 | 114.8 | 114.9 | 63500.0 |
| 2005-04-19 07:30:00 | SPY | ETF | 115.0 | 115.04 | 114.91 | 114.91 | 149000.0 |
| 2005-04-19 08:00:00 | SPY | ETF | 114.9 | 114.95 | 114.78 | 114.87 | 283100.0 |
| 2005-04-19 08:30:00 | SPY | ETF | 114.95 | 115.12 | 114.9 | 115.02 | 613900.0 |
| 2005-04-19 09:00:00 | SPY | ETF | 115.03 | 115.11 | 115.01 | 115.06 | 370600.0 |
| 2005-04-19 09:30:00 | SPY | ETF | 115.1 | 115.27 | 115.0 | 115.25 | 11556900.0 |
| 2005-04-19 10:00:00 | SPY | ETF | 115.26 | 115.33 | 115.05 | 115.13 | 8099500.0 |
| 2005-04-19 10:30:00 | SPY | ETF | 115.13 | 115.23 | 114.83 | 114.98 | 5479500.0 |
| 2005-04-19 11:00:00 | SPY | ETF | 114.98 | 115.32 | 114.93 | 115.29 | 2977800.0 |
| 2005-04-19 11:30:00 | SPY | ETF | 115.26 | 115.29 | 115.12 | 115.26 | 3495600.0 |
| 2005-04-19 12:00:00 | SPY | ETF | 115.26 | 115.3 | 114.99 | 115.08 | 3853800.0 |
| 2005-04-19 12:30:00 | SPY | ETF | 115.08 | 115.25 | 115.03 | 115.15 | 1601800.0 |
| 2005-04-19 13:00:00 | SPY | ETF | 115.15 | 115.24 | 114.95 | 115.14 | 2366500.0 |
| 2005-04-19 13:30:00 | SPY | ETF | 115.13 | 115.49 | 115.11 | 115.42 | 4682700.0 |
| 2005-04-19 14:00:00 | SPY | ETF | 115.43 | 115.53 | 115.25 | 115.4 | 3829400.0 |
| 2005-04-19 14:30:00 | SPY | ETF | 115.38 | 115.49 | 115.24 | 115.41 | 2464700.0 |
| 2005-04-19 15:00:00 | SPY | ETF | 115.41 | 115.42 | 115.11 | 115.27 | 4081600.0 |
| 2005-04-19 15:30:00 | SPY | ETF | 115.27 | 115.45 | 115.21 | 115.3 | 5179300.0 |
| 2005-04-19 16:00:00 | SPY | ETF | 115.3085 | 115.89 | 115.03 | 115.66 | 2000600.0 |
| 2005-04-19 16:30:00 | SPY | ETF | 115.63 | 115.81 | 115.32 | 115.8 | 3530100.0 |
| 2005-04-19 17:00:00 | SPY | ETF | 115.75 | 115.78 | 115.73 | 115.77 | 124800.0 |
| 2005-04-19 17:30:00 | SPY | ETF | 115.75 | 115.78 | 115.74 | 115.76 | 700.0 |
| 2005-04-19 18:00:00 | SPY | ETF | 115.75 | 115.75 | 115.69 | 115.72 | 31800.0 |
| 2005-04-19 18:30:00 | SPY | ETF | 115.72 | 115.76 | 115.7 | 115.76 | 700.0 |
| 2005-04-19 19:00:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 200.0 |
| 2005-04-19 19:30:00 | SPY | ETF | 115.74 | 115.8 | 115.74 | 115.8 | 4700.0 |
| 2005-04-19 09:30:00 | QQQ | ETF | 35.02 | 35.05 | 34.9 | 35.01 | 15963200.0 |
| 2005-04-19 10:00:00 | QQQ | ETF | 35.02 | 35.04 | 34.87 | 34.92 | 7954700.0 |
| 2005-04-19 10:30:00 | QQQ | ETF | 34.91 | 34.97 | 34.75 | 34.84 | 7618600.0 |
| 2005-04-19 11:00:00 | QQQ | ETF | 34.84 | 35.02 | 34.82 | 34.99 | 5721200.0 |
| 2005-04-19 11:30:00 | QQQ | ETF | 34.99 | 35.01 | 34.9 | 34.99 | 3643700.0 |
| 2005-04-19 12:00:00 | QQQ | ETF | 34.98 | 35.0 | 34.86 | 34.89 | 3703700.0 |
| 2005-04-19 12:30:00 | QQQ | ETF | 34.88 | 34.98 | 34.87 | 34.94 | 3504200.0 |
| 2005-04-19 13:00:00 | QQQ | ETF | 34.94 | 34.97 | 34.91 | 34.97 | 2373000.0 |
| 2005-04-19 13:30:00 | QQQ | ETF | 34.97 | 35.1 | 34.96 | 35.07 | 9350000.0 |
| 2005-04-19 14:00:00 | QQQ | ETF | 35.07 | 35.08 | 35.0 | 35.02 | 4161700.0 |
| 2005-04-19 14:30:00 | QQQ | ETF | 35.02 | 35.06 | 34.97 | 35.01 | 3876600.0 |
| 2005-04-19 15:00:00 | QQQ | ETF | 35.01 | 35.03 | 34.95 | 35.02 | 4452700.0 |
| 2005-04-19 15:30:00 | QQQ | ETF | 35.01 | 35.08 | 34.97 | 34.99 | 11698900.0 |
| 2005-04-19 07:30:00 | IWM | ETF | 58.45 | 58.55 | 58.45 | 58.49 | 68800.0 |
| 2005-04-19 08:00:00 | IWM | ETF | 58.47 | 58.49 | 58.39 | 58.485 | 406200.0 |
| 2005-04-19 08:30:00 | IWM | ETF | 58.49 | 58.625 | 58.49 | 58.58 | 139400.0 |
| 2005-04-19 09:00:00 | IWM | ETF | 58.58 | 58.625 | 58.51 | 58.545 | 96800.0 |
| 2005-04-19 09:30:00 | IWM | ETF | 58.555 | 58.84 | 58.48 | 58.84 | 8286200.0 |
| 2005-04-19 10:00:00 | IWM | ETF | 58.85 | 58.94 | 58.71 | 58.785 | 3420600.0 |
| 2005-04-19 10:30:00 | IWM | ETF | 58.79 | 58.85 | 58.57 | 58.63 | 2109400.0 |
| 2005-04-19 11:00:00 | IWM | ETF | 58.625 | 58.825 | 58.625 | 58.795 | 1710600.0 |
| 2005-04-19 11:30:00 | IWM | ETF | 58.805 | 58.81 | 58.71 | 58.765 | 2387400.0 |
| 2005-04-19 12:00:00 | IWM | ETF | 58.77 | 58.815 | 58.67 | 58.69 | 1419600.0 |
> showing 50 of 1,531 rows — these rows as CSV