PREVIEW / etf_1hour / 2019-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-22.parquet
  size:    330 KB
  rows:    10,913

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
2019-03-22 04:00:00	SPY	ETF	284.73	284.86	283.42	283.46	32102.0
2019-03-22 05:00:00	SPY	ETF	283.6	283.92	283.35	283.64	29335.0
2019-03-22 06:00:00	SPY	ETF	283.58	283.78	283.34	283.7	117370.0
2019-03-22 07:00:00	SPY	ETF	283.71	283.86	283.49	283.69	375812.0
2019-03-22 08:00:00	SPY	ETF	283.63	284.92	282.91	283.49	1203412.0
2019-03-22 09:00:00	SPY	ETF	283.41	283.8034	281.73	281.93	11032369.0
2019-03-22 10:00:00	SPY	ETF	281.94	283.01	281.41	281.4599	15073473.0
2019-03-22 11:00:00	SPY	ETF	281.45	281.87	279.62	279.64	18969626.0
2019-03-22 12:00:00	SPY	ETF	279.65	280.42	279.33	280.25	15550906.0
2019-03-22 13:00:00	SPY	ETF	280.25	280.63	279.65	279.81	10543684.0
2019-03-22 14:00:00	SPY	ETF	279.8	281.44	279.74	281.185	12247816.0
2019-03-22 15:00:00	SPY	ETF	281.19	281.51	279.18	279.25	24959923.0
2019-03-22 16:00:00	SPY	ETF	279.26	280.03	279.2317	279.35	8702111.0
2019-03-22 17:00:00	SPY	ETF	279.46	279.74	279.06	279.27	713306.0
2019-03-22 18:00:00	SPY	ETF	279.21	279.74	279.21	279.42	443234.0
2019-03-22 19:00:00	SPY	ETF	279.47	279.58	279.2	279.25	71764.0
2019-03-22 04:00:00	QQQ	ETF	182.78	182.85	181.93	181.99	24802.0
2019-03-22 05:00:00	QQQ	ETF	182.01	182.3	181.91	182.14	24925.0
2019-03-22 06:00:00	QQQ	ETF	182.17	182.17	181.88	181.99	101956.0
2019-03-22 07:00:00	QQQ	ETF	182.03	182.23	181.99	182.11	80759.0
2019-03-22 08:00:00	QQQ	ETF	182.03	182.67	181.62	181.97	393683.0
2019-03-22 09:00:00	QQQ	ETF	181.93	182.27	180.53	180.725	6819656.0
2019-03-22 10:00:00	QQQ	ETF	180.73	181.6985	180.421	180.55	8353851.0
2019-03-22 11:00:00	QQQ	ETF	180.541	180.72	179.1	179.11	9471059.0
2019-03-22 12:00:00	QQQ	ETF	179.12	179.73	178.93	179.58	7879737.0
2019-03-22 13:00:00	QQQ	ETF	179.57	179.87	178.82	178.95	4528515.0
2019-03-22 14:00:00	QQQ	ETF	178.94	179.98	178.89	179.84	5424576.0
2019-03-22 15:00:00	QQQ	ETF	179.85	180.05	178.37	178.49	10827955.0
2019-03-22 16:00:00	QQQ	ETF	178.48	178.94	178.4476	178.53	5794508.0
2019-03-22 17:00:00	QQQ	ETF	178.58	180.0347	178.3	178.42	27090.0
2019-03-22 18:00:00	QQQ	ETF	178.44	178.66	178.44	178.58	16354.0
2019-03-22 19:00:00	QQQ	ETF	178.57	178.63	178.43	178.43	9882.0
2019-03-22 04:00:00	IWM	ETF	155.15	155.15	154.41	154.5	8478.0
2019-03-22 05:00:00	IWM	ETF	154.6	154.6	154.31	154.49	8823.0
2019-03-22 06:00:00	IWM	ETF	154.47	154.54	154.47	154.51	4996.0
2019-03-22 07:00:00	IWM	ETF	154.52	154.59	154.43	154.43	4600.0
2019-03-22 08:00:00	IWM	ETF	154.52	154.56	154.0	154.45	161256.0
2019-03-22 09:00:00	IWM	ETF	154.37	154.545	152.91	152.99	2622284.0
2019-03-22 10:00:00	IWM	ETF	152.99	153.52	152.05	152.08	4461792.0
2019-03-22 11:00:00	IWM	ETF	152.06	152.16	150.23	150.265	6260470.0
2019-03-22 12:00:00	IWM	ETF	150.27	150.75	149.86	150.3	7291928.0
2019-03-22 13:00:00	IWM	ETF	150.3	150.63	149.99	150.05	2607028.0
2019-03-22 14:00:00	IWM	ETF	150.05	151.1	150.0	151.02	2478987.0
2019-03-22 15:00:00	IWM	ETF	151.02	151.24	149.57	149.6	8763492.0
2019-03-22 16:00:00	IWM	ETF	149.6	150.03	149.56	149.56	1474710.0
2019-03-22 17:00:00	IWM	ETF	149.62	149.62	149.5	149.58	675567.0
2019-03-22 18:00:00	IWM	ETF	149.57	149.62	149.57	149.62	75332.0
2019-03-22 19:00:00	IWM	ETF	149.6	149.69	149.55	149.55	9604.0
2019-03-22 04:00:00	DIA	ETF	259.45	259.45	258.38	258.38	1800.0
2019-03-22 05:00:00	DIA	ETF	258.48	258.48	258.48	258.48	500.0

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

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