PREVIEW / etf_30min / 2006-04-27
file: by_date/etf_30min/2006/2006-04-27.parquet size: 64 KB rows: 2,231
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-04-27 06:00:00 | SPY | ETF | 130.28 | 130.28 | 130.03 | 130.03 | 600.0 |
| 2006-04-27 06:30:00 | SPY | ETF | 129.88 | 129.93 | 129.88 | 129.93 | 5500.0 |
| 2006-04-27 07:00:00 | SPY | ETF | 129.93 | 129.98 | 129.86 | 129.98 | 102500.0 |
| 2006-04-27 07:30:00 | SPY | ETF | 129.98 | 129.98 | 129.91 | 129.92 | 59600.0 |
| 2006-04-27 08:00:00 | SPY | ETF | 129.92 | 130.01 | 129.75 | 129.87 | 471600.0 |
| 2006-04-27 08:30:00 | SPY | ETF | 129.85 | 129.93 | 129.82 | 129.86 | 1399800.0 |
| 2006-04-27 09:00:00 | SPY | ETF | 129.85 | 129.99 | 129.84 | 129.91 | 136100.0 |
| 2006-04-27 09:30:00 | SPY | ETF | 129.9 | 129.93 | 129.59 | 129.85 | 6664100.0 |
| 2006-04-27 10:00:00 | SPY | ETF | 129.84 | 131.1 | 129.84 | 130.6 | 33428300.0 |
| 2006-04-27 10:30:00 | SPY | ETF | 130.6 | 130.77 | 130.11 | 130.66 | 11840900.0 |
| 2006-04-27 11:00:00 | SPY | ETF | 130.66 | 131.44 | 130.58 | 131.34 | 16951900.0 |
| 2006-04-27 11:30:00 | SPY | ETF | 131.33 | 131.36 | 130.8 | 131.15 | 8040100.0 |
| 2006-04-27 12:00:00 | SPY | ETF | 131.14 | 131.63 | 131.09 | 131.52 | 5190300.0 |
| 2006-04-27 12:30:00 | SPY | ETF | 131.51 | 131.57 | 131.34 | 131.48 | 4081000.0 |
| 2006-04-27 13:00:00 | SPY | ETF | 131.48 | 131.48 | 130.8 | 131.29 | 4708000.0 |
| 2006-04-27 13:30:00 | SPY | ETF | 131.29 | 131.32 | 131.09 | 131.15 | 3126100.0 |
| 2006-04-27 14:00:00 | SPY | ETF | 131.15 | 131.26 | 130.95 | 131.17 | 3639900.0 |
| 2006-04-27 14:30:00 | SPY | ETF | 131.16 | 131.47 | 131.0 | 131.32 | 5388600.0 |
| 2006-04-27 15:00:00 | SPY | ETF | 131.33 | 131.43 | 131.15 | 131.2 | 3599700.0 |
| 2006-04-27 15:30:00 | SPY | ETF | 131.19 | 131.22 | 130.96 | 131.01 | 9223500.0 |
| 2006-04-27 16:00:00 | SPY | ETF | 131.0 | 131.1 | 130.94 | 131.01 | 988400.0 |
| 2006-04-27 16:30:00 | SPY | ETF | 131.01 | 131.03 | 130.83 | 130.95 | 440900.0 |
| 2006-04-27 17:00:00 | SPY | ETF | 130.9 | 130.97 | 130.89 | 130.9 | 139600.0 |
| 2006-04-27 17:30:00 | SPY | ETF | 130.89 | 130.89 | 130.29 | 130.86 | 41800.0 |
| 2006-04-27 18:00:00 | SPY | ETF | 130.86 | 130.9 | 130.81 | 130.9 | 118800.0 |
| 2006-04-27 19:00:00 | SPY | ETF | 130.87 | 130.87 | 130.85 | 130.85 | 1100.0 |
| 2006-04-27 19:30:00 | SPY | ETF | 130.87 | 130.93 | 130.85 | 130.9 | 1100.0 |
| 2006-04-27 09:30:00 | QQQ | ETF | 41.67 | 41.77 | 41.5 | 41.74 | 14753600.0 |
| 2006-04-27 10:00:00 | QQQ | ETF | 41.74 | 42.12 | 41.74 | 41.98 | 34451400.0 |
| 2006-04-27 10:30:00 | QQQ | ETF | 41.98 | 42.03 | 41.7 | 41.96 | 17788200.0 |
| 2006-04-27 11:00:00 | QQQ | ETF | 41.97 | 42.39 | 41.92 | 42.31 | 22805000.0 |
| 2006-04-27 11:30:00 | QQQ | ETF | 42.3 | 42.37 | 42.19 | 42.31 | 8250800.0 |
| 2006-04-27 12:00:00 | QQQ | ETF | 42.32 | 42.49 | 42.3 | 42.47 | 13476300.0 |
| 2006-04-27 12:30:00 | QQQ | ETF | 42.46 | 42.48 | 42.34 | 42.41 | 6122600.0 |
| 2006-04-27 13:00:00 | QQQ | ETF | 42.41 | 42.42 | 42.27 | 42.35 | 12895600.0 |
| 2006-04-27 13:30:00 | QQQ | ETF | 42.35 | 42.35 | 42.24 | 42.3 | 4168500.0 |
| 2006-04-27 14:00:00 | QQQ | ETF | 42.3 | 42.35 | 42.21 | 42.29 | 5305600.0 |
| 2006-04-27 14:30:00 | QQQ | ETF | 42.29 | 42.46 | 42.24 | 42.39 | 6767200.0 |
| 2006-04-27 15:00:00 | QQQ | ETF | 42.39 | 42.43 | 42.29 | 42.32 | 4601300.0 |
| 2006-04-27 15:30:00 | QQQ | ETF | 42.32 | 42.33 | 42.19 | 42.26 | 11814900.0 |
| 2006-04-27 08:00:00 | IWM | ETF | 75.57 | 75.6 | 75.49 | 75.6 | 11600.0 |
| 2006-04-27 08:30:00 | IWM | ETF | 75.63 | 75.63 | 75.5 | 75.55 | 153400.0 |
| 2006-04-27 09:00:00 | IWM | ETF | 75.54 | 75.58 | 75.5 | 75.51 | 191100.0 |
| 2006-04-27 09:30:00 | IWM | ETF | 75.52 | 75.53 | 74.89 | 75.15 | 6540200.0 |
| 2006-04-27 10:00:00 | IWM | ETF | 75.15 | 76.16 | 75.11 | 75.5 | 17507600.0 |
| 2006-04-27 10:30:00 | IWM | ETF | 75.49 | 75.61 | 75.0 | 75.49 | 6292300.0 |
| 2006-04-27 11:00:00 | IWM | ETF | 75.5 | 76.39 | 75.45 | 76.35 | 7911800.0 |
| 2006-04-27 11:30:00 | IWM | ETF | 76.34 | 76.36 | 75.68 | 76.03 | 4320700.0 |
| 2006-04-27 12:00:00 | IWM | ETF | 76.05 | 76.65 | 76.05 | 76.62 | 10850900.0 |
| 2006-04-27 12:30:00 | IWM | ETF | 76.61 | 76.67 | 76.43 | 76.51 | 3808000.0 |
> showing 50 of 2,231 rows — these rows as CSV