PREVIEW / etf_1hour / 2020-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-28.parquet
  size:    371 KB
  rows:    12,708

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-28 04:00:00	SPY	ETF	304.8	305.05	303.85	303.96	100655.0
2020-05-28 05:00:00	SPY	ETF	304.05	304.81	303.15	303.53	45721.0
2020-05-28 06:00:00	SPY	ETF	303.49	304.38	303.39	304.15	243263.0
2020-05-28 07:00:00	SPY	ETF	304.26	304.88	303.81	304.42	385751.0
2020-05-28 08:00:00	SPY	ETF	304.37	305.31	303.35	304.69	889889.0
2020-05-28 09:00:00	SPY	ETF	304.69	305.2	303.32	304.16	9498607.0
2020-05-28 10:00:00	SPY	ETF	304.15	305.19	303.67	305.09	10002795.0
2020-05-28 11:00:00	SPY	ETF	305.095	305.58	304.5	305.5533	9609058.0
2020-05-28 12:00:00	SPY	ETF	305.56	306.43	305.22	306.25	8275615.0
2020-05-28 13:00:00	SPY	ETF	306.2556	306.84	306.24	306.4643	8025348.0
2020-05-28 14:00:00	SPY	ETF	306.465	306.65	305.46	305.97	7385584.0
2020-05-28 15:00:00	SPY	ETF	305.97	306.455	302.24	302.96	28329217.0
2020-05-28 16:00:00	SPY	ETF	302.96	304.24	302.9066	304.04	5933017.0
2020-05-28 17:00:00	SPY	ETF	304.05	304.15	302.97	303.8	256493.0
2020-05-28 18:00:00	SPY	ETF	303.8	304.11	303.3	303.57	289177.0
2020-05-28 19:00:00	SPY	ETF	303.67	303.95	302.77	302.86	242461.0
2020-05-28 04:00:00	QQQ	ETF	229.91	230.2	229.31	229.51	35942.0
2020-05-28 05:00:00	QQQ	ETF	229.52	230.03	228.63	228.92	30421.0
2020-05-28 06:00:00	QQQ	ETF	229.1	229.76	228.75	229.48	175121.0
2020-05-28 07:00:00	QQQ	ETF	229.63	229.68	228.99	229.02	185512.0
2020-05-28 08:00:00	QQQ	ETF	229.41	230.37	227.55	228.08	810210.0
2020-05-28 09:00:00	QQQ	ETF	228.07	230.96	227.98	230.12	5948974.0
2020-05-28 10:00:00	QQQ	ETF	230.19	231.83	229.68	231.67	5155379.0
2020-05-28 11:00:00	QQQ	ETF	231.67	232.29	230.94	232.26	3586020.0
2020-05-28 12:00:00	QQQ	ETF	232.269	233.15	232.07	232.913	2961790.0
2020-05-28 13:00:00	QQQ	ETF	232.92	233.47	232.75	232.867	3165501.0
2020-05-28 14:00:00	QQQ	ETF	232.87	233.05	232.02	232.41	3468745.0
2020-05-28 15:00:00	QQQ	ETF	232.43	233.03	229.13	229.8	10818886.0
2020-05-28 16:00:00	QQQ	ETF	229.81	231.04	229.7402	230.9	1370040.0
2020-05-28 17:00:00	QQQ	ETF	230.92	231.01	230.75	230.75	63374.0
2020-05-28 18:00:00	QQQ	ETF	230.74	230.84	230.29	230.44	147779.0
2020-05-28 19:00:00	QQQ	ETF	230.51	230.7	229.83	229.9	168823.0
2020-05-28 04:00:00	IWM	ETF	144.12	144.4	143.41	143.62	46729.0
2020-05-28 05:00:00	IWM	ETF	143.58	144.05	142.95	143.3	12200.0
2020-05-28 06:00:00	IWM	ETF	143.09	144.1	143.04	143.95	312054.0
2020-05-28 07:00:00	IWM	ETF	144.0	144.56	143.82	144.33	347627.0
2020-05-28 08:00:00	IWM	ETF	143.97	144.69	143.0	144.44	437330.0
2020-05-28 09:00:00	IWM	ETF	144.43	144.79	142.39	143.47	5893878.0
2020-05-28 10:00:00	IWM	ETF	143.5	143.58	142.14	143.52	5291020.0
2020-05-28 11:00:00	IWM	ETF	143.54	143.97	142.69	143.19	3753030.0
2020-05-28 12:00:00	IWM	ETF	143.2	143.23	142.47	142.77	2659772.0
2020-05-28 13:00:00	IWM	ETF	142.77	142.89	142.17	142.62	2708982.0
2020-05-28 14:00:00	IWM	ETF	142.62	142.82	141.22	141.74	3241735.0
2020-05-28 15:00:00	IWM	ETF	141.74	142.09	137.58	139.74	10336176.0
2020-05-28 16:00:00	IWM	ETF	139.7	140.33	139.5107	140.24	1131918.0
2020-05-28 17:00:00	IWM	ETF	140.3	140.4	139.7	140.1	87973.0
2020-05-28 18:00:00	IWM	ETF	140.28	140.45	139.7	140.28	40288.0
2020-05-28 19:00:00	IWM	ETF	140.28	140.35	139.65	139.65	28256.0
2020-05-28 04:00:00	DIA	ETF	258.1	258.1	257.09	257.09	1565.0
2020-05-28 05:00:00	DIA	ETF	257.26	257.3	256.65	256.77	6824.0

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

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