PREVIEW / etf_30min / 2008-03-03
file: by_date/etf_30min/2008/2008-03-03.parquet size: 157 KB rows: 5,731
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-03-03 04:00:00 | SPY | ETF | 132.73 | 132.73 | 132.61 | 132.68 | 4200.0 |
| 2008-03-03 04:30:00 | SPY | ETF | 132.9 | 132.9 | 132.9 | 132.9 | 200.0 |
| 2008-03-03 05:00:00 | SPY | ETF | 133.04 | 133.1 | 132.92 | 132.92 | 1700.0 |
| 2008-03-03 05:30:00 | SPY | ETF | 133.04 | 133.06 | 133.0 | 133.06 | 25100.0 |
| 2008-03-03 06:00:00 | SPY | ETF | 132.98 | 132.98 | 132.51 | 132.53 | 135000.0 |
| 2008-03-03 06:30:00 | SPY | ETF | 132.74 | 132.76 | 132.68 | 132.74 | 84000.0 |
| 2008-03-03 07:00:00 | SPY | ETF | 132.71 | 132.99 | 132.63 | 132.87 | 493900.0 |
| 2008-03-03 07:30:00 | SPY | ETF | 132.87 | 133.11 | 132.82 | 133.11 | 403300.0 |
| 2008-03-03 08:00:00 | SPY | ETF | 133.11 | 133.4 | 132.3 | 133.28 | 1916400.0 |
| 2008-03-03 08:30:00 | SPY | ETF | 133.25 | 133.82 | 133.09 | 133.25 | 1476700.0 |
| 2008-03-03 09:00:00 | SPY | ETF | 133.25 | 133.3 | 133.06 | 133.14 | 3196400.0 |
| 2008-03-03 09:30:00 | SPY | ETF | 133.14 | 133.25 | 132.43 | 132.6 | 27175837.0 |
| 2008-03-03 10:00:00 | SPY | ETF | 132.6 | 133.73 | 132.5 | 133.57 | 26555902.0 |
| 2008-03-03 10:30:00 | SPY | ETF | 133.58 | 133.59 | 132.87 | 132.99 | 10911054.0 |
| 2008-03-03 11:00:00 | SPY | ETF | 132.98 | 133.21 | 132.7 | 133.06 | 11771601.0 |
| 2008-03-03 11:30:00 | SPY | ETF | 133.06 | 133.62 | 133.0 | 133.52 | 8291617.0 |
| 2008-03-03 12:00:00 | SPY | ETF | 133.52 | 133.78 | 133.2 | 133.67 | 7836422.0 |
| 2008-03-03 12:30:00 | SPY | ETF | 133.67 | 133.81 | 133.12 | 133.29 | 8603175.0 |
| 2008-03-03 13:00:00 | SPY | ETF | 133.29 | 133.5 | 133.06 | 133.3 | 7801464.0 |
| 2008-03-03 13:30:00 | SPY | ETF | 133.3 | 133.6 | 133.05 | 133.13 | 5648383.0 |
| 2008-03-03 14:00:00 | SPY | ETF | 133.13 | 133.33 | 132.65 | 132.84 | 12136560.0 |
| 2008-03-03 14:30:00 | SPY | ETF | 132.85 | 133.57 | 132.24 | 132.35 | 16639364.0 |
| 2008-03-03 15:00:00 | SPY | ETF | 132.3499 | 133.01 | 132.33 | 132.93 | 13398514.0 |
| 2008-03-03 15:30:00 | SPY | ETF | 132.92 | 133.47 | 132.83 | 133.41 | 18548904.0 |
| 2008-03-03 16:00:00 | SPY | ETF | 133.4201 | 133.62 | 133.27 | 133.45 | 4088400.0 |
| 2008-03-03 16:30:00 | SPY | ETF | 133.49 | 133.63 | 133.49 | 133.6 | 199300.0 |
| 2008-03-03 17:00:00 | SPY | ETF | 133.61 | 133.96 | 132.35 | 133.69 | 353200.0 |
| 2008-03-03 17:30:00 | SPY | ETF | 133.69 | 133.79 | 133.69 | 133.71 | 26600.0 |
| 2008-03-03 18:00:00 | SPY | ETF | 133.73 | 133.74 | 133.36 | 133.47 | 3089100.0 |
| 2008-03-03 18:30:00 | SPY | ETF | 133.41 | 133.63 | 133.41 | 133.61 | 3058300.0 |
| 2008-03-03 19:00:00 | SPY | ETF | 133.57 | 133.57 | 133.4 | 133.43 | 7000.0 |
| 2008-03-03 19:30:00 | SPY | ETF | 133.47 | 133.5 | 133.32 | 133.32 | 24000.0 |
| 2008-03-03 04:00:00 | QQQ | ETF | 42.77 | 42.77 | 42.75 | 42.75 | 300.0 |
| 2008-03-03 06:00:00 | QQQ | ETF | 42.75 | 42.75 | 42.74 | 42.74 | 10200.0 |
| 2008-03-03 06:30:00 | QQQ | ETF | 42.72 | 42.74 | 42.72 | 42.74 | 15000.0 |
| 2008-03-03 07:00:00 | QQQ | ETF | 42.75 | 42.83 | 42.73 | 42.83 | 21922.0 |
| 2008-03-03 07:30:00 | QQQ | ETF | 42.83 | 42.9 | 42.79 | 42.9 | 85300.0 |
| 2008-03-03 08:00:00 | QQQ | ETF | 42.89 | 42.97 | 42.86 | 42.95 | 598782.0 |
| 2008-03-03 08:30:00 | QQQ | ETF | 42.95 | 42.99 | 42.86 | 42.91 | 699116.0 |
| 2008-03-03 09:00:00 | QQQ | ETF | 42.91 | 42.98 | 42.86 | 42.93 | 1085918.0 |
| 2008-03-03 09:30:00 | QQQ | ETF | 42.94 | 42.98 | 42.63 | 42.73 | 15325564.0 |
| 2008-03-03 10:00:00 | QQQ | ETF | 42.72 | 42.99 | 42.69 | 42.94 | 15012266.0 |
| 2008-03-03 10:30:00 | QQQ | ETF | 42.94 | 42.94 | 42.62 | 42.67 | 9677682.0 |
| 2008-03-03 11:00:00 | QQQ | ETF | 42.67 | 42.74 | 42.5 | 42.63 | 7806780.0 |
| 2008-03-03 11:30:00 | QQQ | ETF | 42.63 | 42.87 | 42.63 | 42.8499 | 6785601.0 |
| 2008-03-03 12:00:00 | QQQ | ETF | 42.85 | 42.9 | 42.71 | 42.87 | 3196348.0 |
| 2008-03-03 12:30:00 | QQQ | ETF | 42.87 | 42.93 | 42.69 | 42.73 | 10424796.0 |
| 2008-03-03 13:00:00 | QQQ | ETF | 42.73 | 42.81 | 42.65 | 42.72 | 3855169.0 |
| 2008-03-03 13:30:00 | QQQ | ETF | 42.72 | 42.82 | 42.61 | 42.67 | 9592234.0 |
| 2008-03-03 14:00:00 | QQQ | ETF | 42.67 | 42.67 | 42.48 | 42.53 | 8350689.0 |
> showing 50 of 5,731 rows — these rows as CSV