PREVIEW / etf_30min / 2011-02-11
file: by_date/etf_30min/2011/2011-02-11.parquet size: 280 KB rows: 9,184
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-11 04:00:00 | SPY | ETF | 131.87 | 131.87 | 131.84 | 131.84 | 300.0 |
| 2011-02-11 04:30:00 | SPY | ETF | 131.76 | 131.76 | 131.6 | 131.6 | 500.0 |
| 2011-02-11 05:00:00 | SPY | ETF | 131.56 | 131.56 | 131.46 | 131.49 | 45600.0 |
| 2011-02-11 05:30:00 | SPY | ETF | 131.58 | 131.64 | 131.58 | 131.6 | 17700.0 |
| 2011-02-11 06:00:00 | SPY | ETF | 131.57 | 131.78 | 131.57 | 131.77 | 50200.0 |
| 2011-02-11 06:30:00 | SPY | ETF | 131.7 | 132.09 | 131.66 | 131.68 | 96544.0 |
| 2011-02-11 07:00:00 | SPY | ETF | 131.66 | 131.8 | 131.66 | 131.72 | 80074.0 |
| 2011-02-11 07:30:00 | SPY | ETF | 131.77 | 131.97 | 131.73 | 131.93 | 318510.0 |
| 2011-02-11 08:00:00 | SPY | ETF | 131.91 | 131.98 | 131.69 | 131.9 | 630209.0 |
| 2011-02-11 08:30:00 | SPY | ETF | 131.91 | 131.98 | 131.86 | 131.94 | 581637.0 |
| 2011-02-11 09:00:00 | SPY | ETF | 131.94 | 131.95 | 131.78 | 131.81 | 1396293.0 |
| 2011-02-11 09:30:00 | SPY | ETF | 131.8 | 132.14 | 131.77 | 132.11 | 13545896.0 |
| 2011-02-11 10:00:00 | SPY | ETF | 132.12 | 132.31 | 132.06 | 132.29 | 8997700.0 |
| 2011-02-11 10:30:00 | SPY | ETF | 132.3 | 132.79 | 132.28 | 132.76 | 11144622.0 |
| 2011-02-11 11:00:00 | SPY | ETF | 132.76 | 133.12 | 132.67 | 132.885 | 19504262.0 |
| 2011-02-11 11:30:00 | SPY | ETF | 132.88 | 132.91 | 132.7 | 132.78 | 7148108.0 |
| 2011-02-11 12:00:00 | SPY | ETF | 132.78 | 132.83 | 132.48 | 132.57 | 8512451.0 |
| 2011-02-11 12:30:00 | SPY | ETF | 132.58 | 132.84 | 132.56 | 132.79 | 7572266.0 |
| 2011-02-11 13:00:00 | SPY | ETF | 132.8 | 132.94 | 132.76 | 132.83 | 4132192.0 |
| 2011-02-11 13:30:00 | SPY | ETF | 132.8374 | 132.92 | 132.8 | 132.91 | 4572172.0 |
| 2011-02-11 14:00:00 | SPY | ETF | 132.9068 | 133.06 | 132.9 | 133.05 | 5681301.0 |
| 2011-02-11 14:30:00 | SPY | ETF | 133.05 | 133.27 | 133.04 | 133.14 | 8898533.0 |
| 2011-02-11 15:00:00 | SPY | ETF | 133.15 | 133.28 | 133.13 | 133.18 | 5507065.0 |
| 2011-02-11 15:30:00 | SPY | ETF | 133.18 | 133.22 | 133.01 | 133.11 | 17508148.0 |
| 2011-02-11 16:00:00 | SPY | ETF | 133.12 | 133.22 | 132.05 | 133.19 | 9689955.0 |
| 2011-02-11 16:30:00 | SPY | ETF | 133.17 | 133.32 | 132.37 | 133.26 | 1159983.0 |
| 2011-02-11 17:00:00 | SPY | ETF | 133.24 | 133.28 | 133.2 | 133.25 | 163663.0 |
| 2011-02-11 17:30:00 | SPY | ETF | 133.25 | 133.25 | 133.2 | 133.21 | 12612.0 |
| 2011-02-11 18:00:00 | SPY | ETF | 133.23 | 133.23 | 133.15 | 133.2 | 10444.0 |
| 2011-02-11 18:30:00 | SPY | ETF | 133.21 | 133.23 | 133.2 | 133.22 | 11242.0 |
| 2011-02-11 19:00:00 | SPY | ETF | 133.22 | 133.24 | 133.18 | 133.23 | 16528.0 |
| 2011-02-11 19:30:00 | SPY | ETF | 133.22 | 133.27 | 133.21 | 133.24 | 13036.0 |
| 2011-02-11 05:00:00 | QQQ | ETF | 57.73 | 57.77 | 57.73 | 57.77 | 50100.0 |
| 2011-02-11 06:00:00 | QQQ | ETF | 57.78 | 57.78 | 57.76 | 57.77 | 26000.0 |
| 2011-02-11 07:00:00 | QQQ | ETF | 57.81 | 57.85 | 57.78 | 57.83 | 42832.0 |
| 2011-02-11 07:30:00 | QQQ | ETF | 57.82 | 57.91 | 57.82 | 57.9 | 425884.0 |
| 2011-02-11 08:00:00 | QQQ | ETF | 57.9 | 57.95 | 57.87 | 57.91 | 514038.0 |
| 2011-02-11 08:30:00 | QQQ | ETF | 57.91 | 57.96 | 57.88 | 57.92 | 138920.0 |
| 2011-02-11 09:00:00 | QQQ | ETF | 57.92 | 57.92 | 57.85 | 57.86 | 257148.0 |
| 2011-02-11 09:30:00 | QQQ | ETF | 57.87 | 58.01 | 57.77 | 58.0 | 5456119.0 |
| 2011-02-11 10:00:00 | QQQ | ETF | 58.0 | 58.07 | 57.9 | 58.0 | 3307713.0 |
| 2011-02-11 10:30:00 | QQQ | ETF | 58.0 | 58.19 | 57.991 | 58.18 | 3793428.0 |
| 2011-02-11 11:00:00 | QQQ | ETF | 58.18 | 58.3 | 58.12 | 58.19 | 6315889.0 |
| 2011-02-11 11:30:00 | QQQ | ETF | 58.19 | 58.26 | 58.14 | 58.22 | 1568966.0 |
| 2011-02-11 12:00:00 | QQQ | ETF | 58.23 | 58.29 | 58.14 | 58.19 | 2611578.0 |
| 2011-02-11 12:30:00 | QQQ | ETF | 58.1938 | 58.31 | 58.19 | 58.289 | 1477715.0 |
| 2011-02-11 13:00:00 | QQQ | ETF | 58.29 | 58.37 | 58.27 | 58.301 | 1564237.0 |
| 2011-02-11 13:30:00 | QQQ | ETF | 58.3099 | 58.37 | 58.29 | 58.36 | 1775354.0 |
| 2011-02-11 14:00:00 | QQQ | ETF | 58.355 | 58.41 | 58.34 | 58.4 | 1749847.0 |
| 2011-02-11 14:30:00 | QQQ | ETF | 58.41 | 58.48 | 58.39 | 58.42 | 2053327.0 |
> showing 50 of 9,184 rows — these rows as CSV