PREVIEW / etf_30min / 2003-09-30
file: by_date/etf_30min/2003/2003-09-30.parquet size: 25 KB rows: 758
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-30 08:00:00 | SPY | ETF | 100.6 | 100.63 | 100.56 | 100.58 | 26800.0 |
| 2003-09-30 08:30:00 | SPY | ETF | 100.56 | 100.58 | 100.52 | 100.54 | 5100.0 |
| 2003-09-30 09:00:00 | SPY | ETF | 100.59 | 100.59 | 100.45 | 100.5 | 16200.0 |
| 2003-09-30 09:30:00 | SPY | ETF | 100.53 | 100.53 | 99.82 | 99.86 | 5965500.0 |
| 2003-09-30 10:00:00 | SPY | ETF | 99.87 | 100.04 | 99.25 | 99.57 | 10063400.0 |
| 2003-09-30 10:30:00 | SPY | ETF | 99.56 | 99.97 | 99.47 | 99.67 | 7223800.0 |
| 2003-09-30 11:00:00 | SPY | ETF | 99.61 | 99.8 | 99.5 | 99.63 | 2663500.0 |
| 2003-09-30 11:30:00 | SPY | ETF | 99.66 | 99.97 | 99.61 | 99.86 | 3221500.0 |
| 2003-09-30 12:00:00 | SPY | ETF | 99.86 | 100.007 | 99.75 | 99.84 | 2838500.0 |
| 2003-09-30 12:30:00 | SPY | ETF | 99.82 | 100.14 | 99.71 | 100.03 | 2593500.0 |
| 2003-09-30 13:00:00 | SPY | ETF | 100.03 | 100.45 | 99.93 | 100.32 | 4039700.0 |
| 2003-09-30 13:30:00 | SPY | ETF | 100.32 | 100.35 | 100.1 | 100.33 | 1435100.0 |
| 2003-09-30 14:00:00 | SPY | ETF | 100.33 | 100.6 | 100.28 | 100.47 | 3908600.0 |
| 2003-09-30 14:30:00 | SPY | ETF | 100.47 | 100.48 | 100.16 | 100.45 | 2211400.0 |
| 2003-09-30 15:00:00 | SPY | ETF | 100.44 | 100.47 | 99.89 | 100.02 | 3623600.0 |
| 2003-09-30 15:30:00 | SPY | ETF | 100.02 | 100.08 | 99.71 | 99.86 | 4280800.0 |
| 2003-09-30 16:00:00 | SPY | ETF | 99.86 | 100.94 | 99.85 | 100.06 | 4514400.0 |
| 2003-09-30 16:30:00 | SPY | ETF | 99.9 | 99.95 | 99.87 | 99.95 | 224200.0 |
| 2003-09-30 17:00:00 | SPY | ETF | 99.96 | 100.0 | 99.94 | 99.96 | 39100.0 |
| 2003-09-30 17:30:00 | SPY | ETF | 99.93 | 99.93 | 99.83 | 99.83 | 5200.0 |
| 2003-09-30 18:00:00 | SPY | ETF | 99.95 | 100.0 | 99.95 | 100.0 | 4100.0 |
| 2003-09-30 19:00:00 | SPY | ETF | 100.0 | 100.0 | 100.0 | 100.0 | 1000.0 |
| 2003-09-30 19:30:00 | SPY | ETF | 100.0 | 100.0 | 99.9 | 99.9 | 400.0 |
| 2003-09-30 08:00:00 | QQQ | ETF | 33.02 | 33.05 | 32.99 | 33.01 | 43600.0 |
| 2003-09-30 08:30:00 | QQQ | ETF | 33.02 | 33.02 | 32.96 | 32.97 | 38000.0 |
| 2003-09-30 09:00:00 | QQQ | ETF | 32.98 | 33.0 | 32.93 | 32.93 | 112200.0 |
| 2003-09-30 09:30:00 | QQQ | ETF | 32.92 | 32.96 | 32.64 | 32.64 | 10235000.0 |
| 2003-09-30 10:00:00 | QQQ | ETF | 32.7 | 32.7 | 32.36 | 32.49 | 16264000.0 |
| 2003-09-30 10:30:00 | QQQ | ETF | 32.491 | 32.687 | 32.47 | 32.53 | 11819500.0 |
| 2003-09-30 11:00:00 | QQQ | ETF | 32.52 | 32.628 | 32.486 | 32.57 | 5236400.0 |
| 2003-09-30 11:30:00 | QQQ | ETF | 32.56 | 32.67 | 32.51 | 32.592 | 3886100.0 |
| 2003-09-30 12:00:00 | QQQ | ETF | 32.596 | 32.68 | 32.54 | 32.62 | 3037900.0 |
| 2003-09-30 12:30:00 | QQQ | ETF | 32.58 | 32.685 | 32.53 | 32.63 | 4333600.0 |
| 2003-09-30 13:00:00 | QQQ | ETF | 32.629 | 32.83 | 32.599 | 32.74 | 8050500.0 |
| 2003-09-30 13:30:00 | QQQ | ETF | 32.75 | 32.78 | 32.63 | 32.73 | 3825600.0 |
| 2003-09-30 14:00:00 | QQQ | ETF | 32.74 | 32.887 | 32.7 | 32.852 | 6661400.0 |
| 2003-09-30 14:30:00 | QQQ | ETF | 32.851 | 32.87 | 32.666 | 32.755 | 4018100.0 |
| 2003-09-30 15:00:00 | QQQ | ETF | 32.76 | 32.78 | 32.51 | 32.57 | 6653900.0 |
| 2003-09-30 15:30:00 | QQQ | ETF | 32.57 | 32.62 | 32.357 | 32.439 | 13781700.0 |
| 2003-09-30 16:00:00 | QQQ | ETF | 32.441 | 32.49 | 32.37 | 32.4 | 3020100.0 |
| 2003-09-30 16:30:00 | QQQ | ETF | 32.4 | 32.43 | 32.4 | 32.41 | 417400.0 |
| 2003-09-30 17:00:00 | QQQ | ETF | 32.41 | 32.43 | 32.41 | 32.43 | 25700.0 |
| 2003-09-30 17:30:00 | QQQ | ETF | 32.43 | 32.47 | 32.42 | 32.45 | 23300.0 |
| 2003-09-30 18:00:00 | QQQ | ETF | 32.46 | 32.47 | 32.44 | 32.44 | 39400.0 |
| 2003-09-30 18:30:00 | QQQ | ETF | 32.43 | 32.45 | 32.43 | 32.45 | 8100.0 |
| 2003-09-30 19:00:00 | QQQ | ETF | 32.46 | 32.46 | 32.43 | 32.43 | 3500.0 |
| 2003-09-30 19:30:00 | QQQ | ETF | 32.46 | 32.46 | 32.44 | 32.44 | 1800.0 |
| 2003-09-30 08:30:00 | IWM | ETF | 48.96 | 48.96 | 48.96 | 48.96 | 1000.0 |
| 2003-09-30 09:30:00 | IWM | ETF | 48.94 | 49.0 | 48.485 | 48.485 | 864800.0 |
| 2003-09-30 10:00:00 | IWM | ETF | 48.485 | 48.5 | 48.095 | 48.26 | 1545600.0 |
> showing 50 of 758 rows — these rows as CSV