PREVIEW / etf_1hour / 2018-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-26.parquet
  size:    327 KB
  rows:    10,873

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-26 04:00:00	SPY	ETF	266.0	266.22	265.33	265.66	80978.0
2018-10-26 05:00:00	SPY	ETF	265.59	265.59	264.1	264.68	372962.0
2018-10-26 06:00:00	SPY	ETF	264.68	265.28	264.51	264.94	284281.0
2018-10-26 07:00:00	SPY	ETF	264.99	265.8	264.99	265.22	634662.0
2018-10-26 08:00:00	SPY	ETF	265.22	267.07	264.75	266.25	2325607.0
2018-10-26 09:00:00	SPY	ETF	266.22	271.0	265.1	265.81	16327890.0
2018-10-26 10:00:00	SPY	ETF	265.8	265.81	262.29	262.48	29813727.0
2018-10-26 11:00:00	SPY	ETF	262.44	266.19	262.32	265.31	22790563.0
2018-10-26 12:00:00	SPY	ETF	265.31	268.32	265.22	267.56	18956903.0
2018-10-26 13:00:00	SPY	ETF	267.55	268.78	265.95	267.29	16814051.0
2018-10-26 14:00:00	SPY	ETF	267.3	267.59	264.13	264.47	20372996.0
2018-10-26 15:00:00	SPY	ETF	264.46	266.79	263.6601	265.29	51782336.0
2018-10-26 16:00:00	SPY	ETF	265.27	270.0735	265.01	265.7	16146662.0
2018-10-26 17:00:00	SPY	ETF	265.89	266.43	265.33	266.43	883809.0
2018-10-26 18:00:00	SPY	ETF	266.43	266.51	266.32	266.37	98983.0
2018-10-26 19:00:00	SPY	ETF	266.37	266.5	266.21	266.37	35853.0
2018-10-26 04:00:00	QQQ	ETF	166.7	166.7	165.77	166.01	171567.0
2018-10-26 05:00:00	QQQ	ETF	165.99	166.01	163.86	164.22	256140.0
2018-10-26 06:00:00	QQQ	ETF	164.21	165.1	163.89	164.5	187254.0
2018-10-26 07:00:00	QQQ	ETF	164.55	165.41	164.55	165.0	739487.0
2018-10-26 08:00:00	QQQ	ETF	164.7201	166.7	164.46	165.73	1714297.0
2018-10-26 09:00:00	QQQ	ETF	165.72	167.76	164.76	167.0	16188763.0
2018-10-26 10:00:00	QQQ	ETF	166.99	166.99	164.23	164.4	18882455.0
2018-10-26 11:00:00	QQQ	ETF	164.38	167.29	164.25	166.92	15115987.0
2018-10-26 12:00:00	QQQ	ETF	166.91	169.46	166.88	168.86	12339091.0
2018-10-26 13:00:00	QQQ	ETF	168.85	169.96	167.27	168.21	16141849.0
2018-10-26 14:00:00	QQQ	ETF	168.21	168.43	165.87	166.14	9594494.0
2018-10-26 15:00:00	QQQ	ETF	166.12	167.62	165.54	166.79	22739439.0
2018-10-26 16:00:00	QQQ	ETF	166.8	167.71	166.56	167.12	3849128.0
2018-10-26 17:00:00	QQQ	ETF	167.08	167.67	166.66	167.39	1335666.0
2018-10-26 18:00:00	QQQ	ETF	167.48	167.5	167.3	167.31	7175.0
2018-10-26 19:00:00	QQQ	ETF	167.31	167.39	167.17	167.3	14892.0
2018-10-26 04:00:00	IWM	ETF	147.26	147.26	146.88	146.99	4340.0
2018-10-26 05:00:00	IWM	ETF	147.0	147.0	146.15	146.4	19680.0
2018-10-26 06:00:00	IWM	ETF	146.54	146.9	146.39	146.82	33695.0
2018-10-26 07:00:00	IWM	ETF	146.93	147.23	146.9	147.0	58850.0
2018-10-26 08:00:00	IWM	ETF	147.0001	147.73	146.7	147.69	372753.0
2018-10-26 09:00:00	IWM	ETF	147.65	147.79	146.83	146.98	3822665.0
2018-10-26 10:00:00	IWM	ETF	146.96	146.96	144.81	144.845	6177183.0
2018-10-26 11:00:00	IWM	ETF	144.84	147.4	144.7	146.695	4826710.0
2018-10-26 12:00:00	IWM	ETF	146.69	148.79	146.65	148.4642	3635532.0
2018-10-26 13:00:00	IWM	ETF	148.45	149.42	147.71	148.66	3614827.0
2018-10-26 14:00:00	IWM	ETF	148.66	148.8299	147.09	147.2	3299762.0
2018-10-26 15:00:00	IWM	ETF	147.19	148.07	146.7	147.4	6779759.0
2018-10-26 16:00:00	IWM	ETF	147.38	148.14	147.37	147.74	1341233.0
2018-10-26 17:00:00	IWM	ETF	147.96	147.9999	147.65	147.75	19522.0
2018-10-26 18:00:00	IWM	ETF	148.08	148.08	147.86	147.86	4694.0
2018-10-26 19:00:00	IWM	ETF	147.71	147.99	147.71	147.99	7767.0
2018-10-26 04:00:00	DIA	ETF	246.9	247.08	246.62	246.75	3499.0
2018-10-26 05:00:00	DIA	ETF	246.3	246.6	246.16	246.16	2333.0

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

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