PREVIEW / etf_30min / 2008-06-13
file: by_date/etf_30min/2008/2008-06-13.parquet size: 164 KB rows: 5,613
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-06-13 04:00:00 | SPY | ETF | 134.21 | 134.21 | 134.21 | 134.21 | 500.0 |
| 2008-06-13 05:00:00 | SPY | ETF | 134.33 | 134.33 | 134.33 | 134.33 | 100.0 |
| 2008-06-13 06:00:00 | SPY | ETF | 134.55 | 134.66 | 134.46 | 134.66 | 8300.0 |
| 2008-06-13 06:30:00 | SPY | ETF | 134.71 | 134.76 | 134.61 | 134.7 | 14200.0 |
| 2008-06-13 07:00:00 | SPY | ETF | 134.75 | 134.76 | 134.5 | 134.57 | 204300.0 |
| 2008-06-13 07:30:00 | SPY | ETF | 134.51 | 134.67 | 134.37 | 134.66 | 371109.0 |
| 2008-06-13 08:00:00 | SPY | ETF | 134.46 | 134.96 | 134.1 | 134.51 | 4321755.0 |
| 2008-06-13 08:30:00 | SPY | ETF | 134.7 | 135.47 | 134.35 | 135.21 | 10943883.0 |
| 2008-06-13 09:00:00 | SPY | ETF | 135.22 | 135.39 | 135.15 | 135.17 | 2865906.0 |
| 2008-06-13 09:30:00 | SPY | ETF | 135.17 | 135.37 | 134.61 | 135.25 | 34928503.0 |
| 2008-06-13 10:00:00 | SPY | ETF | 135.25 | 136.35 | 135.15 | 136.07 | 35459025.0 |
| 2008-06-13 10:30:00 | SPY | ETF | 136.07 | 136.13 | 135.54 | 135.77 | 16831052.0 |
| 2008-06-13 11:00:00 | SPY | ETF | 135.77 | 136.13 | 135.7 | 136.09 | 13343305.0 |
| 2008-06-13 11:30:00 | SPY | ETF | 136.08 | 136.1202 | 135.77 | 135.78 | 8509896.0 |
| 2008-06-13 12:00:00 | SPY | ETF | 135.77 | 135.93 | 135.72 | 135.76 | 6641201.0 |
| 2008-06-13 12:30:00 | SPY | ETF | 135.76 | 135.93 | 135.35 | 135.41 | 13068319.0 |
| 2008-06-13 13:00:00 | SPY | ETF | 135.41 | 135.51 | 135.06 | 135.33 | 14220775.0 |
| 2008-06-13 13:30:00 | SPY | ETF | 135.34 | 135.42 | 134.87 | 135.12 | 12093112.0 |
| 2008-06-13 14:00:00 | SPY | ETF | 135.13 | 135.49 | 134.9 | 135.24 | 14456557.0 |
| 2008-06-13 14:30:00 | SPY | ETF | 135.27 | 135.725 | 135.23 | 135.69 | 10507932.0 |
| 2008-06-13 15:00:00 | SPY | ETF | 135.7 | 135.87 | 135.51 | 135.55 | 10835861.0 |
| 2008-06-13 15:30:00 | SPY | ETF | 135.55 | 136.42 | 135.33 | 136.4 | 24741180.0 |
| 2008-06-13 16:00:00 | SPY | ETF | 136.4101 | 136.52 | 135.1 | 136.08 | 5670372.0 |
| 2008-06-13 16:30:00 | SPY | ETF | 136.08 | 136.15 | 136.04 | 136.05 | 164619.0 |
| 2008-06-13 17:00:00 | SPY | ETF | 136.05 | 136.09 | 135.95 | 135.95 | 108450.0 |
| 2008-06-13 17:30:00 | SPY | ETF | 135.96 | 136.0 | 135.92 | 135.99 | 4883.0 |
| 2008-06-13 18:00:00 | SPY | ETF | 135.98 | 136.14 | 135.98 | 136.0 | 26821.0 |
| 2008-06-13 18:30:00 | SPY | ETF | 136.08 | 136.1 | 136.0 | 136.1 | 4917.0 |
| 2008-06-13 19:00:00 | SPY | ETF | 136.05 | 136.08 | 136.05 | 136.08 | 4200.0 |
| 2008-06-13 19:30:00 | SPY | ETF | 136.08 | 136.09 | 136.02 | 136.02 | 3739.0 |
| 2008-06-13 05:30:00 | QQQ | ETF | 47.27 | 47.27 | 47.27 | 47.27 | 300.0 |
| 2008-06-13 06:00:00 | QQQ | ETF | 47.33 | 47.39 | 47.33 | 47.39 | 6000.0 |
| 2008-06-13 06:30:00 | QQQ | ETF | 47.37 | 47.42 | 47.37 | 47.42 | 6000.0 |
| 2008-06-13 07:00:00 | QQQ | ETF | 47.43 | 47.44 | 47.36 | 47.36 | 22300.0 |
| 2008-06-13 07:30:00 | QQQ | ETF | 47.34 | 47.4 | 47.3 | 47.4 | 129548.0 |
| 2008-06-13 08:00:00 | QQQ | ETF | 47.4 | 47.55 | 47.32 | 47.44 | 2263539.0 |
| 2008-06-13 08:30:00 | QQQ | ETF | 47.43 | 47.87 | 47.34 | 47.8 | 5429719.0 |
| 2008-06-13 09:00:00 | QQQ | ETF | 47.8 | 47.8591 | 47.7 | 47.71 | 1702023.0 |
| 2008-06-13 09:30:00 | QQQ | ETF | 47.7 | 47.86 | 47.46 | 47.841 | 24583368.0 |
| 2008-06-13 10:00:00 | QQQ | ETF | 47.84 | 48.47 | 47.81 | 48.35 | 28447768.0 |
| 2008-06-13 10:30:00 | QQQ | ETF | 48.35 | 48.37 | 48.1 | 48.2 | 14493540.0 |
| 2008-06-13 11:00:00 | QQQ | ETF | 48.2 | 48.34 | 48.19 | 48.32 | 6933227.0 |
| 2008-06-13 11:30:00 | QQQ | ETF | 48.33 | 48.33 | 48.2 | 48.24 | 4726614.0 |
| 2008-06-13 12:00:00 | QQQ | ETF | 48.24 | 48.3001 | 48.215 | 48.23 | 2838647.0 |
| 2008-06-13 12:30:00 | QQQ | ETF | 48.24 | 48.26 | 48.01 | 48.11 | 8331567.0 |
| 2008-06-13 13:00:00 | QQQ | ETF | 48.11 | 48.14 | 47.91 | 48.02 | 8905750.0 |
| 2008-06-13 13:30:00 | QQQ | ETF | 48.03 | 48.05 | 47.8 | 47.9 | 7106774.0 |
| 2008-06-13 14:00:00 | QQQ | ETF | 47.9 | 48.04 | 47.79 | 47.95 | 8014790.0 |
| 2008-06-13 14:30:00 | QQQ | ETF | 47.95 | 48.17 | 47.94 | 48.15 | 7769497.0 |
| 2008-06-13 15:00:00 | QQQ | ETF | 48.151 | 48.16 | 47.98 | 48.0 | 5948463.0 |
> showing 50 of 5,613 rows — these rows as CSV