PREVIEW / etf_30min / 2006-05-30
file: by_date/etf_30min/2006/2006-05-30.parquet size: 66 KB rows: 2,331
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-05-30 04:00:00 | SPY | ETF | 127.78 | 127.78 | 127.78 | 127.78 | 200.0 |
| 2006-05-30 06:30:00 | SPY | ETF | 127.73 | 127.78 | 127.7 | 127.71 | 125600.0 |
| 2006-05-30 07:00:00 | SPY | ETF | 127.75 | 127.88 | 127.75 | 127.84 | 128300.0 |
| 2006-05-30 07:30:00 | SPY | ETF | 127.85 | 128.1 | 127.8 | 127.89 | 184800.0 |
| 2006-05-30 08:00:00 | SPY | ETF | 127.55 | 128.09 | 127.55 | 127.91 | 871800.0 |
| 2006-05-30 08:30:00 | SPY | ETF | 127.92 | 127.92 | 127.8 | 127.89 | 558100.0 |
| 2006-05-30 09:00:00 | SPY | ETF | 127.89 | 127.97 | 127.86 | 127.97 | 805400.0 |
| 2006-05-30 09:30:00 | SPY | ETF | 127.97 | 128.0 | 127.35 | 127.43 | 9967700.0 |
| 2006-05-30 10:00:00 | SPY | ETF | 127.42 | 127.51 | 127.18 | 127.36 | 6670600.0 |
| 2006-05-30 10:30:00 | SPY | ETF | 127.36 | 127.5 | 127.17 | 127.4 | 3456400.0 |
| 2006-05-30 11:00:00 | SPY | ETF | 127.39 | 127.45 | 126.99 | 127.04 | 4059200.0 |
| 2006-05-30 11:30:00 | SPY | ETF | 127.05 | 127.35 | 126.99 | 127.26 | 3684900.0 |
| 2006-05-30 12:00:00 | SPY | ETF | 127.26 | 127.32 | 126.98 | 127.3 | 2310200.0 |
| 2006-05-30 12:30:00 | SPY | ETF | 127.29 | 127.35 | 126.96 | 127.01 | 2367000.0 |
| 2006-05-30 13:00:00 | SPY | ETF | 127.02 | 127.08 | 126.88 | 126.96 | 3057300.0 |
| 2006-05-30 13:30:00 | SPY | ETF | 126.96 | 127.01 | 126.73 | 126.98 | 4873800.0 |
| 2006-05-30 14:00:00 | SPY | ETF | 126.98 | 127.12 | 126.88 | 126.97 | 2646500.0 |
| 2006-05-30 14:30:00 | SPY | ETF | 126.96 | 127.08 | 126.86 | 126.92 | 1829500.0 |
| 2006-05-30 15:00:00 | SPY | ETF | 126.91 | 126.91 | 126.51 | 126.58 | 4742500.0 |
| 2006-05-30 15:30:00 | SPY | ETF | 126.58 | 126.64 | 126.26 | 126.28 | 9555000.0 |
| 2006-05-30 16:00:00 | SPY | ETF | 126.3 | 126.3 | 126.07 | 126.1 | 2281200.0 |
| 2006-05-30 16:30:00 | SPY | ETF | 126.13 | 126.19 | 126.09 | 126.12 | 566500.0 |
| 2006-05-30 17:00:00 | SPY | ETF | 126.12 | 126.18 | 126.01 | 126.18 | 127700.0 |
| 2006-05-30 17:30:00 | SPY | ETF | 126.17 | 126.27 | 126.16 | 126.17 | 353200.0 |
| 2006-05-30 18:00:00 | SPY | ETF | 126.17 | 126.19 | 126.1 | 126.15 | 24500.0 |
| 2006-05-30 18:30:00 | SPY | ETF | 126.16 | 126.16 | 126.16 | 126.16 | 100.0 |
| 2006-05-30 19:00:00 | SPY | ETF | 126.17 | 126.18 | 126.17 | 126.18 | 800.0 |
| 2006-05-30 19:30:00 | SPY | ETF | 126.19 | 126.19 | 126.18 | 126.18 | 1600.0 |
| 2006-05-30 09:30:00 | QQQ | ETF | 39.31 | 39.33 | 39.06 | 39.06 | 15984100.0 |
| 2006-05-30 10:00:00 | QQQ | ETF | 39.07 | 39.13 | 39.01 | 39.06 | 9049400.0 |
| 2006-05-30 10:30:00 | QQQ | ETF | 39.06 | 39.1 | 38.97 | 39.02 | 8561000.0 |
| 2006-05-30 11:00:00 | QQQ | ETF | 39.02 | 39.04 | 38.87 | 38.89 | 10904900.0 |
| 2006-05-30 11:30:00 | QQQ | ETF | 38.89 | 39.03 | 38.87 | 38.99 | 9351300.0 |
| 2006-05-30 12:00:00 | QQQ | ETF | 38.99 | 39.0 | 38.88 | 39.0 | 4436300.0 |
| 2006-05-30 12:30:00 | QQQ | ETF | 38.99 | 39.03 | 38.88 | 38.91 | 2320300.0 |
| 2006-05-30 13:00:00 | QQQ | ETF | 38.91 | 38.94 | 38.85 | 38.89 | 3485100.0 |
| 2006-05-30 13:30:00 | QQQ | ETF | 38.89 | 38.93 | 38.83 | 38.92 | 4501900.0 |
| 2006-05-30 14:00:00 | QQQ | ETF | 38.92 | 38.96 | 38.87 | 38.92 | 2907900.0 |
| 2006-05-30 14:30:00 | QQQ | ETF | 38.91 | 38.96 | 38.87 | 38.92 | 4609100.0 |
| 2006-05-30 15:00:00 | QQQ | ETF | 38.92 | 38.93 | 38.81 | 38.83 | 5599400.0 |
| 2006-05-30 15:30:00 | QQQ | ETF | 38.83 | 38.84 | 38.61 | 38.62 | 17067500.0 |
| 2006-05-30 07:30:00 | IWM | ETF | 72.25 | 72.35 | 72.24 | 72.24 | 1800.0 |
| 2006-05-30 08:00:00 | IWM | ETF | 71.95 | 72.85 | 71.95 | 72.3 | 219600.0 |
| 2006-05-30 08:30:00 | IWM | ETF | 72.29 | 72.29 | 72.17 | 72.22 | 1056600.0 |
| 2006-05-30 09:00:00 | IWM | ETF | 72.18 | 72.3 | 72.17 | 72.29 | 222800.0 |
| 2006-05-30 09:30:00 | IWM | ETF | 72.31 | 72.35 | 71.54 | 71.77 | 4012600.0 |
| 2006-05-30 10:00:00 | IWM | ETF | 71.77 | 71.89 | 71.6 | 71.74 | 4852000.0 |
| 2006-05-30 10:30:00 | IWM | ETF | 71.73 | 71.88 | 71.6 | 71.75 | 3647400.0 |
| 2006-05-30 11:00:00 | IWM | ETF | 71.75 | 71.76 | 71.32 | 71.39 | 2911100.0 |
| 2006-05-30 11:30:00 | IWM | ETF | 71.38 | 71.56 | 71.27 | 71.5 | 2550800.0 |
> showing 50 of 2,331 rows — these rows as CSV