PREVIEW / etf_30min / 2006-03-03
file: by_date/etf_30min/2006/2006-03-03.parquet size: 61 KB rows: 2,156
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-03 06:00:00 | SPY | ETF | 129.38 | 129.39 | 129.38 | 129.38 | 25000.0 |
| 2006-03-03 06:30:00 | SPY | ETF | 129.36 | 129.36 | 129.36 | 129.36 | 2000.0 |
| 2006-03-03 07:00:00 | SPY | ETF | 129.36 | 129.37 | 129.27 | 129.27 | 6400.0 |
| 2006-03-03 07:30:00 | SPY | ETF | 129.3 | 129.3 | 129.3 | 129.3 | 1000.0 |
| 2006-03-03 08:00:00 | SPY | ETF | 129.25 | 129.36 | 129.13 | 129.16 | 325700.0 |
| 2006-03-03 08:30:00 | SPY | ETF | 129.15 | 129.16 | 128.74 | 128.74 | 918900.0 |
| 2006-03-03 09:00:00 | SPY | ETF | 128.74 | 128.85 | 128.2 | 128.67 | 3714300.0 |
| 2006-03-03 09:30:00 | SPY | ETF | 128.66 | 128.97 | 128.65 | 128.94 | 5344600.0 |
| 2006-03-03 10:00:00 | SPY | ETF | 128.94 | 129.19 | 128.71 | 129.13 | 7663000.0 |
| 2006-03-03 10:30:00 | SPY | ETF | 129.12 | 129.29 | 128.85 | 128.94 | 4315500.0 |
| 2006-03-03 11:00:00 | SPY | ETF | 128.94 | 129.08 | 128.81 | 128.9 | 2449400.0 |
| 2006-03-03 11:30:00 | SPY | ETF | 128.91 | 129.14 | 128.76 | 129.07 | 1860300.0 |
| 2006-03-03 12:00:00 | SPY | ETF | 129.07 | 129.55 | 129.05 | 129.49 | 5743100.0 |
| 2006-03-03 12:30:00 | SPY | ETF | 129.5 | 129.7 | 129.37 | 129.56 | 4331600.0 |
| 2006-03-03 13:00:00 | SPY | ETF | 129.55 | 129.86 | 129.44 | 129.8 | 3768800.0 |
| 2006-03-03 13:30:00 | SPY | ETF | 129.84 | 130.07 | 129.78 | 129.88 | 5662700.0 |
| 2006-03-03 14:00:00 | SPY | ETF | 129.88 | 129.94 | 129.73 | 129.75 | 2918600.0 |
| 2006-03-03 14:30:00 | SPY | ETF | 129.74 | 129.92 | 129.64 | 129.81 | 2798000.0 |
| 2006-03-03 15:00:00 | SPY | ETF | 129.82 | 129.84 | 129.23 | 129.38 | 7540900.0 |
| 2006-03-03 15:30:00 | SPY | ETF | 129.38 | 129.44 | 128.99 | 128.99 | 8895700.0 |
| 2006-03-03 16:00:00 | SPY | ETF | 128.99 | 129.03 | 128.76 | 128.76 | 2463800.0 |
| 2006-03-03 16:30:00 | SPY | ETF | 128.76 | 129.5617 | 128.65 | 128.76 | 1107100.0 |
| 2006-03-03 17:00:00 | SPY | ETF | 128.76 | 128.82 | 128.76 | 128.78 | 11800.0 |
| 2006-03-03 17:30:00 | SPY | ETF | 128.8 | 128.82 | 128.8 | 128.82 | 1200.0 |
| 2006-03-03 18:00:00 | SPY | ETF | 128.79 | 128.79 | 128.75 | 128.79 | 26300.0 |
| 2006-03-03 18:30:00 | SPY | ETF | 128.77 | 128.83 | 128.77 | 128.83 | 1000.0 |
| 2006-03-03 19:00:00 | SPY | ETF | 128.84 | 128.85 | 128.84 | 128.84 | 500.0 |
| 2006-03-03 09:30:00 | QQQ | ETF | 41.45 | 41.58 | 41.25 | 41.53 | 15953700.0 |
| 2006-03-03 10:00:00 | QQQ | ETF | 41.53 | 41.71 | 41.42 | 41.66 | 8810100.0 |
| 2006-03-03 10:30:00 | QQQ | ETF | 41.66 | 41.7 | 41.49 | 41.54 | 4919100.0 |
| 2006-03-03 11:00:00 | QQQ | ETF | 41.53 | 41.63 | 41.49 | 41.53 | 4134600.0 |
| 2006-03-03 11:30:00 | QQQ | ETF | 41.58 | 41.68 | 41.52 | 41.65 | 2883300.0 |
| 2006-03-03 12:00:00 | QQQ | ETF | 41.66 | 41.85 | 41.63 | 41.84 | 7914300.0 |
| 2006-03-03 12:30:00 | QQQ | ETF | 41.84 | 41.93 | 41.79 | 41.85 | 5025900.0 |
| 2006-03-03 13:00:00 | QQQ | ETF | 41.85 | 41.92 | 41.8 | 41.91 | 3514700.0 |
| 2006-03-03 13:30:00 | QQQ | ETF | 41.92 | 42.01 | 41.9 | 41.93 | 11036800.0 |
| 2006-03-03 14:00:00 | QQQ | ETF | 41.93 | 41.97 | 41.82 | 41.83 | 7132000.0 |
| 2006-03-03 14:30:00 | QQQ | ETF | 41.82 | 41.88 | 41.77 | 41.84 | 4248700.0 |
| 2006-03-03 15:00:00 | QQQ | ETF | 41.84 | 41.86 | 41.49 | 41.57 | 10774900.0 |
| 2006-03-03 15:30:00 | QQQ | ETF | 41.58 | 41.61 | 41.43 | 41.44 | 12082800.0 |
| 2006-03-03 07:00:00 | IWM | ETF | 73.67 | 73.67 | 73.67 | 73.67 | 900.0 |
| 2006-03-03 08:00:00 | IWM | ETF | 73.54 | 73.6 | 73.54 | 73.6 | 2600.0 |
| 2006-03-03 08:30:00 | IWM | ETF | 73.57 | 73.57 | 73.28 | 73.28 | 81700.0 |
| 2006-03-03 09:00:00 | IWM | ETF | 73.28 | 73.3 | 73.0 | 73.19 | 559000.0 |
| 2006-03-03 09:30:00 | IWM | ETF | 73.21 | 73.42 | 73.15 | 73.37 | 3756300.0 |
| 2006-03-03 10:00:00 | IWM | ETF | 73.37 | 73.72 | 73.23 | 73.65 | 2946500.0 |
| 2006-03-03 10:30:00 | IWM | ETF | 73.66 | 73.72 | 73.26 | 73.34 | 3605300.0 |
| 2006-03-03 11:00:00 | IWM | ETF | 73.33 | 73.48 | 73.22 | 73.3 | 2826400.0 |
| 2006-03-03 11:30:00 | IWM | ETF | 73.29 | 73.58 | 73.18 | 73.54 | 2474400.0 |
| 2006-03-03 12:00:00 | IWM | ETF | 73.56 | 73.95 | 73.56 | 73.92 | 2565800.0 |
> showing 50 of 2,156 rows — these rows as CSV