PREVIEW / etf_1hour / 2020-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-22.parquet
  size:    361 KB
  rows:    12,478

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-22 04:00:00	SPY	ETF	308.5	309.36	308.03	309.15	115380.0
2020-06-22 05:00:00	SPY	ETF	309.27	309.79	308.95	309.01	86181.0
2020-06-22 06:00:00	SPY	ETF	308.96	308.99	308.22	308.44	97379.0
2020-06-22 07:00:00	SPY	ETF	308.43	308.48	307.55	308.46	394617.0
2020-06-22 08:00:00	SPY	ETF	308.46	309.45	306.1	308.26	1173035.0
2020-06-22 09:00:00	SPY	ETF	308.2	308.67	306.75	308.51	9406706.0
2020-06-22 10:00:00	SPY	ETF	308.515	309.67	308.15	308.16	10417949.0
2020-06-22 11:00:00	SPY	ETF	308.16	309.46	307.85	309.1001	8905284.0
2020-06-22 12:00:00	SPY	ETF	309.11	310.81	309.1016	310.495	8342439.0
2020-06-22 13:00:00	SPY	ETF	310.505	310.81	309.96	310.45	4325790.0
2020-06-22 14:00:00	SPY	ETF	310.46	311.04	309.72	310.955	6015549.0
2020-06-22 15:00:00	SPY	ETF	310.95	311.05	309.3	310.68	17355686.0
2020-06-22 16:00:00	SPY	ETF	310.71	311.5	310.149	311.12	5796499.0
2020-06-22 17:00:00	SPY	ETF	311.02	311.27	310.62	311.2	340986.0
2020-06-22 18:00:00	SPY	ETF	311.21	312.0	310.94	311.94	372873.0
2020-06-22 19:00:00	SPY	ETF	311.9	312.56	311.85	312.3299	268934.0
2020-06-22 04:00:00	QQQ	ETF	244.1	244.4	243.76	244.26	45640.0
2020-06-22 05:00:00	QQQ	ETF	244.31	244.86	244.25	244.37	23138.0
2020-06-22 06:00:00	QQQ	ETF	244.35	244.41	243.86	244.02	21572.0
2020-06-22 07:00:00	QQQ	ETF	244.0	244.35	243.561	244.35	204558.0
2020-06-22 08:00:00	QQQ	ETF	243.7601	244.5	242.75	243.93	159171.0
2020-06-22 09:00:00	QQQ	ETF	243.92	244.455	243.38	244.455	3483634.0
2020-06-22 10:00:00	QQQ	ETF	244.46	245.35	244.46	244.51	2961717.0
2020-06-22 11:00:00	QQQ	ETF	244.5	245.61	244.27	245.371	1987643.0
2020-06-22 12:00:00	QQQ	ETF	245.37	246.49	245.36	246.235	2645596.0
2020-06-22 13:00:00	QQQ	ETF	246.2388	246.41	245.88	246.275	1507886.0
2020-06-22 14:00:00	QQQ	ETF	246.28	246.8	245.8013	246.72	2171837.0
2020-06-22 15:00:00	QQQ	ETF	246.71	246.87	245.56	246.77	4611099.0
2020-06-22 16:00:00	QQQ	ETF	246.78	247.18	246.6	246.93	793031.0
2020-06-22 17:00:00	QQQ	ETF	247.04	247.1	246.88	247.08	30983.0
2020-06-22 18:00:00	QQQ	ETF	246.94	247.5	246.81	247.46	69963.0
2020-06-22 19:00:00	QQQ	ETF	247.42	247.75	247.36	247.65	92691.0
2020-06-22 04:00:00	IWM	ETF	141.0	141.8	140.87	141.75	55490.0
2020-06-22 05:00:00	IWM	ETF	141.95	142.07	141.36	141.36	7756.0
2020-06-22 06:00:00	IWM	ETF	141.3	141.35	140.84	141.0	33552.0
2020-06-22 07:00:00	IWM	ETF	140.99	141.09	140.43	140.86	146443.0
2020-06-22 08:00:00	IWM	ETF	140.56	141.23	139.96	140.3	476526.0
2020-06-22 09:00:00	IWM	ETF	140.25	140.64	138.83	140.08	4137041.0
2020-06-22 10:00:00	IWM	ETF	140.09	141.03	139.79	139.97	3808497.0
2020-06-22 11:00:00	IWM	ETF	139.94	140.99	139.7875	140.76	2157534.0
2020-06-22 12:00:00	IWM	ETF	140.77	142.35	140.765	142.09	1707818.0
2020-06-22 13:00:00	IWM	ETF	142.1	142.32	141.58	141.95	1566042.0
2020-06-22 14:00:00	IWM	ETF	141.95	142.52	141.47	142.43	1519122.0
2020-06-22 15:00:00	IWM	ETF	142.42	142.56	141.5	142.47	5628319.0
2020-06-22 16:00:00	IWM	ETF	142.47	142.89	140.9718	142.74	2643051.0
2020-06-22 17:00:00	IWM	ETF	142.57	142.75	142.4	142.75	42929.0
2020-06-22 18:00:00	IWM	ETF	142.75	143.07	142.4	142.97	217092.0
2020-06-22 19:00:00	IWM	ETF	142.96	143.45	142.96	143.34	49396.0
2020-06-22 04:00:00	DIA	ETF	258.0	259.35	258.0	259.35	3929.0
2020-06-22 05:00:00	DIA	ETF	259.38	259.82	259.0	259.0	1217.0

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

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