PREVIEW / etf_1hour / 2018-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-04.parquet
  size:    309 KB
  rows:    10,069

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-04-04 04:00:00	SPY	ETF	257.98	258.12	256.39	257.24	155563.0
2018-04-04 05:00:00	SPY	ETF	257.2	257.23	256.75	257.07	57265.0
2018-04-04 06:00:00	SPY	ETF	257.07	257.07	255.39	256.26	217207.0
2018-04-04 07:00:00	SPY	ETF	256.32	257.24	256.3	256.95	1118644.0
2018-04-04 08:00:00	SPY	ETF	256.71	259.3	256.29	257.2	2286288.0
2018-04-04 09:00:00	SPY	ETF	257.29	258.37	256.6	258.34	14878632.0
2018-04-04 10:00:00	SPY	ETF	258.33	259.6	257.6	259.5	17669400.0
2018-04-04 11:00:00	SPY	ETF	259.5	260.48	258.78	260.06	12712067.0
2018-04-04 12:00:00	SPY	ETF	260.0544	261.41	259.76	260.88	10609687.0
2018-04-04 13:00:00	SPY	ETF	260.89	261.02	259.59	260.39	10072371.0
2018-04-04 14:00:00	SPY	ETF	260.4	262.79	260.31	262.67	12952732.0
2018-04-04 15:00:00	SPY	ETF	262.65	264.355	262.45	263.83	26070039.0
2018-04-04 16:00:00	SPY	ETF	263.79	264.16	263.56	263.88	11458463.0
2018-04-04 17:00:00	SPY	ETF	263.9	264.05	257.39	263.95	328224.0
2018-04-04 18:00:00	SPY	ETF	263.95	264.45	263.82	264.36	70431.0
2018-04-04 19:00:00	SPY	ETF	264.3	264.62	264.13	264.57	121916.0
2018-04-04 20:00:00	SPY	ETF	263.56	264.57	263.56	264.53	1540.0
2018-04-04 04:00:00	QQQ	ETF	155.13	155.26	153.75	154.33	196369.0
2018-04-04 05:00:00	QQQ	ETF	154.33	154.45	153.97	154.4	84728.0
2018-04-04 06:00:00	QQQ	ETF	154.34	154.37	153.37	153.99	91248.0
2018-04-04 07:00:00	QQQ	ETF	154.0	154.69	154.0	154.48	468041.0
2018-04-04 08:00:00	QQQ	ETF	154.57	154.89	153.95	154.81	1471189.0
2018-04-04 09:00:00	QQQ	ETF	154.88	155.6	154.04	155.415	7852396.0
2018-04-04 10:00:00	QQQ	ETF	155.4	156.3	154.73	156.25	7638288.0
2018-04-04 11:00:00	QQQ	ETF	156.24	157.47	155.67	157.16	6931679.0
2018-04-04 12:00:00	QQQ	ETF	157.17	158.1577	156.941	157.48	6191774.0
2018-04-04 13:00:00	QQQ	ETF	157.4848	157.59	156.45	157.1199	5148519.0
2018-04-04 14:00:00	QQQ	ETF	157.12	158.8422	157.0199	158.77	8458239.0
2018-04-04 15:00:00	QQQ	ETF	158.74	160.23	158.59	159.74	10294241.0
2018-04-04 16:00:00	QQQ	ETF	159.71	160.09	159.61	160.0	2305617.0
2018-04-04 17:00:00	QQQ	ETF	159.92	160.17	159.74	160.07	365190.0
2018-04-04 18:00:00	QQQ	ETF	160.03	160.3	159.84	160.28	81469.0
2018-04-04 19:00:00	QQQ	ETF	160.25	160.48	160.06	160.39	64301.0
2018-04-04 04:00:00	IWM	ETF	148.71	148.71	147.85	148.29	28490.0
2018-04-04 05:00:00	IWM	ETF	148.0	148.11	148.0	148.11	2485.0
2018-04-04 06:00:00	IWM	ETF	148.0	148.0	147.5	147.66	18158.0
2018-04-04 07:00:00	IWM	ETF	147.9	148.55	147.9	148.49	173380.0
2018-04-04 08:00:00	IWM	ETF	148.49	150.25	147.83	148.98	412882.0
2018-04-04 09:00:00	IWM	ETF	148.96	149.78	148.27	149.63	3994806.0
2018-04-04 10:00:00	IWM	ETF	149.63	150.51	149.091	150.2	3846014.0
2018-04-04 11:00:00	IWM	ETF	150.21	150.835	149.78	150.4132	1921763.0
2018-04-04 12:00:00	IWM	ETF	150.42	151.34	150.26	150.89	1525310.0
2018-04-04 13:00:00	IWM	ETF	150.89	150.982	150.22	150.46	1538114.0
2018-04-04 14:00:00	IWM	ETF	150.47	151.87	150.45	151.82	2438700.0
2018-04-04 15:00:00	IWM	ETF	151.81	152.58	151.53	152.15	5143176.0
2018-04-04 16:00:00	IWM	ETF	152.15	152.42	152.02	152.12	1289821.0
2018-04-04 17:00:00	IWM	ETF	152.13	152.21	152.06	152.21	785190.0
2018-04-04 18:00:00	IWM	ETF	152.19	152.53	152.06	152.49	24135.0
2018-04-04 19:00:00	IWM	ETF	152.34	152.56	152.26	152.54	8479.0
2018-04-04 04:00:00	DIA	ETF	237.3	237.36	235.64	235.9	2598.0

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

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