PREVIEW / etf_1hour / 2020-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-08.parquet
  size:    374 KB
  rows:    12,742

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-08 04:00:00	SPY	ETF	265.8	265.88	263.03	264.12	142630.0
2020-04-08 05:00:00	SPY	ETF	264.1	264.78	263.51	264.03	88786.0
2020-04-08 06:00:00	SPY	ETF	264.04	265.87	263.85	265.73	139888.0
2020-04-08 07:00:00	SPY	ETF	265.71	266.96	265.39	266.66	572708.0
2020-04-08 08:00:00	SPY	ETF	266.6	267.95	263.34	267.3	1268198.0
2020-04-08 09:00:00	SPY	ETF	267.26	269.0	266.25	266.48	12748787.0
2020-04-08 10:00:00	SPY	ETF	266.485	269.0	265.56	268.92	16500843.0
2020-04-08 11:00:00	SPY	ETF	268.95	271.72	268.32	270.79	16935678.0
2020-04-08 12:00:00	SPY	ETF	270.795	272.37	270.24	271.5	16917266.0
2020-04-08 13:00:00	SPY	ETF	271.5	272.15	270.06	270.31	14950617.0
2020-04-08 14:00:00	SPY	ETF	270.305	273.82	270.18	273.755	18518978.0
2020-04-08 15:00:00	SPY	ETF	273.77	276.0	272.15	274.07	41084841.0
2020-04-08 16:00:00	SPY	ETF	274.1	274.49	273.65	274.2	10285163.0
2020-04-08 17:00:00	SPY	ETF	274.15	274.32	273.7	273.92	282955.0
2020-04-08 18:00:00	SPY	ETF	273.93	274.03	273.06	273.59	519518.0
2020-04-08 19:00:00	SPY	ETF	273.56	275.29	273.26	274.99	564941.0
2020-04-08 04:00:00	QQQ	ETF	196.56	196.6	194.86	195.62	105891.0
2020-04-08 05:00:00	QQQ	ETF	195.75	196.16	195.28	195.61	106556.0
2020-04-08 06:00:00	QQQ	ETF	195.64	196.93	195.56	196.91	136888.0
2020-04-08 07:00:00	QQQ	ETF	196.91	197.77	196.61	197.52	206899.0
2020-04-08 08:00:00	QQQ	ETF	197.4	198.34	195.31	197.68	380255.0
2020-04-08 09:00:00	QQQ	ETF	197.73	199.03	196.85	197.02	4766999.0
2020-04-08 10:00:00	QQQ	ETF	197.03	198.63	196.37	198.52	5698478.0
2020-04-08 11:00:00	QQQ	ETF	198.54	199.88	197.99	199.165	5007378.0
2020-04-08 12:00:00	QQQ	ETF	199.19	200.01	198.86	199.49	4275717.0
2020-04-08 13:00:00	QQQ	ETF	199.53	199.8699	198.22	198.33	3950604.0
2020-04-08 14:00:00	QQQ	ETF	198.32	200.48	198.26	200.4319	4652954.0
2020-04-08 15:00:00	QQQ	ETF	200.448	201.17	199.12	200.47	8861496.0
2020-04-08 16:00:00	QQQ	ETF	200.47	200.57	199.3873	200.17	1277689.0
2020-04-08 17:00:00	QQQ	ETF	200.1	200.1	199.91	199.99	42377.0
2020-04-08 18:00:00	QQQ	ETF	199.94	199.94	199.21	199.65	102075.0
2020-04-08 19:00:00	QQQ	ETF	199.61	201.0	199.47	200.78	139331.0
2020-04-08 04:00:00	IWM	ETF	112.05	112.05	112.05	112.05	100.0
2020-04-08 05:00:00	IWM	ETF	112.4	112.6	112.1	112.1	7000.0
2020-04-08 06:00:00	IWM	ETF	112.25	113.07	112.13	113.07	20392.0
2020-04-08 07:00:00	IWM	ETF	112.99	113.75	112.9	113.6	168514.0
2020-04-08 08:00:00	IWM	ETF	113.2501	114.51	111.56	114.38	132173.0
2020-04-08 09:00:00	IWM	ETF	114.39	115.86	114.01	114.07	3851241.0
2020-04-08 10:00:00	IWM	ETF	114.09	116.025	113.55	115.92	4629091.0
2020-04-08 11:00:00	IWM	ETF	115.92	117.82	115.72	116.96	6017334.0
2020-04-08 12:00:00	IWM	ETF	116.9798	118.65	116.6	118.13	5065445.0
2020-04-08 13:00:00	IWM	ETF	118.15	118.61	117.09	117.12	3818140.0
2020-04-08 14:00:00	IWM	ETF	117.13	118.89	117.13	118.675	4410842.0
2020-04-08 15:00:00	IWM	ETF	118.675	119.24	117.74	118.17	10786711.0
2020-04-08 16:00:00	IWM	ETF	118.16	118.37	117.79	117.99	1706303.0
2020-04-08 17:00:00	IWM	ETF	118.18	118.18	117.9	118.07	9134.0
2020-04-08 18:00:00	IWM	ETF	117.94	118.07	117.7	117.9	68382.0
2020-04-08 19:00:00	IWM	ETF	117.92	118.64	117.92	118.52	68865.0
2020-04-08 04:00:00	DIA	ETF	226.84	226.94	224.97	226.0	5000.0
2020-04-08 05:00:00	DIA	ETF	225.83	226.26	225.77	226.21	2000.0

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

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