PREVIEW / etf_30min / 2016-02-11
file: by_date/etf_30min/2016/2016-02-11.parquet size: 428 KB rows: 14,464
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-11 04:00:00 | SPY | ETF | 182.41 | 182.79 | 181.5 | 181.66 | 156578.0 |
| 2016-02-11 04:30:00 | SPY | ETF | 181.77 | 182.17 | 181.53 | 182.03 | 50309.0 |
| 2016-02-11 05:00:00 | SPY | ETF | 181.98 | 182.09 | 181.57 | 181.87 | 36325.0 |
| 2016-02-11 05:30:00 | SPY | ETF | 181.87 | 182.27 | 181.74 | 182.06 | 66089.0 |
| 2016-02-11 06:00:00 | SPY | ETF | 182.2 | 182.25 | 181.73 | 181.94 | 188446.0 |
| 2016-02-11 06:30:00 | SPY | ETF | 182.0 | 182.13 | 181.3 | 181.33 | 325075.0 |
| 2016-02-11 07:00:00 | SPY | ETF | 181.31 | 182.24 | 180.91 | 182.22 | 766823.0 |
| 2016-02-11 07:30:00 | SPY | ETF | 182.24 | 182.44 | 181.67 | 181.75 | 755784.0 |
| 2016-02-11 08:00:00 | SPY | ETF | 181.79 | 182.4 | 181.22 | 182.24 | 1213705.0 |
| 2016-02-11 08:30:00 | SPY | ETF | 182.25 | 182.57 | 182.0 | 182.1 | 998030.0 |
| 2016-02-11 09:00:00 | SPY | ETF | 182.1 | 182.49 | 182.01 | 182.36 | 1519749.0 |
| 2016-02-11 09:30:00 | SPY | ETF | 182.34 | 183.95 | 182.16 | 183.51 | 22007194.0 |
| 2016-02-11 10:00:00 | SPY | ETF | 183.51 | 183.86 | 182.61 | 182.7125 | 13493210.0 |
| 2016-02-11 10:30:00 | SPY | ETF | 182.71 | 183.06 | 182.13 | 182.2689 | 11276828.0 |
| 2016-02-11 11:00:00 | SPY | ETF | 182.25 | 182.57 | 181.69 | 181.76 | 15365665.0 |
| 2016-02-11 11:30:00 | SPY | ETF | 181.77 | 182.37 | 181.39 | 182.135 | 15341561.0 |
| 2016-02-11 12:00:00 | SPY | ETF | 182.135 | 182.54 | 181.73 | 182.03 | 8043994.0 |
| 2016-02-11 12:30:00 | SPY | ETF | 182.02 | 182.62 | 181.66 | 182.495 | 8693716.0 |
| 2016-02-11 13:00:00 | SPY | ETF | 182.51 | 182.87 | 182.25 | 182.389 | 9136621.0 |
| 2016-02-11 13:30:00 | SPY | ETF | 182.38 | 182.7 | 181.79 | 182.0 | 10609429.0 |
| 2016-02-11 14:00:00 | SPY | ETF | 181.995 | 182.19 | 181.36 | 181.445 | 10169016.0 |
| 2016-02-11 14:30:00 | SPY | ETF | 181.44 | 183.86 | 181.09 | 183.1611 | 32952259.0 |
| 2016-02-11 15:00:00 | SPY | ETF | 183.16 | 183.38 | 182.29 | 183.3 | 17539440.0 |
| 2016-02-11 15:30:00 | SPY | ETF | 183.295 | 184.1 | 182.9 | 183.06 | 22904572.0 |
| 2016-02-11 16:00:00 | SPY | ETF | 183.05 | 183.379 | 182.64 | 183.09 | 10404377.0 |
| 2016-02-11 16:30:00 | SPY | ETF | 183.09 | 183.26 | 183.01 | 183.16 | 3828653.0 |
| 2016-02-11 17:00:00 | SPY | ETF | 183.22 | 183.35 | 183.15 | 183.18 | 77258.0 |
| 2016-02-11 17:30:00 | SPY | ETF | 183.22 | 183.35 | 183.13 | 183.35 | 57699.0 |
| 2016-02-11 18:00:00 | SPY | ETF | 183.35 | 183.65 | 183.35 | 183.54 | 308448.0 |
| 2016-02-11 18:30:00 | SPY | ETF | 183.6 | 183.66 | 183.5 | 183.65 | 32681.0 |
| 2016-02-11 19:00:00 | SPY | ETF | 183.6 | 183.79 | 183.28 | 183.79 | 66443.0 |
| 2016-02-11 19:30:00 | SPY | ETF | 183.7 | 183.79 | 183.46 | 183.67 | 77870.0 |
| 2016-02-11 20:00:00 | SPY | ETF | 183.0518 | 183.0518 | 183.0518 | 183.0518 | 90884.0 |
| 2016-02-11 04:00:00 | QQQ | ETF | 95.25 | 95.25 | 94.68 | 94.68 | 21059.0 |
| 2016-02-11 04:30:00 | QQQ | ETF | 94.82 | 94.9 | 94.7 | 94.9 | 2096.0 |
| 2016-02-11 05:00:00 | QQQ | ETF | 94.88 | 94.88 | 94.68 | 94.73 | 2300.0 |
| 2016-02-11 05:30:00 | QQQ | ETF | 94.87 | 94.97 | 94.87 | 94.94 | 4500.0 |
| 2016-02-11 06:00:00 | QQQ | ETF | 94.97 | 95.15 | 94.87 | 95.01 | 21515.0 |
| 2016-02-11 06:30:00 | QQQ | ETF | 94.97 | 95.06 | 94.58 | 94.58 | 60985.0 |
| 2016-02-11 07:00:00 | QQQ | ETF | 94.5 | 95.13 | 94.5 | 95.13 | 88638.0 |
| 2016-02-11 07:30:00 | QQQ | ETF | 95.16 | 95.23 | 94.83 | 94.9 | 80708.0 |
| 2016-02-11 08:00:00 | QQQ | ETF | 94.95 | 95.33 | 94.47 | 95.25 | 160310.0 |
| 2016-02-11 08:30:00 | QQQ | ETF | 95.23 | 95.56 | 95.2 | 95.29 | 309498.0 |
| 2016-02-11 09:00:00 | QQQ | ETF | 95.31 | 95.57 | 95.21 | 95.46 | 506432.0 |
| 2016-02-11 09:30:00 | QQQ | ETF | 95.45 | 96.62 | 95.38 | 96.4 | 9136941.0 |
| 2016-02-11 10:00:00 | QQQ | ETF | 96.37 | 96.58 | 95.85 | 95.92 | 4771628.0 |
| 2016-02-11 10:30:00 | QQQ | ETF | 95.92 | 96.13 | 95.64 | 95.7 | 3478201.0 |
| 2016-02-11 11:00:00 | QQQ | ETF | 95.7 | 95.88 | 95.33 | 95.4 | 4381459.0 |
| 2016-02-11 11:30:00 | QQQ | ETF | 95.4 | 95.96 | 95.19 | 95.8 | 3193470.0 |
| 2016-02-11 12:00:00 | QQQ | ETF | 95.8 | 96.06 | 95.54 | 95.75 | 2427776.0 |
> showing 50 of 14,464 rows — these rows as CSV