PREVIEW / etf_1hour / 2018-12-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	246.31	246.49	245.81	246.36	67224.0
2018-12-21 05:00:00	SPY	ETF	246.35	246.61	245.67	246.6	82638.0
2018-12-21 06:00:00	SPY	ETF	246.55	247.06	246.43	246.7	81199.0
2018-12-21 07:00:00	SPY	ETF	246.71	246.9	246.14	246.65	368552.0
2018-12-21 08:00:00	SPY	ETF	246.65	248.24	246.0	247.6	1402215.0
2018-12-21 09:00:00	SPY	ETF	247.64	248.25	246.1	246.77	25970564.0
2018-12-21 10:00:00	SPY	ETF	246.8	249.71	246.01	247.2	36397953.0
2018-12-21 11:00:00	SPY	ETF	247.21	247.23	245.02	245.28	25360677.0
2018-12-21 12:00:00	SPY	ETF	245.28	245.58	242.57	243.6	32366761.0
2018-12-21 13:00:00	SPY	ETF	243.61	244.86	243.067	243.62	18995960.0
2018-12-21 14:00:00	SPY	ETF	243.62	244.13	242.43	243.0	18952050.0
2018-12-21 15:00:00	SPY	ETF	242.99	243.42	239.98	240.69	52526832.0
2018-12-21 16:00:00	SPY	ETF	240.62	241.24	240.11	241.09	34279014.0
2018-12-21 17:00:00	SPY	ETF	241.1	241.1	240.41	240.68	3033578.0
2018-12-21 18:00:00	SPY	ETF	240.6	240.7	240.18	240.3	459747.0
2018-12-21 19:00:00	SPY	ETF	240.3	240.7	240.26	240.35	173454.0
2018-12-21 04:00:00	QQQ	ETF	152.88	153.09	152.5	153.09	35068.0
2018-12-21 05:00:00	QQQ	ETF	153.03	153.22	152.67	153.16	22039.0
2018-12-21 06:00:00	QQQ	ETF	153.15	153.54	153.07	153.19	26610.0
2018-12-21 07:00:00	QQQ	ETF	153.18	153.29	152.73	153.0	89909.0
2018-12-21 08:00:00	QQQ	ETF	153.0	154.11	152.29	153.75	588253.0
2018-12-21 09:00:00	QQQ	ETF	153.75	154.25	152.2	152.59	12499374.0
2018-12-21 10:00:00	QQQ	ETF	152.59	154.09	151.49	152.29	18921640.0
2018-12-21 11:00:00	QQQ	ETF	152.29	152.31	150.34	150.4849	12919895.0
2018-12-21 12:00:00	QQQ	ETF	150.48	150.54	148.24	149.37	22398191.0
2018-12-21 13:00:00	QQQ	ETF	149.37	150.33	149.04	149.43	12674797.0
2018-12-21 14:00:00	QQQ	ETF	149.42	149.82	148.54	149.05	10924154.0
2018-12-21 15:00:00	QQQ	ETF	149.04	149.21	146.72	147.58	25740636.0
2018-12-21 16:00:00	QQQ	ETF	147.57	148.06	147.35	147.96	4200559.0
2018-12-21 17:00:00	QQQ	ETF	147.85	148.0	147.4	147.5	5532708.0
2018-12-21 18:00:00	QQQ	ETF	147.49	147.57	147.21	147.35	105211.0
2018-12-21 19:00:00	QQQ	ETF	147.31	147.4	147.15	147.23	47766.0
2018-12-21 04:00:00	IWM	ETF	131.79	131.8	131.77	131.8	4900.0
2018-12-21 05:00:00	IWM	ETF	131.67	131.75	131.67	131.75	2600.0
2018-12-21 06:00:00	IWM	ETF	131.89	132.37	131.89	132.34	12170.0
2018-12-21 07:00:00	IWM	ETF	132.23	132.32	131.96	132.1	10159.0
2018-12-21 08:00:00	IWM	ETF	131.94	132.91	131.8	132.48	90799.0
2018-12-21 09:00:00	IWM	ETF	132.7	132.9	131.02	131.57	5340109.0
2018-12-21 10:00:00	IWM	ETF	131.57	132.95	130.82	131.88	9218087.0
2018-12-21 11:00:00	IWM	ETF	131.85	131.96	130.26	130.33	4395870.0
2018-12-21 12:00:00	IWM	ETF	130.33	130.36	128.78	129.04	7767104.0
2018-12-21 13:00:00	IWM	ETF	129.03	130.1	128.79	129.4	3822077.0
2018-12-21 14:00:00	IWM	ETF	129.39	129.75	128.9	129.32	3706192.0
2018-12-21 15:00:00	IWM	ETF	129.32	129.49	127.98	128.29	10683941.0
2018-12-21 16:00:00	IWM	ETF	128.25	129.0	128.16	128.9	2204422.0
2018-12-21 17:00:00	IWM	ETF	128.9	144.02	128.37	128.4	1155559.0
2018-12-21 18:00:00	IWM	ETF	128.4	128.41	128.09	128.39	194041.0
2018-12-21 19:00:00	IWM	ETF	128.37	128.39	128.25	128.3	3411.0
2018-12-21 04:00:00	DIA	ETF	228.65	228.95	228.52	228.9	23400.0
2018-12-21 05:00:00	DIA	ETF	228.5	229.0	228.5	229.0	5499.0

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

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