PREVIEW / etf_30min / 2004-09-27
file: by_date/etf_30min/2004/2004-09-27.parquet size: 34 KB rows: 1,154
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-09-27 08:00:00 | SPY | ETF | 111.05 | 111.2 | 111.05 | 111.1 | 28400.0 |
| 2004-09-27 08:30:00 | SPY | ETF | 111.11 | 111.13 | 111.06 | 111.08 | 93400.0 |
| 2004-09-27 09:00:00 | SPY | ETF | 111.11 | 111.12 | 111.02 | 111.1 | 106700.0 |
| 2004-09-27 09:30:00 | SPY | ETF | 111.1 | 111.15 | 110.84 | 110.88 | 5193100.0 |
| 2004-09-27 10:00:00 | SPY | ETF | 110.87 | 110.97 | 110.75 | 110.86 | 2996300.0 |
| 2004-09-27 10:30:00 | SPY | ETF | 110.86 | 110.91 | 110.71 | 110.78 | 2676300.0 |
| 2004-09-27 11:00:00 | SPY | ETF | 110.77 | 110.95 | 110.73 | 110.87 | 1817000.0 |
| 2004-09-27 11:30:00 | SPY | ETF | 110.87 | 110.94 | 110.72 | 110.78 | 2251000.0 |
| 2004-09-27 12:00:00 | SPY | ETF | 110.8 | 111.08 | 110.77 | 110.96 | 1862100.0 |
| 2004-09-27 12:30:00 | SPY | ETF | 110.97 | 111.2 | 110.86 | 111.15 | 2281800.0 |
| 2004-09-27 13:00:00 | SPY | ETF | 111.15 | 111.16 | 110.98 | 111.09 | 2423600.0 |
| 2004-09-27 13:30:00 | SPY | ETF | 111.08 | 111.14 | 110.98 | 111.08 | 1141700.0 |
| 2004-09-27 14:00:00 | SPY | ETF | 111.09 | 111.11 | 110.67 | 110.77 | 2471400.0 |
| 2004-09-27 14:30:00 | SPY | ETF | 110.78 | 110.92 | 110.72 | 110.9 | 2304000.0 |
| 2004-09-27 15:00:00 | SPY | ETF | 110.9 | 111.03 | 110.85 | 110.87 | 3590000.0 |
| 2004-09-27 15:30:00 | SPY | ETF | 110.88 | 110.9 | 110.58 | 110.67 | 5015400.0 |
| 2004-09-27 16:00:00 | SPY | ETF | 110.68 | 110.895 | 110.63 | 110.78 | 1293900.0 |
| 2004-09-27 16:30:00 | SPY | ETF | 110.74 | 110.84 | 110.74 | 110.8 | 78200.0 |
| 2004-09-27 17:00:00 | SPY | ETF | 110.82 | 110.82 | 110.75 | 110.76 | 286200.0 |
| 2004-09-27 17:30:00 | SPY | ETF | 110.73 | 110.74 | 110.68 | 110.7 | 43400.0 |
| 2004-09-27 18:00:00 | SPY | ETF | 110.7 | 110.75 | 110.7 | 110.75 | 163500.0 |
| 2004-09-27 18:30:00 | SPY | ETF | 110.74 | 110.74 | 110.74 | 110.74 | 3300.0 |
| 2004-09-27 19:00:00 | SPY | ETF | 110.74 | 110.74 | 110.74 | 110.74 | 5700.0 |
| 2004-09-27 19:30:00 | SPY | ETF | 110.74 | 110.76 | 110.74 | 110.74 | 800.0 |
| 2004-09-27 08:00:00 | QQQ | ETF | 34.65 | 34.71 | 34.65 | 34.66 | 23400.0 |
| 2004-09-27 08:30:00 | QQQ | ETF | 34.66 | 34.67 | 34.63 | 34.64 | 58600.0 |
| 2004-09-27 09:00:00 | QQQ | ETF | 34.65 | 34.67 | 34.58 | 34.61 | 330700.0 |
| 2004-09-27 09:30:00 | QQQ | ETF | 34.62 | 34.62 | 34.48 | 34.53 | 15593100.0 |
| 2004-09-27 10:00:00 | QQQ | ETF | 34.53 | 34.66 | 34.49 | 34.614 | 11429300.0 |
| 2004-09-27 10:30:00 | QQQ | ETF | 34.611 | 34.7 | 34.56 | 34.61 | 6592800.0 |
| 2004-09-27 11:00:00 | QQQ | ETF | 34.61 | 34.71 | 34.58 | 34.67 | 4041500.0 |
| 2004-09-27 11:30:00 | QQQ | ETF | 34.67 | 34.67 | 34.53 | 34.559 | 4299600.0 |
| 2004-09-27 12:00:00 | QQQ | ETF | 34.56 | 34.68 | 34.54 | 34.61 | 3783400.0 |
| 2004-09-27 12:30:00 | QQQ | ETF | 34.609 | 34.739 | 34.59 | 34.69 | 5403700.0 |
| 2004-09-27 13:00:00 | QQQ | ETF | 34.69 | 34.69 | 34.6 | 34.64 | 2782100.0 |
| 2004-09-27 13:30:00 | QQQ | ETF | 34.64 | 34.65 | 34.58 | 34.627 | 3150600.0 |
| 2004-09-27 14:00:00 | QQQ | ETF | 34.62 | 34.67 | 34.48 | 34.52 | 5214200.0 |
| 2004-09-27 14:30:00 | QQQ | ETF | 34.52 | 34.59 | 34.49 | 34.58 | 5614000.0 |
| 2004-09-27 15:00:00 | QQQ | ETF | 34.58 | 34.64 | 34.53 | 34.55 | 4477800.0 |
| 2004-09-27 15:30:00 | QQQ | ETF | 34.54 | 34.57 | 34.38 | 34.44 | 8778400.0 |
| 2004-09-27 16:00:00 | QQQ | ETF | 34.44 | 34.549 | 34.41 | 34.52 | 2640800.0 |
| 2004-09-27 16:30:00 | QQQ | ETF | 34.52 | 34.53 | 34.51 | 34.53 | 49400.0 |
| 2004-09-27 17:00:00 | QQQ | ETF | 34.522 | 34.534 | 34.49 | 34.5 | 80600.0 |
| 2004-09-27 17:30:00 | QQQ | ETF | 34.51 | 34.53 | 34.5 | 34.51 | 12300.0 |
| 2004-09-27 18:00:00 | QQQ | ETF | 34.51 | 34.53 | 34.5 | 34.52 | 17400.0 |
| 2004-09-27 18:30:00 | QQQ | ETF | 34.52 | 34.52 | 34.52 | 34.52 | 200.0 |
| 2004-09-27 19:00:00 | QQQ | ETF | 34.52 | 34.52 | 34.52 | 34.52 | 1100.0 |
| 2004-09-27 19:30:00 | QQQ | ETF | 34.51 | 34.51 | 34.51 | 34.51 | 3000.0 |
| 2004-09-27 08:30:00 | IWM | ETF | 56.105 | 56.105 | 56.105 | 56.105 | 4000.0 |
| 2004-09-27 09:00:00 | IWM | ETF | 56.125 | 56.125 | 56.11 | 56.11 | 8400.0 |
> showing 50 of 1,154 rows — these rows as CSV