PREVIEW / etf_30min / 2008-05-30
file: by_date/etf_30min/2008/2008-05-30.parquet size: 154 KB rows: 5,664
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-30 04:00:00 | SPY | ETF | 139.96 | 140.07 | 139.96 | 140.07 | 2500.0 |
| 2008-05-30 04:30:00 | SPY | ETF | 140.12 | 140.12 | 140.12 | 140.12 | 1000.0 |
| 2008-05-30 05:00:00 | SPY | ETF | 140.15 | 140.15 | 140.15 | 140.15 | 500.0 |
| 2008-05-30 05:30:00 | SPY | ETF | 140.2 | 140.29 | 140.2 | 140.22 | 26500.0 |
| 2008-05-30 06:00:00 | SPY | ETF | 140.3 | 140.3 | 140.27 | 140.28 | 10600.0 |
| 2008-05-30 06:30:00 | SPY | ETF | 140.21 | 140.37 | 140.21 | 140.37 | 27300.0 |
| 2008-05-30 07:00:00 | SPY | ETF | 140.3 | 140.35 | 140.25 | 140.35 | 107514.0 |
| 2008-05-30 07:30:00 | SPY | ETF | 140.31 | 140.31 | 140.2 | 140.27 | 147253.0 |
| 2008-05-30 08:00:00 | SPY | ETF | 140.26 | 140.34 | 140.22 | 140.33 | 1355750.0 |
| 2008-05-30 08:30:00 | SPY | ETF | 140.37 | 140.64 | 140.36 | 140.45 | 2482757.0 |
| 2008-05-30 09:00:00 | SPY | ETF | 140.45 | 140.58 | 140.45 | 140.48 | 2235867.0 |
| 2008-05-30 09:30:00 | SPY | ETF | 140.47 | 140.53 | 140.125 | 140.22 | 12750255.0 |
| 2008-05-30 10:00:00 | SPY | ETF | 140.22 | 140.69 | 140.12 | 140.68 | 12107624.0 |
| 2008-05-30 10:30:00 | SPY | ETF | 140.68 | 140.7 | 140.21 | 140.32 | 7613979.0 |
| 2008-05-30 11:00:00 | SPY | ETF | 140.32 | 140.38 | 140.05 | 140.12 | 7836427.0 |
| 2008-05-30 11:30:00 | SPY | ETF | 140.12 | 140.51 | 140.1 | 140.47 | 7515651.0 |
| 2008-05-30 12:00:00 | SPY | ETF | 140.48 | 140.51 | 140.33 | 140.47 | 4351088.0 |
| 2008-05-30 12:30:00 | SPY | ETF | 140.47 | 140.57 | 140.42 | 140.47 | 4802676.0 |
| 2008-05-30 13:00:00 | SPY | ETF | 140.47 | 140.53 | 140.31 | 140.49 | 4393744.0 |
| 2008-05-30 13:30:00 | SPY | ETF | 140.49 | 140.7 | 140.41 | 140.57 | 3930928.0 |
| 2008-05-30 14:00:00 | SPY | ETF | 140.57 | 140.57 | 140.36 | 140.4 | 5085518.0 |
| 2008-05-30 14:30:00 | SPY | ETF | 140.4 | 140.64 | 140.4 | 140.58 | 4918512.0 |
| 2008-05-30 15:00:00 | SPY | ETF | 140.58 | 140.74 | 140.31 | 140.48 | 7496484.0 |
| 2008-05-30 15:30:00 | SPY | ETF | 140.49 | 140.69 | 140.08 | 140.11 | 17027450.0 |
| 2008-05-30 16:00:00 | SPY | ETF | 140.21 | 140.36 | 140.07 | 140.32 | 3825694.0 |
| 2008-05-30 16:30:00 | SPY | ETF | 140.31 | 140.48 | 140.0961 | 140.47 | 2082434.0 |
| 2008-05-30 17:00:00 | SPY | ETF | 140.47 | 140.56 | 140.35 | 140.35 | 122818.0 |
| 2008-05-30 17:30:00 | SPY | ETF | 140.35 | 140.36 | 140.3 | 140.34 | 45500.0 |
| 2008-05-30 18:00:00 | SPY | ETF | 140.38 | 140.38 | 140.38 | 140.38 | 100.0 |
| 2008-05-30 18:30:00 | SPY | ETF | 140.4 | 140.44 | 140.4 | 140.44 | 12600.0 |
| 2008-05-30 19:00:00 | SPY | ETF | 140.4 | 140.4 | 140.4 | 140.4 | 3500.0 |
| 2008-05-30 19:30:00 | SPY | ETF | 140.4 | 140.42 | 140.4 | 140.4 | 2593.0 |
| 2008-05-30 20:00:00 | SPY | ETF | 140.4 | 140.4 | 140.4 | 140.4 | 500.0 |
| 2008-05-30 06:30:00 | QQQ | ETF | 49.91 | 49.95 | 49.91 | 49.93 | 5100.0 |
| 2008-05-30 07:00:00 | QQQ | ETF | 49.93 | 49.96 | 49.93 | 49.96 | 14800.0 |
| 2008-05-30 07:30:00 | QQQ | ETF | 49.95 | 49.96 | 49.9 | 49.9 | 134305.0 |
| 2008-05-30 08:00:00 | QQQ | ETF | 49.91 | 49.95 | 49.89 | 49.93 | 557853.0 |
| 2008-05-30 08:30:00 | QQQ | ETF | 49.95 | 50.04 | 49.95 | 49.98 | 1794649.0 |
| 2008-05-30 09:00:00 | QQQ | ETF | 49.98 | 49.98 | 49.86 | 49.88 | 729720.0 |
| 2008-05-30 09:30:00 | QQQ | ETF | 49.89 | 49.97 | 49.75 | 49.92 | 11953893.0 |
| 2008-05-30 10:00:00 | QQQ | ETF | 49.92 | 50.11 | 49.88 | 50.11 | 8255907.0 |
| 2008-05-30 10:30:00 | QQQ | ETF | 50.1 | 50.11 | 49.94 | 50.0 | 7302619.0 |
| 2008-05-30 11:00:00 | QQQ | ETF | 50.01 | 50.02 | 49.92 | 49.97 | 6053727.0 |
| 2008-05-30 11:30:00 | QQQ | ETF | 49.97 | 50.1 | 49.95 | 50.07 | 5904620.0 |
| 2008-05-30 12:00:00 | QQQ | ETF | 50.08 | 50.08 | 50.0 | 50.05 | 3116879.0 |
| 2008-05-30 12:30:00 | QQQ | ETF | 50.06 | 50.12 | 50.01 | 50.1 | 4962144.0 |
| 2008-05-30 13:00:00 | QQQ | ETF | 50.11 | 50.12 | 50.03 | 50.1 | 3771680.0 |
| 2008-05-30 13:30:00 | QQQ | ETF | 50.1 | 50.21 | 50.06 | 50.13 | 5043650.0 |
| 2008-05-30 14:00:00 | QQQ | ETF | 50.14 | 50.14 | 50.045 | 50.09 | 4341648.0 |
| 2008-05-30 14:30:00 | QQQ | ETF | 50.0817 | 50.21 | 50.08 | 50.1901 | 3107848.0 |
> showing 50 of 5,664 rows — these rows as CSV