PREVIEW / etf_30min / 2008-06-11
file: by_date/etf_30min/2008/2008-06-11.parquet size: 169 KB rows: 5,885
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-11 04:00:00 | SPY | ETF | 136.33 | 136.66 | 136.33 | 136.66 | 200.0 |
| 2008-06-11 05:30:00 | SPY | ETF | 136.34 | 136.34 | 136.34 | 136.34 | 300.0 |
| 2008-06-11 06:00:00 | SPY | ETF | 136.42 | 136.54 | 136.4 | 136.49 | 76900.0 |
| 2008-06-11 06:30:00 | SPY | ETF | 136.31 | 136.47 | 136.31 | 136.38 | 14000.0 |
| 2008-06-11 07:00:00 | SPY | ETF | 136.49 | 136.62 | 136.42 | 136.54 | 232150.0 |
| 2008-06-11 07:30:00 | SPY | ETF | 136.53 | 136.6 | 136.48 | 136.54 | 187181.0 |
| 2008-06-11 08:00:00 | SPY | ETF | 136.54 | 136.57 | 136.37 | 136.37 | 431988.0 |
| 2008-06-11 08:30:00 | SPY | ETF | 136.36 | 136.39 | 136.19 | 136.28 | 906321.0 |
| 2008-06-11 09:00:00 | SPY | ETF | 136.27 | 136.28 | 135.95 | 135.97 | 1367041.0 |
| 2008-06-11 09:30:00 | SPY | ETF | 135.97 | 136.085 | 135.51 | 135.53 | 16180148.0 |
| 2008-06-11 10:00:00 | SPY | ETF | 135.53 | 135.54 | 134.44 | 134.53 | 38977594.0 |
| 2008-06-11 10:30:00 | SPY | ETF | 134.53 | 135.27 | 134.45 | 135.19 | 32113285.0 |
| 2008-06-11 11:00:00 | SPY | ETF | 135.19 | 135.24 | 134.48 | 134.58 | 18389460.0 |
| 2008-06-11 11:30:00 | SPY | ETF | 134.57 | 136.2592 | 134.45 | 134.98 | 20867887.0 |
| 2008-06-11 12:00:00 | SPY | ETF | 134.98 | 135.11 | 134.59 | 134.64 | 13593784.0 |
| 2008-06-11 12:30:00 | SPY | ETF | 134.63 | 136.2591 | 134.31 | 134.67 | 19573651.0 |
| 2008-06-11 13:00:00 | SPY | ETF | 134.65 | 136.2592 | 134.56 | 134.81 | 10919278.0 |
| 2008-06-11 13:30:00 | SPY | ETF | 134.81 | 134.84 | 134.45 | 134.74 | 16020512.0 |
| 2008-06-11 14:00:00 | SPY | ETF | 134.7395 | 135.15 | 134.48 | 134.9 | 19764333.0 |
| 2008-06-11 14:30:00 | SPY | ETF | 134.9 | 134.96 | 134.55 | 134.56 | 9465838.0 |
| 2008-06-11 15:00:00 | SPY | ETF | 134.56 | 134.9 | 134.33 | 134.62 | 15022174.0 |
| 2008-06-11 15:30:00 | SPY | ETF | 134.63 | 134.71 | 133.93 | 133.96 | 29119709.0 |
| 2008-06-11 16:00:00 | SPY | ETF | 134.01 | 136.2591 | 133.87 | 136.2591 | 6372509.0 |
| 2008-06-11 16:30:00 | SPY | ETF | 133.94 | 136.26 | 133.93 | 133.94 | 7504602.0 |
| 2008-06-11 17:00:00 | SPY | ETF | 133.94 | 134.12 | 133.91 | 133.91 | 2325771.0 |
| 2008-06-11 17:30:00 | SPY | ETF | 133.95 | 134.09 | 133.92 | 133.93 | 81322.0 |
| 2008-06-11 18:00:00 | SPY | ETF | 133.9 | 133.99 | 133.85 | 133.98 | 12850.0 |
| 2008-06-11 18:30:00 | SPY | ETF | 133.99 | 134.09 | 133.99 | 134.09 | 29300.0 |
| 2008-06-11 19:00:00 | SPY | ETF | 134.09 | 134.18 | 134.07 | 134.09 | 15589.0 |
| 2008-06-11 19:30:00 | SPY | ETF | 134.09 | 134.16 | 134.08 | 134.15 | 5400.0 |
| 2008-06-11 06:30:00 | QQQ | ETF | 48.66 | 48.66 | 48.66 | 48.66 | 500.0 |
| 2008-06-11 07:00:00 | QQQ | ETF | 48.67 | 48.74 | 48.67 | 48.74 | 76300.0 |
| 2008-06-11 07:30:00 | QQQ | ETF | 48.72 | 48.77 | 48.72 | 48.74 | 12000.0 |
| 2008-06-11 08:00:00 | QQQ | ETF | 48.74 | 48.75 | 48.62 | 48.63 | 160548.0 |
| 2008-06-11 08:30:00 | QQQ | ETF | 48.62 | 48.64 | 48.55 | 48.61 | 386059.0 |
| 2008-06-11 09:00:00 | QQQ | ETF | 48.61 | 48.62 | 48.44 | 48.45 | 543635.0 |
| 2008-06-11 09:30:00 | QQQ | ETF | 48.45 | 48.52 | 48.19 | 48.2 | 10901146.0 |
| 2008-06-11 10:00:00 | QQQ | ETF | 48.19 | 48.2 | 47.71 | 47.73 | 19792369.0 |
| 2008-06-11 10:30:00 | QQQ | ETF | 47.73 | 48.13 | 47.71 | 48.13 | 21318510.0 |
| 2008-06-11 11:00:00 | QQQ | ETF | 48.12 | 48.14 | 47.78 | 47.8 | 11953000.0 |
| 2008-06-11 11:30:00 | QQQ | ETF | 47.8 | 47.98 | 47.73 | 47.94 | 12540079.0 |
| 2008-06-11 12:00:00 | QQQ | ETF | 47.94 | 47.96 | 47.75 | 47.77 | 5556608.0 |
| 2008-06-11 12:30:00 | QQQ | ETF | 47.77 | 47.84 | 47.6 | 47.65 | 9928612.0 |
| 2008-06-11 13:00:00 | QQQ | ETF | 47.65 | 47.78 | 47.625 | 47.74 | 6141451.0 |
| 2008-06-11 13:30:00 | QQQ | ETF | 47.74 | 47.74 | 47.6 | 47.68 | 7458718.0 |
| 2008-06-11 14:00:00 | QQQ | ETF | 47.68 | 47.9 | 47.59 | 47.8 | 11568485.0 |
| 2008-06-11 14:30:00 | QQQ | ETF | 47.79 | 47.82 | 47.66 | 47.66 | 5657828.0 |
| 2008-06-11 15:00:00 | QQQ | ETF | 47.66 | 48.1058 | 47.48 | 47.57 | 9301150.0 |
| 2008-06-11 15:30:00 | QQQ | ETF | 47.56 | 47.58 | 47.35 | 47.37 | 19454362.0 |
| 2008-06-11 16:00:00 | QQQ | ETF | 47.37 | 47.7883 | 47.3335 | 47.37 | 4596908.0 |
> showing 50 of 5,885 rows — these rows as CSV