PREVIEW / etf_30min / 2010-09-14
file: by_date/etf_30min/2010/2010-09-14.parquet size: 258 KB rows: 8,520
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-14 04:00:00 | SPY | ETF | 112.53 | 112.53 | 112.48 | 112.48 | 200.0 |
| 2010-09-14 04:30:00 | SPY | ETF | 112.43 | 112.43 | 112.4 | 112.4 | 700.0 |
| 2010-09-14 05:00:00 | SPY | ETF | 112.4 | 112.46 | 112.31 | 112.31 | 3184.0 |
| 2010-09-14 05:30:00 | SPY | ETF | 112.33 | 112.43 | 112.33 | 112.43 | 1780.0 |
| 2010-09-14 06:00:00 | SPY | ETF | 112.55 | 112.62 | 112.53 | 112.62 | 700.0 |
| 2010-09-14 06:30:00 | SPY | ETF | 112.61 | 112.61 | 112.51 | 112.53 | 21200.0 |
| 2010-09-14 07:00:00 | SPY | ETF | 112.52 | 112.53 | 112.28 | 112.35 | 216550.0 |
| 2010-09-14 07:30:00 | SPY | ETF | 112.33 | 112.46 | 112.3 | 112.44 | 235375.0 |
| 2010-09-14 08:00:00 | SPY | ETF | 112.44 | 112.72 | 112.32 | 112.64 | 2160210.0 |
| 2010-09-14 08:30:00 | SPY | ETF | 112.7 | 113.1 | 112.43 | 112.43 | 2170929.0 |
| 2010-09-14 09:00:00 | SPY | ETF | 112.43 | 112.55 | 112.38 | 112.5 | 889647.0 |
| 2010-09-14 09:30:00 | SPY | ETF | 112.5 | 112.6 | 112.08 | 112.34 | 21597687.0 |
| 2010-09-14 10:00:00 | SPY | ETF | 112.35 | 112.59 | 112.23 | 112.54 | 15770286.0 |
| 2010-09-14 10:30:00 | SPY | ETF | 112.5417 | 112.87 | 112.49 | 112.78 | 16579410.0 |
| 2010-09-14 11:00:00 | SPY | ETF | 112.78 | 113.14 | 112.75 | 112.97 | 14304858.0 |
| 2010-09-14 11:30:00 | SPY | ETF | 112.98 | 113.24 | 112.95 | 113.2 | 15746238.0 |
| 2010-09-14 12:00:00 | SPY | ETF | 113.2 | 113.29 | 113.08 | 113.19 | 7964319.0 |
| 2010-09-14 12:30:00 | SPY | ETF | 113.19 | 113.2 | 112.89 | 112.96 | 9066349.0 |
| 2010-09-14 13:00:00 | SPY | ETF | 112.95 | 113.04 | 112.75 | 112.84 | 7153665.0 |
| 2010-09-14 13:30:00 | SPY | ETF | 112.83 | 112.93 | 112.62 | 112.765 | 9311332.0 |
| 2010-09-14 14:00:00 | SPY | ETF | 112.77 | 112.89 | 112.72 | 112.79 | 7375262.0 |
| 2010-09-14 14:30:00 | SPY | ETF | 112.7831 | 113.06 | 112.73 | 112.985 | 9591629.0 |
| 2010-09-14 15:00:00 | SPY | ETF | 112.99 | 113.12 | 112.91 | 113.05 | 11274342.0 |
| 2010-09-14 15:30:00 | SPY | ETF | 113.05 | 113.22 | 112.63 | 112.65 | 33804923.0 |
| 2010-09-14 16:00:00 | SPY | ETF | 112.65 | 113.1425 | 112.325 | 112.68 | 11397747.0 |
| 2010-09-14 16:30:00 | SPY | ETF | 112.68 | 112.68 | 112.35 | 112.43 | 2021635.0 |
| 2010-09-14 17:00:00 | SPY | ETF | 112.43 | 112.48 | 112.4 | 112.48 | 71890.0 |
| 2010-09-14 17:30:00 | SPY | ETF | 112.47 | 112.53 | 112.47 | 112.49 | 58491.0 |
| 2010-09-14 18:00:00 | SPY | ETF | 112.48 | 112.5 | 112.27 | 112.31 | 345574.0 |
| 2010-09-14 18:30:00 | SPY | ETF | 112.32 | 112.39 | 112.28 | 112.38 | 99361.0 |
| 2010-09-14 19:00:00 | SPY | ETF | 112.39 | 112.42 | 112.35 | 112.37 | 19618.0 |
| 2010-09-14 19:30:00 | SPY | ETF | 112.38 | 112.42 | 112.36 | 112.39 | 31272.0 |
| 2010-09-14 04:00:00 | QQQ | ETF | 47.16 | 47.16 | 47.16 | 47.16 | 7040.0 |
| 2010-09-14 05:00:00 | QQQ | ETF | 47.14 | 47.15 | 47.14 | 47.14 | 930.0 |
| 2010-09-14 06:00:00 | QQQ | ETF | 47.19 | 47.19 | 47.18 | 47.19 | 2496.0 |
| 2010-09-14 06:30:00 | QQQ | ETF | 47.2 | 47.2 | 47.18 | 47.18 | 200.0 |
| 2010-09-14 07:00:00 | QQQ | ETF | 47.11 | 47.11 | 47.06 | 47.07 | 15155.0 |
| 2010-09-14 07:30:00 | QQQ | ETF | 47.06 | 47.11 | 47.06 | 47.11 | 11460.0 |
| 2010-09-14 08:00:00 | QQQ | ETF | 47.07 | 47.3 | 47.07 | 47.3 | 906581.0 |
| 2010-09-14 08:30:00 | QQQ | ETF | 47.27 | 47.33 | 47.1 | 47.11 | 460843.0 |
| 2010-09-14 09:00:00 | QQQ | ETF | 47.11 | 47.18 | 47.11 | 47.17 | 183459.0 |
| 2010-09-14 09:30:00 | QQQ | ETF | 47.17 | 47.28 | 47.08 | 47.22 | 6880012.0 |
| 2010-09-14 10:00:00 | QQQ | ETF | 47.23 | 47.32 | 47.15 | 47.3 | 5657385.0 |
| 2010-09-14 10:30:00 | QQQ | ETF | 47.29 | 47.47 | 47.25 | 47.42 | 7572874.0 |
| 2010-09-14 11:00:00 | QQQ | ETF | 47.42 | 47.56 | 47.41 | 47.49 | 6252644.0 |
| 2010-09-14 11:30:00 | QQQ | ETF | 47.49 | 47.65 | 47.4861 | 47.62 | 7472340.0 |
| 2010-09-14 12:00:00 | QQQ | ETF | 47.62 | 47.7 | 47.58 | 47.65 | 3762439.0 |
| 2010-09-14 12:30:00 | QQQ | ETF | 47.655 | 47.655 | 47.5 | 47.59 | 5750946.0 |
| 2010-09-14 13:00:00 | QQQ | ETF | 47.58 | 47.61 | 47.45 | 47.49 | 2843994.0 |
| 2010-09-14 13:30:00 | QQQ | ETF | 47.5 | 47.54 | 47.4 | 47.5 | 4054351.0 |
> showing 50 of 8,520 rows — these rows as CSV