PREVIEW / etf_30min / 2010-02-11
file: by_date/etf_30min/2010/2010-02-11.parquet size: 245 KB rows: 8,113
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-02-11 04:00:00 | SPY | ETF | 107.48 | 107.49 | 107.37 | 107.37 | 1500.0 |
| 2010-02-11 04:30:00 | SPY | ETF | 107.3 | 107.34 | 107.22 | 107.34 | 4300.0 |
| 2010-02-11 05:00:00 | SPY | ETF | 107.35 | 107.36 | 107.35 | 107.36 | 200.0 |
| 2010-02-11 06:00:00 | SPY | ETF | 107.15 | 107.15 | 106.85 | 106.93 | 19350.0 |
| 2010-02-11 06:30:00 | SPY | ETF | 106.93 | 107.49 | 106.82 | 107.24 | 112660.0 |
| 2010-02-11 07:00:00 | SPY | ETF | 107.34 | 107.4 | 106.94 | 107.17 | 348022.0 |
| 2010-02-11 07:30:00 | SPY | ETF | 107.08 | 107.29 | 107.06 | 107.25 | 383647.0 |
| 2010-02-11 08:00:00 | SPY | ETF | 107.23 | 107.37 | 106.95 | 107.13 | 2387959.0 |
| 2010-02-11 08:30:00 | SPY | ETF | 107.2 | 107.47 | 107.01 | 107.07 | 3614497.0 |
| 2010-02-11 09:00:00 | SPY | ETF | 107.06 | 107.06 | 106.5 | 106.86 | 5272083.0 |
| 2010-02-11 09:30:00 | SPY | ETF | 106.87 | 106.91 | 106.25 | 106.71 | 23844172.0 |
| 2010-02-11 10:00:00 | SPY | ETF | 106.71 | 107.17 | 106.46 | 107.01 | 17512174.0 |
| 2010-02-11 10:30:00 | SPY | ETF | 107.01 | 107.02 | 106.54 | 106.64 | 16935746.0 |
| 2010-02-11 11:00:00 | SPY | ETF | 106.64 | 107.48 | 106.62 | 107.44 | 21562974.0 |
| 2010-02-11 11:30:00 | SPY | ETF | 107.45 | 107.96 | 107.32 | 107.78 | 18697052.0 |
| 2010-02-11 12:00:00 | SPY | ETF | 107.78 | 108.02 | 107.73 | 107.78 | 11099433.0 |
| 2010-02-11 12:30:00 | SPY | ETF | 107.78 | 107.9 | 107.71 | 107.81 | 7704168.0 |
| 2010-02-11 13:00:00 | SPY | ETF | 107.81 | 108.16 | 107.7 | 108.06 | 16766976.0 |
| 2010-02-11 13:30:00 | SPY | ETF | 108.06 | 108.25 | 107.86 | 107.9905 | 13025414.0 |
| 2010-02-11 14:00:00 | SPY | ETF | 107.99 | 108.24 | 107.94 | 108.21 | 6765037.0 |
| 2010-02-11 14:30:00 | SPY | ETF | 108.21 | 108.25 | 107.91 | 108.05 | 10974122.0 |
| 2010-02-11 15:00:00 | SPY | ETF | 108.06 | 108.18 | 107.95 | 107.955 | 7806287.0 |
| 2010-02-11 15:30:00 | SPY | ETF | 107.96 | 108.15 | 107.82 | 108.09 | 19921077.0 |
| 2010-02-11 16:00:00 | SPY | ETF | 108.1 | 108.18 | 106.75 | 108.12 | 9001135.0 |
| 2010-02-11 16:30:00 | SPY | ETF | 108.12 | 108.37 | 108.12 | 108.31 | 2288030.0 |
| 2010-02-11 17:00:00 | SPY | ETF | 108.31 | 108.43 | 107.0472 | 108.27 | 1244471.0 |
| 2010-02-11 17:30:00 | SPY | ETF | 108.28 | 108.34 | 108.23 | 108.27 | 22670.0 |
| 2010-02-11 18:00:00 | SPY | ETF | 108.27 | 108.29 | 108.19 | 108.19 | 33562.0 |
| 2010-02-11 18:30:00 | SPY | ETF | 108.18 | 108.19 | 108.14 | 108.17 | 52490.0 |
| 2010-02-11 19:00:00 | SPY | ETF | 108.18 | 108.23 | 108.18 | 108.18 | 18950.0 |
| 2010-02-11 19:30:00 | SPY | ETF | 108.19 | 108.2 | 108.06 | 108.09 | 138118.0 |
| 2010-02-11 06:30:00 | QQQ | ETF | 43.2 | 43.2 | 43.07 | 43.12 | 128356.0 |
| 2010-02-11 07:00:00 | QQQ | ETF | 43.12 | 43.19 | 43.04 | 43.08 | 259369.0 |
| 2010-02-11 07:30:00 | QQQ | ETF | 43.09 | 43.17 | 43.09 | 43.16 | 175604.0 |
| 2010-02-11 08:00:00 | QQQ | ETF | 43.13 | 43.14 | 43.04 | 43.12 | 174400.0 |
| 2010-02-11 08:30:00 | QQQ | ETF | 43.13 | 43.23 | 43.09 | 43.12 | 738658.0 |
| 2010-02-11 09:00:00 | QQQ | ETF | 43.11 | 43.11 | 42.88 | 43.0 | 863930.0 |
| 2010-02-11 09:30:00 | QQQ | ETF | 43.01 | 43.03 | 42.76 | 42.87 | 7731110.0 |
| 2010-02-11 10:00:00 | QQQ | ETF | 42.8701 | 43.09 | 42.77 | 43.05 | 5863110.0 |
| 2010-02-11 10:30:00 | QQQ | ETF | 43.031 | 43.06 | 42.885 | 42.91 | 6280361.0 |
| 2010-02-11 11:00:00 | QQQ | ETF | 42.91 | 43.43 | 42.91 | 43.4101 | 10476091.0 |
| 2010-02-11 11:30:00 | QQQ | ETF | 43.42 | 43.63 | 43.36 | 43.5901 | 8583526.0 |
| 2010-02-11 12:00:00 | QQQ | ETF | 43.6 | 43.75 | 43.5776 | 43.68 | 5273396.0 |
| 2010-02-11 12:30:00 | QQQ | ETF | 43.6731 | 43.69 | 43.6 | 43.65 | 5199147.0 |
| 2010-02-11 13:00:00 | QQQ | ETF | 43.65 | 43.76 | 43.59 | 43.72 | 2625301.0 |
| 2010-02-11 13:30:00 | QQQ | ETF | 43.73 | 43.78 | 43.67 | 43.72 | 3233987.0 |
| 2010-02-11 14:00:00 | QQQ | ETF | 43.7199 | 43.79 | 43.69 | 43.77 | 3786867.0 |
| 2010-02-11 14:30:00 | QQQ | ETF | 43.77 | 43.79 | 43.63 | 43.6975 | 4615151.0 |
| 2010-02-11 15:00:00 | QQQ | ETF | 43.7 | 43.75 | 43.66 | 43.67 | 2801577.0 |
| 2010-02-11 15:30:00 | QQQ | ETF | 43.67 | 43.71 | 43.59 | 43.66 | 7406355.0 |
> showing 50 of 8,113 rows — these rows as CSV