PREVIEW / etf_30min / 2006-05-16
file: by_date/etf_30min/2006/2006-05-16.parquet size: 65 KB rows: 2,323
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-16 06:00:00 | SPY | ETF | 129.43 | 129.43 | 129.43 | 129.43 | 300.0 |
| 2006-05-16 06:30:00 | SPY | ETF | 129.4 | 129.45 | 129.4 | 129.45 | 65000.0 |
| 2006-05-16 07:00:00 | SPY | ETF | 129.49 | 129.5 | 129.4 | 129.45 | 30800.0 |
| 2006-05-16 07:30:00 | SPY | ETF | 129.47 | 129.61 | 129.47 | 129.61 | 94800.0 |
| 2006-05-16 08:00:00 | SPY | ETF | 129.62 | 129.62 | 129.4 | 129.54 | 1015000.0 |
| 2006-05-16 08:30:00 | SPY | ETF | 129.57 | 129.86 | 129.57 | 129.86 | 828700.0 |
| 2006-05-16 09:00:00 | SPY | ETF | 129.86 | 129.9 | 129.53 | 129.79 | 2020200.0 |
| 2006-05-16 09:30:00 | SPY | ETF | 129.76 | 130.0 | 129.69 | 129.77 | 7930200.0 |
| 2006-05-16 10:00:00 | SPY | ETF | 129.77 | 129.81 | 129.49 | 129.62 | 5509900.0 |
| 2006-05-16 10:30:00 | SPY | ETF | 129.62 | 129.75 | 129.52 | 129.55 | 3383900.0 |
| 2006-05-16 11:00:00 | SPY | ETF | 129.56 | 129.69 | 129.37 | 129.391 | 2877100.0 |
| 2006-05-16 11:30:00 | SPY | ETF | 129.4 | 129.41 | 129.01 | 129.31 | 8401100.0 |
| 2006-05-16 12:00:00 | SPY | ETF | 129.32 | 129.44 | 129.21 | 129.36 | 3576900.0 |
| 2006-05-16 12:30:00 | SPY | ETF | 129.35 | 129.68 | 129.33 | 129.66 | 3234300.0 |
| 2006-05-16 13:00:00 | SPY | ETF | 129.66 | 129.9 | 129.57 | 129.82 | 4285300.0 |
| 2006-05-16 13:30:00 | SPY | ETF | 129.83 | 129.95 | 129.68 | 129.73 | 3625400.0 |
| 2006-05-16 14:00:00 | SPY | ETF | 129.71 | 129.76 | 129.48 | 129.56 | 1916200.0 |
| 2006-05-16 14:30:00 | SPY | ETF | 129.57 | 129.79 | 129.52 | 129.54 | 1746200.0 |
| 2006-05-16 15:00:00 | SPY | ETF | 129.55 | 129.66 | 129.38 | 129.46 | 5391300.0 |
| 2006-05-16 15:30:00 | SPY | ETF | 129.45 | 129.53 | 129.35 | 129.3606 | 3285400.0 |
| 2006-05-16 16:00:00 | SPY | ETF | 129.35 | 129.37 | 129.11 | 129.34 | 715100.0 |
| 2006-05-16 16:30:00 | SPY | ETF | 129.34 | 129.41 | 129.28 | 129.28 | 63800.0 |
| 2006-05-16 17:00:00 | SPY | ETF | 129.28 | 129.3 | 129.27 | 129.3 | 15000.0 |
| 2006-05-16 17:30:00 | SPY | ETF | 129.41 | 129.41 | 129.27 | 129.33 | 32000.0 |
| 2006-05-16 18:00:00 | SPY | ETF | 129.28 | 129.3 | 129.27 | 129.3 | 500.0 |
| 2006-05-16 18:30:00 | SPY | ETF | 129.3 | 129.3 | 129.29 | 129.29 | 1900.0 |
| 2006-05-16 19:30:00 | SPY | ETF | 129.39 | 129.39 | 129.37 | 129.37 | 200.0 |
| 2006-05-16 09:30:00 | QQQ | ETF | 40.16 | 40.26 | 40.14 | 40.19 | 11771000.0 |
| 2006-05-16 10:00:00 | QQQ | ETF | 40.19 | 40.2 | 40.03 | 40.16 | 10626400.0 |
| 2006-05-16 10:30:00 | QQQ | ETF | 40.16 | 40.2 | 40.08 | 40.09 | 3911700.0 |
| 2006-05-16 11:00:00 | QQQ | ETF | 40.09 | 40.11 | 39.98 | 39.98 | 5502300.0 |
| 2006-05-16 11:30:00 | QQQ | ETF | 39.98 | 39.99 | 39.77 | 39.89 | 10590000.0 |
| 2006-05-16 12:00:00 | QQQ | ETF | 39.89 | 39.95 | 39.8 | 39.85 | 4534100.0 |
| 2006-05-16 12:30:00 | QQQ | ETF | 39.85 | 39.95 | 39.84 | 39.92 | 7094600.0 |
| 2006-05-16 13:00:00 | QQQ | ETF | 39.91 | 40.15 | 39.91 | 40.11 | 29655200.0 |
| 2006-05-16 13:30:00 | QQQ | ETF | 40.11 | 40.16 | 40.05 | 40.09 | 9752900.0 |
| 2006-05-16 14:00:00 | QQQ | ETF | 40.08 | 40.09 | 39.98 | 40.0 | 4125000.0 |
| 2006-05-16 14:30:00 | QQQ | ETF | 39.99 | 40.05 | 39.96 | 39.96 | 3582300.0 |
| 2006-05-16 15:00:00 | QQQ | ETF | 39.96 | 40.03 | 39.87 | 39.9 | 7951100.0 |
| 2006-05-16 15:30:00 | QQQ | ETF | 39.91 | 39.92 | 39.85 | 39.88 | 6543000.0 |
| 2006-05-16 08:00:00 | IWM | ETF | 73.12 | 73.3 | 73.12 | 73.3 | 106000.0 |
| 2006-05-16 08:30:00 | IWM | ETF | 73.38 | 75.51 | 73.37 | 73.51 | 447800.0 |
| 2006-05-16 09:00:00 | IWM | ETF | 73.48 | 73.54 | 73.42 | 73.43 | 391500.0 |
| 2006-05-16 09:30:00 | IWM | ETF | 73.46 | 73.87 | 73.35 | 73.68 | 7045700.0 |
| 2006-05-16 10:00:00 | IWM | ETF | 73.68 | 73.7 | 73.31 | 73.49 | 5900000.0 |
| 2006-05-16 10:30:00 | IWM | ETF | 73.48 | 73.6 | 73.4 | 73.42 | 1458700.0 |
| 2006-05-16 11:00:00 | IWM | ETF | 73.42 | 73.5 | 73.2 | 73.3 | 1924300.0 |
| 2006-05-16 11:30:00 | IWM | ETF | 73.31 | 73.31 | 72.94 | 73.13 | 3619200.0 |
| 2006-05-16 12:00:00 | IWM | ETF | 73.13 | 73.48 | 73.0 | 73.13 | 1781800.0 |
| 2006-05-16 12:30:00 | IWM | ETF | 73.14 | 73.37 | 73.12 | 73.36 | 1459700.0 |
> showing 50 of 2,323 rows — these rows as CSV