PREVIEW / etf_1hour / 2020-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-12.parquet
  size:    425 KB
  rows:    14,688

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-03-12 04:00:00	SPY	ETF	263.95	265.0	261.02	261.52	248682.0
2020-03-12 05:00:00	SPY	ETF	261.43	263.68	260.73	262.38	249836.0
2020-03-12 06:00:00	SPY	ETF	262.3	262.96	260.73	262.96	229878.0
2020-03-12 07:00:00	SPY	ETF	262.81	262.96	260.78	260.9	1137036.0
2020-03-12 08:00:00	SPY	ETF	265.0	267.41	255.6	256.74	4130914.0
2020-03-12 09:00:00	SPY	ETF	256.6	259.12	249.55	258.62	30726260.0
2020-03-12 10:00:00	SPY	ETF	258.6	258.79	253.24	257.76	57885154.0
2020-03-12 11:00:00	SPY	ETF	257.75	257.8	251.13	252.81	36652703.0
2020-03-12 12:00:00	SPY	ETF	252.79	262.22	250.36	260.0	45956253.0
2020-03-12 13:00:00	SPY	ETF	259.99	266.66	253.2	257.12	69405244.0
2020-03-12 14:00:00	SPY	ETF	257.1	258.0	251.87	252.07	33753275.0
2020-03-12 15:00:00	SPY	ETF	252.08	255.15	247.68	248.1	75604404.0
2020-03-12 16:00:00	SPY	ETF	248.1	264.5	245.35	246.04	16591108.0
2020-03-12 17:00:00	SPY	ETF	246.0	248.11	242.0	243.26	14039445.0
2020-03-12 18:00:00	SPY	ETF	243.5	249.26	242.91	247.1	3765610.0
2020-03-12 19:00:00	SPY	ETF	247.56	248.21	243.94	244.85	680066.0
2020-03-12 04:00:00	QQQ	ETF	187.69	188.48	185.72	186.13	196296.0
2020-03-12 05:00:00	QQQ	ETF	186.14	187.08	185.64	186.62	110270.0
2020-03-12 06:00:00	QQQ	ETF	186.39	186.75	185.61	186.75	66791.0
2020-03-12 07:00:00	QQQ	ETF	186.8	186.8	184.89	184.89	501169.0
2020-03-12 08:00:00	QQQ	ETF	184.9	189.55	182.74	183.57	1109071.0
2020-03-12 09:00:00	QQQ	ETF	183.57	184.98	178.82	184.81	11410900.0
2020-03-12 10:00:00	QQQ	ETF	184.79	185.9	182.01	185.12	19490838.0
2020-03-12 11:00:00	QQQ	ETF	185.13	185.14	179.78	180.79	13821269.0
2020-03-12 12:00:00	QQQ	ETF	180.77	186.77	178.85	185.35	15944416.0
2020-03-12 13:00:00	QQQ	ETF	185.35	190.78	181.52	184.4191	19964820.0
2020-03-12 14:00:00	QQQ	ETF	184.39	185.08	180.26	180.315	8947625.0
2020-03-12 15:00:00	QQQ	ETF	180.33	182.42	176.94	177.25	19053479.0
2020-03-12 16:00:00	QQQ	ETF	177.29	178.3	174.13	174.85	5636016.0
2020-03-12 17:00:00	QQQ	ETF	174.79	176.25	171.72	172.22	1460298.0
2020-03-12 18:00:00	QQQ	ETF	172.53	176.8	172.25	175.31	1624415.0
2020-03-12 19:00:00	QQQ	ETF	175.7	175.99	172.87	173.64	191606.0
2020-03-12 04:00:00	IWM	ETF	120.81	121.0	119.01	120.08	30539.0
2020-03-12 05:00:00	IWM	ETF	119.34	120.77	119.32	120.1	42957.0
2020-03-12 06:00:00	IWM	ETF	119.91	120.29	119.32	120.29	50320.0
2020-03-12 07:00:00	IWM	ETF	120.43	120.43	119.2	119.33	138557.0
2020-03-12 08:00:00	IWM	ETF	119.69	122.21	117.0	117.4	268889.0
2020-03-12 09:00:00	IWM	ETF	117.4	117.9	112.05	116.64	4620443.0
2020-03-12 10:00:00	IWM	ETF	116.58	117.19	113.425	116.32	8783369.0
2020-03-12 11:00:00	IWM	ETF	116.33	116.39	112.5639	112.96	6400671.0
2020-03-12 12:00:00	IWM	ETF	112.94	117.67	112.05	117.08	6339874.0
2020-03-12 13:00:00	IWM	ETF	117.08	119.9	113.19	114.92	7563359.0
2020-03-12 14:00:00	IWM	ETF	114.91	115.39	112.885	113.03	4458037.0
2020-03-12 15:00:00	IWM	ETF	113.04	113.83	111.6	111.72	10799268.0
2020-03-12 16:00:00	IWM	ETF	111.71	113.2	109.69	109.83	5181147.0
2020-03-12 17:00:00	IWM	ETF	109.87	111.97	108.01	108.38	111048.0
2020-03-12 18:00:00	IWM	ETF	108.71	111.97	108.51	110.59	53582.0
2020-03-12 19:00:00	IWM	ETF	110.77	111.97	109.17	109.48	101212.0
2020-03-12 04:00:00	DIA	ETF	225.0	227.35	224.1	224.69	30278.0
2020-03-12 05:00:00	DIA	ETF	224.36	226.0	224.0	225.5	13047.0

> showing 50 of 14,688 rows — these rows as CSV

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