PREVIEW / etf_1hour / 2020-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-22.parquet
  size:    362 KB
  rows:    12,373

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-22 04:00:00	SPY	ETF	275.77	277.5	275.6	277.47	179785.0
2020-04-22 05:00:00	SPY	ETF	277.57	277.91	276.97	277.17	139266.0
2020-04-22 06:00:00	SPY	ETF	277.3	277.3	276.11	276.58	94468.0
2020-04-22 07:00:00	SPY	ETF	276.66	277.45	276.3	276.95	733582.0
2020-04-22 08:00:00	SPY	ETF	274.07	278.56	273.29	278.33	3321204.0
2020-04-22 09:00:00	SPY	ETF	278.31	278.9	277.05	277.81	9996231.0
2020-04-22 10:00:00	SPY	ETF	277.8	278.67	276.91	277.59	10829514.0
2020-04-22 11:00:00	SPY	ETF	277.625	279.05	277.26	278.68	8941554.0
2020-04-22 12:00:00	SPY	ETF	278.67	279.3	278.32	278.59	6891940.0
2020-04-22 13:00:00	SPY	ETF	278.6	279.5	278.22	279.24	7977008.0
2020-04-22 14:00:00	SPY	ETF	279.25	280.24	278.96	279.99	13060490.0
2020-04-22 15:00:00	SPY	ETF	280.0	281.0	279.07	279.17	24548575.0
2020-04-22 16:00:00	SPY	ETF	279.17	279.31	278.5	279.31	4661120.0
2020-04-22 17:00:00	SPY	ETF	279.28	279.37	279.12	279.36	136833.0
2020-04-22 18:00:00	SPY	ETF	279.18	279.43	278.2	278.26	349796.0
2020-04-22 19:00:00	SPY	ETF	278.42	278.45	277.65	278.15	339575.0
2020-04-22 04:00:00	QQQ	ETF	207.4	208.67	207.4	208.67	171921.0
2020-04-22 05:00:00	QQQ	ETF	208.65	209.05	208.47	208.6	14702.0
2020-04-22 06:00:00	QQQ	ETF	208.71	208.72	207.7	208.1	110051.0
2020-04-22 07:00:00	QQQ	ETF	208.09	208.45	207.85	208.45	857746.0
2020-04-22 08:00:00	QQQ	ETF	208.42	209.35	205.76	209.21	1342605.0
2020-04-22 09:00:00	QQQ	ETF	209.18	209.88	208.33	209.3	6954993.0
2020-04-22 10:00:00	QQQ	ETF	209.28	210.09	208.59	209.27	5865696.0
2020-04-22 11:00:00	QQQ	ETF	209.27	210.09	209.01	209.78	3402022.0
2020-04-22 12:00:00	QQQ	ETF	209.8	210.46	209.66	210.1	2870902.0
2020-04-22 13:00:00	QQQ	ETF	210.13	211.17	209.88	211.06	2629747.0
2020-04-22 14:00:00	QQQ	ETF	211.05	211.85	210.83	211.73	3271112.0
2020-04-22 15:00:00	QQQ	ETF	211.725	212.35	211.0	211.07	6879414.0
2020-04-22 16:00:00	QQQ	ETF	211.07	211.9	210.42	210.69	1744716.0
2020-04-22 17:00:00	QQQ	ETF	210.8	211.0	210.61	210.8	34747.0
2020-04-22 18:00:00	QQQ	ETF	210.82	210.82	210.22	210.31	54180.0
2020-04-22 19:00:00	QQQ	ETF	210.41	210.41	209.98	210.23	69755.0
2020-04-22 04:00:00	IWM	ETF	118.8	119.45	118.8	119.45	23529.0
2020-04-22 05:00:00	IWM	ETF	119.66	120.21	119.58	119.91	51013.0
2020-04-22 06:00:00	IWM	ETF	119.76	119.76	119.33	119.76	1800.0
2020-04-22 07:00:00	IWM	ETF	119.64	119.77	119.22	119.62	76981.0
2020-04-22 08:00:00	IWM	ETF	119.54	120.33	117.36	120.33	467296.0
2020-04-22 09:00:00	IWM	ETF	120.34	120.99	119.01	119.37	3454817.0
2020-04-22 10:00:00	IWM	ETF	119.38	120.08	118.77	119.3	3465258.0
2020-04-22 11:00:00	IWM	ETF	119.32	120.17	119.23	119.96	1717995.0
2020-04-22 12:00:00	IWM	ETF	119.97	120.15	119.065	119.21	1872258.0
2020-04-22 13:00:00	IWM	ETF	119.21	119.67	118.79	119.4965	2216567.0
2020-04-22 14:00:00	IWM	ETF	119.49	119.89	119.36	119.65	1740059.0
2020-04-22 15:00:00	IWM	ETF	119.65	120.29	119.12	119.29	5252719.0
2020-04-22 16:00:00	IWM	ETF	119.31	119.31	118.87	119.21	1597642.0
2020-04-22 17:00:00	IWM	ETF	119.38	119.38	119.18	119.28	27395.0
2020-04-22 18:00:00	IWM	ETF	119.33	119.33	118.59	118.66	31224.0
2020-04-22 19:00:00	IWM	ETF	118.64	118.64	118.26	118.48	52211.0
2020-04-22 04:00:00	DIA	ETF	233.02	233.62	233.02	233.61	1150.0
2020-04-22 05:00:00	DIA	ETF	233.56	233.89	233.56	233.89	210.0

> showing 50 of 12,373 rows — these rows as CSV

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