PREVIEW / etf_30min / 2005-09-01
file: by_date/etf_30min/2005/2005-09-01.parquet size: 48 KB rows: 1,654
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-09-01 06:30:00 | SPY | ETF | 122.37 | 122.37 | 122.37 | 122.37 | 2500.0 |
| 2005-09-01 07:00:00 | SPY | ETF | 122.36 | 122.43 | 122.36 | 122.43 | 12200.0 |
| 2005-09-01 07:30:00 | SPY | ETF | 122.4 | 122.49 | 122.36 | 122.49 | 213600.0 |
| 2005-09-01 08:00:00 | SPY | ETF | 122.48 | 122.61 | 122.36 | 122.5 | 256300.0 |
| 2005-09-01 08:30:00 | SPY | ETF | 122.46 | 122.62 | 122.38 | 122.59 | 831600.0 |
| 2005-09-01 09:00:00 | SPY | ETF | 122.59 | 122.59 | 122.44 | 122.49 | 271300.0 |
| 2005-09-01 09:30:00 | SPY | ETF | 122.51 | 122.78 | 122.37 | 122.6 | 6604400.0 |
| 2005-09-01 10:00:00 | SPY | ETF | 122.6 | 122.61 | 121.99 | 122.11 | 9416700.0 |
| 2005-09-01 10:30:00 | SPY | ETF | 122.102 | 122.27 | 121.93 | 122.23 | 6494700.0 |
| 2005-09-01 11:00:00 | SPY | ETF | 122.23 | 122.8 | 122.16 | 122.62 | 7694000.0 |
| 2005-09-01 11:30:00 | SPY | ETF | 122.62 | 123.15 | 122.5 | 122.95 | 7869700.0 |
| 2005-09-01 12:00:00 | SPY | ETF | 122.95 | 123.0 | 122.73 | 122.84 | 3932700.0 |
| 2005-09-01 12:30:00 | SPY | ETF | 122.84 | 122.89 | 122.51 | 122.56 | 2208600.0 |
| 2005-09-01 13:00:00 | SPY | ETF | 122.56 | 122.76 | 122.55 | 122.7 | 1753700.0 |
| 2005-09-01 13:30:00 | SPY | ETF | 122.7 | 122.8 | 122.34 | 122.41 | 3431200.0 |
| 2005-09-01 14:00:00 | SPY | ETF | 122.41 | 122.6 | 122.16 | 122.44 | 5392400.0 |
| 2005-09-01 14:30:00 | SPY | ETF | 122.45 | 122.76 | 122.4 | 122.53 | 4210500.0 |
| 2005-09-01 15:00:00 | SPY | ETF | 122.53 | 122.74 | 122.5 | 122.55 | 2226700.0 |
| 2005-09-01 15:30:00 | SPY | ETF | 122.55 | 122.95 | 122.47 | 122.56 | 5742900.0 |
| 2005-09-01 16:00:00 | SPY | ETF | 122.55 | 123.1 | 122.42 | 123.1 | 327600.0 |
| 2005-09-01 16:30:00 | SPY | ETF | 122.45 | 122.49 | 122.4 | 122.43 | 4033700.0 |
| 2005-09-01 17:00:00 | SPY | ETF | 122.4 | 122.49 | 122.4 | 122.48 | 128500.0 |
| 2005-09-01 17:30:00 | SPY | ETF | 122.44 | 122.45 | 122.42 | 122.45 | 1600.0 |
| 2005-09-01 18:00:00 | SPY | ETF | 122.5 | 122.5 | 122.43 | 122.43 | 3900.0 |
| 2005-09-01 19:00:00 | SPY | ETF | 122.46 | 122.46 | 122.46 | 122.46 | 600.0 |
| 2005-09-01 09:30:00 | QQQ | ETF | 38.98 | 39.07 | 38.95 | 39.03 | 8038500.0 |
| 2005-09-01 10:00:00 | QQQ | ETF | 39.03 | 39.03 | 38.81 | 38.84 | 9086100.0 |
| 2005-09-01 10:30:00 | QQQ | ETF | 38.85 | 38.89 | 38.78 | 38.87 | 6175800.0 |
| 2005-09-01 11:00:00 | QQQ | ETF | 38.87 | 39.05 | 38.86 | 39.01 | 7916700.0 |
| 2005-09-01 11:30:00 | QQQ | ETF | 39.0 | 39.15 | 38.95 | 39.04 | 8470000.0 |
| 2005-09-01 12:00:00 | QQQ | ETF | 39.04 | 39.05 | 38.96 | 39.0 | 4094000.0 |
| 2005-09-01 12:30:00 | QQQ | ETF | 39.0 | 39.05 | 38.93 | 38.93 | 3487700.0 |
| 2005-09-01 13:00:00 | QQQ | ETF | 38.94 | 39.02 | 38.93 | 38.99 | 2050300.0 |
| 2005-09-01 13:30:00 | QQQ | ETF | 38.99 | 39.03 | 38.86 | 38.88 | 3926400.0 |
| 2005-09-01 14:00:00 | QQQ | ETF | 38.88 | 38.99 | 38.82 | 38.9 | 4786000.0 |
| 2005-09-01 14:30:00 | QQQ | ETF | 38.9 | 39.0 | 38.88 | 38.92 | 4357100.0 |
| 2005-09-01 15:00:00 | QQQ | ETF | 38.92 | 38.97 | 38.9 | 38.92 | 3375800.0 |
| 2005-09-01 15:30:00 | QQQ | ETF | 38.93 | 39.9 | 38.89 | 38.91 | 4272900.0 |
| 2005-09-01 08:00:00 | IWM | ETF | 66.43 | 66.53 | 66.43 | 66.53 | 9400.0 |
| 2005-09-01 08:30:00 | IWM | ETF | 66.42 | 66.47 | 66.42 | 66.47 | 3600.0 |
| 2005-09-01 09:00:00 | IWM | ETF | 66.43 | 66.49 | 66.42 | 66.42 | 111700.0 |
| 2005-09-01 09:30:00 | IWM | ETF | 66.42 | 66.75 | 66.42 | 66.7 | 3254400.0 |
| 2005-09-01 10:00:00 | IWM | ETF | 66.7 | 66.7 | 66.27 | 66.35 | 3002400.0 |
| 2005-09-01 10:30:00 | IWM | ETF | 66.34 | 66.44 | 66.21 | 66.42 | 1989900.0 |
| 2005-09-01 11:00:00 | IWM | ETF | 66.43 | 66.82 | 66.33 | 66.69 | 1896800.0 |
| 2005-09-01 11:30:00 | IWM | ETF | 66.7 | 66.88 | 66.61 | 66.76 | 2673300.0 |
| 2005-09-01 12:00:00 | IWM | ETF | 66.76 | 66.8 | 66.63 | 66.68 | 782600.0 |
| 2005-09-01 12:30:00 | IWM | ETF | 66.67 | 66.72 | 66.46 | 66.52 | 728900.0 |
| 2005-09-01 13:00:00 | IWM | ETF | 66.52 | 66.6 | 66.45 | 66.55 | 540100.0 |
| 2005-09-01 13:30:00 | IWM | ETF | 66.55 | 66.63 | 66.3 | 66.35 | 857400.0 |
> showing 50 of 1,654 rows — these rows as CSV