PREVIEW / etf_1hour / 2020-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-21.parquet
  size:    353 KB
  rows:    12,208

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-05-21 04:00:00	SPY	ETF	295.66	295.72	294.64	295.53	89360.0
2020-05-21 05:00:00	SPY	ETF	295.68	295.79	295.0	295.0	49382.0
2020-05-21 06:00:00	SPY	ETF	294.98	295.66	294.77	295.44	95954.0
2020-05-21 07:00:00	SPY	ETF	295.47	296.27	295.47	295.69	592093.0
2020-05-21 08:00:00	SPY	ETF	295.69	296.76	295.01	296.44	908804.0
2020-05-21 09:00:00	SPY	ETF	296.4	297.67	296.2	297.135	7157228.0
2020-05-21 10:00:00	SPY	ETF	297.13	297.43	295.26	295.83	10904931.0
2020-05-21 11:00:00	SPY	ETF	295.825	295.825	293.6886	294.87	12420236.0
2020-05-21 12:00:00	SPY	ETF	294.87	295.93	294.58	294.95	7659274.0
2020-05-21 13:00:00	SPY	ETF	294.95	295.82	294.73	295.19	6925538.0
2020-05-21 14:00:00	SPY	ETF	295.2	295.81	294.38	294.72	7890136.0
2020-05-21 15:00:00	SPY	ETF	294.715	295.66	294.51	294.79	15870059.0
2020-05-21 16:00:00	SPY	ETF	294.78	297.0247	294.0	294.08	5930436.0
2020-05-21 17:00:00	SPY	ETF	294.1	294.88	294.07	294.2	117271.0
2020-05-21 18:00:00	SPY	ETF	294.17	294.97	293.8	294.78	263648.0
2020-05-21 19:00:00	SPY	ETF	294.81	295.4	294.8	295.37	177273.0
2020-05-21 04:00:00	QQQ	ETF	231.0	231.0	229.75	230.3	42261.0
2020-05-21 05:00:00	QQQ	ETF	230.4	230.52	230.05	230.05	32932.0
2020-05-21 06:00:00	QQQ	ETF	230.0	230.39	229.85	230.29	26117.0
2020-05-21 07:00:00	QQQ	ETF	230.33	230.98	230.33	230.68	193489.0
2020-05-21 08:00:00	QQQ	ETF	230.68	231.36	230.0	231.23	321309.0
2020-05-21 09:00:00	QQQ	ETF	231.13	232.135	230.8	231.25	4735602.0
2020-05-21 10:00:00	QQQ	ETF	231.25	231.4	229.17	229.97	7306597.0
2020-05-21 11:00:00	QQQ	ETF	229.95	229.95	228.34	229.38	5599917.0
2020-05-21 12:00:00	QQQ	ETF	229.38	230.33	229.33	229.46	3595292.0
2020-05-21 13:00:00	QQQ	ETF	229.46	230.12	229.18	229.47	2944062.0
2020-05-21 14:00:00	QQQ	ETF	229.48	230.05	228.66	229.08	3204566.0
2020-05-21 15:00:00	QQQ	ETF	229.07	229.75	228.66	228.87	6286514.0
2020-05-21 16:00:00	QQQ	ETF	228.9	229.01	228.3002	228.45	2473547.0
2020-05-21 17:00:00	QQQ	ETF	228.44	228.7	228.43	228.58	53668.0
2020-05-21 18:00:00	QQQ	ETF	228.53	229.1	228.28	229.09	91270.0
2020-05-21 19:00:00	QQQ	ETF	229.09	229.58	229.06	229.58	146538.0
2020-05-21 04:00:00	IWM	ETF	133.85	133.85	132.4	133.0	20707.0
2020-05-21 05:00:00	IWM	ETF	132.85	132.85	132.66	132.66	1500.0
2020-05-21 06:00:00	IWM	ETF	132.5	132.97	132.5	132.88	12119.0
2020-05-21 07:00:00	IWM	ETF	132.97	133.81	132.93	133.0	136784.0
2020-05-21 08:00:00	IWM	ETF	133.0	134.08	132.4	133.76	186758.0
2020-05-21 09:00:00	IWM	ETF	133.82	134.8801	133.47	134.66	3121054.0
2020-05-21 10:00:00	IWM	ETF	134.66	134.91	133.31	133.86	3958049.0
2020-05-21 11:00:00	IWM	ETF	133.85	134.24	132.5787	133.82	4218750.0
2020-05-21 12:00:00	IWM	ETF	133.845	134.88	133.84	134.58	3231575.0
2020-05-21 13:00:00	IWM	ETF	134.6	135.06	134.37	134.61	2299270.0
2020-05-21 14:00:00	IWM	ETF	134.61	135.02	134.2	134.45	2602215.0
2020-05-21 15:00:00	IWM	ETF	134.45	134.88	134.07	134.29	5074036.0
2020-05-21 16:00:00	IWM	ETF	134.32	134.32	133.66	133.69	2237361.0
2020-05-21 17:00:00	IWM	ETF	133.76	134.12	133.76	133.92	15032.0
2020-05-21 18:00:00	IWM	ETF	133.92	134.35	133.62	134.33	63497.0
2020-05-21 19:00:00	IWM	ETF	134.34	134.82	134.34	134.82	58096.0
2020-05-21 04:00:00	DIA	ETF	244.25	244.25	244.02	244.02	900.0
2020-05-21 06:00:00	DIA	ETF	244.24	244.66	244.24	244.49	1850.0

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

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