PREVIEW / etf_1hour / 2020-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-03.parquet
  size:    366 KB
  rows:    12,447

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-03 04:00:00	SPY	ETF	250.0	250.26	248.44	249.14	71040.0
2020-04-03 05:00:00	SPY	ETF	249.14	249.45	248.02	249.42	96492.0
2020-04-03 06:00:00	SPY	ETF	249.45	249.82	248.8	249.6	113268.0
2020-04-03 07:00:00	SPY	ETF	249.59	253.03	249.38	252.65	822971.0
2020-04-03 08:00:00	SPY	ETF	249.9301	252.97	248.2	251.32	3494832.0
2020-04-03 09:00:00	SPY	ETF	251.32	253.32	250.48	251.8	15469262.0
2020-04-03 10:00:00	SPY	ETF	251.85	252.74	248.78	249.64	17736841.0
2020-04-03 11:00:00	SPY	ETF	249.63	250.29	247.4	248.217	16294378.0
2020-04-03 12:00:00	SPY	ETF	248.21	248.55	246.35	247.575	13465998.0
2020-04-03 13:00:00	SPY	ETF	247.5758	248.18	245.65	246.09	11019171.0
2020-04-03 14:00:00	SPY	ETF	246.08	247.78	245.22	247.71	13807032.0
2020-04-03 15:00:00	SPY	ETF	247.7	249.17	245.86	248.21	33513938.0
2020-04-03 16:00:00	SPY	ETF	248.27	249.1	247.88	248.36	6445613.0
2020-04-03 17:00:00	SPY	ETF	248.2	248.6	248.19	248.33	710287.0
2020-04-03 18:00:00	SPY	ETF	248.28	248.4	247.8	247.86	965223.0
2020-04-03 19:00:00	SPY	ETF	247.94	248.09	247.53	247.92	132992.0
2020-04-03 04:00:00	QQQ	ETF	184.7	185.0	183.59	184.04	35257.0
2020-04-03 05:00:00	QQQ	ETF	184.12	184.37	183.47	184.23	30764.0
2020-04-03 06:00:00	QQQ	ETF	184.4	184.72	184.01	184.5	44831.0
2020-04-03 07:00:00	QQQ	ETF	184.48	186.81	184.27	186.55	196573.0
2020-04-03 08:00:00	QQQ	ETF	186.51	186.73	183.99	185.55	546719.0
2020-04-03 09:00:00	QQQ	ETF	185.5	187.0716	184.93	186.13	4856540.0
2020-04-03 10:00:00	QQQ	ETF	186.13	186.77	183.91	184.37	6642834.0
2020-04-03 11:00:00	QQQ	ETF	184.37	184.77	183.1	183.64	4987916.0
2020-04-03 12:00:00	QQQ	ETF	183.67	183.89	182.33	183.08	3902661.0
2020-04-03 13:00:00	QQQ	ETF	183.06	183.54	181.57	181.8698	3655941.0
2020-04-03 14:00:00	QQQ	ETF	181.86	183.09	181.29	183.0125	4300736.0
2020-04-03 15:00:00	QQQ	ETF	183.0	183.94	181.665	183.52	8831444.0
2020-04-03 16:00:00	QQQ	ETF	183.52	184.15	183.37	183.8	1237696.0
2020-04-03 17:00:00	QQQ	ETF	183.66	183.66	183.4	183.62	61046.0
2020-04-03 18:00:00	QQQ	ETF	183.62	183.75	183.11	183.21	12350.0
2020-04-03 19:00:00	QQQ	ETF	183.2	183.28	183.02	183.12	13774.0
2020-04-03 04:00:00	IWM	ETF	106.52	106.52	105.79	106.07	11750.0
2020-04-03 05:00:00	IWM	ETF	106.11	106.29	105.81	106.25	33744.0
2020-04-03 06:00:00	IWM	ETF	106.18	106.3	106.12	106.12	2300.0
2020-04-03 07:00:00	IWM	ETF	106.19	107.56	106.05	107.56	111355.0
2020-04-03 08:00:00	IWM	ETF	106.5399	107.49	105.9	106.68	398366.0
2020-04-03 09:00:00	IWM	ETF	106.87	108.0	106.17	107.33	3725586.0
2020-04-03 10:00:00	IWM	ETF	107.34	107.61	105.14	105.76	5239127.0
2020-04-03 11:00:00	IWM	ETF	105.76	105.97	104.04	104.57	3799489.0
2020-04-03 12:00:00	IWM	ETF	104.59	104.72	103.58	104.1	3282214.0
2020-04-03 13:00:00	IWM	ETF	104.08	104.13	102.6	103.175	5363557.0
2020-04-03 14:00:00	IWM	ETF	103.17	104.14	102.87	104.07	4197079.0
2020-04-03 15:00:00	IWM	ETF	104.08	104.7	103.165	104.62	7946520.0
2020-04-03 16:00:00	IWM	ETF	104.64	105.05	103.52	104.49	1253868.0
2020-04-03 17:00:00	IWM	ETF	104.5	104.82	104.3	104.5	12170.0
2020-04-03 18:00:00	IWM	ETF	104.45	104.45	104.31	104.31	7674.0
2020-04-03 19:00:00	IWM	ETF	104.26	104.35	104.21	104.21	5545.0
2020-04-03 04:00:00	DIA	ETF	212.24	212.38	211.15	211.15	3280.0
2020-04-03 05:00:00	DIA	ETF	211.51	211.51	210.66	211.41	13783.0

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

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