PREVIEW / etf_1hour / 2015-01-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-27.parquet
  size:    247 KB
  rows:    7,828

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-27 04:00:00	SPY	ETF	205.49	205.49	204.95	204.95	6242.0
2015-01-27 05:00:00	SPY	ETF	205.01	205.15	204.85	204.85	58175.0
2015-01-27 06:00:00	SPY	ETF	204.8	204.98	204.62	204.63	182447.0
2015-01-27 07:00:00	SPY	ETF	204.81	204.81	204.06	204.22	1154057.0
2015-01-27 08:00:00	SPY	ETF	204.22	205.795	202.94	203.32	3253846.0
2015-01-27 09:00:00	SPY	ETF	203.31	203.44	202.58	202.863	21699330.0
2015-01-27 10:00:00	SPY	ETF	202.87	203.235	201.74	202.2	25501225.0
2015-01-27 11:00:00	SPY	ETF	202.2	203.0	202.09	202.47	17305533.0
2015-01-27 12:00:00	SPY	ETF	202.465	203.25	202.41	203.23	10582990.0
2015-01-27 13:00:00	SPY	ETF	203.235	203.75	203.05	203.33	10974291.0
2015-01-27 14:00:00	SPY	ETF	203.32	204.12	203.3	203.425	10055787.0
2015-01-27 15:00:00	SPY	ETF	203.425	203.625	202.64	202.75	22101172.0
2015-01-27 16:00:00	SPY	ETF	202.74	204.34	202.7348	204.18	8444130.0
2015-01-27 17:00:00	SPY	ETF	204.17	204.2	204.0	204.08	257121.0
2015-01-27 18:00:00	SPY	ETF	204.08	204.11	203.82	203.9	213546.0
2015-01-27 19:00:00	SPY	ETF	203.96	203.98	203.72	203.92	180465.0
2015-01-27 04:00:00	QQQ	ETF	104.0	104.0	103.75	103.75	1400.0
2015-01-27 06:00:00	QQQ	ETF	103.65	103.71	103.44	103.44	79200.0
2015-01-27 07:00:00	QQQ	ETF	103.47	103.54	103.13	103.25	80841.0
2015-01-27 08:00:00	QQQ	ETF	103.24	104.14	102.55	102.68	796535.0
2015-01-27 09:00:00	QQQ	ETF	102.72	102.75	101.87	101.97	7978083.0
2015-01-27 10:00:00	QQQ	ETF	101.953	102.15	101.1	101.49	7518352.0
2015-01-27 11:00:00	QQQ	ETF	101.49	101.91	101.42	101.62	4196858.0
2015-01-27 12:00:00	QQQ	ETF	101.61	102.04	101.6	101.97	2610349.0
2015-01-27 13:00:00	QQQ	ETF	101.98	102.38	101.939	102.12	2996886.0
2015-01-27 14:00:00	QQQ	ETF	102.11	102.56	102.11	102.1363	2940558.0
2015-01-27 15:00:00	QQQ	ETF	102.14	102.26	101.41	101.48	9746991.0
2015-01-27 16:00:00	QQQ	ETF	101.47	102.79	101.44	102.73	4242918.0
2015-01-27 17:00:00	QQQ	ETF	101.47	102.7	101.44	102.62	238867.0
2015-01-27 18:00:00	QQQ	ETF	102.62	102.67	102.49	102.63	57826.0
2015-01-27 19:00:00	QQQ	ETF	102.62	102.62	102.54	102.62	43365.0
2015-01-27 04:00:00	IWM	ETF	119.19	119.19	119.19	119.19	197.0
2015-01-27 06:00:00	IWM	ETF	118.73	118.73	118.73	118.73	5000.0
2015-01-27 07:00:00	IWM	ETF	118.8	118.81	118.49	118.58	78127.0
2015-01-27 08:00:00	IWM	ETF	118.58	118.59	117.67	117.9	240478.0
2015-01-27 09:00:00	IWM	ETF	117.9	118.49	117.71	118.15	3773954.0
2015-01-27 10:00:00	IWM	ETF	118.15	118.46	117.62	118.09	5709464.0
2015-01-27 11:00:00	IWM	ETF	118.08	118.72	117.96	118.43	3091008.0
2015-01-27 12:00:00	IWM	ETF	118.43	118.95	118.33	118.79	2238179.0
2015-01-27 13:00:00	IWM	ETF	118.79	119.19	118.74	118.84	1853374.0
2015-01-27 14:00:00	IWM	ETF	118.838	119.25	118.825	118.91	2440407.0
2015-01-27 15:00:00	IWM	ETF	118.91	119.07	118.45	118.65	4739515.0
2015-01-27 16:00:00	IWM	ETF	118.65	119.45	118.64	119.4	1691793.0
2015-01-27 17:00:00	IWM	ETF	119.33	119.33	119.2	119.2	33547.0
2015-01-27 18:00:00	IWM	ETF	119.15	119.3	119.15	119.3	700.0
2015-01-27 19:00:00	IWM	ETF	119.2	119.23	119.1	119.12	8174.0
2015-01-27 04:00:00	DIA	ETF	179.0	179.0	179.0	179.0	600.0
2015-01-27 05:00:00	DIA	ETF	176.0	176.0	175.8	175.8	300.0
2015-01-27 06:00:00	DIA	ETF	175.69	175.82	175.69	175.75	1200.0
2015-01-27 07:00:00	DIA	ETF	174.62	174.62	174.5	174.5	600.0

> showing 50 of 7,828 rows — these rows as CSV

> unlock the full archive -- $79 one-time