PREVIEW / etf_30min / 2005-11-08
file: by_date/etf_30min/2005/2005-11-08.parquet size: 49 KB rows: 1,755
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-08 07:00:00 | SPY | ETF | 122.28 | 122.3 | 122.25 | 122.25 | 6100.0 |
| 2005-11-08 07:30:00 | SPY | ETF | 122.2 | 122.2 | 122.07 | 122.07 | 252500.0 |
| 2005-11-08 08:00:00 | SPY | ETF | 122.2 | 122.3 | 122.07 | 122.08 | 1442700.0 |
| 2005-11-08 08:30:00 | SPY | ETF | 122.1 | 122.1 | 122.0 | 122.0 | 508900.0 |
| 2005-11-08 09:00:00 | SPY | ETF | 122.01 | 122.02 | 121.9 | 121.95 | 1004000.0 |
| 2005-11-08 09:30:00 | SPY | ETF | 121.95 | 122.03 | 121.79 | 121.9 | 6468400.0 |
| 2005-11-08 10:00:00 | SPY | ETF | 121.9 | 122.03 | 121.83 | 122.0 | 3681400.0 |
| 2005-11-08 10:30:00 | SPY | ETF | 122.0 | 122.13 | 121.91 | 121.94 | 3026500.0 |
| 2005-11-08 11:00:00 | SPY | ETF | 121.94 | 122.21 | 121.92 | 122.14 | 2696600.0 |
| 2005-11-08 11:30:00 | SPY | ETF | 122.15 | 122.42 | 122.08 | 122.32 | 3957100.0 |
| 2005-11-08 12:00:00 | SPY | ETF | 122.32 | 122.34 | 122.17 | 122.2601 | 1414200.0 |
| 2005-11-08 12:30:00 | SPY | ETF | 122.28 | 122.32 | 122.06 | 122.24 | 2998400.0 |
| 2005-11-08 13:00:00 | SPY | ETF | 122.25 | 122.27 | 121.96 | 122.12 | 3736700.0 |
| 2005-11-08 13:30:00 | SPY | ETF | 122.13 | 122.18 | 121.97 | 122.04 | 1224400.0 |
| 2005-11-08 14:00:00 | SPY | ETF | 122.05 | 122.21 | 122.03 | 122.1 | 956800.0 |
| 2005-11-08 14:30:00 | SPY | ETF | 122.1 | 122.18 | 121.98 | 122.09 | 926600.0 |
| 2005-11-08 15:00:00 | SPY | ETF | 122.1 | 122.31 | 122.09 | 122.28 | 2913300.0 |
| 2005-11-08 15:30:00 | SPY | ETF | 122.29 | 122.3 | 122.04 | 122.07 | 3311400.0 |
| 2005-11-08 16:00:00 | SPY | ETF | 122.1 | 122.25 | 121.955 | 122.23 | 741200.0 |
| 2005-11-08 16:30:00 | SPY | ETF | 122.23 | 122.25 | 122.19 | 122.25 | 163700.0 |
| 2005-11-08 17:00:00 | SPY | ETF | 122.25 | 122.25 | 122.2 | 122.23 | 32800.0 |
| 2005-11-08 17:30:00 | SPY | ETF | 122.25 | 122.27 | 122.22 | 122.22 | 1600.0 |
| 2005-11-08 18:00:00 | SPY | ETF | 122.23 | 122.24 | 122.2 | 122.24 | 42300.0 |
| 2005-11-08 18:30:00 | SPY | ETF | 122.23 | 122.23 | 122.23 | 122.23 | 2500.0 |
| 2005-11-08 19:00:00 | SPY | ETF | 122.19 | 122.19 | 122.16 | 122.16 | 1600.0 |
| 2005-11-08 09:30:00 | QQQ | ETF | 40.06 | 40.15 | 39.99 | 40.03 | 18004600.0 |
| 2005-11-08 10:00:00 | QQQ | ETF | 40.03 | 40.13 | 40.0 | 40.12 | 8298500.0 |
| 2005-11-08 10:30:00 | QQQ | ETF | 40.12 | 40.23 | 40.11 | 40.15 | 6498700.0 |
| 2005-11-08 11:00:00 | QQQ | ETF | 40.14 | 40.28 | 40.12 | 40.24 | 8398300.0 |
| 2005-11-08 11:30:00 | QQQ | ETF | 40.24 | 40.35 | 40.18 | 40.33 | 7867000.0 |
| 2005-11-08 12:00:00 | QQQ | ETF | 40.33 | 40.34 | 40.27 | 40.31 | 4763100.0 |
| 2005-11-08 12:30:00 | QQQ | ETF | 40.3 | 40.31 | 40.16 | 40.23 | 3554200.0 |
| 2005-11-08 13:00:00 | QQQ | ETF | 40.22 | 40.23 | 40.13 | 40.22 | 3186400.0 |
| 2005-11-08 13:30:00 | QQQ | ETF | 40.22 | 40.24 | 40.1 | 40.16 | 2742200.0 |
| 2005-11-08 14:00:00 | QQQ | ETF | 40.16 | 40.22 | 40.0 | 40.18 | 2465200.0 |
| 2005-11-08 14:30:00 | QQQ | ETF | 40.18 | 40.19 | 40.11 | 40.13 | 2033200.0 |
| 2005-11-08 15:00:00 | QQQ | ETF | 40.13 | 40.22 | 40.12 | 40.2 | 3155200.0 |
| 2005-11-08 15:30:00 | QQQ | ETF | 40.21 | 40.21 | 40.06 | 40.13 | 4840300.0 |
| 2005-11-08 07:30:00 | IWM | ETF | 65.62 | 65.62 | 65.6 | 65.6 | 9800.0 |
| 2005-11-08 08:00:00 | IWM | ETF | 65.69 | 65.7 | 65.56 | 65.58 | 270500.0 |
| 2005-11-08 08:30:00 | IWM | ETF | 65.51 | 65.51 | 65.47 | 65.47 | 4700.0 |
| 2005-11-08 09:00:00 | IWM | ETF | 65.45 | 65.45 | 65.35 | 65.41 | 166000.0 |
| 2005-11-08 09:30:00 | IWM | ETF | 65.43 | 65.43 | 65.1 | 65.17 | 3844200.0 |
| 2005-11-08 10:00:00 | IWM | ETF | 65.17 | 65.28 | 65.06 | 65.24 | 3282000.0 |
| 2005-11-08 10:30:00 | IWM | ETF | 65.26 | 65.36 | 65.19 | 65.2 | 1517900.0 |
| 2005-11-08 11:00:00 | IWM | ETF | 65.21 | 65.45 | 65.13 | 65.39 | 1741700.0 |
| 2005-11-08 11:30:00 | IWM | ETF | 65.38 | 65.57 | 65.25 | 65.51 | 1544000.0 |
| 2005-11-08 12:00:00 | IWM | ETF | 65.51 | 65.53 | 65.27 | 65.44 | 732600.0 |
| 2005-11-08 12:30:00 | IWM | ETF | 65.45 | 65.49 | 65.23 | 65.3 | 554400.0 |
| 2005-11-08 13:00:00 | IWM | ETF | 65.29 | 65.39 | 65.14 | 65.37 | 767000.0 |
> showing 50 of 1,755 rows — these rows as CSV