PREVIEW / etf_1hour / 2018-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-31.parquet
  size:    353 KB
  rows:    11,611

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-12-31 04:00:00	SPY	ETF	249.62	249.9	249.57	249.85	46850.0
2018-12-31 05:00:00	SPY	ETF	249.86	249.95	249.6	249.82	44227.0
2018-12-31 06:00:00	SPY	ETF	249.78	249.95	249.7	249.87	45357.0
2018-12-31 07:00:00	SPY	ETF	249.86	250.4	249.8	250.25	211279.0
2018-12-31 08:00:00	SPY	ETF	247.75	250.35	247.75	249.43	545587.0
2018-12-31 09:00:00	SPY	ETF	249.44	250.16	249.12	249.39	11020322.0
2018-12-31 10:00:00	SPY	ETF	249.4	249.91	248.12	248.3999	12212011.0
2018-12-31 11:00:00	SPY	ETF	248.39	248.805	247.47	248.72	12035350.0
2018-12-31 12:00:00	SPY	ETF	248.73	249.44	248.26	249.36	9990367.0
2018-12-31 13:00:00	SPY	ETF	249.36	250.12	248.89	248.96	10870349.0
2018-12-31 14:00:00	SPY	ETF	248.9415	249.38	247.87	248.7	15621647.0
2018-12-31 15:00:00	SPY	ETF	248.7	250.12	248.06	250.12	34570556.0
2018-12-31 16:00:00	SPY	ETF	250.11	250.48	249.4	250.1	31510708.0
2018-12-31 17:00:00	SPY	ETF	250.11	250.15	249.79	250.15	1239859.0
2018-12-31 18:00:00	SPY	ETF	250.05	250.1	249.95	250.0	33950.0
2018-12-31 19:00:00	SPY	ETF	250.0	250.1	250.0	250.09	12944.0
2018-12-31 04:00:00	QQQ	ETF	154.11	154.35	154.08	154.35	10736.0
2018-12-31 05:00:00	QQQ	ETF	154.42	154.42	154.2	154.27	14958.0
2018-12-31 06:00:00	QQQ	ETF	154.31	154.48	154.31	154.48	15825.0
2018-12-31 07:00:00	QQQ	ETF	154.43	154.89	154.41	154.83	117414.0
2018-12-31 08:00:00	QQQ	ETF	154.83	154.89	154.1	154.32	341004.0
2018-12-31 09:00:00	QQQ	ETF	154.33	154.98	153.84	154.2256	4495136.0
2018-12-31 10:00:00	QQQ	ETF	154.24	154.58	153.05	153.26	5512555.0
2018-12-31 11:00:00	QQQ	ETF	153.27	153.8	152.71	153.74	6777235.0
2018-12-31 12:00:00	QQQ	ETF	153.75	154.31	153.43	154.12	4757702.0
2018-12-31 13:00:00	QQQ	ETF	154.13	154.64	153.7	153.76	3443755.0
2018-12-31 14:00:00	QQQ	ETF	153.76	154.05	153.065	153.61	4734211.0
2018-12-31 15:00:00	QQQ	ETF	153.6	154.26	153.01	154.25	8858392.0
2018-12-31 16:00:00	QQQ	ETF	154.26	154.57	153.5544	154.41	2341094.0
2018-12-31 17:00:00	QQQ	ETF	154.48	154.52	154.26	154.45	632543.0
2018-12-31 18:00:00	QQQ	ETF	154.4	154.55	154.35	154.37	3047.0
2018-12-31 19:00:00	QQQ	ETF	154.4	154.4	154.34	154.3401	3828.0
2018-12-31 04:00:00	IWM	ETF	133.86	134.0	133.86	134.0	4225.0
2018-12-31 05:00:00	IWM	ETF	134.11	134.11	133.87	133.9	18257.0
2018-12-31 06:00:00	IWM	ETF	133.95	134.02	133.9	133.97	35900.0
2018-12-31 07:00:00	IWM	ETF	133.91	134.25	133.91	134.21	14703.0
2018-12-31 08:00:00	IWM	ETF	134.05	134.25	133.73	133.79	42683.0
2018-12-31 09:00:00	IWM	ETF	133.75	134.05	132.81	133.18	2725938.0
2018-12-31 10:00:00	IWM	ETF	133.19	133.54	132.33	132.47	3300808.0
2018-12-31 11:00:00	IWM	ETF	132.47	132.82	131.8	132.76	3550493.0
2018-12-31 12:00:00	IWM	ETF	132.7701	133.17	132.52	133.06	2123581.0
2018-12-31 13:00:00	IWM	ETF	133.07	133.3927	132.83	132.84	1860073.0
2018-12-31 14:00:00	IWM	ETF	132.84	133.16	132.45	132.845	3113801.0
2018-12-31 15:00:00	IWM	ETF	132.85	133.95	132.57	133.92	6198154.0
2018-12-31 16:00:00	IWM	ETF	133.925	134.42	133.75	134.27	1877493.0
2018-12-31 17:00:00	IWM	ETF	134.11	134.23	133.9	133.9	778478.0
2018-12-31 18:00:00	IWM	ETF	134.03	134.12	134.03	134.05	1097.0
2018-12-31 19:00:00	IWM	ETF	134.05	134.27	134.05	134.23	820.0
2018-12-31 04:00:00	DIA	ETF	232.0	232.56	232.0	232.56	808.0
2018-12-31 06:00:00	DIA	ETF	232.68	232.7	232.68	232.7	2500.0

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

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