PREVIEW / etf_30min / 2004-12-10
file: by_date/etf_30min/2004/2004-12-10.parquet size: 39 KB rows: 1,328
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-10 08:00:00 | SPY | ETF | 118.97 | 119.02 | 118.95 | 118.95 | 80900.0 |
| 2004-12-10 08:30:00 | SPY | ETF | 118.95 | 119.0 | 118.86 | 118.91 | 117600.0 |
| 2004-12-10 09:00:00 | SPY | ETF | 118.91 | 118.96 | 118.89 | 118.89 | 86000.0 |
| 2004-12-10 09:30:00 | SPY | ETF | 118.91 | 119.36 | 118.85 | 119.21 | 6447300.0 |
| 2004-12-10 10:00:00 | SPY | ETF | 119.2 | 119.34 | 118.99 | 119.01 | 3644400.0 |
| 2004-12-10 10:30:00 | SPY | ETF | 119.03 | 119.07 | 118.87 | 118.96 | 6904500.0 |
| 2004-12-10 11:00:00 | SPY | ETF | 118.97 | 119.32 | 118.93 | 119.23 | 3201400.0 |
| 2004-12-10 11:30:00 | SPY | ETF | 119.23 | 119.24 | 118.98 | 119.02 | 2356500.0 |
| 2004-12-10 12:00:00 | SPY | ETF | 119.03 | 119.25 | 118.99 | 119.17 | 1982500.0 |
| 2004-12-10 12:30:00 | SPY | ETF | 119.17 | 119.25 | 119.11 | 119.2 | 1143900.0 |
| 2004-12-10 13:00:00 | SPY | ETF | 119.19 | 119.4 | 119.13 | 119.26 | 3388000.0 |
| 2004-12-10 13:30:00 | SPY | ETF | 119.26 | 119.55 | 119.19 | 119.49 | 6078600.0 |
| 2004-12-10 14:00:00 | SPY | ETF | 119.49 | 119.56 | 119.2 | 119.22 | 2752200.0 |
| 2004-12-10 14:30:00 | SPY | ETF | 119.22 | 119.37 | 119.12 | 119.24 | 2262700.0 |
| 2004-12-10 15:00:00 | SPY | ETF | 119.24 | 119.38 | 119.19 | 119.31 | 1303200.0 |
| 2004-12-10 15:30:00 | SPY | ETF | 119.31 | 119.38 | 119.09 | 119.17 | 3527200.0 |
| 2004-12-10 16:00:00 | SPY | ETF | 119.15 | 119.35 | 119.13 | 119.26 | 1781100.0 |
| 2004-12-10 16:30:00 | SPY | ETF | 119.25 | 119.33 | 119.18 | 119.3 | 80900.0 |
| 2004-12-10 17:00:00 | SPY | ETF | 119.35 | 119.39 | 119.32 | 119.37 | 15700.0 |
| 2004-12-10 17:30:00 | SPY | ETF | 119.33 | 119.38 | 119.33 | 119.38 | 5800.0 |
| 2004-12-10 18:00:00 | SPY | ETF | 119.39 | 119.39 | 119.33 | 119.34 | 2700.0 |
| 2004-12-10 19:00:00 | SPY | ETF | 119.34 | 119.37 | 119.34 | 119.37 | 800.0 |
| 2004-12-10 19:30:00 | SPY | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 100.0 |
| 2004-12-10 08:00:00 | QQQ | ETF | 39.87 | 39.89 | 39.83 | 39.85 | 752170.0 |
| 2004-12-10 08:30:00 | QQQ | ETF | 39.85 | 39.89 | 39.833 | 39.89 | 308779.0 |
| 2004-12-10 09:00:00 | QQQ | ETF | 39.89 | 40.0 | 39.82 | 39.84 | 1039285.0 |
| 2004-12-10 09:30:00 | QQQ | ETF | 39.74 | 40.051 | 39.74 | 40.0 | 14423842.0 |
| 2004-12-10 10:00:00 | QQQ | ETF | 40.0 | 40.07 | 39.89 | 39.93 | 9465304.0 |
| 2004-12-10 10:30:00 | QQQ | ETF | 39.927 | 39.94 | 39.86 | 39.886 | 5946039.0 |
| 2004-12-10 11:00:00 | QQQ | ETF | 39.886 | 40.04 | 39.86 | 40.004 | 5661355.0 |
| 2004-12-10 11:30:00 | QQQ | ETF | 40.01 | 40.01 | 39.883 | 39.899 | 4886190.0 |
| 2004-12-10 12:00:00 | QQQ | ETF | 39.89 | 39.9664 | 39.84 | 39.94 | 4758026.0 |
| 2004-12-10 12:30:00 | QQQ | ETF | 39.939 | 39.988 | 39.898 | 39.929 | 2586370.0 |
| 2004-12-10 13:00:00 | QQQ | ETF | 39.926 | 40.03 | 39.9 | 39.98 | 5836076.0 |
| 2004-12-10 13:30:00 | QQQ | ETF | 39.979 | 40.07 | 39.91 | 40.03 | 5532951.0 |
| 2004-12-10 14:00:00 | QQQ | ETF | 40.024 | 40.06 | 39.89 | 39.907 | 5596447.0 |
| 2004-12-10 14:30:00 | QQQ | ETF | 39.9 | 39.956 | 39.846 | 39.9184 | 5441041.0 |
| 2004-12-10 15:00:00 | QQQ | ETF | 39.92 | 39.98 | 39.9 | 39.953 | 4525951.0 |
| 2004-12-10 15:30:00 | QQQ | ETF | 39.9599 | 39.96 | 39.84 | 39.91 | 6338661.0 |
| 2004-12-10 16:00:00 | QQQ | ETF | 39.91 | 39.998 | 39.9 | 39.95 | 2587926.0 |
| 2004-12-10 16:30:00 | QQQ | ETF | 39.95 | 39.98 | 39.94 | 39.97 | 64158.0 |
| 2004-12-10 17:00:00 | QQQ | ETF | 39.98 | 39.98 | 39.96 | 39.98 | 39147.0 |
| 2004-12-10 17:30:00 | QQQ | ETF | 39.99 | 40.01 | 39.95 | 39.98 | 43930.0 |
| 2004-12-10 18:00:00 | QQQ | ETF | 39.975 | 39.997 | 39.96 | 39.97 | 6020.0 |
| 2004-12-10 08:00:00 | IWM | ETF | 62.55 | 62.55 | 62.525 | 62.525 | 7800.0 |
| 2004-12-10 08:30:00 | IWM | ETF | 62.47 | 62.495 | 62.465 | 62.475 | 3000.0 |
| 2004-12-10 09:00:00 | IWM | ETF | 62.475 | 62.5 | 62.465 | 62.5 | 18400.0 |
| 2004-12-10 09:30:00 | IWM | ETF | 62.505 | 62.795 | 62.415 | 62.655 | 1568400.0 |
| 2004-12-10 10:00:00 | IWM | ETF | 62.65 | 62.79 | 62.595 | 62.64 | 1402400.0 |
| 2004-12-10 10:30:00 | IWM | ETF | 62.64 | 62.67 | 62.545 | 62.605 | 583200.0 |
> showing 50 of 1,328 rows — these rows as CSV