PREVIEW / etf_1hour / 2020-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-29.parquet
  size:    362 KB
  rows:    12,526

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-29 04:00:00	SPY	ETF	302.28	302.51	301.71	302.26	79132.0
2020-05-29 05:00:00	SPY	ETF	302.42	303.3	302.09	303.26	77402.0
2020-05-29 06:00:00	SPY	ETF	303.23	303.67	303.13	303.49	65326.0
2020-05-29 07:00:00	SPY	ETF	303.42	303.81	303.14	303.46	255962.0
2020-05-29 08:00:00	SPY	ETF	303.4701	303.8	302.07	302.65	734229.0
2020-05-29 09:00:00	SPY	ETF	302.6	303.14	301.78	302.23	8636332.0
2020-05-29 10:00:00	SPY	ETF	302.24	302.59	300.63	301.0299	12749430.0
2020-05-29 11:00:00	SPY	ETF	301.02	302.06	300.48	301.67	9471813.0
2020-05-29 12:00:00	SPY	ETF	301.7	302.27	299.47	301.631	11909548.0
2020-05-29 13:00:00	SPY	ETF	301.63	301.87	300.72	301.13	7962142.0
2020-05-29 14:00:00	SPY	ETF	301.14	303.64	300.07	303.57	19629504.0
2020-05-29 15:00:00	SPY	ETF	303.56	304.96	303.08	304.16	31526092.0
2020-05-29 16:00:00	SPY	ETF	304.17	306.13	304.06	306.0	13482096.0
2020-05-29 17:00:00	SPY	ETF	306.03	306.09	304.32	305.91	748951.0
2020-05-29 18:00:00	SPY	ETF	306.0	306.0	305.82	305.93	72231.0
2020-05-29 19:00:00	SPY	ETF	305.92	306.1	305.88	306.1	122070.0
2020-05-29 04:00:00	QQQ	ETF	229.75	229.76	229.14	229.58	51179.0
2020-05-29 05:00:00	QQQ	ETF	229.6	230.13	229.2	230.11	30664.0
2020-05-29 06:00:00	QQQ	ETF	230.14	230.46	230.07	230.34	18900.0
2020-05-29 07:00:00	QQQ	ETF	230.38	231.32	230.23	231.2	134881.0
2020-05-29 08:00:00	QQQ	ETF	230.47	231.6301	229.91	230.76	327654.0
2020-05-29 09:00:00	QQQ	ETF	230.82	231.43	229.94	230.8499	4913590.0
2020-05-29 10:00:00	QQQ	ETF	230.87	231.01	228.96	229.66	7864469.0
2020-05-29 11:00:00	QQQ	ETF	229.66	230.73	228.76	230.51	4684417.0
2020-05-29 12:00:00	QQQ	ETF	230.52	230.96	228.89	230.54	3631949.0
2020-05-29 13:00:00	QQQ	ETF	230.54	230.9	229.92	230.33	2983730.0
2020-05-29 14:00:00	QQQ	ETF	230.34	231.82	229.2472	231.79	8724991.0
2020-05-29 15:00:00	QQQ	ETF	231.78	233.6	231.64	232.88	11169868.0
2020-05-29 16:00:00	QQQ	ETF	232.92	234.03	232.86	234.02	1555172.0
2020-05-29 17:00:00	QQQ	ETF	233.96	233.96	233.79	233.89	66151.0
2020-05-29 18:00:00	QQQ	ETF	233.9	233.94	233.8	233.85	12689.0
2020-05-29 19:00:00	QQQ	ETF	233.85	233.95	233.36	233.8	166554.0
2020-05-29 04:00:00	IWM	ETF	139.0	139.2	138.6	138.88	22415.0
2020-05-29 05:00:00	IWM	ETF	138.99	139.45	138.98	139.43	9400.0
2020-05-29 06:00:00	IWM	ETF	139.45	139.78	139.29	139.42	40050.0
2020-05-29 07:00:00	IWM	ETF	139.59	139.88	139.3	139.58	29662.0
2020-05-29 08:00:00	IWM	ETF	139.55	139.9099	138.41	138.95	108564.0
2020-05-29 09:00:00	IWM	ETF	138.94	139.16	137.4	137.99	5637218.0
2020-05-29 10:00:00	IWM	ETF	138.01	138.41	136.72	136.98	4872347.0
2020-05-29 11:00:00	IWM	ETF	136.97	137.98	136.75	137.54	3775683.0
2020-05-29 12:00:00	IWM	ETF	137.55	137.78	136.41	137.42	2687740.0
2020-05-29 13:00:00	IWM	ETF	137.42	137.84	137.02	137.36	3103716.0
2020-05-29 14:00:00	IWM	ETF	137.35	138.79	136.64	138.78	4807240.0
2020-05-29 15:00:00	IWM	ETF	138.8	139.28	138.22	138.76	9321168.0
2020-05-29 16:00:00	IWM	ETF	138.75	140.33	138.74	140.26	3346107.0
2020-05-29 17:00:00	IWM	ETF	140.39	140.39	139.66	139.8	39073.0
2020-05-29 18:00:00	IWM	ETF	139.71	139.78	139.52	139.7	4930.0
2020-05-29 19:00:00	IWM	ETF	139.74	139.9	138.9	139.88	86898.0
2020-05-29 04:00:00	DIA	ETF	253.67	253.85	253.49	253.7	3250.0
2020-05-29 05:00:00	DIA	ETF	253.81	254.36	253.81	254.33	1400.0

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

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