PREVIEW / etf_30min / 2015-10-22
file: by_date/etf_30min/2015/2015-10-22.parquet size: 387 KB rows: 12,858
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-10-22 04:00:00 | SPY | ETF | 202.07 | 202.21 | 201.94 | 201.99 | 4086.0 |
| 2015-10-22 04:30:00 | SPY | ETF | 202.07 | 202.1 | 202.03 | 202.07 | 1105.0 |
| 2015-10-22 05:00:00 | SPY | ETF | 202.12 | 202.22 | 202.1 | 202.19 | 4210.0 |
| 2015-10-22 05:30:00 | SPY | ETF | 202.22 | 202.27 | 202.19 | 202.19 | 3018.0 |
| 2015-10-22 06:00:00 | SPY | ETF | 202.21 | 202.29 | 202.21 | 202.26 | 16060.0 |
| 2015-10-22 06:30:00 | SPY | ETF | 202.25 | 202.37 | 202.21 | 202.24 | 62622.0 |
| 2015-10-22 07:00:00 | SPY | ETF | 202.24 | 202.32 | 202.18 | 202.29 | 50560.0 |
| 2015-10-22 07:30:00 | SPY | ETF | 202.31 | 202.31 | 202.15 | 202.22 | 144192.0 |
| 2015-10-22 08:00:00 | SPY | ETF | 202.2 | 202.48 | 202.06 | 202.48 | 524492.0 |
| 2015-10-22 08:30:00 | SPY | ETF | 202.22 | 202.99 | 202.12 | 202.73 | 1478953.0 |
| 2015-10-22 09:00:00 | SPY | ETF | 202.73 | 203.11 | 202.45 | 203.0 | 1990878.0 |
| 2015-10-22 09:30:00 | SPY | ETF | 202.98 | 203.93 | 202.81 | 203.91 | 17292759.0 |
| 2015-10-22 10:00:00 | SPY | ETF | 203.9 | 204.28 | 203.8 | 203.9873 | 11628531.0 |
| 2015-10-22 10:30:00 | SPY | ETF | 203.99 | 204.52 | 203.87 | 204.511 | 11156144.0 |
| 2015-10-22 11:00:00 | SPY | ETF | 204.51 | 204.62 | 204.31 | 204.38 | 11252143.0 |
| 2015-10-22 11:30:00 | SPY | ETF | 204.39 | 204.86 | 204.28 | 204.67 | 9224998.0 |
| 2015-10-22 12:00:00 | SPY | ETF | 204.67 | 205.28 | 204.5601 | 205.2299 | 11620505.0 |
| 2015-10-22 12:30:00 | SPY | ETF | 205.23 | 205.51 | 205.16 | 205.3 | 11065269.0 |
| 2015-10-22 13:00:00 | SPY | ETF | 205.31 | 205.44 | 205.0801 | 205.17 | 8433726.0 |
| 2015-10-22 13:30:00 | SPY | ETF | 205.17 | 205.22 | 204.73 | 204.73 | 9072162.0 |
| 2015-10-22 14:00:00 | SPY | ETF | 204.74 | 204.81 | 204.1 | 204.56 | 13650867.0 |
| 2015-10-22 14:30:00 | SPY | ETF | 204.57 | 205.19 | 204.37 | 205.17 | 9278497.0 |
| 2015-10-22 15:00:00 | SPY | ETF | 205.16 | 205.39 | 204.75 | 205.37 | 14633917.0 |
| 2015-10-22 15:30:00 | SPY | ETF | 205.37 | 205.425 | 204.92 | 205.22 | 16574911.0 |
| 2015-10-22 16:00:00 | SPY | ETF | 205.21 | 206.03 | 205.1 | 205.86 | 8565986.0 |
| 2015-10-22 16:30:00 | SPY | ETF | 205.86 | 206.21 | 205.78 | 206.21 | 4680081.0 |
| 2015-10-22 17:00:00 | SPY | ETF | 206.17 | 206.3 | 204.6191 | 206.26 | 574385.0 |
| 2015-10-22 17:30:00 | SPY | ETF | 206.26 | 206.28 | 206.07 | 206.07 | 65564.0 |
| 2015-10-22 18:00:00 | SPY | ETF | 206.09 | 206.82 | 205.99 | 206.57 | 346296.0 |
| 2015-10-22 18:30:00 | SPY | ETF | 206.54 | 206.65 | 206.52 | 206.55 | 87430.0 |
| 2015-10-22 19:00:00 | SPY | ETF | 206.55 | 206.58 | 206.44 | 206.53 | 202100.0 |
| 2015-10-22 19:30:00 | SPY | ETF | 206.53 | 206.56 | 206.46 | 206.56 | 68251.0 |
| 2015-10-22 04:00:00 | QQQ | ETF | 107.84 | 107.84 | 107.84 | 107.84 | 100.0 |
| 2015-10-22 04:30:00 | QQQ | ETF | 107.76 | 107.76 | 107.75 | 107.75 | 600.0 |
| 2015-10-22 05:30:00 | QQQ | ETF | 107.84 | 107.85 | 107.84 | 107.85 | 400.0 |
| 2015-10-22 06:00:00 | QQQ | ETF | 107.88 | 107.88 | 107.88 | 107.88 | 100.0 |
| 2015-10-22 06:30:00 | QQQ | ETF | 107.93 | 107.93 | 107.9 | 107.91 | 6650.0 |
| 2015-10-22 07:00:00 | QQQ | ETF | 107.92 | 107.95 | 107.92 | 107.95 | 48001.0 |
| 2015-10-22 07:30:00 | QQQ | ETF | 107.95 | 107.99 | 107.9 | 107.94 | 109704.0 |
| 2015-10-22 08:00:00 | QQQ | ETF | 107.9 | 108.06 | 107.9 | 108.06 | 115401.0 |
| 2015-10-22 08:30:00 | QQQ | ETF | 108.03 | 108.37 | 107.94 | 108.27 | 112885.0 |
| 2015-10-22 09:00:00 | QQQ | ETF | 108.25 | 108.54 | 108.13 | 108.48 | 367613.0 |
| 2015-10-22 09:30:00 | QQQ | ETF | 108.49 | 109.05 | 108.171 | 108.96 | 6511253.0 |
| 2015-10-22 10:00:00 | QQQ | ETF | 108.97 | 109.14 | 108.83 | 108.9 | 3662213.0 |
| 2015-10-22 10:30:00 | QQQ | ETF | 108.91 | 109.38 | 108.865 | 109.37 | 2762745.0 |
| 2015-10-22 11:00:00 | QQQ | ETF | 109.369 | 109.51 | 109.23 | 109.25 | 2129468.0 |
| 2015-10-22 11:30:00 | QQQ | ETF | 109.25 | 109.45 | 109.09 | 109.3219 | 1783786.0 |
| 2015-10-22 12:00:00 | QQQ | ETF | 109.32 | 109.645 | 109.25 | 109.61 | 2000001.0 |
| 2015-10-22 12:30:00 | QQQ | ETF | 109.62 | 109.8 | 109.57 | 109.69 | 1878423.0 |
| 2015-10-22 13:00:00 | QQQ | ETF | 109.69 | 109.77 | 109.5 | 109.55 | 1338484.0 |
> showing 50 of 12,858 rows — these rows as CSV