PREVIEW / etf_1hour / 2020-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-27.parquet
  size:    373 KB
  rows:    12,865

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-27 04:00:00	SPY	ETF	301.86	302.71	301.79	302.64	99488.0
2020-05-27 05:00:00	SPY	ETF	302.71	303.86	302.42	303.69	124888.0
2020-05-27 06:00:00	SPY	ETF	303.68	303.75	303.01	303.3	111889.0
2020-05-27 07:00:00	SPY	ETF	303.26	303.49	302.71	302.8	554673.0
2020-05-27 08:00:00	SPY	ETF	302.7201	303.5	300.0	302.25	1718560.0
2020-05-27 09:00:00	SPY	ETF	302.25	302.79	299.57	299.89	11933812.0
2020-05-27 10:00:00	SPY	ETF	299.91	300.59	296.87	298.04	16640885.0
2020-05-27 11:00:00	SPY	ETF	298.03	299.62	297.41	299.55	13936661.0
2020-05-27 12:00:00	SPY	ETF	299.54	300.52	299.28	300.17	7970860.0
2020-05-27 13:00:00	SPY	ETF	300.165	300.49	299.45	300.36	7053290.0
2020-05-27 14:00:00	SPY	ETF	300.36	301.78	300.36	301.74	9300279.0
2020-05-27 15:00:00	SPY	ETF	301.74	303.57	301.375	303.48	26258005.0
2020-05-27 16:00:00	SPY	ETF	303.49	304.25	303.14	303.99	7227008.0
2020-05-27 17:00:00	SPY	ETF	303.97	304.18	303.53	303.75	281689.0
2020-05-27 18:00:00	SPY	ETF	303.83	304.24	303.41	304.09	400983.0
2020-05-27 19:00:00	SPY	ETF	304.1	304.63	303.73	304.54	326835.0
2020-05-27 04:00:00	QQQ	ETF	231.38	231.55	231.01	231.52	60812.0
2020-05-27 05:00:00	QQQ	ETF	231.54	232.02	231.27	232.0	44844.0
2020-05-27 06:00:00	QQQ	ETF	231.96	231.96	231.1	231.29	58604.0
2020-05-27 07:00:00	QQQ	ETF	231.38	231.38	230.34	230.34	194403.0
2020-05-27 08:00:00	QQQ	ETF	230.7299	231.5296	229.13	229.21	414254.0
2020-05-27 09:00:00	QQQ	ETF	229.16	229.51	226.3	226.69	7791121.0
2020-05-27 10:00:00	QQQ	ETF	226.68	227.59	223.94	224.9	10400466.0
2020-05-27 11:00:00	QQQ	ETF	224.91	226.52	224.05	226.38	7798621.0
2020-05-27 12:00:00	QQQ	ETF	226.38	227.94	226.13	227.5	4159285.0
2020-05-27 13:00:00	QQQ	ETF	227.46	227.93	226.92	227.89	4338326.0
2020-05-27 14:00:00	QQQ	ETF	227.89	229.55	227.89	229.5401	5295740.0
2020-05-27 15:00:00	QQQ	ETF	229.55	230.41	228.98	230.28	6583391.0
2020-05-27 16:00:00	QQQ	ETF	230.28	230.61	230.0	230.42	1060994.0
2020-05-27 17:00:00	QQQ	ETF	230.42	230.5	230.29	230.35	30022.0
2020-05-27 18:00:00	QQQ	ETF	230.3	230.43	229.72	230.21	112382.0
2020-05-27 19:00:00	QQQ	ETF	230.25	230.48	229.83	230.46	64970.0
2020-05-27 04:00:00	IWM	ETF	141.11	141.9	141.0	141.88	61962.0
2020-05-27 05:00:00	IWM	ETF	141.9	143.49	141.81	143.43	73944.0
2020-05-27 06:00:00	IWM	ETF	143.44	143.48	142.4	142.5	46276.0
2020-05-27 07:00:00	IWM	ETF	142.65	142.65	141.82	141.91	594860.0
2020-05-27 08:00:00	IWM	ETF	142.03	142.94	140.29	141.73	719453.0
2020-05-27 09:00:00	IWM	ETF	141.57	142.2	139.12	139.48	5883135.0
2020-05-27 10:00:00	IWM	ETF	139.48	140.67	137.33	138.09	5834218.0
2020-05-27 11:00:00	IWM	ETF	138.12	139.93	137.75	139.9	4303030.0
2020-05-27 12:00:00	IWM	ETF	139.91	141.04	139.64	140.74	3293363.0
2020-05-27 13:00:00	IWM	ETF	140.75	141.49	140.29	141.38	2902329.0
2020-05-27 14:00:00	IWM	ETF	141.38	142.21	141.38	142.02	3186905.0
2020-05-27 15:00:00	IWM	ETF	142.01	143.5	141.97	143.06	8574366.0
2020-05-27 16:00:00	IWM	ETF	143.08	143.72	142.82	143.4	1008164.0
2020-05-27 17:00:00	IWM	ETF	143.53	143.53	143.09	143.35	127523.0
2020-05-27 18:00:00	IWM	ETF	143.35	143.46	142.86	143.36	62332.0
2020-05-27 19:00:00	IWM	ETF	143.4	143.59	143.0	143.55	40919.0
2020-05-27 04:00:00	DIA	ETF	252.73	253.52	252.73	253.45	4410.0
2020-05-27 05:00:00	DIA	ETF	253.55	254.62	253.43	254.36	2830.0

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

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