PREVIEW / etf_30min / 2015-01-05
file: by_date/etf_30min/2015/2015-01-05.parquet size: 391 KB rows: 13,245
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-05 04:00:00 | SPY | ETF | 205.11 | 205.11 | 204.71 | 204.74 | 18321.0 |
| 2015-01-05 04:30:00 | SPY | ETF | 204.69 | 204.75 | 204.63 | 204.65 | 17325.0 |
| 2015-01-05 05:00:00 | SPY | ETF | 204.65 | 204.72 | 204.65 | 204.72 | 2030.0 |
| 2015-01-05 05:30:00 | SPY | ETF | 204.62 | 204.62 | 204.39 | 204.39 | 36182.0 |
| 2015-01-05 06:00:00 | SPY | ETF | 204.37 | 204.69 | 204.37 | 204.69 | 6800.0 |
| 2015-01-05 06:30:00 | SPY | ETF | 204.62 | 204.62 | 204.4 | 204.44 | 30190.0 |
| 2015-01-05 07:00:00 | SPY | ETF | 204.41 | 204.58 | 204.4 | 204.58 | 85517.0 |
| 2015-01-05 07:30:00 | SPY | ETF | 204.59 | 204.69 | 204.52 | 204.52 | 138425.0 |
| 2015-01-05 08:00:00 | SPY | ETF | 204.54 | 205.43 | 204.34 | 204.38 | 692627.0 |
| 2015-01-05 08:30:00 | SPY | ETF | 204.36 | 204.38 | 203.82 | 204.0 | 652127.0 |
| 2015-01-05 09:00:00 | SPY | ETF | 204.0 | 204.22 | 203.97 | 204.19 | 933804.0 |
| 2015-01-05 09:30:00 | SPY | ETF | 204.17 | 204.37 | 203.09 | 203.121 | 16250831.0 |
| 2015-01-05 10:00:00 | SPY | ETF | 203.12 | 203.5 | 202.9 | 203.24 | 10896919.0 |
| 2015-01-05 10:30:00 | SPY | ETF | 203.23 | 203.23 | 202.5 | 202.8 | 14783853.0 |
| 2015-01-05 11:00:00 | SPY | ETF | 202.8 | 202.83 | 202.15 | 202.26 | 12658248.0 |
| 2015-01-05 11:30:00 | SPY | ETF | 202.26 | 202.89 | 202.17 | 202.69 | 10380939.0 |
| 2015-01-05 12:00:00 | SPY | ETF | 202.69 | 202.79 | 201.93 | 201.95 | 7122112.0 |
| 2015-01-05 12:30:00 | SPY | ETF | 201.96 | 202.245 | 201.66 | 201.93 | 8784419.0 |
| 2015-01-05 13:00:00 | SPY | ETF | 201.93 | 202.04 | 201.56 | 201.73 | 8595075.0 |
| 2015-01-05 13:30:00 | SPY | ETF | 201.72 | 202.16 | 201.6577 | 201.995 | 10195083.0 |
| 2015-01-05 14:00:00 | SPY | ETF | 201.995 | 202.02 | 201.58 | 201.73 | 8200085.0 |
| 2015-01-05 14:30:00 | SPY | ETF | 201.73 | 201.82 | 201.37 | 201.4401 | 8055089.0 |
| 2015-01-05 15:00:00 | SPY | ETF | 201.44 | 201.95 | 201.35 | 201.75 | 10158691.0 |
| 2015-01-05 15:30:00 | SPY | ETF | 201.75 | 202.32 | 201.62 | 201.8 | 24354943.0 |
| 2015-01-05 16:00:00 | SPY | ETF | 201.8 | 202.2334 | 201.63 | 201.99 | 5616440.0 |
| 2015-01-05 16:30:00 | SPY | ETF | 202.0 | 202.14 | 201.72 | 202.14 | 3755596.0 |
| 2015-01-05 17:00:00 | SPY | ETF | 202.14 | 202.18 | 202.06 | 202.12 | 1062331.0 |
| 2015-01-05 17:30:00 | SPY | ETF | 202.08 | 202.16 | 201.72 | 201.72 | 257314.0 |
| 2015-01-05 18:00:00 | SPY | ETF | 202.15 | 202.28 | 202.15 | 202.19 | 73766.0 |
| 2015-01-05 18:30:00 | SPY | ETF | 202.19 | 202.31 | 202.15 | 202.3 | 79090.0 |
| 2015-01-05 19:00:00 | SPY | ETF | 202.28 | 202.28 | 202.17 | 202.17 | 12378.0 |
| 2015-01-05 19:30:00 | SPY | ETF | 202.18 | 202.18 | 201.91 | 201.96 | 77227.0 |
| 2015-01-05 20:00:00 | SPY | ETF | 201.7163 | 201.7163 | 201.7163 | 201.7163 | 385000.0 |
| 2015-01-05 05:30:00 | QQQ | ETF | 102.6 | 102.6 | 102.51 | 102.51 | 17450.0 |
| 2015-01-05 06:00:00 | QQQ | ETF | 102.57 | 102.65 | 102.57 | 102.64 | 8600.0 |
| 2015-01-05 07:00:00 | QQQ | ETF | 102.56 | 102.59 | 102.56 | 102.57 | 23188.0 |
| 2015-01-05 07:30:00 | QQQ | ETF | 102.68 | 102.69 | 102.65 | 102.67 | 4119.0 |
| 2015-01-05 08:00:00 | QQQ | ETF | 102.62 | 102.94 | 102.55 | 102.55 | 43341.0 |
| 2015-01-05 08:30:00 | QQQ | ETF | 102.56 | 102.56 | 102.33 | 102.39 | 98198.0 |
| 2015-01-05 09:00:00 | QQQ | ETF | 102.42 | 102.56 | 102.42 | 102.49 | 97441.0 |
| 2015-01-05 09:30:00 | QQQ | ETF | 102.49 | 102.61 | 102.03 | 102.06 | 4996041.0 |
| 2015-01-05 10:00:00 | QQQ | ETF | 102.055 | 102.3332 | 101.89 | 102.17 | 3031208.0 |
| 2015-01-05 10:30:00 | QQQ | ETF | 102.16 | 102.17 | 101.76 | 101.955 | 2508967.0 |
| 2015-01-05 11:00:00 | QQQ | ETF | 101.96 | 102.01 | 101.6099 | 101.66 | 2186431.0 |
| 2015-01-05 11:30:00 | QQQ | ETF | 101.66 | 102.12 | 101.62 | 102.01 | 1504668.0 |
| 2015-01-05 12:00:00 | QQQ | ETF | 102.0 | 102.06 | 101.66 | 101.67 | 1293833.0 |
| 2015-01-05 12:30:00 | QQQ | ETF | 101.67 | 101.83 | 101.47 | 101.6 | 1280200.0 |
| 2015-01-05 13:00:00 | QQQ | ETF | 101.605 | 101.605 | 101.33 | 101.4 | 1393421.0 |
| 2015-01-05 13:30:00 | QQQ | ETF | 101.41 | 101.67 | 101.38 | 101.555 | 1261942.0 |
| 2015-01-05 14:00:00 | QQQ | ETF | 101.55 | 101.59 | 101.3 | 101.385 | 1838144.0 |
> showing 50 of 13,245 rows — these rows as CSV