PREVIEW / etf_1hour / 2020-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-21.parquet
  size:    382 KB
  rows:    13,075

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-21 04:00:00	SPY	ETF	279.19	280.3	279.09	279.8	70967.0
2020-04-21 05:00:00	SPY	ETF	280.0	280.18	277.54	278.2	265808.0
2020-04-21 06:00:00	SPY	ETF	278.12	278.72	276.64	277.42	451141.0
2020-04-21 07:00:00	SPY	ETF	277.27	279.44	275.83	276.3	1489863.0
2020-04-21 08:00:00	SPY	ETF	276.3	280.79	275.22	275.44	2061638.0
2020-04-21 09:00:00	SPY	ETF	275.42	278.04	275.1	277.65	15290423.0
2020-04-21 10:00:00	SPY	ETF	277.655	277.81	274.11	274.18	16087139.0
2020-04-21 11:00:00	SPY	ETF	274.16	274.37	272.14	273.61	20346958.0
2020-04-21 12:00:00	SPY	ETF	273.6	273.86	272.02	273.41	13380157.0
2020-04-21 13:00:00	SPY	ETF	273.41	275.0	273.21	274.02	13565858.0
2020-04-21 14:00:00	SPY	ETF	274.02	275.69	273.24	273.49	11673677.0
2020-04-21 15:00:00	SPY	ETF	273.49	275.51	272.5	273.02	25694760.0
2020-04-21 16:00:00	SPY	ETF	273.0101	273.77	273.0101	273.6	4255615.0
2020-04-21 17:00:00	SPY	ETF	273.6	274.41	273.04	274.19	416807.0
2020-04-21 18:00:00	SPY	ETF	274.16	275.0	273.8	274.15	353589.0
2020-04-21 19:00:00	SPY	ETF	274.17	274.5	273.4	274.39	255734.0
2020-04-21 04:00:00	QQQ	ETF	211.48	212.16	211.37	211.98	37727.0
2020-04-21 05:00:00	QQQ	ETF	212.11	212.31	211.02	211.1	81235.0
2020-04-21 06:00:00	QQQ	ETF	211.59	211.71	210.18	210.45	85004.0
2020-04-21 07:00:00	QQQ	ETF	210.44	210.82	210.0	210.06	220422.0
2020-04-21 08:00:00	QQQ	ETF	210.358	212.3	209.83	210.12	351384.0
2020-04-21 09:00:00	QQQ	ETF	210.14	211.16	208.23	209.54	7240988.0
2020-04-21 10:00:00	QQQ	ETF	209.55	209.68	204.72	204.91	10870914.0
2020-04-21 11:00:00	QQQ	ETF	204.89	205.36	203.63	205.12	9586131.0
2020-04-21 12:00:00	QQQ	ETF	205.11	205.365	203.91	204.84	5648872.0
2020-04-21 13:00:00	QQQ	ETF	204.85	206.94	204.69	206.405	7919668.0
2020-04-21 14:00:00	QQQ	ETF	206.4	207.89	205.38	205.55	8486553.0
2020-04-21 15:00:00	QQQ	ETF	205.56	206.99	204.51	204.78	9802055.0
2020-04-21 16:00:00	QQQ	ETF	204.78	206.3767	204.7797	205.89	1474249.0
2020-04-21 17:00:00	QQQ	ETF	205.97	206.45	205.77	206.22	374698.0
2020-04-21 18:00:00	QQQ	ETF	206.22	206.76	205.96	206.2	128796.0
2020-04-21 19:00:00	QQQ	ETF	206.36	206.46	205.72	206.41	90003.0
2020-04-21 04:00:00	IWM	ETF	119.02	119.43	118.81	118.9	8282.0
2020-04-21 05:00:00	IWM	ETF	118.83	118.83	117.4	117.6	18602.0
2020-04-21 06:00:00	IWM	ETF	117.84	118.01	116.9	117.41	155417.0
2020-04-21 07:00:00	IWM	ETF	117.43	117.66	116.86	117.11	169937.0
2020-04-21 08:00:00	IWM	ETF	117.2601	119.2	116.3899	116.46	412584.0
2020-04-21 09:00:00	IWM	ETF	116.48	119.13	116.205	119.11	4596524.0
2020-04-21 10:00:00	IWM	ETF	119.11	119.24	117.61	117.65	4332497.0
2020-04-21 11:00:00	IWM	ETF	117.65	117.68	116.61	117.445	4267325.0
2020-04-21 12:00:00	IWM	ETF	117.44	117.515	116.48	117.38	2291618.0
2020-04-21 13:00:00	IWM	ETF	117.37	118.225	117.2	117.55	2476028.0
2020-04-21 14:00:00	IWM	ETF	117.55	118.55	117.3	117.67	2001468.0
2020-04-21 15:00:00	IWM	ETF	117.66	118.81	117.37	117.68	6229200.0
2020-04-21 16:00:00	IWM	ETF	117.67	118.19	117.63	117.86	968693.0
2020-04-21 17:00:00	IWM	ETF	117.31	118.38	117.31	118.2	106607.0
2020-04-21 18:00:00	IWM	ETF	118.31	118.63	117.74	118.3	59397.0
2020-04-21 19:00:00	IWM	ETF	118.44	118.71	117.94	118.61	30405.0
2020-04-21 04:00:00	DIA	ETF	233.72	234.71	233.72	234.24	6550.0
2020-04-21 05:00:00	DIA	ETF	234.11	234.11	232.2	232.24	7887.0

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

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