PREVIEW / etf_30min / 2007-12-12
file: by_date/etf_30min/2007/2007-12-12.parquet size: 152 KB rows: 5,443
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-12 04:00:00 | SPY | ETF | 149.27 | 149.27 | 149.24 | 149.24 | 12900.0 |
| 2007-12-12 04:30:00 | SPY | ETF | 149.27 | 149.44 | 149.22 | 149.22 | 20700.0 |
| 2007-12-12 05:00:00 | SPY | ETF | 149.3 | 149.3 | 149.3 | 149.3 | 1000.0 |
| 2007-12-12 05:30:00 | SPY | ETF | 149.14 | 149.14 | 149.13 | 149.13 | 1500.0 |
| 2007-12-12 06:00:00 | SPY | ETF | 149.22 | 149.4 | 149.22 | 149.4 | 112100.0 |
| 2007-12-12 06:30:00 | SPY | ETF | 149.45 | 149.56 | 149.41 | 149.49 | 269200.0 |
| 2007-12-12 07:00:00 | SPY | ETF | 149.45 | 149.45 | 149.1 | 149.16 | 1165000.0 |
| 2007-12-12 07:30:00 | SPY | ETF | 149.18 | 149.74 | 149.13 | 149.58 | 1447200.0 |
| 2007-12-12 08:00:00 | SPY | ETF | 149.59 | 149.68 | 148.26 | 149.42 | 3927600.0 |
| 2007-12-12 08:30:00 | SPY | ETF | 149.4 | 149.66 | 149.29 | 149.41 | 4107100.0 |
| 2007-12-12 09:00:00 | SPY | ETF | 149.4 | 152.0 | 149.4 | 151.51 | 33711096.0 |
| 2007-12-12 09:30:00 | SPY | ETF | 151.54 | 151.75 | 150.57 | 150.93 | 41051965.0 |
| 2007-12-12 10:00:00 | SPY | ETF | 150.93 | 150.95 | 150.34 | 150.8 | 16184329.0 |
| 2007-12-12 10:30:00 | SPY | ETF | 150.8 | 150.8 | 149.86 | 149.87 | 19523911.0 |
| 2007-12-12 11:00:00 | SPY | ETF | 149.86 | 150.54 | 149.85 | 150.08 | 11185602.0 |
| 2007-12-12 11:30:00 | SPY | ETF | 150.09 | 150.58 | 150.02 | 150.15 | 15288239.0 |
| 2007-12-12 12:00:00 | SPY | ETF | 150.14 | 150.22 | 149.75 | 149.83 | 9252579.0 |
| 2007-12-12 12:30:00 | SPY | ETF | 149.82 | 149.825 | 148.86 | 149.25 | 16222270.0 |
| 2007-12-12 13:00:00 | SPY | ETF | 149.25 | 151.32 | 148.93 | 149.29 | 10627140.0 |
| 2007-12-12 13:30:00 | SPY | ETF | 149.29 | 149.82 | 149.15 | 149.7 | 14873886.0 |
| 2007-12-12 14:00:00 | SPY | ETF | 149.707 | 149.91 | 149.31 | 149.31 | 11244889.0 |
| 2007-12-12 14:30:00 | SPY | ETF | 149.31 | 149.8962 | 148.97 | 149.0 | 11554972.0 |
| 2007-12-12 15:00:00 | SPY | ETF | 148.97 | 149.0 | 147.2 | 148.05 | 43824388.0 |
| 2007-12-12 15:30:00 | SPY | ETF | 148.05 | 149.23 | 147.41 | 149.16 | 36114794.0 |
| 2007-12-12 16:00:00 | SPY | ETF | 149.2 | 149.37 | 147.58 | 149.34 | 8916900.0 |
| 2007-12-12 16:30:00 | SPY | ETF | 149.29 | 150.61 | 149.29 | 149.44 | 4388100.0 |
| 2007-12-12 17:00:00 | SPY | ETF | 149.45 | 149.46 | 149.38 | 149.44 | 114100.0 |
| 2007-12-12 17:30:00 | SPY | ETF | 148.18 | 149.43 | 148.18 | 149.37 | 1021700.0 |
| 2007-12-12 18:00:00 | SPY | ETF | 149.36 | 149.38 | 149.26 | 149.26 | 52100.0 |
| 2007-12-12 18:30:00 | SPY | ETF | 149.28 | 149.28 | 149.14 | 149.15 | 57200.0 |
| 2007-12-12 19:00:00 | SPY | ETF | 149.14 | 149.26 | 149.1 | 149.26 | 23500.0 |
| 2007-12-12 19:30:00 | SPY | ETF | 149.22 | 149.23 | 149.16 | 149.23 | 20700.0 |
| 2007-12-12 04:00:00 | QQQ | ETF | 51.72 | 51.72 | 51.72 | 51.72 | 200.0 |
| 2007-12-12 04:30:00 | QQQ | ETF | 51.72 | 51.72 | 51.72 | 51.72 | 100.0 |
| 2007-12-12 06:00:00 | QQQ | ETF | 51.7 | 51.72 | 51.7 | 51.72 | 2900.0 |
| 2007-12-12 06:30:00 | QQQ | ETF | 51.77 | 51.8 | 51.76 | 51.77 | 200400.0 |
| 2007-12-12 07:00:00 | QQQ | ETF | 51.74 | 51.77 | 51.68 | 51.69 | 117665.0 |
| 2007-12-12 07:30:00 | QQQ | ETF | 51.69 | 51.91 | 51.66 | 51.82 | 695835.0 |
| 2007-12-12 08:00:00 | QQQ | ETF | 51.82 | 51.9 | 51.69 | 51.78 | 1690986.0 |
| 2007-12-12 08:30:00 | QQQ | ETF | 51.78 | 51.79 | 51.71 | 51.71 | 1759991.0 |
| 2007-12-12 09:00:00 | QQQ | ETF | 51.73 | 52.4 | 51.73 | 52.24 | 6973354.0 |
| 2007-12-12 09:30:00 | QQQ | ETF | 52.25 | 52.43 | 52.13 | 52.24 | 20244653.0 |
| 2007-12-12 10:00:00 | QQQ | ETF | 52.2302 | 52.32 | 52.1 | 52.28 | 10491973.0 |
| 2007-12-12 10:30:00 | QQQ | ETF | 52.2801 | 52.3 | 52.0 | 52.01 | 10094455.0 |
| 2007-12-12 11:00:00 | QQQ | ETF | 52.0 | 52.22 | 52.0 | 52.098 | 6351224.0 |
| 2007-12-12 11:30:00 | QQQ | ETF | 52.09 | 52.25 | 52.09 | 52.17 | 7618796.0 |
| 2007-12-12 12:00:00 | QQQ | ETF | 52.17 | 52.18 | 52.03 | 52.07 | 5643703.0 |
| 2007-12-12 12:30:00 | QQQ | ETF | 52.07 | 52.07 | 51.62 | 51.8 | 11511949.0 |
| 2007-12-12 13:00:00 | QQQ | ETF | 51.8 | 51.94 | 51.68 | 51.85 | 5732785.0 |
| 2007-12-12 13:30:00 | QQQ | ETF | 51.84 | 52.02 | 51.8 | 51.95 | 4210393.0 |
> showing 50 of 5,443 rows — these rows as CSV