PREVIEW / etf_1hour / 2020-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-23.parquet
  size:    374 KB
  rows:    12,773

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-09-23 04:00:00	SPY	ETF	330.9	331.58	330.67	331.58	41757.0
2020-09-23 05:00:00	SPY	ETF	331.55	331.88	331.38	331.87	37912.0
2020-09-23 06:00:00	SPY	ETF	331.8	331.93	331.3	331.7	92380.0
2020-09-23 07:00:00	SPY	ETF	331.71	331.75	330.81	330.81	211255.0
2020-09-23 08:00:00	SPY	ETF	331.0301	331.7904	330.15	330.66	375344.0
2020-09-23 09:00:00	SPY	ETF	330.61	331.2	329.7	329.83	5631719.0
2020-09-23 10:00:00	SPY	ETF	329.815	330.25	328.51	329.08	7430517.0
2020-09-23 11:00:00	SPY	ETF	329.08	329.665	327.44	327.51	7610244.0
2020-09-23 12:00:00	SPY	ETF	327.51	328.67	327.12	328.66	5625367.0
2020-09-23 13:00:00	SPY	ETF	328.65	328.729	326.645	326.9905	6389967.0
2020-09-23 14:00:00	SPY	ETF	327.0	327.01	323.44	323.64	15054755.0
2020-09-23 15:00:00	SPY	ETF	323.63	324.0199	322.1	322.66	30581993.0
2020-09-23 16:00:00	SPY	ETF	322.66	323.22	322.52	323.1	9766569.0
2020-09-23 17:00:00	SPY	ETF	323.06	323.12	322.5	322.78	486611.0
2020-09-23 18:00:00	SPY	ETF	322.78	323.49	322.57	322.72	255212.0
2020-09-23 19:00:00	SPY	ETF	322.93	323.0	321.04	321.7	442805.0
2020-09-23 04:00:00	QQQ	ETF	272.18	273.2	272.18	273.19	68731.0
2020-09-23 05:00:00	QQQ	ETF	273.2	273.83	273.15	273.83	50654.0
2020-09-23 06:00:00	QQQ	ETF	273.75	273.75	272.73	273.23	61306.0
2020-09-23 07:00:00	QQQ	ETF	273.35	273.35	271.5	271.63	271174.0
2020-09-23 08:00:00	QQQ	ETF	271.63	273.36	271.23	271.82	649568.0
2020-09-23 09:00:00	QQQ	ETF	271.84	272.34	270.2	270.38	3408444.0
2020-09-23 10:00:00	QQQ	ETF	270.38	270.9773	269.2	270.03	5609134.0
2020-09-23 11:00:00	QQQ	ETF	270.01	270.65	268.05	268.16	4100052.0
2020-09-23 12:00:00	QQQ	ETF	268.14	269.56	267.75	269.48	3574272.0
2020-09-23 13:00:00	QQQ	ETF	269.47	269.55	267.36	267.57	3466897.0
2020-09-23 14:00:00	QQQ	ETF	267.58	267.87	264.37	264.645	7165703.0
2020-09-23 15:00:00	QQQ	ETF	264.65	265.38	263.2502	264.08	11004343.0
2020-09-23 16:00:00	QQQ	ETF	264.09	264.45	263.77	264.12	1274073.0
2020-09-23 17:00:00	QQQ	ETF	264.06	264.29	263.1	263.39	145877.0
2020-09-23 18:00:00	QQQ	ETF	263.4	264.29	263.3	263.49	209788.0
2020-09-23 19:00:00	QQQ	ETF	263.6	263.85	261.81	262.42	329912.0
2020-09-23 04:00:00	IWM	ETF	148.5	149.08	148.5	149.08	12681.0
2020-09-23 05:00:00	IWM	ETF	148.91	149.17	148.91	149.17	4659.0
2020-09-23 06:00:00	IWM	ETF	149.1	149.25	148.92	149.24	63811.0
2020-09-23 07:00:00	IWM	ETF	149.17	149.23	148.76	148.8	91108.0
2020-09-23 08:00:00	IWM	ETF	149.1599	149.19	148.43	148.59	240652.0
2020-09-23 09:00:00	IWM	ETF	148.5	149.43	148.38	148.68	2273590.0
2020-09-23 10:00:00	IWM	ETF	148.68	148.75	147.53	148.22	2516010.0
2020-09-23 11:00:00	IWM	ETF	148.21	148.64	147.23	147.27	2134077.0
2020-09-23 12:00:00	IWM	ETF	147.27	147.89	147.14	147.78	1774161.0
2020-09-23 13:00:00	IWM	ETF	147.79	147.815	146.77	146.9	1408948.0
2020-09-23 14:00:00	IWM	ETF	146.895	146.895	144.73	144.84	4105271.0
2020-09-23 15:00:00	IWM	ETF	144.86	145.225	143.98	144.12	6826259.0
2020-09-23 16:00:00	IWM	ETF	144.12	144.33	143.94	144.2	2680670.0
2020-09-23 17:00:00	IWM	ETF	144.43	144.43	144.0	144.07	716179.0
2020-09-23 18:00:00	IWM	ETF	144.07	144.51	144.07	144.15	29018.0
2020-09-23 19:00:00	IWM	ETF	144.12	144.12	143.43	143.7	46072.0
2020-09-23 04:00:00	DIA	ETF	274.12	274.69	274.12	274.66	2900.0
2020-09-23 05:00:00	DIA	ETF	274.71	274.71	274.56	274.6	672.0

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

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