PREVIEW / etf_1hour / 2018-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-25.parquet
  size:    333 KB
  rows:    10,893

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-10-25 04:00:00	SPY	ETF	267.43	267.75	267.2	267.68	167710.0
2018-10-25 05:00:00	SPY	ETF	267.66	268.67	267.55	268.57	209833.0
2018-10-25 06:00:00	SPY	ETF	268.65	268.65	267.61	268.06	259392.0
2018-10-25 07:00:00	SPY	ETF	268.0	268.22	267.33	267.49	698441.0
2018-10-25 08:00:00	SPY	ETF	267.97	268.18	265.91	267.25	1778872.0
2018-10-25 09:00:00	SPY	ETF	267.22	268.3	266.23	268.09	17650374.0
2018-10-25 10:00:00	SPY	ETF	268.09	269.44	267.77	268.67	20726946.0
2018-10-25 11:00:00	SPY	ETF	268.66	270.1	267.94	269.44	15848930.0
2018-10-25 12:00:00	SPY	ETF	269.44	269.8	268.655	269.58	11855712.0
2018-10-25 13:00:00	SPY	ETF	269.59	270.27	268.75	269.81	9702566.0
2018-10-25 14:00:00	SPY	ETF	269.8	271.8	269.54	271.2801	15974929.0
2018-10-25 15:00:00	SPY	ETF	271.285	271.81	269.56	270.14	26476823.0
2018-10-25 16:00:00	SPY	ETF	270.11	271.0	267.29	267.55	13951477.0
2018-10-25 17:00:00	SPY	ETF	267.56	270.08	265.1418	267.26	902132.0
2018-10-25 18:00:00	SPY	ETF	267.26	267.47	266.21	267.4	358156.0
2018-10-25 19:00:00	SPY	ETF	267.39	267.49	267.0	267.05	82743.0
2018-10-25 20:00:00	SPY	ETF	270.08	270.08	267.03	267.05	520.0
2018-10-25 04:00:00	QQQ	ETF	167.76	168.4	167.66	168.27	180991.0
2018-10-25 05:00:00	QQQ	ETF	168.3	169.36	168.25	169.36	261316.0
2018-10-25 06:00:00	QQQ	ETF	169.36	169.36	168.47	168.64	240476.0
2018-10-25 07:00:00	QQQ	ETF	168.62	168.62	167.92	168.14	340772.0
2018-10-25 08:00:00	QQQ	ETF	168.12	168.73	166.8	167.74	731424.0
2018-10-25 09:00:00	QQQ	ETF	167.72	169.22	167.16	169.08	11852152.0
2018-10-25 10:00:00	QQQ	ETF	169.08	170.189	168.66	169.46	12039160.0
2018-10-25 11:00:00	QQQ	ETF	169.47	170.51	168.96	170.07	6438268.0
2018-10-25 12:00:00	QQQ	ETF	170.08	170.3185	169.29	169.9	4457923.0
2018-10-25 13:00:00	QQQ	ETF	169.9	170.56	169.4	170.36	4745661.0
2018-10-25 14:00:00	QQQ	ETF	170.36	172.08	170.1	171.64	7069299.0
2018-10-25 15:00:00	QQQ	ETF	171.64	172.01	170.77	170.96	17315825.0
2018-10-25 16:00:00	QQQ	ETF	170.95	171.06	167.5	167.55	8172409.0
2018-10-25 17:00:00	QQQ	ETF	167.46	168.43	166.61	167.3	1120088.0
2018-10-25 18:00:00	QQQ	ETF	167.2	167.82	166.46	167.8	372739.0
2018-10-25 19:00:00	QQQ	ETF	167.76	167.8	167.27	167.37	128290.0
2018-10-25 04:00:00	IWM	ETF	147.0	147.13	146.81	147.1	18161.0
2018-10-25 05:00:00	IWM	ETF	147.2	147.64	147.06	147.56	10800.0
2018-10-25 06:00:00	IWM	ETF	147.65	147.65	147.2	147.41	12587.0
2018-10-25 07:00:00	IWM	ETF	147.38	147.45	146.81	146.99	108925.0
2018-10-25 08:00:00	IWM	ETF	147.43	147.43	146.73	146.89	189113.0
2018-10-25 09:00:00	IWM	ETF	146.83	148.21	146.41	147.92	4825676.0
2018-10-25 10:00:00	IWM	ETF	147.93	149.03	147.39	148.53	5631894.0
2018-10-25 11:00:00	IWM	ETF	148.54	149.52	148.3231	148.92	3686744.0
2018-10-25 12:00:00	IWM	ETF	148.91	149.14	148.3338	148.74	2059531.0
2018-10-25 13:00:00	IWM	ETF	148.74	149.17	148.32	148.8	2235411.0
2018-10-25 14:00:00	IWM	ETF	148.79	149.82	148.66	149.63	2703811.0
2018-10-25 15:00:00	IWM	ETF	149.63	149.77	148.8	149.06	5637697.0
2018-10-25 16:00:00	IWM	ETF	149.06	149.14	147.98	148.13	1287460.0
2018-10-25 17:00:00	IWM	ETF	148.29	148.29	147.31	147.73	52919.0
2018-10-25 18:00:00	IWM	ETF	147.75	147.86	147.27	147.85	23735.0
2018-10-25 19:00:00	IWM	ETF	147.81	147.92	147.72	147.76	8204.0
2018-10-25 04:00:00	DIA	ETF	247.37	247.89	247.37	247.8	900.0

> showing 50 of 10,893 rows — these rows as CSV

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