PREVIEW / etf_30min / 2006-03-31
file: by_date/etf_30min/2006/2006-03-31.parquet size: 59 KB rows: 2,160
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-31 04:30:00 | SPY | ETF | 128.89 | 128.99 | 128.89 | 128.99 | 200.0 |
| 2006-03-31 06:00:00 | SPY | ETF | 129.59 | 129.59 | 129.59 | 129.59 | 1000.0 |
| 2006-03-31 06:30:00 | SPY | ETF | 129.62 | 129.62 | 129.62 | 129.62 | 500.0 |
| 2006-03-31 07:00:00 | SPY | ETF | 129.59 | 129.65 | 129.58 | 129.65 | 24200.0 |
| 2006-03-31 07:30:00 | SPY | ETF | 129.66 | 129.69 | 129.59 | 129.6 | 32400.0 |
| 2006-03-31 08:00:00 | SPY | ETF | 129.62 | 129.74 | 129.59 | 129.66 | 927700.0 |
| 2006-03-31 08:30:00 | SPY | ETF | 129.66 | 129.88 | 129.59 | 129.74 | 1096800.0 |
| 2006-03-31 09:00:00 | SPY | ETF | 129.74 | 130.1 | 129.74 | 130.04 | 1317300.0 |
| 2006-03-31 09:30:00 | SPY | ETF | 130.02 | 130.24 | 129.65 | 130.12 | 6947000.0 |
| 2006-03-31 10:00:00 | SPY | ETF | 130.13 | 130.18 | 129.84 | 129.84 | 4302800.0 |
| 2006-03-31 10:30:00 | SPY | ETF | 129.84 | 130.07 | 129.81 | 129.9 | 3377300.0 |
| 2006-03-31 11:00:00 | SPY | ETF | 129.89 | 129.97 | 129.68 | 129.69 | 3602400.0 |
| 2006-03-31 11:30:00 | SPY | ETF | 129.69 | 129.9 | 129.62 | 129.84 | 2700200.0 |
| 2006-03-31 12:00:00 | SPY | ETF | 129.83 | 129.9737 | 129.71 | 129.79 | 2634200.0 |
| 2006-03-31 12:30:00 | SPY | ETF | 129.79 | 129.95 | 129.73 | 129.76 | 2674300.0 |
| 2006-03-31 13:00:00 | SPY | ETF | 129.76 | 129.82 | 129.57 | 129.63 | 1805500.0 |
| 2006-03-31 13:30:00 | SPY | ETF | 129.62 | 129.7 | 129.37 | 129.48 | 4285500.0 |
| 2006-03-31 14:00:00 | SPY | ETF | 129.48 | 129.68 | 129.46 | 129.54 | 4436600.0 |
| 2006-03-31 14:30:00 | SPY | ETF | 129.53 | 129.81 | 129.52 | 129.71 | 4170400.0 |
| 2006-03-31 15:00:00 | SPY | ETF | 129.7 | 129.74 | 129.52 | 129.64 | 3081200.0 |
| 2006-03-31 15:30:00 | SPY | ETF | 129.65 | 129.71 | 129.4 | 129.49 | 9277500.0 |
| 2006-03-31 16:00:00 | SPY | ETF | 129.49 | 129.86 | 129.405 | 129.83 | 3270200.0 |
| 2006-03-31 16:30:00 | SPY | ETF | 129.79 | 129.88 | 129.79 | 129.85 | 45400.0 |
| 2006-03-31 17:00:00 | SPY | ETF | 129.83 | 129.86 | 129.5764 | 129.84 | 37800.0 |
| 2006-03-31 17:30:00 | SPY | ETF | 129.86 | 129.86 | 129.81 | 129.81 | 15900.0 |
| 2006-03-31 18:00:00 | SPY | ETF | 129.84 | 129.84 | 129.84 | 129.84 | 300.0 |
| 2006-03-31 18:30:00 | SPY | ETF | 129.83 | 129.83 | 129.83 | 129.83 | 100.0 |
| 2006-03-31 09:30:00 | QQQ | ETF | 42.13 | 42.19 | 42.03 | 42.14 | 9636800.0 |
| 2006-03-31 10:00:00 | QQQ | ETF | 42.14 | 42.18 | 41.97 | 41.97 | 7304100.0 |
| 2006-03-31 10:30:00 | QQQ | ETF | 41.97 | 42.06 | 41.96 | 42.0 | 5666100.0 |
| 2006-03-31 11:00:00 | QQQ | ETF | 42.0 | 42.03 | 41.92 | 41.92 | 3525400.0 |
| 2006-03-31 11:30:00 | QQQ | ETF | 41.93 | 42.04 | 41.9 | 42.03 | 3937000.0 |
| 2006-03-31 12:00:00 | QQQ | ETF | 42.02 | 42.07 | 41.99 | 42.03 | 1955600.0 |
| 2006-03-31 12:30:00 | QQQ | ETF | 42.02 | 42.11 | 42.01 | 42.01 | 3897000.0 |
| 2006-03-31 13:00:00 | QQQ | ETF | 42.01 | 42.04 | 41.93 | 41.96 | 2337800.0 |
| 2006-03-31 13:30:00 | QQQ | ETF | 41.95 | 42.01 | 41.84 | 41.89 | 5165500.0 |
| 2006-03-31 14:00:00 | QQQ | ETF | 41.89 | 41.98 | 41.87 | 41.9 | 2806900.0 |
| 2006-03-31 14:30:00 | QQQ | ETF | 41.91 | 42.05 | 41.89 | 41.98 | 4829000.0 |
| 2006-03-31 15:00:00 | QQQ | ETF | 41.98 | 42.0 | 41.92 | 41.97 | 2861900.0 |
| 2006-03-31 15:30:00 | QQQ | ETF | 41.98 | 42.01 | 41.88 | 41.93 | 8715700.0 |
| 2006-03-31 07:00:00 | IWM | ETF | 75.57 | 75.57 | 75.57 | 75.57 | 2000.0 |
| 2006-03-31 08:00:00 | IWM | ETF | 75.65 | 75.65 | 75.65 | 75.65 | 200.0 |
| 2006-03-31 08:30:00 | IWM | ETF | 75.71 | 75.8 | 75.71 | 75.75 | 8700.0 |
| 2006-03-31 09:00:00 | IWM | ETF | 75.75 | 75.93 | 75.75 | 75.91 | 20100.0 |
| 2006-03-31 09:30:00 | IWM | ETF | 75.93 | 75.95 | 75.61 | 75.77 | 2886800.0 |
| 2006-03-31 10:00:00 | IWM | ETF | 75.77 | 75.9 | 75.57 | 75.62 | 2015300.0 |
| 2006-03-31 10:30:00 | IWM | ETF | 75.63 | 75.77 | 75.61 | 75.66 | 913700.0 |
| 2006-03-31 11:00:00 | IWM | ETF | 75.66 | 75.73 | 75.56 | 75.56 | 933800.0 |
| 2006-03-31 11:30:00 | IWM | ETF | 75.56 | 75.58 | 75.41 | 75.52 | 1803600.0 |
| 2006-03-31 12:00:00 | IWM | ETF | 75.52 | 75.71 | 75.47 | 75.64 | 938900.0 |
> showing 50 of 2,160 rows — these rows as CSV