PREVIEW / etf_1hour / 2020-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-23.parquet
  size:    365 KB
  rows:    12,655

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-06-23 04:00:00	SPY	ETF	313.37	313.51	312.75	312.89	39326.0
2020-06-23 05:00:00	SPY	ETF	312.74	313.51	312.66	313.22	31138.0
2020-06-23 06:00:00	SPY	ETF	313.31	313.96	313.15	313.47	81666.0
2020-06-23 07:00:00	SPY	ETF	313.61	313.9	313.19	313.79	225083.0
2020-06-23 08:00:00	SPY	ETF	313.3398	314.57	309.91	314.22	580545.0
2020-06-23 09:00:00	SPY	ETF	314.2	314.36	312.62	312.98	6770936.0
2020-06-23 10:00:00	SPY	ETF	312.965	313.65	312.11	312.78	9219882.0
2020-06-23 11:00:00	SPY	ETF	312.77	314.18	312.38	313.82	6773578.0
2020-06-23 12:00:00	SPY	ETF	313.83	314.03	313.4	313.67	5244189.0
2020-06-23 13:00:00	SPY	ETF	313.67	314.5	313.5	314.18	5568683.0
2020-06-23 14:00:00	SPY	ETF	314.195	314.195	313.11	313.3577	5626919.0
2020-06-23 15:00:00	SPY	ETF	313.36	313.61	311.6101	312.03	20814988.0
2020-06-23 16:00:00	SPY	ETF	312.02	313.2132	311.19	311.31	6243769.0
2020-06-23 17:00:00	SPY	ETF	311.3	311.49	311.17	311.49	104371.0
2020-06-23 18:00:00	SPY	ETF	311.4	311.91	310.9	310.98	219364.0
2020-06-23 19:00:00	SPY	ETF	310.92	311.69	310.76	311.2	184328.0
2020-06-23 04:00:00	QQQ	ETF	248.66	248.78	248.13	248.23	62356.0
2020-06-23 05:00:00	QQQ	ETF	248.15	248.63	248.11	248.56	17717.0
2020-06-23 06:00:00	QQQ	ETF	248.5	248.91	248.5	248.53	66484.0
2020-06-23 07:00:00	QQQ	ETF	248.55	248.89	248.33	248.65	126777.0
2020-06-23 08:00:00	QQQ	ETF	248.61	248.8696	246.5	248.6506	822361.0
2020-06-23 09:00:00	QQQ	ETF	248.6799	248.84	247.82	248.44	3146428.0
2020-06-23 10:00:00	QQQ	ETF	248.43	249.5962	247.96	249.154	4038211.0
2020-06-23 11:00:00	QQQ	ETF	249.13	250.29	248.85	250.29	3050005.0
2020-06-23 12:00:00	QQQ	ETF	250.3	250.49	250.0	250.34	2517778.0
2020-06-23 13:00:00	QQQ	ETF	250.34	251.15	250.32	250.86	3068584.0
2020-06-23 14:00:00	QQQ	ETF	250.87	250.87	249.87	249.9	3040285.0
2020-06-23 15:00:00	QQQ	ETF	249.92	250.07	248.22	248.73	6839773.0
2020-06-23 16:00:00	QQQ	ETF	248.73	249.11	248.2	248.26	962351.0
2020-06-23 17:00:00	QQQ	ETF	248.27	248.84	248.25	248.57	64895.0
2020-06-23 18:00:00	QQQ	ETF	248.45	248.84	248.151	248.2499	121304.0
2020-06-23 19:00:00	QQQ	ETF	248.21	248.7	248.05	248.35	91688.0
2020-06-23 04:00:00	IWM	ETF	144.08	144.25	143.7	143.74	13035.0
2020-06-23 05:00:00	IWM	ETF	143.6	144.22	143.6	144.22	4909.0
2020-06-23 06:00:00	IWM	ETF	144.25	144.68	144.2	144.56	26458.0
2020-06-23 07:00:00	IWM	ETF	144.5	144.89	144.09	144.75	138661.0
2020-06-23 08:00:00	IWM	ETF	144.1899	145.25	142.68	144.8	189597.0
2020-06-23 09:00:00	IWM	ETF	144.8	144.85	143.67	143.94	1914116.0
2020-06-23 10:00:00	IWM	ETF	143.94	144.08	142.6674	142.975	2928956.0
2020-06-23 11:00:00	IWM	ETF	142.96	143.65	142.65	143.58	1905994.0
2020-06-23 12:00:00	IWM	ETF	143.6	143.73	143.17	143.415	1253009.0
2020-06-23 13:00:00	IWM	ETF	143.4	144.09	143.395	143.99	2839435.0
2020-06-23 14:00:00	IWM	ETF	143.98	144.13	143.28	143.63	1795135.0
2020-06-23 15:00:00	IWM	ETF	143.64	143.81	142.83	143.02	3521500.0
2020-06-23 16:00:00	IWM	ETF	143.02	143.15	142.5	142.73	1101669.0
2020-06-23 17:00:00	IWM	ETF	142.73	142.76	142.66	142.75	16026.0
2020-06-23 18:00:00	IWM	ETF	142.66	143.05	142.45	142.461	46012.0
2020-06-23 19:00:00	IWM	ETF	142.49	142.87	142.4	142.6	20078.0
2020-06-23 04:00:00	DIA	ETF	262.65	262.9	262.5	262.6	9800.0
2020-06-23 05:00:00	DIA	ETF	262.56	262.87	262.55	262.87	1500.0

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

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