PREVIEW / etf_1hour / 2020-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-20.parquet
  size:    401 KB
  rows:    13,714

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
2020-03-20 04:00:00	SPY	ETF	243.85	249.79	243.85	248.89	347903.0
2020-03-20 05:00:00	SPY	ETF	249.0	250.08	247.74	249.48	345281.0
2020-03-20 06:00:00	SPY	ETF	249.48	249.96	246.0	246.75	700080.0
2020-03-20 07:00:00	SPY	ETF	246.52	246.75	242.8	244.74	1620665.0
2020-03-20 08:00:00	SPY	ETF	237.698	249.795	237.698	240.77	3743756.0
2020-03-20 09:00:00	SPY	ETF	240.79	243.55	236.61	239.11	36438001.0
2020-03-20 10:00:00	SPY	ETF	239.1	244.41	238.82	244.06	57356040.0
2020-03-20 11:00:00	SPY	ETF	244.05	244.47	237.74	238.82	47382928.0
2020-03-20 12:00:00	SPY	ETF	238.79	242.5416	234.3	237.47	37020876.0
2020-03-20 13:00:00	SPY	ETF	237.475	239.7899	236.44	237.83	22889265.0
2020-03-20 14:00:00	SPY	ETF	237.835	238.89	231.2	232.31	31170788.0
2020-03-20 15:00:00	SPY	ETF	232.31	234.91	228.5	228.94	72947275.0
2020-03-20 16:00:00	SPY	ETF	228.94	230.41	226.41	227.1999	27359225.0
2020-03-20 17:00:00	SPY	ETF	227.02	228.8	226.4	226.7	3138419.0
2020-03-20 18:00:00	SPY	ETF	226.64	229.685	226.61	227.0	2581732.0
2020-03-20 19:00:00	SPY	ETF	227.0	228.8	226.37	226.4	279340.0
2020-03-20 04:00:00	QQQ	ETF	183.0	186.72	183.0	186.72	199469.0
2020-03-20 05:00:00	QQQ	ETF	186.72	186.9	185.8	186.83	92607.0
2020-03-20 06:00:00	QQQ	ETF	186.84	186.98	185.31	185.71	177236.0
2020-03-20 07:00:00	QQQ	ETF	185.68	185.8	183.06	184.0	432281.0
2020-03-20 08:00:00	QQQ	ETF	184.1	185.62	175.7	181.6	560718.0
2020-03-20 09:00:00	QQQ	ETF	181.58	183.1	178.25	179.82	10239828.0
2020-03-20 10:00:00	QQQ	ETF	179.78	182.87	179.56	182.65	12874348.0
2020-03-20 11:00:00	QQQ	ETF	182.66	182.86	178.29	178.74	13029811.0
2020-03-20 12:00:00	QQQ	ETF	178.7	179.11	174.48	177.41	15575857.0
2020-03-20 13:00:00	QQQ	ETF	177.43	179.0499	176.49	177.54	7759229.0
2020-03-20 14:00:00	QQQ	ETF	177.54	178.53	172.99	173.65	12038658.0
2020-03-20 15:00:00	QQQ	ETF	173.65	175.42	170.1	170.74	19682723.0
2020-03-20 16:00:00	QQQ	ETF	170.75	171.35	168.88	169.68	3926929.0
2020-03-20 17:00:00	QQQ	ETF	169.68	170.7	169.05	169.1	629036.0
2020-03-20 18:00:00	QQQ	ETF	169.09	170.55	168.94	169.15	4075246.0
2020-03-20 19:00:00	QQQ	ETF	169.19	169.75	169.05	169.06	164742.0
2020-03-20 04:00:00	IWM	ETF	107.42	109.45	107.26	109.0	193191.0
2020-03-20 05:00:00	IWM	ETF	109.27	109.95	108.82	109.4	80335.0
2020-03-20 06:00:00	IWM	ETF	109.7	109.7	108.16	108.27	62866.0
2020-03-20 07:00:00	IWM	ETF	108.31	108.31	106.04	107.5	259174.0
2020-03-20 08:00:00	IWM	ETF	107.86	108.18	103.92	105.6899	282563.0
2020-03-20 09:00:00	IWM	ETF	105.61	108.04	104.05	105.31	6982273.0
2020-03-20 10:00:00	IWM	ETF	105.31	108.585	104.65	108.334	6593496.0
2020-03-20 11:00:00	IWM	ETF	108.35	108.76	104.36	105.496	5833941.0
2020-03-20 12:00:00	IWM	ETF	105.52	105.9	102.28	104.95	9006694.0
2020-03-20 13:00:00	IWM	ETF	104.97	106.5	104.72	105.79	4687498.0
2020-03-20 14:00:00	IWM	ETF	105.8	106.0	101.4089	101.93	7391786.0
2020-03-20 15:00:00	IWM	ETF	101.93	103.43	100.45	101.29	18357094.0
2020-03-20 16:00:00	IWM	ETF	101.25	102.08	99.63	100.0	2817820.0
2020-03-20 17:00:00	IWM	ETF	100.0	101.4	99.87	99.9299	666276.0
2020-03-20 18:00:00	IWM	ETF	99.93	101.78	99.51	99.87	1011787.0
2020-03-20 19:00:00	IWM	ETF	99.86	101.4	99.86	100.1	73925.0
2020-03-20 04:00:00	DIA	ETF	207.18	210.0	206.39	208.56	54052.0
2020-03-20 05:00:00	DIA	ETF	208.61	209.55	207.75	209.11	10155.0

> showing 50 of 13,714 rows — these rows as CSV

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