PREVIEW / etf_30min / 2005-08-05
file: by_date/etf_30min/2005/2005-08-05.parquet size: 45 KB rows: 1,595
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-08-05 07:30:00 | SPY | ETF | 123.99 | 124.0 | 123.93 | 123.93 | 39000.0 |
| 2005-08-05 08:00:00 | SPY | ETF | 123.92 | 123.93 | 123.82 | 123.92 | 437500.0 |
| 2005-08-05 08:30:00 | SPY | ETF | 123.92 | 123.98 | 123.37 | 123.41 | 3286300.0 |
| 2005-08-05 09:00:00 | SPY | ETF | 123.43 | 123.55 | 123.4 | 123.44 | 323200.0 |
| 2005-08-05 09:30:00 | SPY | ETF | 123.45 | 123.54 | 123.26 | 123.27 | 5384100.0 |
| 2005-08-05 10:00:00 | SPY | ETF | 123.27 | 123.98 | 122.95 | 123.03 | 7029800.0 |
| 2005-08-05 10:30:00 | SPY | ETF | 123.03 | 123.14 | 122.92 | 123.06 | 3744900.0 |
| 2005-08-05 11:00:00 | SPY | ETF | 123.05 | 123.46 | 122.79 | 122.87 | 3870800.0 |
| 2005-08-05 11:30:00 | SPY | ETF | 122.89 | 122.89 | 122.69 | 122.7 | 2663100.0 |
| 2005-08-05 12:00:00 | SPY | ETF | 122.69 | 122.82 | 122.67 | 122.81 | 2415900.0 |
| 2005-08-05 12:30:00 | SPY | ETF | 122.81 | 123.31 | 122.68 | 122.82 | 1129900.0 |
| 2005-08-05 13:00:00 | SPY | ETF | 122.81 | 123.03 | 122.8 | 122.89 | 2563400.0 |
| 2005-08-05 13:30:00 | SPY | ETF | 122.89 | 122.94 | 122.78 | 122.89 | 1489000.0 |
| 2005-08-05 14:00:00 | SPY | ETF | 122.9 | 122.91 | 122.68 | 122.73 | 1197000.0 |
| 2005-08-05 14:30:00 | SPY | ETF | 122.74 | 122.92 | 122.73 | 122.75 | 2711700.0 |
| 2005-08-05 15:00:00 | SPY | ETF | 122.74 | 122.87 | 122.71 | 122.87 | 2552700.0 |
| 2005-08-05 15:30:00 | SPY | ETF | 122.87 | 122.98 | 122.76 | 122.77 | 9108500.0 |
| 2005-08-05 16:00:00 | SPY | ETF | 122.79 | 122.95 | 122.7 | 122.88 | 661800.0 |
| 2005-08-05 16:30:00 | SPY | ETF | 122.86 | 122.88 | 122.8 | 122.86 | 77200.0 |
| 2005-08-05 17:00:00 | SPY | ETF | 122.82 | 122.86 | 122.81 | 122.81 | 4000.0 |
| 2005-08-05 17:30:00 | SPY | ETF | 122.88 | 122.88 | 122.81 | 122.82 | 1400.0 |
| 2005-08-05 18:00:00 | SPY | ETF | 122.81 | 122.81 | 122.75 | 122.75 | 7900.0 |
| 2005-08-05 19:00:00 | SPY | ETF | 122.82 | 122.82 | 122.82 | 122.82 | 900.0 |
| 2005-08-05 19:30:00 | SPY | ETF | 122.82 | 122.82 | 122.82 | 122.82 | 900.0 |
| 2005-08-05 09:30:00 | QQQ | ETF | 39.61 | 39.79 | 39.6 | 39.66 | 11649000.0 |
| 2005-08-05 10:00:00 | QQQ | ETF | 39.65 | 39.69 | 39.51 | 39.53 | 9233100.0 |
| 2005-08-05 10:30:00 | QQQ | ETF | 39.53 | 39.58 | 39.45 | 39.51 | 5766700.0 |
| 2005-08-05 11:00:00 | QQQ | ETF | 39.51 | 39.54 | 39.46 | 39.47 | 3684900.0 |
| 2005-08-05 11:30:00 | QQQ | ETF | 39.47 | 39.5 | 39.43 | 39.45 | 5743800.0 |
| 2005-08-05 12:00:00 | QQQ | ETF | 39.45 | 39.54 | 39.43 | 39.53 | 3702300.0 |
| 2005-08-05 12:30:00 | QQQ | ETF | 39.54 | 39.55 | 39.49 | 39.5 | 1496100.0 |
| 2005-08-05 13:00:00 | QQQ | ETF | 39.51 | 39.64 | 39.49 | 39.57 | 4698800.0 |
| 2005-08-05 13:30:00 | QQQ | ETF | 39.57 | 39.6 | 39.52 | 39.53 | 1710400.0 |
| 2005-08-05 14:00:00 | QQQ | ETF | 39.53 | 39.54 | 39.47 | 39.51 | 1413200.0 |
| 2005-08-05 14:30:00 | QQQ | ETF | 39.51 | 39.59 | 39.48 | 39.5 | 2486400.0 |
| 2005-08-05 15:00:00 | QQQ | ETF | 39.5 | 39.55 | 39.48 | 39.55 | 2751200.0 |
| 2005-08-05 15:30:00 | QQQ | ETF | 39.55 | 39.6 | 39.48 | 39.48 | 6104400.0 |
| 2005-08-05 08:00:00 | IWM | ETF | 67.0 | 67.03 | 67.0 | 67.03 | 10200.0 |
| 2005-08-05 08:30:00 | IWM | ETF | 66.92 | 66.92 | 66.65 | 66.65 | 16900.0 |
| 2005-08-05 09:00:00 | IWM | ETF | 66.69 | 66.74 | 66.67 | 66.74 | 56800.0 |
| 2005-08-05 09:30:00 | IWM | ETF | 66.76 | 66.82 | 66.35 | 66.36 | 6357000.0 |
| 2005-08-05 10:00:00 | IWM | ETF | 66.36 | 66.37 | 66.13 | 66.14 | 6171700.0 |
| 2005-08-05 10:30:00 | IWM | ETF | 66.14 | 66.21 | 66.05 | 66.16 | 2010600.0 |
| 2005-08-05 11:00:00 | IWM | ETF | 66.16 | 66.2 | 65.99 | 66.0 | 1187800.0 |
| 2005-08-05 11:30:00 | IWM | ETF | 66.01 | 66.02 | 65.71 | 65.73 | 2894700.0 |
| 2005-08-05 12:00:00 | IWM | ETF | 65.73 | 65.82 | 65.66 | 65.82 | 2739900.0 |
| 2005-08-05 12:30:00 | IWM | ETF | 65.83 | 65.88 | 65.8 | 65.82 | 1160200.0 |
| 2005-08-05 13:00:00 | IWM | ETF | 65.8 | 65.98 | 65.8 | 65.92 | 1516800.0 |
| 2005-08-05 13:30:00 | IWM | ETF | 65.93 | 65.94 | 65.81 | 65.84 | 1162200.0 |
| 2005-08-05 14:00:00 | IWM | ETF | 65.84 | 65.84 | 65.74 | 65.82 | 1204400.0 |
> showing 50 of 1,595 rows — these rows as CSV