PREVIEW / etf_30min / 2003-11-12
file: by_date/etf_30min/2003/2003-11-12.parquet size: 27 KB rows: 826
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-11-12 08:00:00 | SPY | ETF | 105.27 | 105.32 | 105.27 | 105.27 | 8200.0 |
| 2003-11-12 08:30:00 | SPY | ETF | 105.25 | 105.29 | 105.25 | 105.27 | 11800.0 |
| 2003-11-12 09:00:00 | SPY | ETF | 105.27 | 105.28 | 105.22 | 105.22 | 11000.0 |
| 2003-11-12 09:30:00 | SPY | ETF | 105.23 | 105.5 | 105.16 | 105.41 | 2935500.0 |
| 2003-11-12 10:00:00 | SPY | ETF | 105.41 | 105.58 | 105.36 | 105.51 | 1893600.0 |
| 2003-11-12 10:30:00 | SPY | ETF | 105.51 | 105.62 | 105.42 | 105.44 | 1211700.0 |
| 2003-11-12 11:00:00 | SPY | ETF | 105.44 | 105.57 | 105.41 | 105.44 | 951400.0 |
| 2003-11-12 11:30:00 | SPY | ETF | 105.43 | 105.84 | 105.41 | 105.81 | 2207800.0 |
| 2003-11-12 12:00:00 | SPY | ETF | 105.75 | 105.91 | 105.75 | 105.81 | 2770500.0 |
| 2003-11-12 12:30:00 | SPY | ETF | 105.81 | 105.87 | 105.74 | 105.77 | 575300.0 |
| 2003-11-12 13:00:00 | SPY | ETF | 105.77 | 105.97 | 105.75 | 105.89 | 674200.0 |
| 2003-11-12 13:30:00 | SPY | ETF | 105.87 | 106.0 | 105.85 | 105.87 | 978700.0 |
| 2003-11-12 14:00:00 | SPY | ETF | 105.86 | 106.11 | 105.84 | 106.11 | 1538800.0 |
| 2003-11-12 14:30:00 | SPY | ETF | 106.1 | 106.45 | 106.01 | 106.4 | 2581500.0 |
| 2003-11-12 15:00:00 | SPY | ETF | 106.45 | 106.47 | 106.31 | 106.34 | 2410800.0 |
| 2003-11-12 15:30:00 | SPY | ETF | 106.35 | 106.42 | 106.18 | 106.38 | 2582700.0 |
| 2003-11-12 16:00:00 | SPY | ETF | 106.38 | 106.45 | 106.21 | 106.29 | 1670700.0 |
| 2003-11-12 16:30:00 | SPY | ETF | 106.24 | 106.45 | 106.24 | 106.45 | 156500.0 |
| 2003-11-12 17:00:00 | SPY | ETF | 106.48 | 106.5 | 106.45 | 106.49 | 16300.0 |
| 2003-11-12 17:30:00 | SPY | ETF | 106.5 | 106.55 | 106.47 | 106.48 | 28800.0 |
| 2003-11-12 18:00:00 | SPY | ETF | 106.48 | 106.49 | 106.44 | 106.44 | 10200.0 |
| 2003-11-12 18:30:00 | SPY | ETF | 106.4 | 106.44 | 106.4 | 106.4 | 10500.0 |
| 2003-11-12 08:00:00 | QQQ | ETF | 35.19 | 35.19 | 35.14 | 35.15 | 31300.0 |
| 2003-11-12 08:30:00 | QQQ | ETF | 35.15 | 35.15 | 35.13 | 35.14 | 57000.0 |
| 2003-11-12 09:00:00 | QQQ | ETF | 35.14 | 35.18 | 35.13 | 35.18 | 68200.0 |
| 2003-11-12 09:30:00 | QQQ | ETF | 35.17 | 35.371 | 35.14 | 35.3 | 12175300.0 |
| 2003-11-12 10:00:00 | QQQ | ETF | 35.3 | 35.41 | 35.279 | 35.366 | 7001300.0 |
| 2003-11-12 10:30:00 | QQQ | ETF | 35.37 | 35.41 | 35.26 | 35.31 | 5387900.0 |
| 2003-11-12 11:00:00 | QQQ | ETF | 35.3 | 35.38 | 35.28 | 35.3 | 2766200.0 |
| 2003-11-12 11:30:00 | QQQ | ETF | 35.299 | 35.49 | 35.257 | 35.485 | 6768700.0 |
| 2003-11-12 12:00:00 | QQQ | ETF | 35.485 | 35.56 | 35.46 | 35.51 | 4875000.0 |
| 2003-11-12 12:30:00 | QQQ | ETF | 35.51 | 35.53 | 35.47 | 35.47 | 1587400.0 |
| 2003-11-12 13:00:00 | QQQ | ETF | 35.48 | 35.64 | 35.47 | 35.62 | 2870500.0 |
| 2003-11-12 13:30:00 | QQQ | ETF | 35.61 | 35.68 | 35.58 | 35.6 | 3075700.0 |
| 2003-11-12 14:00:00 | QQQ | ETF | 35.59 | 35.73 | 35.57 | 35.717 | 3160600.0 |
| 2003-11-12 14:30:00 | QQQ | ETF | 35.71 | 35.87 | 35.7 | 35.84 | 6777500.0 |
| 2003-11-12 15:00:00 | QQQ | ETF | 35.84 | 35.87 | 35.77 | 35.77 | 5383100.0 |
| 2003-11-12 15:30:00 | QQQ | ETF | 35.76 | 35.881 | 35.7 | 35.83 | 6212000.0 |
| 2003-11-12 16:00:00 | QQQ | ETF | 35.84 | 35.963 | 35.62 | 35.88 | 5131600.0 |
| 2003-11-12 16:30:00 | QQQ | ETF | 35.87 | 36.02 | 35.85 | 36.01 | 1418400.0 |
| 2003-11-12 17:00:00 | QQQ | ETF | 36.01 | 36.05 | 35.992 | 36.048 | 909300.0 |
| 2003-11-12 17:30:00 | QQQ | ETF | 36.048 | 36.1 | 36.01 | 36.012 | 408100.0 |
| 2003-11-12 18:00:00 | QQQ | ETF | 36.02 | 36.036 | 35.999 | 35.999 | 58200.0 |
| 2003-11-12 18:30:00 | QQQ | ETF | 36.0 | 36.0 | 35.98 | 35.99 | 5200.0 |
| 2003-11-12 19:00:00 | QQQ | ETF | 35.99 | 35.99 | 35.98 | 35.98 | 5900.0 |
| 2003-11-12 19:30:00 | QQQ | ETF | 35.98 | 35.98 | 35.96 | 35.97 | 32100.0 |
| 2003-11-12 09:30:00 | IWM | ETF | 52.84 | 53.35 | 52.84 | 53.28 | 1522200.0 |
| 2003-11-12 10:00:00 | IWM | ETF | 53.29 | 53.375 | 53.155 | 53.325 | 921800.0 |
| 2003-11-12 10:30:00 | IWM | ETF | 53.335 | 53.444 | 53.325 | 53.325 | 106000.0 |
| 2003-11-12 11:00:00 | IWM | ETF | 53.355 | 53.455 | 53.325 | 53.35 | 234800.0 |
> showing 50 of 826 rows — these rows as CSV