PREVIEW / etf_30min / 2005-06-06
file: by_date/etf_30min/2005/2005-06-06.parquet size: 43 KB rows: 1,505
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-06-06 04:00:00 | SPY | ETF | 120.13 | 120.13 | 120.12 | 120.12 | 2300.0 |
| 2005-06-06 05:30:00 | SPY | ETF | 120.1 | 120.1 | 120.1 | 120.1 | 500.0 |
| 2005-06-06 06:00:00 | SPY | ETF | 120.08 | 120.08 | 120.08 | 120.08 | 5000.0 |
| 2005-06-06 07:00:00 | SPY | ETF | 120.08 | 120.08 | 120.06 | 120.06 | 1500.0 |
| 2005-06-06 07:30:00 | SPY | ETF | 120.06 | 120.1 | 120.05 | 120.09 | 40200.0 |
| 2005-06-06 08:00:00 | SPY | ETF | 120.07 | 120.07 | 119.95 | 119.96 | 112200.0 |
| 2005-06-06 08:30:00 | SPY | ETF | 119.96 | 119.96 | 119.92 | 119.94 | 57700.0 |
| 2005-06-06 09:00:00 | SPY | ETF | 119.94 | 120.01 | 119.94 | 119.99 | 30900.0 |
| 2005-06-06 09:30:00 | SPY | ETF | 120.02 | 120.05 | 119.86 | 119.92 | 5481700.0 |
| 2005-06-06 10:00:00 | SPY | ETF | 119.93 | 120.0 | 119.81 | 119.9 | 2811300.0 |
| 2005-06-06 10:30:00 | SPY | ETF | 119.89 | 119.94 | 119.55 | 119.62 | 4361300.0 |
| 2005-06-06 11:00:00 | SPY | ETF | 119.62 | 119.75 | 119.57 | 119.72 | 4283300.0 |
| 2005-06-06 11:30:00 | SPY | ETF | 119.73 | 119.73 | 119.62 | 119.66 | 1584600.0 |
| 2005-06-06 12:00:00 | SPY | ETF | 119.67 | 119.91 | 119.67 | 119.82 | 3421900.0 |
| 2005-06-06 12:30:00 | SPY | ETF | 119.83 | 119.84 | 119.77 | 119.78 | 705800.0 |
| 2005-06-06 13:00:00 | SPY | ETF | 119.77 | 119.87 | 119.69 | 119.83 | 1091000.0 |
| 2005-06-06 13:30:00 | SPY | ETF | 119.84 | 120.02 | 119.82 | 119.95 | 2215500.0 |
| 2005-06-06 14:00:00 | SPY | ETF | 119.96 | 120.13 | 119.9 | 120.02 | 2746200.0 |
| 2005-06-06 14:30:00 | SPY | ETF | 120.03 | 120.11 | 119.93 | 119.99 | 1712800.0 |
| 2005-06-06 15:00:00 | SPY | ETF | 119.99 | 120.08 | 119.87 | 120.06 | 1780900.0 |
| 2005-06-06 15:30:00 | SPY | ETF | 120.06 | 120.2 | 119.89 | 120.14 | 2669600.0 |
| 2005-06-06 16:00:00 | SPY | ETF | 120.08 | 120.1 | 120.03 | 120.09 | 268800.0 |
| 2005-06-06 16:30:00 | SPY | ETF | 120.05 | 120.09 | 120.04 | 120.05 | 225500.0 |
| 2005-06-06 17:00:00 | SPY | ETF | 120.06 | 120.06 | 120.04 | 120.04 | 1000.0 |
| 2005-06-06 17:30:00 | SPY | ETF | 120.04 | 120.8 | 120.02 | 120.02 | 54600.0 |
| 2005-06-06 18:00:00 | SPY | ETF | 120.06 | 120.11 | 120.06 | 120.11 | 4100.0 |
| 2005-06-06 09:30:00 | QQQ | ETF | 38.13 | 38.18 | 38.06 | 38.1 | 7444100.0 |
| 2005-06-06 10:00:00 | QQQ | ETF | 38.1 | 38.16 | 38.05 | 38.08 | 4887200.0 |
| 2005-06-06 10:30:00 | QQQ | ETF | 38.08 | 38.1 | 37.98 | 37.99 | 5108200.0 |
| 2005-06-06 11:00:00 | QQQ | ETF | 37.99 | 38.03 | 37.96 | 38.02 | 4232300.0 |
| 2005-06-06 11:30:00 | QQQ | ETF | 38.02 | 38.04 | 37.98 | 38.0 | 2489300.0 |
| 2005-06-06 12:00:00 | QQQ | ETF | 38.0 | 38.11 | 38.0 | 38.08 | 3855500.0 |
| 2005-06-06 12:30:00 | QQQ | ETF | 38.08 | 38.09 | 38.04 | 38.05 | 1003300.0 |
| 2005-06-06 13:00:00 | QQQ | ETF | 38.04 | 38.08 | 38.04 | 38.08 | 1094200.0 |
| 2005-06-06 13:30:00 | QQQ | ETF | 38.08 | 38.17 | 38.06 | 38.15 | 2951600.0 |
| 2005-06-06 14:00:00 | QQQ | ETF | 38.15 | 38.19 | 38.11 | 38.15 | 3561300.0 |
| 2005-06-06 14:30:00 | QQQ | ETF | 38.14 | 38.19 | 38.11 | 38.12 | 2589000.0 |
| 2005-06-06 15:00:00 | QQQ | ETF | 38.12 | 38.13 | 38.05 | 38.1 | 3418300.0 |
| 2005-06-06 15:30:00 | QQQ | ETF | 38.09 | 38.15 | 38.07 | 38.1 | 6157800.0 |
| 2005-06-06 09:30:00 | IWM | ETF | 61.73 | 61.855 | 61.615 | 61.68 | 1046200.0 |
| 2005-06-06 10:00:00 | IWM | ETF | 61.68 | 61.75 | 61.59 | 61.7 | 1250600.0 |
| 2005-06-06 10:30:00 | IWM | ETF | 61.695 | 61.72 | 61.525 | 61.53 | 1340800.0 |
| 2005-06-06 11:00:00 | IWM | ETF | 61.535 | 61.675 | 61.53 | 61.66 | 981000.0 |
| 2005-06-06 11:30:00 | IWM | ETF | 61.65 | 61.675 | 61.595 | 61.6 | 450000.0 |
| 2005-06-06 12:00:00 | IWM | ETF | 61.6 | 61.79 | 61.6 | 61.78 | 2277200.0 |
| 2005-06-06 12:30:00 | IWM | ETF | 61.775 | 61.78 | 61.715 | 61.72 | 608400.0 |
| 2005-06-06 13:00:00 | IWM | ETF | 61.72 | 61.75 | 61.7 | 61.73 | 402600.0 |
| 2005-06-06 13:30:00 | IWM | ETF | 61.735 | 61.945 | 61.72 | 61.915 | 1711400.0 |
| 2005-06-06 14:00:00 | IWM | ETF | 61.92 | 62.05 | 61.9 | 61.935 | 2444000.0 |
| 2005-06-06 14:30:00 | IWM | ETF | 61.935 | 62.035 | 61.87 | 61.95 | 1174600.0 |
> showing 50 of 1,505 rows — these rows as CSV