PREVIEW / etf_30min / 2003-08-25
file: by_date/etf_30min/2003/2003-08-25.parquet size: 22 KB rows: 704
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-08-25 08:00:00 | SPY | ETF | 99.5 | 99.58 | 99.5 | 99.58 | 12300.0 |
| 2003-08-25 08:30:00 | SPY | ETF | 99.63 | 99.7 | 99.62 | 99.68 | 29300.0 |
| 2003-08-25 09:00:00 | SPY | ETF | 99.73 | 99.76 | 99.7 | 99.75 | 17000.0 |
| 2003-08-25 09:30:00 | SPY | ETF | 99.71 | 101.35 | 99.48 | 99.61 | 3925200.0 |
| 2003-08-25 10:00:00 | SPY | ETF | 99.62 | 99.81 | 99.41 | 99.66 | 2481700.0 |
| 2003-08-25 10:30:00 | SPY | ETF | 99.64 | 99.72 | 99.45 | 99.59 | 1617600.0 |
| 2003-08-25 11:00:00 | SPY | ETF | 99.57 | 99.64 | 99.28 | 99.6 | 1840000.0 |
| 2003-08-25 11:30:00 | SPY | ETF | 99.6 | 99.7 | 99.46 | 99.58 | 1105500.0 |
| 2003-08-25 12:00:00 | SPY | ETF | 99.58 | 99.67 | 99.47 | 99.63 | 955000.0 |
| 2003-08-25 12:30:00 | SPY | ETF | 99.63 | 99.82 | 99.55 | 99.81 | 1003900.0 |
| 2003-08-25 13:00:00 | SPY | ETF | 99.82 | 99.88 | 99.71 | 99.72 | 1620700.0 |
| 2003-08-25 13:30:00 | SPY | ETF | 99.71 | 99.78 | 99.66 | 99.73 | 1033500.0 |
| 2003-08-25 14:00:00 | SPY | ETF | 99.73 | 99.83 | 99.62 | 99.72 | 664200.0 |
| 2003-08-25 14:30:00 | SPY | ETF | 99.72 | 99.77 | 99.54 | 99.58 | 895200.0 |
| 2003-08-25 15:00:00 | SPY | ETF | 99.59 | 99.83 | 99.55 | 99.66 | 1387100.0 |
| 2003-08-25 15:30:00 | SPY | ETF | 99.67 | 99.9 | 99.63 | 99.82 | 1617700.0 |
| 2003-08-25 16:00:00 | SPY | ETF | 99.83 | 100.0 | 99.76 | 99.94 | 1029300.0 |
| 2003-08-25 16:30:00 | SPY | ETF | 99.92 | 99.95 | 99.9 | 99.95 | 117600.0 |
| 2003-08-25 17:00:00 | SPY | ETF | 99.94 | 99.94 | 99.92 | 99.94 | 6800.0 |
| 2003-08-25 17:30:00 | SPY | ETF | 99.94 | 99.99 | 99.94 | 99.99 | 11100.0 |
| 2003-08-25 18:00:00 | SPY | ETF | 99.94 | 99.94 | 99.94 | 99.94 | 300.0 |
| 2003-08-25 18:30:00 | SPY | ETF | 99.94 | 99.94 | 99.93 | 99.93 | 6500.0 |
| 2003-08-25 19:00:00 | SPY | ETF | 99.91 | 99.96 | 99.91 | 99.96 | 3000.0 |
| 2003-08-25 08:00:00 | QQQ | ETF | 32.31 | 32.31 | 32.26 | 32.3 | 39000.0 |
| 2003-08-25 08:30:00 | QQQ | ETF | 32.3 | 32.37 | 32.3 | 32.36 | 35900.0 |
| 2003-08-25 09:00:00 | QQQ | ETF | 32.34 | 32.39 | 32.33 | 32.36 | 55800.0 |
| 2003-08-25 09:30:00 | QQQ | ETF | 32.36 | 32.508 | 32.3 | 32.37 | 7538800.0 |
| 2003-08-25 10:00:00 | QQQ | ETF | 32.37 | 32.47 | 32.25 | 32.36 | 5459300.0 |
| 2003-08-25 10:30:00 | QQQ | ETF | 32.362 | 32.41 | 32.26 | 32.27 | 3471500.0 |
| 2003-08-25 11:00:00 | QQQ | ETF | 32.27 | 32.37 | 32.21 | 32.31 | 3725500.0 |
| 2003-08-25 11:30:00 | QQQ | ETF | 32.31 | 32.35 | 32.24 | 32.289 | 2103000.0 |
| 2003-08-25 12:00:00 | QQQ | ETF | 32.28 | 32.37 | 32.25 | 32.35 | 1414400.0 |
| 2003-08-25 12:30:00 | QQQ | ETF | 32.35 | 32.47 | 32.29 | 32.45 | 1876300.0 |
| 2003-08-25 13:00:00 | QQQ | ETF | 32.44 | 32.49 | 32.38 | 32.39 | 2015900.0 |
| 2003-08-25 13:30:00 | QQQ | ETF | 32.4 | 32.42 | 32.35 | 32.38 | 1013800.0 |
| 2003-08-25 14:00:00 | QQQ | ETF | 32.38 | 32.46 | 32.37 | 32.4 | 1311200.0 |
| 2003-08-25 14:30:00 | QQQ | ETF | 32.4 | 32.42 | 32.28 | 32.327 | 1968800.0 |
| 2003-08-25 15:00:00 | QQQ | ETF | 32.32 | 32.42 | 32.31 | 32.34 | 2175500.0 |
| 2003-08-25 15:30:00 | QQQ | ETF | 32.36 | 32.48 | 32.33 | 32.45 | 3834400.0 |
| 2003-08-25 16:00:00 | QQQ | ETF | 32.46 | 32.54 | 32.43 | 32.52 | 1698500.0 |
| 2003-08-25 16:30:00 | QQQ | ETF | 32.52 | 32.55 | 32.5 | 32.54 | 123000.0 |
| 2003-08-25 17:00:00 | QQQ | ETF | 32.53 | 32.54 | 32.51 | 32.54 | 38500.0 |
| 2003-08-25 17:30:00 | QQQ | ETF | 32.54 | 32.55 | 32.524 | 32.55 | 19300.0 |
| 2003-08-25 18:00:00 | QQQ | ETF | 32.54 | 32.56 | 32.53 | 32.55 | 15200.0 |
| 2003-08-25 18:30:00 | QQQ | ETF | 32.55 | 32.56 | 32.55 | 32.55 | 4800.0 |
| 2003-08-25 19:30:00 | QQQ | ETF | 32.53 | 32.53 | 32.51 | 32.53 | 2800.0 |
| 2003-08-25 09:30:00 | IWM | ETF | 48.37 | 48.545 | 48.125 | 48.19 | 869200.0 |
| 2003-08-25 10:00:00 | IWM | ETF | 48.21 | 48.235 | 48.125 | 48.15 | 240200.0 |
| 2003-08-25 10:30:00 | IWM | ETF | 48.15 | 48.15 | 48.065 | 48.095 | 348800.0 |
| 2003-08-25 11:00:00 | IWM | ETF | 48.1 | 48.1 | 47.965 | 47.965 | 523600.0 |
> showing 50 of 704 rows — these rows as CSV