PREVIEW / etf_1hour / 2020-06-25

all etf 1-hour files

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

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-25 04:00:00	SPY	ETF	301.53	304.75	301.48	304.4	183573.0
2020-06-25 05:00:00	SPY	ETF	304.39	305.33	303.84	304.08	114714.0
2020-06-25 06:00:00	SPY	ETF	304.2	304.52	303.79	304.51	237808.0
2020-06-25 07:00:00	SPY	ETF	304.47	304.52	302.3	302.44	662358.0
2020-06-25 08:00:00	SPY	ETF	302.47	304.47	300.83	302.91	1800877.0
2020-06-25 09:00:00	SPY	ETF	302.95	304.09	301.28	302.98	10570562.0
2020-06-25 10:00:00	SPY	ETF	302.99	304.98	302.87	303.96	12954161.0
2020-06-25 11:00:00	SPY	ETF	303.96	304.38	302.51	303.84	11029089.0
2020-06-25 12:00:00	SPY	ETF	303.86	305.27	303.85	304.66	7319301.0
2020-06-25 13:00:00	SPY	ETF	304.66	305.03	304.06	304.57	6842063.0
2020-06-25 14:00:00	SPY	ETF	304.56	304.8485	303.5	304.27	6549981.0
2020-06-25 15:00:00	SPY	ETF	304.26	307.64	304.0	307.31	24167097.0
2020-06-25 16:00:00	SPY	ETF	307.25	308.0	306.56	307.42	4878796.0
2020-06-25 17:00:00	SPY	ETF	307.42	307.45	307.13	307.28	179899.0
2020-06-25 18:00:00	SPY	ETF	307.23	307.47	306.92	307.42	252485.0
2020-06-25 19:00:00	SPY	ETF	307.4	308.0	307.16	307.37	249069.0
2020-06-25 04:00:00	QQQ	ETF	242.38	244.58	242.35	244.34	88515.0
2020-06-25 05:00:00	QQQ	ETF	244.2	245.03	243.9	243.95	46854.0
2020-06-25 06:00:00	QQQ	ETF	244.13	244.48	243.8	244.48	133179.0
2020-06-25 07:00:00	QQQ	ETF	244.51	244.54	243.25	243.31	163327.0
2020-06-25 08:00:00	QQQ	ETF	243.31	244.54	241.69	243.89	373990.0
2020-06-25 09:00:00	QQQ	ETF	243.84	244.38	241.14	242.65	5901544.0
2020-06-25 10:00:00	QQQ	ETF	242.64	244.27	242.19	243.77	6499480.0
2020-06-25 11:00:00	QQQ	ETF	243.75	244.035	242.62	243.89	3872292.0
2020-06-25 12:00:00	QQQ	ETF	243.91	244.95	243.91	244.25	3091427.0
2020-06-25 13:00:00	QQQ	ETF	244.24	244.65	243.8	244.3	1746371.0
2020-06-25 14:00:00	QQQ	ETF	244.33	244.3784	243.14	243.81	2418937.0
2020-06-25 15:00:00	QQQ	ETF	243.81	246.34	243.59	246.08	6702471.0
2020-06-25 16:00:00	QQQ	ETF	246.07	246.55	245.86	246.3	926964.0
2020-06-25 17:00:00	QQQ	ETF	246.43	246.43	246.0	246.05	54471.0
2020-06-25 18:00:00	QQQ	ETF	246.05	246.46	246.04	246.44	42085.0
2020-06-25 19:00:00	QQQ	ETF	246.39	246.86	246.26	246.52	87258.0
2020-06-25 04:00:00	IWM	ETF	136.65	138.5	136.31	138.36	26588.0
2020-06-25 05:00:00	IWM	ETF	138.19	139.19	138.18	138.36	11200.0
2020-06-25 06:00:00	IWM	ETF	138.38	138.4	137.99	138.01	147593.0
2020-06-25 07:00:00	IWM	ETF	138.1	138.18	136.7	136.7	248578.0
2020-06-25 08:00:00	IWM	ETF	137.62	138.01	136.5	137.19	332565.0
2020-06-25 09:00:00	IWM	ETF	137.33	138.03	136.29	137.83	4883959.0
2020-06-25 10:00:00	IWM	ETF	137.795	139.9	137.715	138.18	6708038.0
2020-06-25 11:00:00	IWM	ETF	138.17	138.5	137.16	138.115	3243559.0
2020-06-25 12:00:00	IWM	ETF	138.135	139.36	138.11	138.78	3603125.0
2020-06-25 13:00:00	IWM	ETF	138.76	138.86	138.23	138.33	1662654.0
2020-06-25 14:00:00	IWM	ETF	138.35	138.48	137.81	138.14	2106724.0
2020-06-25 15:00:00	IWM	ETF	138.13	140.58	138.045	140.41	8510526.0
2020-06-25 16:00:00	IWM	ETF	140.43	140.76	139.85	140.29	1626524.0
2020-06-25 17:00:00	IWM	ETF	140.05	140.45	140.05	140.14	21650.0
2020-06-25 18:00:00	IWM	ETF	140.16	140.39	139.99	140.17	19675.0
2020-06-25 19:00:00	IWM	ETF	140.25	140.7	140.23	140.25	47545.0
2020-06-25 04:00:00	DIA	ETF	253.51	254.9	252.17	254.84	9475.0
2020-06-25 05:00:00	DIA	ETF	254.84	255.4	254.13	254.62	4120.0

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

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