PREVIEW / etf_1hour / 2020-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-01.parquet
  size:    365 KB
  rows:    12,590

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-07-01 04:00:00	SPY	ETF	308.74	309.12	308.5	308.75	27363.0
2020-07-01 05:00:00	SPY	ETF	308.88	309.37	307.94	308.15	51438.0
2020-07-01 06:00:00	SPY	ETF	307.98	308.63	307.16	307.44	168281.0
2020-07-01 07:00:00	SPY	ETF	307.45	307.48	306.42	307.15	659956.0
2020-07-01 08:00:00	SPY	ETF	307.1	309.58	306.48	309.55	1704234.0
2020-07-01 09:00:00	SPY	ETF	309.55	310.92	309.3	309.81	10515314.0
2020-07-01 10:00:00	SPY	ETF	309.85	311.26	309.76	310.6	10314533.0
2020-07-01 11:00:00	SPY	ETF	310.63	310.7	309.07	310.26	7525567.0
2020-07-01 12:00:00	SPY	ETF	310.2501	311.44	310.11	310.78	7591684.0
2020-07-01 13:00:00	SPY	ETF	310.79	311.07	310.295	310.74	4570130.0
2020-07-01 14:00:00	SPY	ETF	310.745	311.275	310.3	310.91	6712867.0
2020-07-01 15:00:00	SPY	ETF	310.91	311.89	310.44	310.57	15763630.0
2020-07-01 16:00:00	SPY	ETF	310.58	311.658	310.11	310.14	5156340.0
2020-07-01 17:00:00	SPY	ETF	310.11	310.25	309.97	310.13	146971.0
2020-07-01 18:00:00	SPY	ETF	310.16	310.65	309.95	310.64	262230.0
2020-07-01 19:00:00	SPY	ETF	310.64	310.75	310.15	310.35	218616.0
2020-07-01 20:00:00	SPY	ETF	310.33	310.33	310.33	310.33	200.0
2020-07-01 04:00:00	QQQ	ETF	247.36	247.68	247.22	247.22	32881.0
2020-07-01 05:00:00	QQQ	ETF	247.43	247.7	246.77	246.96	15360.0
2020-07-01 06:00:00	QQQ	ETF	246.82	247.29	246.33	246.54	47308.0
2020-07-01 07:00:00	QQQ	ETF	246.52	246.62	245.92	246.15	150759.0
2020-07-01 08:00:00	QQQ	ETF	246.3199	247.71	245.97	247.62	325632.0
2020-07-01 09:00:00	QQQ	ETF	247.7	248.7	247.0802	247.62	4933655.0
2020-07-01 10:00:00	QQQ	ETF	247.65	249.46	247.46	249.2961	4240004.0
2020-07-01 11:00:00	QQQ	ETF	249.32	249.81	248.92	249.6	4341393.0
2020-07-01 12:00:00	QQQ	ETF	249.6	250.53	249.5	250.17	3175049.0
2020-07-01 13:00:00	QQQ	ETF	250.18	250.44	249.53	250.335	2429205.0
2020-07-01 14:00:00	QQQ	ETF	250.33	250.71	249.87	250.43	2122768.0
2020-07-01 15:00:00	QQQ	ETF	250.44	251.52	250.35	250.43	5446959.0
2020-07-01 16:00:00	QQQ	ETF	250.44	250.59	250.14	250.25	887402.0
2020-07-01 17:00:00	QQQ	ETF	250.22	250.31	250.09	250.2	28550.0
2020-07-01 18:00:00	QQQ	ETF	250.2	250.66	250.09	250.65	89540.0
2020-07-01 19:00:00	QQQ	ETF	250.69	250.76	250.44	250.6	110568.0
2020-07-01 04:00:00	IWM	ETF	142.71	142.75	142.55	142.6	12400.0
2020-07-01 05:00:00	IWM	ETF	142.77	143.09	142.01	142.01	14724.0
2020-07-01 06:00:00	IWM	ETF	142.0	142.38	141.06	141.55	31669.0
2020-07-01 07:00:00	IWM	ETF	141.58	141.6	141.1	141.36	113683.0
2020-07-01 08:00:00	IWM	ETF	142.3	143.1	141.27	143.09	273337.0
2020-07-01 09:00:00	IWM	ETF	143.02	144.51	143.02	143.34	3089267.0
2020-07-01 10:00:00	IWM	ETF	143.4	144.33	142.4	142.86	3461514.0
2020-07-01 11:00:00	IWM	ETF	142.87	142.955	141.24	142.26	3218617.0
2020-07-01 12:00:00	IWM	ETF	142.27	142.89	141.8	142.35	2184030.0
2020-07-01 13:00:00	IWM	ETF	142.34	142.38	141.32	141.45	1596078.0
2020-07-01 14:00:00	IWM	ETF	141.45	142.22	141.45	142.12	1420591.0
2020-07-01 15:00:00	IWM	ETF	142.12	142.76	141.73	141.81	3592186.0
2020-07-01 16:00:00	IWM	ETF	141.83	142.08	141.7	141.7	1025676.0
2020-07-01 17:00:00	IWM	ETF	141.65	141.76	141.5	141.53	25551.0
2020-07-01 18:00:00	IWM	ETF	141.7	141.9	141.54	141.89	51251.0
2020-07-01 19:00:00	IWM	ETF	141.82	142.03	141.79	141.84	45009.0
2020-07-01 20:00:00	IWM	ETF	141.82	141.82	141.8	141.8	300.0

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

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