PREVIEW / etf_1hour / 2018-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-28.parquet
  size:    349 KB
  rows:    11,340

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-28 04:00:00	SPY	ETF	248.9	249.28	248.58	249.28	49165.0
2018-12-28 05:00:00	SPY	ETF	249.25	250.32	249.25	250.09	158303.0
2018-12-28 06:00:00	SPY	ETF	250.1	251.16	249.39	250.02	291322.0
2018-12-28 07:00:00	SPY	ETF	250.02	250.31	249.14	249.81	440986.0
2018-12-28 08:00:00	SPY	ETF	249.55	250.14	247.6	249.92	692940.0
2018-12-28 09:00:00	SPY	ETF	249.88	250.11	248.31	249.46	18439138.0
2018-12-28 10:00:00	SPY	ETF	249.47	249.72	246.45	247.555	19295926.0
2018-12-28 11:00:00	SPY	ETF	247.56	249.02	247.05	248.55	13400630.0
2018-12-28 12:00:00	SPY	ETF	248.55	249.32	248.04	248.17	10455536.0
2018-12-28 13:00:00	SPY	ETF	248.18	249.0	247.37	248.57	11492187.0
2018-12-28 14:00:00	SPY	ETF	248.58	251.4	248.575	251.04	23064033.0
2018-12-28 15:00:00	SPY	ETF	251.06	251.255	246.9	247.81	40924035.0
2018-12-28 16:00:00	SPY	ETF	247.81	248.06	247.27	247.86	12279104.0
2018-12-28 17:00:00	SPY	ETF	247.86	247.99	247.34	247.58	188229.0
2018-12-28 18:00:00	SPY	ETF	247.57	247.75	247.51	247.55	14512.0
2018-12-28 19:00:00	SPY	ETF	247.52	247.66	247.52	247.57	26841.0
2018-12-28 04:00:00	QQQ	ETF	153.7	153.94	153.41	153.94	17660.0
2018-12-28 05:00:00	QQQ	ETF	154.0	154.55	153.96	154.4	97194.0
2018-12-28 06:00:00	QQQ	ETF	154.35	154.96	153.97	154.16	74062.0
2018-12-28 07:00:00	QQQ	ETF	154.19	154.48	153.63	154.01	506513.0
2018-12-28 08:00:00	QQQ	ETF	154.36	154.5	153.05	154.06	315679.0
2018-12-28 09:00:00	QQQ	ETF	154.07	154.28	152.68	153.83	8684830.0
2018-12-28 10:00:00	QQQ	ETF	153.82	153.95	151.72	152.46	9554056.0
2018-12-28 11:00:00	QQQ	ETF	152.47	153.75	152.12	153.5	6109290.0
2018-12-28 12:00:00	QQQ	ETF	153.51	154.04	153.16	153.4	4420731.0
2018-12-28 13:00:00	QQQ	ETF	153.4	153.86	152.7	153.59	4972281.0
2018-12-28 14:00:00	QQQ	ETF	153.6	155.59	153.6	155.4427	8068544.0
2018-12-28 15:00:00	QQQ	ETF	155.45	155.57	152.48	153.05	16380966.0
2018-12-28 16:00:00	QQQ	ETF	153.07	154.9162	152.67	152.9801	2121113.0
2018-12-28 17:00:00	QQQ	ETF	153.0	153.16	152.78	152.78	51019.0
2018-12-28 18:00:00	QQQ	ETF	152.95	152.97	152.9	152.9	3758.0
2018-12-28 19:00:00	QQQ	ETF	152.9	152.97	152.9	152.96	11591.0
2018-12-28 04:00:00	IWM	ETF	132.37	132.58	132.37	132.58	350.0
2018-12-28 05:00:00	IWM	ETF	132.68	133.14	132.68	132.97	22150.0
2018-12-28 06:00:00	IWM	ETF	132.95	133.4	132.69	132.82	14052.0
2018-12-28 07:00:00	IWM	ETF	133.0	133.06	132.87	133.06	42288.0
2018-12-28 08:00:00	IWM	ETF	133.0	133.07	131.85	132.78	117871.0
2018-12-28 09:00:00	IWM	ETF	132.73	133.67	132.05	133.06	3420054.0
2018-12-28 10:00:00	IWM	ETF	133.06	133.19	131.54	132.0151	5102794.0
2018-12-28 11:00:00	IWM	ETF	132.04	132.73	131.73	132.35	2650350.0
2018-12-28 12:00:00	IWM	ETF	132.36	132.88	132.1	132.13	2283219.0
2018-12-28 13:00:00	IWM	ETF	132.13	132.69	131.8064	132.61	2149216.0
2018-12-28 14:00:00	IWM	ETF	132.62	135.01	132.6	134.75	6806029.0
2018-12-28 15:00:00	IWM	ETF	134.745	134.84	132.63	132.89	8289973.0
2018-12-28 16:00:00	IWM	ETF	132.88	133.23	132.76	133.0	1624181.0
2018-12-28 17:00:00	IWM	ETF	133.0	133.12	132.85	132.86	30375.0
2018-12-28 18:00:00	IWM	ETF	132.9	133.0	132.9	132.99	3854.0
2018-12-28 19:00:00	IWM	ETF	132.96	133.0	132.96	133.0	6746.0
2018-12-28 04:00:00	DIA	ETF	231.43	231.87	231.43	231.71	412.0
2018-12-28 05:00:00	DIA	ETF	232.49	232.93	232.47	232.93	6100.0

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

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