PREVIEW / etf_30min / 2010-12-16
file: by_date/etf_30min/2010/2010-12-16.parquet size: 267 KB rows: 8,924
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-12-16 04:00:00 | SPY | ETF | 124.39 | 124.47 | 124.39 | 124.47 | 1100.0 |
| 2010-12-16 04:30:00 | SPY | ETF | 124.34 | 124.34 | 124.34 | 124.34 | 150.0 |
| 2010-12-16 05:30:00 | SPY | ETF | 124.28 | 124.28 | 124.18 | 124.18 | 700.0 |
| 2010-12-16 06:00:00 | SPY | ETF | 124.14 | 124.15 | 124.14 | 124.15 | 800.0 |
| 2010-12-16 06:30:00 | SPY | ETF | 124.28 | 124.39 | 124.28 | 124.39 | 24300.0 |
| 2010-12-16 07:00:00 | SPY | ETF | 124.39 | 124.48 | 124.39 | 124.41 | 24600.0 |
| 2010-12-16 07:30:00 | SPY | ETF | 124.41 | 124.48 | 124.08 | 124.2 | 511990.0 |
| 2010-12-16 08:00:00 | SPY | ETF | 124.17 | 124.44 | 123.99 | 124.28 | 613947.0 |
| 2010-12-16 08:30:00 | SPY | ETF | 124.38 | 124.38 | 124.19 | 124.26 | 410371.0 |
| 2010-12-16 09:00:00 | SPY | ETF | 124.25 | 124.32 | 124.14 | 124.19 | 576227.0 |
| 2010-12-16 09:30:00 | SPY | ETF | 124.18 | 124.36 | 123.75 | 123.77 | 13646318.0 |
| 2010-12-16 10:00:00 | SPY | ETF | 123.77 | 124.24 | 123.75 | 124.06 | 18170876.0 |
| 2010-12-16 10:30:00 | SPY | ETF | 124.06 | 124.2 | 123.94 | 124.19 | 9413293.0 |
| 2010-12-16 11:00:00 | SPY | ETF | 124.19 | 124.7 | 124.15 | 124.65 | 21298677.0 |
| 2010-12-16 11:30:00 | SPY | ETF | 124.65 | 124.7 | 124.55 | 124.65 | 7107528.0 |
| 2010-12-16 12:00:00 | SPY | ETF | 124.66 | 124.68 | 124.56 | 124.565 | 6143042.0 |
| 2010-12-16 12:30:00 | SPY | ETF | 124.56 | 124.9 | 124.56 | 124.85 | 7124598.0 |
| 2010-12-16 13:00:00 | SPY | ETF | 124.86 | 124.89 | 124.79 | 124.8 | 8188571.0 |
| 2010-12-16 13:30:00 | SPY | ETF | 124.8 | 124.91 | 124.69 | 124.805 | 5235804.0 |
| 2010-12-16 14:00:00 | SPY | ETF | 124.81 | 124.85 | 124.65 | 124.68 | 7995316.0 |
| 2010-12-16 14:30:00 | SPY | ETF | 124.69 | 124.7 | 124.56 | 124.58 | 12686094.0 |
| 2010-12-16 15:00:00 | SPY | ETF | 124.59 | 124.77 | 124.54 | 124.65 | 11713516.0 |
| 2010-12-16 15:30:00 | SPY | ETF | 124.64 | 124.83 | 124.64 | 124.79 | 19113823.0 |
| 2010-12-16 16:00:00 | SPY | ETF | 124.79 | 124.94 | 123.99 | 124.84 | 16238686.0 |
| 2010-12-16 16:30:00 | SPY | ETF | 124.85 | 124.92 | 123.98 | 124.9 | 4041149.0 |
| 2010-12-16 17:00:00 | SPY | ETF | 124.93 | 124.94 | 124.8 | 124.8 | 1700613.0 |
| 2010-12-16 17:30:00 | SPY | ETF | 124.88 | 124.9 | 124.85 | 124.87 | 28747.0 |
| 2010-12-16 18:00:00 | SPY | ETF | 124.9 | 124.9 | 124.79 | 124.83 | 37153.0 |
| 2010-12-16 18:30:00 | SPY | ETF | 124.84 | 124.85 | 124.79 | 124.82 | 593000.0 |
| 2010-12-16 19:00:00 | SPY | ETF | 124.82 | 124.82 | 124.76 | 124.81 | 30410.0 |
| 2010-12-16 19:30:00 | SPY | ETF | 124.79 | 124.89 | 124.75 | 124.85 | 46104.0 |
| 2010-12-16 06:30:00 | QQQ | ETF | 54.26 | 54.26 | 54.26 | 54.26 | 200.0 |
| 2010-12-16 07:00:00 | QQQ | ETF | 54.28 | 54.3 | 54.26 | 54.28 | 13300.0 |
| 2010-12-16 07:30:00 | QQQ | ETF | 54.27 | 54.3 | 54.16 | 54.19 | 30874.0 |
| 2010-12-16 08:00:00 | QQQ | ETF | 54.2 | 54.3 | 54.19 | 54.29 | 160863.0 |
| 2010-12-16 08:30:00 | QQQ | ETF | 54.27 | 54.27 | 54.21 | 54.25 | 213404.0 |
| 2010-12-16 09:00:00 | QQQ | ETF | 54.24 | 54.25 | 54.19 | 54.2 | 263037.0 |
| 2010-12-16 09:30:00 | QQQ | ETF | 54.21 | 54.35 | 54.06 | 54.12 | 6193175.0 |
| 2010-12-16 10:00:00 | QQQ | ETF | 54.11 | 54.36 | 54.07 | 54.2805 | 7116548.0 |
| 2010-12-16 10:30:00 | QQQ | ETF | 54.29 | 54.37 | 54.2501 | 54.34 | 2323841.0 |
| 2010-12-16 11:00:00 | QQQ | ETF | 54.35 | 54.64 | 54.31 | 54.58 | 6206922.0 |
| 2010-12-16 11:30:00 | QQQ | ETF | 54.58 | 54.61 | 54.5501 | 54.59 | 1380775.0 |
| 2010-12-16 12:00:00 | QQQ | ETF | 54.581 | 54.6 | 54.54 | 54.55 | 1394176.0 |
| 2010-12-16 12:30:00 | QQQ | ETF | 54.5462 | 54.66 | 54.5405 | 54.64 | 1540184.0 |
| 2010-12-16 13:00:00 | QQQ | ETF | 54.64 | 54.65 | 54.5901 | 54.61 | 1791860.0 |
| 2010-12-16 13:30:00 | QQQ | ETF | 54.605 | 54.649 | 54.55 | 54.56 | 1537532.0 |
| 2010-12-16 14:00:00 | QQQ | ETF | 54.5699 | 54.605 | 54.54 | 54.5599 | 1548047.0 |
| 2010-12-16 14:30:00 | QQQ | ETF | 54.55 | 54.56 | 54.51 | 54.52 | 1618191.0 |
| 2010-12-16 15:00:00 | QQQ | ETF | 54.52 | 54.62 | 54.52 | 54.57 | 1773017.0 |
| 2010-12-16 15:30:00 | QQQ | ETF | 54.57 | 54.6 | 54.53 | 54.57 | 3955288.0 |
> showing 50 of 8,924 rows — these rows as CSV