PREVIEW / etf_30min / 2005-11-10
file: by_date/etf_30min/2005/2005-11-10.parquet size: 53 KB rows: 1,784
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-11-10 07:00:00 | SPY | ETF | 122.37 | 122.37 | 122.37 | 122.37 | 100.0 |
| 2005-11-10 07:30:00 | SPY | ETF | 122.35 | 122.37 | 122.35 | 122.37 | 2300.0 |
| 2005-11-10 08:00:00 | SPY | ETF | 122.37 | 122.41 | 122.25 | 122.31 | 672400.0 |
| 2005-11-10 08:30:00 | SPY | ETF | 122.32 | 122.36 | 122.23 | 122.29 | 908400.0 |
| 2005-11-10 09:00:00 | SPY | ETF | 122.29 | 122.49 | 122.28 | 122.35 | 438200.0 |
| 2005-11-10 09:30:00 | SPY | ETF | 122.34 | 122.58 | 122.23 | 122.35 | 6311400.0 |
| 2005-11-10 10:00:00 | SPY | ETF | 122.36 | 122.38 | 121.75 | 121.93 | 10028800.0 |
| 2005-11-10 10:30:00 | SPY | ETF | 121.92 | 122.1 | 121.75 | 122.01 | 4844500.0 |
| 2005-11-10 11:00:00 | SPY | ETF | 122.0 | 122.26 | 121.91 | 122.03 | 3304800.0 |
| 2005-11-10 11:30:00 | SPY | ETF | 122.05 | 122.15 | 121.82 | 122.09 | 2643600.0 |
| 2005-11-10 12:00:00 | SPY | ETF | 122.09 | 122.31 | 122.02 | 122.22 | 2138000.0 |
| 2005-11-10 12:30:00 | SPY | ETF | 122.24 | 122.33 | 122.12 | 122.23 | 3145700.0 |
| 2005-11-10 13:00:00 | SPY | ETF | 122.23 | 122.6 | 122.21 | 122.47 | 6542100.0 |
| 2005-11-10 13:30:00 | SPY | ETF | 122.45 | 123.23 | 122.41 | 123.12 | 12098200.0 |
| 2005-11-10 14:00:00 | SPY | ETF | 123.12 | 123.26 | 123.03 | 123.22 | 4509800.0 |
| 2005-11-10 14:30:00 | SPY | ETF | 123.23 | 123.86 | 123.14 | 123.46 | 7512400.0 |
| 2005-11-10 15:00:00 | SPY | ETF | 123.45 | 123.52 | 123.31 | 123.37 | 6561700.0 |
| 2005-11-10 15:30:00 | SPY | ETF | 123.36 | 123.48 | 123.24 | 123.35 | 4542700.0 |
| 2005-11-10 16:00:00 | SPY | ETF | 123.35 | 123.4 | 123.3 | 123.37 | 753500.0 |
| 2005-11-10 16:30:00 | SPY | ETF | 123.37 | 123.38 | 123.3 | 123.38 | 44200.0 |
| 2005-11-10 17:00:00 | SPY | ETF | 123.34 | 123.34 | 123.31 | 123.31 | 2100.0 |
| 2005-11-10 17:30:00 | SPY | ETF | 123.35 | 123.35 | 123.35 | 123.35 | 400.0 |
| 2005-11-10 18:00:00 | SPY | ETF | 123.35 | 123.38 | 123.32 | 123.38 | 80500.0 |
| 2005-11-10 19:00:00 | SPY | ETF | 123.36 | 123.41 | 123.36 | 123.41 | 4800.0 |
| 2005-11-10 09:30:00 | QQQ | ETF | 40.18 | 40.28 | 40.12 | 40.14 | 7611100.0 |
| 2005-11-10 10:00:00 | QQQ | ETF | 40.13 | 40.15 | 39.94 | 40.01 | 11862700.0 |
| 2005-11-10 10:30:00 | QQQ | ETF | 40.01 | 40.07 | 39.92 | 40.06 | 7357000.0 |
| 2005-11-10 11:00:00 | QQQ | ETF | 40.06 | 40.09 | 39.99 | 40.05 | 4571600.0 |
| 2005-11-10 11:30:00 | QQQ | ETF | 40.04 | 40.07 | 39.95 | 40.06 | 4351300.0 |
| 2005-11-10 12:00:00 | QQQ | ETF | 40.06 | 40.14 | 40.02 | 40.12 | 2965500.0 |
| 2005-11-10 12:30:00 | QQQ | ETF | 40.12 | 40.14 | 40.07 | 40.11 | 2880700.0 |
| 2005-11-10 13:00:00 | QQQ | ETF | 40.12 | 40.31 | 40.11 | 40.26 | 8926400.0 |
| 2005-11-10 13:30:00 | QQQ | ETF | 40.26 | 40.54 | 40.22 | 40.5 | 14997500.0 |
| 2005-11-10 14:00:00 | QQQ | ETF | 40.49 | 40.6 | 40.46 | 40.59 | 9117000.0 |
| 2005-11-10 14:30:00 | QQQ | ETF | 40.59 | 40.65 | 40.55 | 40.63 | 8379800.0 |
| 2005-11-10 15:00:00 | QQQ | ETF | 40.62 | 40.68 | 40.53 | 40.62 | 13243600.0 |
| 2005-11-10 15:30:00 | QQQ | ETF | 40.62 | 40.69 | 40.6 | 40.6 | 11757000.0 |
| 2005-11-10 08:00:00 | IWM | ETF | 65.67 | 65.67 | 65.67 | 65.67 | 8000.0 |
| 2005-11-10 08:30:00 | IWM | ETF | 65.64 | 65.64 | 65.57 | 65.57 | 15300.0 |
| 2005-11-10 09:00:00 | IWM | ETF | 65.59 | 65.69 | 65.59 | 65.62 | 36900.0 |
| 2005-11-10 09:30:00 | IWM | ETF | 65.64 | 65.65 | 65.3 | 65.34 | 2506200.0 |
| 2005-11-10 10:00:00 | IWM | ETF | 65.35 | 65.4 | 64.83 | 65.02 | 5274800.0 |
| 2005-11-10 10:30:00 | IWM | ETF | 65.01 | 65.4 | 64.74 | 65.04 | 2528000.0 |
| 2005-11-10 11:00:00 | IWM | ETF | 65.04 | 65.14 | 64.9 | 64.99 | 2515500.0 |
| 2005-11-10 11:30:00 | IWM | ETF | 64.99 | 65.08 | 64.85 | 65.02 | 1674800.0 |
| 2005-11-10 12:00:00 | IWM | ETF | 65.03 | 65.13 | 64.96 | 65.11 | 469600.0 |
| 2005-11-10 12:30:00 | IWM | ETF | 65.11 | 65.2 | 65.0 | 65.07 | 2594100.0 |
| 2005-11-10 13:00:00 | IWM | ETF | 65.06 | 65.4 | 65.06 | 65.39 | 2052500.0 |
| 2005-11-10 13:30:00 | IWM | ETF | 65.39 | 65.93 | 65.3 | 65.86 | 2710100.0 |
| 2005-11-10 14:00:00 | IWM | ETF | 65.86 | 66.01 | 65.84 | 66.0 | 2156900.0 |
> showing 50 of 1,784 rows — these rows as CSV