PREVIEW / etf_1hour / 2018-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-20.parquet
  size:    335 KB
  rows:    11,010

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
2018-11-20 04:00:00	SPY	ETF	267.93	268.05	267.27	267.6	29757.0
2018-11-20 05:00:00	SPY	ETF	267.61	267.99	267.35	267.66	131675.0
2018-11-20 06:00:00	SPY	ETF	267.63	268.31	267.27	268.1	454060.0
2018-11-20 07:00:00	SPY	ETF	268.1	268.1	266.21	266.31	898780.0
2018-11-20 08:00:00	SPY	ETF	267.46	268.95	265.46	265.54	1749519.0
2018-11-20 09:00:00	SPY	ETF	265.53	269.1	264.04	264.62	20566853.0
2018-11-20 10:00:00	SPY	ETF	264.6102	266.8	263.32	266.61	28181244.0
2018-11-20 11:00:00	SPY	ETF	266.63	266.79	264.83	266.28	12538256.0
2018-11-20 12:00:00	SPY	ETF	266.27	267.0	265.125	265.2011	9337751.0
2018-11-20 13:00:00	SPY	ETF	265.2	265.51	264.28	264.37	9748223.0
2018-11-20 14:00:00	SPY	ETF	264.375	265.25	263.76	264.165	13212585.0
2018-11-20 15:00:00	SPY	ETF	264.17	265.06	263.15	264.2	27894538.0
2018-11-20 16:00:00	SPY	ETF	264.19	264.2305	263.57	263.65	7868157.0
2018-11-20 17:00:00	SPY	ETF	263.7	264.12	263.47	263.95	301388.0
2018-11-20 18:00:00	SPY	ETF	263.82	263.82	263.18	263.57	210718.0
2018-11-20 19:00:00	SPY	ETF	263.6	264.29	263.58	264.12	193691.0
2018-11-20 04:00:00	QQQ	ETF	161.11	161.15	160.49	160.84	71226.0
2018-11-20 05:00:00	QQQ	ETF	160.75	161.01	160.45	160.66	108591.0
2018-11-20 06:00:00	QQQ	ETF	160.59	161.14	160.19	160.97	160569.0
2018-11-20 07:00:00	QQQ	ETF	160.9	160.9	159.62	159.66	793559.0
2018-11-20 08:00:00	QQQ	ETF	159.68	161.2	158.73	158.87	1198387.0
2018-11-20 09:00:00	QQQ	ETF	158.87	159.76	157.8	158.44	18319655.0
2018-11-20 10:00:00	QQQ	ETF	158.45	161.11	157.13	161.03	20632775.0
2018-11-20 11:00:00	QQQ	ETF	161.02	161.18	159.63	160.82	11012043.0
2018-11-20 12:00:00	QQQ	ETF	160.82	161.38	159.83	159.91	6244662.0
2018-11-20 13:00:00	QQQ	ETF	159.9	160.19	159.1	159.1	4443232.0
2018-11-20 14:00:00	QQQ	ETF	159.09	159.76	158.67	158.99	7968682.0
2018-11-20 15:00:00	QQQ	ETF	159.04	159.64	158.13	159.22	15299055.0
2018-11-20 16:00:00	QQQ	ETF	159.23	159.24	158.89	158.92	2891753.0
2018-11-20 17:00:00	QQQ	ETF	158.9	158.94	158.7	158.88	109120.0
2018-11-20 18:00:00	QQQ	ETF	158.97	159.01	158.6	158.75	103750.0
2018-11-20 19:00:00	QQQ	ETF	158.8	159.52	158.8	159.34	147418.0
2018-11-20 04:00:00	IWM	ETF	148.17	148.44	148.17	148.44	2063.0
2018-11-20 05:00:00	IWM	ETF	148.27	148.4	148.24	148.4	11400.0
2018-11-20 06:00:00	IWM	ETF	148.41	148.51	148.41	148.51	1000.0
2018-11-20 07:00:00	IWM	ETF	148.57	148.57	147.75	147.75	72506.0
2018-11-20 08:00:00	IWM	ETF	148.86	148.86	147.3	147.32	216486.0
2018-11-20 09:00:00	IWM	ETF	147.37	147.71	146.08	146.43	3823579.0
2018-11-20 10:00:00	IWM	ETF	146.4499	148.23	145.59	148.18	4334820.0
2018-11-20 11:00:00	IWM	ETF	148.1714	148.43	146.86	147.77	3184517.0
2018-11-20 12:00:00	IWM	ETF	147.77	148.14	146.35	146.45	2742070.0
2018-11-20 13:00:00	IWM	ETF	146.43	146.93	145.99	146.13	1871124.0
2018-11-20 14:00:00	IWM	ETF	146.12	146.8	145.9199	146.125	1877480.0
2018-11-20 15:00:00	IWM	ETF	146.13	146.7699	145.64	146.06	4881553.0
2018-11-20 16:00:00	IWM	ETF	146.06	156.0	145.25	145.73	1177446.0
2018-11-20 17:00:00	IWM	ETF	145.61	145.8	145.35	145.65	10561.0
2018-11-20 18:00:00	IWM	ETF	145.8	145.8	145.58	145.7	11370.0
2018-11-20 19:00:00	IWM	ETF	145.79	146.09	145.78	146.02	8420.0
2018-11-20 04:00:00	DIA	ETF	248.88	248.88	248.3	248.76	1029.0
2018-11-20 05:00:00	DIA	ETF	248.64	248.78	248.64	248.7	2300.0

> showing 50 of 11,010 rows — these rows as CSV

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