PREVIEW / etf_30min / 2005-12-27
file: by_date/etf_30min/2005/2005-12-27.parquet size: 59 KB rows: 2,061
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-12-27 05:30:00 | SPY | ETF | 127.1 | 127.1 | 127.1 | 127.1 | 100.0 |
| 2005-12-27 07:00:00 | SPY | ETF | 127.04 | 127.04 | 127.04 | 127.04 | 2400.0 |
| 2005-12-27 07:30:00 | SPY | ETF | 127.06 | 127.06 | 127.02 | 127.05 | 7200.0 |
| 2005-12-27 08:00:00 | SPY | ETF | 127.07 | 127.09 | 127.02 | 127.05 | 71100.0 |
| 2005-12-27 08:30:00 | SPY | ETF | 127.03 | 127.05 | 127.01 | 127.03 | 64300.0 |
| 2005-12-27 09:00:00 | SPY | ETF | 127.03 | 127.045 | 126.92 | 126.92 | 160100.0 |
| 2005-12-27 09:30:00 | SPY | ETF | 126.92 | 127.05 | 126.9 | 127.0 | 3237000.0 |
| 2005-12-27 10:00:00 | SPY | ETF | 127.0 | 127.02 | 126.78 | 126.83 | 1813300.0 |
| 2005-12-27 10:30:00 | SPY | ETF | 126.86 | 126.91 | 126.76 | 126.77 | 2096900.0 |
| 2005-12-27 11:00:00 | SPY | ETF | 126.77 | 126.8 | 126.44 | 126.51 | 2702400.0 |
| 2005-12-27 11:30:00 | SPY | ETF | 126.51 | 126.53 | 126.08 | 126.1 | 4804200.0 |
| 2005-12-27 12:00:00 | SPY | ETF | 126.1 | 126.15 | 125.92 | 126.14 | 3934600.0 |
| 2005-12-27 12:30:00 | SPY | ETF | 126.14 | 126.17 | 125.97 | 126.01 | 1602100.0 |
| 2005-12-27 13:00:00 | SPY | ETF | 126.01 | 126.12 | 125.64 | 125.76 | 4145900.0 |
| 2005-12-27 13:30:00 | SPY | ETF | 125.77 | 126.03 | 125.5 | 125.61 | 4228800.0 |
| 2005-12-27 14:00:00 | SPY | ETF | 125.61 | 125.89 | 125.59 | 125.86 | 3162100.0 |
| 2005-12-27 14:30:00 | SPY | ETF | 125.89 | 125.92 | 125.65 | 125.71 | 3219300.0 |
| 2005-12-27 15:00:00 | SPY | ETF | 125.72 | 125.86 | 125.61 | 125.8 | 2253200.0 |
| 2005-12-27 15:30:00 | SPY | ETF | 125.8 | 125.81 | 125.48 | 125.51 | 4585200.0 |
| 2005-12-27 16:00:00 | SPY | ETF | 125.51 | 125.56 | 125.35 | 125.42 | 698400.0 |
| 2005-12-27 16:30:00 | SPY | ETF | 125.44 | 125.52 | 125.44 | 125.45 | 213200.0 |
| 2005-12-27 17:00:00 | SPY | ETF | 125.47 | 125.48 | 125.47 | 125.48 | 2100.0 |
| 2005-12-27 17:30:00 | SPY | ETF | 125.46 | 125.52 | 125.42 | 125.45 | 62100.0 |
| 2005-12-27 18:00:00 | SPY | ETF | 125.46 | 125.51 | 125.46 | 125.51 | 700.0 |
| 2005-12-27 19:00:00 | SPY | ETF | 125.47 | 125.47 | 125.47 | 125.47 | 200.0 |
| 2005-12-27 19:30:00 | SPY | ETF | 125.52 | 125.52 | 125.52 | 125.52 | 4000.0 |
| 2005-12-27 09:30:00 | QQQ | ETF | 41.52 | 41.68 | 41.49 | 41.62 | 7521400.0 |
| 2005-12-27 10:00:00 | QQQ | ETF | 41.61 | 41.62 | 41.45 | 41.48 | 3677500.0 |
| 2005-12-27 10:30:00 | QQQ | ETF | 41.48 | 41.52 | 41.44 | 41.44 | 2315100.0 |
| 2005-12-27 11:00:00 | QQQ | ETF | 41.44 | 41.51 | 41.3 | 41.32 | 3498100.0 |
| 2005-12-27 11:30:00 | QQQ | ETF | 41.32 | 41.33 | 41.12 | 41.13 | 6415800.0 |
| 2005-12-27 12:00:00 | QQQ | ETF | 41.13 | 41.18 | 41.06 | 41.16 | 6036600.0 |
| 2005-12-27 12:30:00 | QQQ | ETF | 41.15 | 41.18 | 41.1 | 41.13 | 1989600.0 |
| 2005-12-27 13:00:00 | QQQ | ETF | 41.13 | 41.18 | 41.04 | 41.08 | 3165400.0 |
| 2005-12-27 13:30:00 | QQQ | ETF | 41.08 | 41.11 | 40.97 | 41.01 | 3597100.0 |
| 2005-12-27 14:00:00 | QQQ | ETF | 41.0 | 41.16 | 40.99 | 41.15 | 3028200.0 |
| 2005-12-27 14:30:00 | QQQ | ETF | 41.15 | 41.17 | 41.07 | 41.1 | 2028100.0 |
| 2005-12-27 15:00:00 | QQQ | ETF | 41.1 | 41.15 | 41.05 | 41.12 | 2571300.0 |
| 2005-12-27 15:30:00 | QQQ | ETF | 41.12 | 41.13 | 40.99 | 41.04 | 4572100.0 |
| 2005-12-27 08:00:00 | IWM | ETF | 68.33 | 68.41 | 68.33 | 68.33 | 21100.0 |
| 2005-12-27 08:30:00 | IWM | ETF | 68.35 | 68.41 | 68.34 | 68.41 | 5200.0 |
| 2005-12-27 09:00:00 | IWM | ETF | 68.35 | 68.37 | 68.32 | 68.34 | 46900.0 |
| 2005-12-27 09:30:00 | IWM | ETF | 68.35 | 68.43 | 68.2 | 68.23 | 1842800.0 |
| 2005-12-27 10:00:00 | IWM | ETF | 68.23 | 68.23 | 67.94 | 67.97 | 1077600.0 |
| 2005-12-27 10:30:00 | IWM | ETF | 67.97 | 68.07 | 67.9 | 67.95 | 784000.0 |
| 2005-12-27 11:00:00 | IWM | ETF | 67.91 | 67.98 | 67.72 | 67.73 | 1540800.0 |
| 2005-12-27 11:30:00 | IWM | ETF | 67.74 | 67.74 | 67.44 | 67.45 | 2872300.0 |
| 2005-12-27 12:00:00 | IWM | ETF | 67.44 | 67.49 | 67.28 | 67.42 | 2510200.0 |
| 2005-12-27 12:30:00 | IWM | ETF | 67.42 | 67.51 | 67.3 | 67.39 | 2327800.0 |
| 2005-12-27 13:00:00 | IWM | ETF | 67.39 | 67.5 | 67.23 | 67.27 | 1888500.0 |
> showing 50 of 2,061 rows — these rows as CSV