PREVIEW / etf_1hour / 2020-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-16.parquet
  size:    384 KB
  rows:    13,084

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-04-16 04:00:00	SPY	ETF	279.89	280.26	279.35	279.39	86295.0
2020-04-16 05:00:00	SPY	ETF	279.17	279.52	278.59	279.25	88121.0
2020-04-16 06:00:00	SPY	ETF	279.28	279.74	278.4	279.16	148148.0
2020-04-16 07:00:00	SPY	ETF	279.2	279.25	277.89	278.3	428636.0
2020-04-16 08:00:00	SPY	ETF	279.02	280.7	276.32	279.15	2181322.0
2020-04-16 09:00:00	SPY	ETF	279.08	279.7393	276.69	276.8167	10665277.0
2020-04-16 10:00:00	SPY	ETF	276.81	278.63	275.76	278.52	16560956.0
2020-04-16 11:00:00	SPY	ETF	278.51	280.03	278.18	279.72	15439637.0
2020-04-16 12:00:00	SPY	ETF	279.72	279.99	275.84	277.27	19190577.0
2020-04-16 13:00:00	SPY	ETF	277.27	278.2	276.99	277.4401	12286269.0
2020-04-16 14:00:00	SPY	ETF	277.48	279.0	276.8	278.34	12059824.0
2020-04-16 15:00:00	SPY	ETF	278.31	279.98	277.54	279.21	23600621.0
2020-04-16 16:00:00	SPY	ETF	279.16	283.4	278.89	283.3	7764255.0
2020-04-16 17:00:00	SPY	ETF	283.23	289.4	279.1	286.8	4655865.0
2020-04-16 18:00:00	SPY	ETF	286.8	288.5	285.55	288.06	3895005.0
2020-04-16 19:00:00	SPY	ETF	288.05	289.07	286.56	287.5	1745986.0
2020-04-16 04:00:00	QQQ	ETF	211.43	212.0	211.41	211.47	95367.0
2020-04-16 05:00:00	QQQ	ETF	211.48	211.63	210.89	211.36	51130.0
2020-04-16 06:00:00	QQQ	ETF	211.47	211.8	210.78	211.62	53058.0
2020-04-16 07:00:00	QQQ	ETF	211.56	211.56	210.5	210.81	250973.0
2020-04-16 08:00:00	QQQ	ETF	211.42	212.25	208.68	211.83	667838.0
2020-04-16 09:00:00	QQQ	ETF	211.81	212.25	210.82	210.89	6051835.0
2020-04-16 10:00:00	QQQ	ETF	210.89	212.63	209.69	212.44	8617912.0
2020-04-16 11:00:00	QQQ	ETF	212.44	214.3	212.13	214.08	7980118.0
2020-04-16 12:00:00	QQQ	ETF	214.075	214.369	210.02	211.42	8112299.0
2020-04-16 13:00:00	QQQ	ETF	211.42	212.2	210.97	211.43	4653235.0
2020-04-16 14:00:00	QQQ	ETF	211.45	212.83	210.87	212.3314	4701785.0
2020-04-16 15:00:00	QQQ	ETF	212.34	213.88	211.51	213.35	8618809.0
2020-04-16 16:00:00	QQQ	ETF	213.33	215.73	212.377	215.53	1569714.0
2020-04-16 17:00:00	QQQ	ETF	215.5	218.5	213.12	217.59	1411923.0
2020-04-16 18:00:00	QQQ	ETF	217.59	218.01	216.6	217.72	948324.0
2020-04-16 19:00:00	QQQ	ETF	217.72	218.85	217.5	218.11	667563.0
2020-04-16 04:00:00	IWM	ETF	118.84	119.26	118.74	118.74	21337.0
2020-04-16 05:00:00	IWM	ETF	118.52	118.52	118.19	118.25	4100.0
2020-04-16 06:00:00	IWM	ETF	118.0	118.59	117.92	118.56	11631.0
2020-04-16 07:00:00	IWM	ETF	118.44	118.52	117.64	117.67	72374.0
2020-04-16 08:00:00	IWM	ETF	117.69	119.19	117.07	118.02	373746.0
2020-04-16 09:00:00	IWM	ETF	118.02	118.42	116.21	116.26	3210538.0
2020-04-16 10:00:00	IWM	ETF	116.26	117.51	115.375	117.35	6524066.0
2020-04-16 11:00:00	IWM	ETF	117.38	117.69	115.94	116.51	4641983.0
2020-04-16 12:00:00	IWM	ETF	116.53	116.67	114.555	115.1303	4920329.0
2020-04-16 13:00:00	IWM	ETF	115.14	115.75	114.925	115.18	3344073.0
2020-04-16 14:00:00	IWM	ETF	115.15	116.18	114.88	115.8	3588531.0
2020-04-16 15:00:00	IWM	ETF	115.77	117.1	115.32	116.95	6941140.0
2020-04-16 16:00:00	IWM	ETF	116.95	120.41	116.55	120.39	2573841.0
2020-04-16 17:00:00	IWM	ETF	120.38	124.49	120.16	122.85	1536248.0
2020-04-16 18:00:00	IWM	ETF	122.75	123.0	116.91	122.9	1069628.0
2020-04-16 19:00:00	IWM	ETF	122.95	123.95	122.54	123.01	267668.0
2020-04-16 04:00:00	DIA	ETF	236.5	237.08	236.5	236.64	3850.0
2020-04-16 05:00:00	DIA	ETF	236.01	236.3	235.88	236.09	4250.0

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

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