PREVIEW / etf_30min / 2015-01-22
file: by_date/etf_30min/2015/2015-01-22.parquet size: 396 KB rows: 13,313
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-22 04:00:00 | SPY | ETF | 203.57 | 203.75 | 203.1 | 203.1 | 1668.0 |
| 2015-01-22 04:30:00 | SPY | ETF | 203.75 | 203.97 | 203.15 | 203.9 | 4077.0 |
| 2015-01-22 05:00:00 | SPY | ETF | 203.5 | 203.7 | 203.5 | 203.7 | 28750.0 |
| 2015-01-22 05:30:00 | SPY | ETF | 203.65 | 203.65 | 203.2 | 203.2 | 2070.0 |
| 2015-01-22 06:00:00 | SPY | ETF | 203.28 | 203.41 | 203.28 | 203.41 | 1699.0 |
| 2015-01-22 06:30:00 | SPY | ETF | 203.4 | 203.53 | 203.4 | 203.42 | 8450.0 |
| 2015-01-22 07:00:00 | SPY | ETF | 203.5 | 203.54 | 203.3 | 203.43 | 114390.0 |
| 2015-01-22 07:30:00 | SPY | ETF | 203.43 | 204.25 | 203.42 | 204.06 | 755594.0 |
| 2015-01-22 08:00:00 | SPY | ETF | 204.08 | 204.23 | 203.3 | 204.07 | 749676.0 |
| 2015-01-22 08:30:00 | SPY | ETF | 204.08 | 205.09 | 203.39 | 204.13 | 7319960.0 |
| 2015-01-22 09:00:00 | SPY | ETF | 204.16 | 204.58 | 203.9 | 204.0 | 2290390.0 |
| 2015-01-22 09:30:00 | SPY | ETF | 203.99 | 204.5 | 202.33 | 202.94 | 22711841.0 |
| 2015-01-22 10:00:00 | SPY | ETF | 202.94 | 204.12 | 202.87 | 203.94 | 12357444.0 |
| 2015-01-22 10:30:00 | SPY | ETF | 203.95 | 204.92 | 203.84 | 204.9 | 10965331.0 |
| 2015-01-22 11:00:00 | SPY | ETF | 204.9 | 204.95 | 204.17 | 204.61 | 10743881.0 |
| 2015-01-22 11:30:00 | SPY | ETF | 204.62 | 204.69 | 204.03 | 204.35 | 5711866.0 |
| 2015-01-22 12:00:00 | SPY | ETF | 204.34 | 204.58 | 204.06 | 204.495 | 6206166.0 |
| 2015-01-22 12:30:00 | SPY | ETF | 204.5 | 204.54 | 204.14 | 204.28 | 3636643.0 |
| 2015-01-22 13:00:00 | SPY | ETF | 204.2749 | 204.58 | 204.13 | 204.269 | 3810896.0 |
| 2015-01-22 13:30:00 | SPY | ETF | 204.263 | 204.72 | 204.245 | 204.655 | 3717007.0 |
| 2015-01-22 14:00:00 | SPY | ETF | 204.66 | 205.0 | 204.55 | 204.99 | 7296586.0 |
| 2015-01-22 14:30:00 | SPY | ETF | 204.99 | 205.93 | 204.96 | 205.87 | 13005275.0 |
| 2015-01-22 15:00:00 | SPY | ETF | 205.88 | 206.26 | 205.83 | 206.08 | 15812019.0 |
| 2015-01-22 15:30:00 | SPY | ETF | 206.08 | 206.19 | 205.87 | 206.09 | 20024780.0 |
| 2015-01-22 16:00:00 | SPY | ETF | 206.11 | 206.14 | 202.991 | 206.02 | 6904222.0 |
| 2015-01-22 16:30:00 | SPY | ETF | 206.03 | 206.13 | 206.02 | 206.08 | 1665569.0 |
| 2015-01-22 17:00:00 | SPY | ETF | 206.11 | 206.13 | 206.04 | 206.08 | 8602174.0 |
| 2015-01-22 17:30:00 | SPY | ETF | 206.06 | 206.12 | 206.02 | 206.09 | 243814.0 |
| 2015-01-22 18:00:00 | SPY | ETF | 206.09 | 206.09 | 205.93 | 206.05 | 149920.0 |
| 2015-01-22 18:30:00 | SPY | ETF | 206.06 | 206.1 | 205.96 | 205.96 | 24669.0 |
| 2015-01-22 19:00:00 | SPY | ETF | 205.96 | 205.96 | 205.81 | 205.83 | 338406.0 |
| 2015-01-22 19:30:00 | SPY | ETF | 205.83 | 205.91 | 205.81 | 205.89 | 143005.0 |
| 2015-01-22 04:00:00 | QQQ | ETF | 102.29 | 102.29 | 102.29 | 102.29 | 290.0 |
| 2015-01-22 06:00:00 | QQQ | ETF | 102.1 | 102.1 | 102.1 | 102.1 | 100.0 |
| 2015-01-22 07:00:00 | QQQ | ETF | 102.18 | 102.18 | 102.05 | 102.13 | 37564.0 |
| 2015-01-22 07:30:00 | QQQ | ETF | 102.1 | 102.54 | 102.1 | 102.45 | 101964.0 |
| 2015-01-22 08:00:00 | QQQ | ETF | 102.48 | 102.53 | 102.34 | 102.5 | 51416.0 |
| 2015-01-22 08:30:00 | QQQ | ETF | 102.45 | 102.97 | 102.16 | 102.58 | 782380.0 |
| 2015-01-22 09:00:00 | QQQ | ETF | 102.58 | 102.76 | 102.14 | 102.56 | 546557.0 |
| 2015-01-22 09:30:00 | QQQ | ETF | 102.54 | 102.94 | 101.64 | 102.01 | 6676853.0 |
| 2015-01-22 10:00:00 | QQQ | ETF | 102.02 | 102.71 | 101.99 | 102.53 | 3172439.0 |
| 2015-01-22 10:30:00 | QQQ | ETF | 102.535 | 103.17 | 102.48 | 103.17 | 2976271.0 |
| 2015-01-22 11:00:00 | QQQ | ETF | 103.16 | 103.35 | 102.94 | 103.26 | 2431282.0 |
| 2015-01-22 11:30:00 | QQQ | ETF | 103.27 | 103.3099 | 102.995 | 103.16 | 1600885.0 |
| 2015-01-22 12:00:00 | QQQ | ETF | 103.17 | 103.2699 | 102.98 | 103.25 | 1107160.0 |
| 2015-01-22 12:30:00 | QQQ | ETF | 103.25 | 103.265 | 102.99 | 103.08 | 985028.0 |
| 2015-01-22 13:00:00 | QQQ | ETF | 103.07 | 103.2 | 102.91 | 102.97 | 1015635.0 |
| 2015-01-22 13:30:00 | QQQ | ETF | 102.97 | 103.24 | 102.97 | 103.125 | 972674.0 |
| 2015-01-22 14:00:00 | QQQ | ETF | 103.13 | 103.36 | 103.03 | 103.31 | 1498075.0 |
| 2015-01-22 14:30:00 | QQQ | ETF | 103.31 | 103.83 | 103.31 | 103.776 | 3508996.0 |
> showing 50 of 13,313 rows — these rows as CSV