PREVIEW / etf_1hour / 2020-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-22.parquet
  size:    367 KB
  rows:    12,531

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-22 04:00:00	SPY	ETF	326.64	327.52	326.45	326.77	49465.0
2020-09-22 05:00:00	SPY	ETF	326.88	328.0	326.88	327.77	24577.0
2020-09-22 06:00:00	SPY	ETF	327.73	328.23	327.44	327.83	60054.0
2020-09-22 07:00:00	SPY	ETF	327.83	328.58	326.73	327.07	436191.0
2020-09-22 08:00:00	SPY	ETF	327.07	328.62	326.14	327.72	505884.0
2020-09-22 09:00:00	SPY	ETF	327.72	329.15	327.0	327.47	7767752.0
2020-09-22 10:00:00	SPY	ETF	327.47	328.96	326.2889	326.3236	9437412.0
2020-09-22 11:00:00	SPY	ETF	326.34	327.72	325.86	327.62	7567840.0
2020-09-22 12:00:00	SPY	ETF	327.61	328.3	326.93	327.31	4385157.0
2020-09-22 13:00:00	SPY	ETF	327.3	329.13	327.16	329.08	5098691.0
2020-09-22 14:00:00	SPY	ETF	329.09	329.87	329.05	329.18	6877526.0
2020-09-22 15:00:00	SPY	ETF	329.2	330.9	328.92	330.33	14714347.0
2020-09-22 16:00:00	SPY	ETF	330.33	330.386	329.59	330.07	3905266.0
2020-09-22 17:00:00	SPY	ETF	330.06	330.3	330.0	330.14	66569.0
2020-09-22 18:00:00	SPY	ETF	330.2	330.32	329.44	329.55	125119.0
2020-09-22 19:00:00	SPY	ETF	329.41	330.2	329.34	330.16	98564.0
2020-09-22 04:00:00	QQQ	ETF	267.41	268.79	267.26	268.42	51931.0
2020-09-22 05:00:00	QQQ	ETF	268.36	270.0	268.36	269.6	25474.0
2020-09-22 06:00:00	QQQ	ETF	269.38	270.3	269.21	269.77	23997.0
2020-09-22 07:00:00	QQQ	ETF	269.51	270.03	268.24	268.47	127831.0
2020-09-22 08:00:00	QQQ	ETF	269.5389	269.99	266.27	269.54	317305.0
2020-09-22 09:00:00	QQQ	ETF	269.53	270.23	267.21	268.59	5158998.0
2020-09-22 10:00:00	QQQ	ETF	268.6	269.71	267.06	267.11	4765620.0
2020-09-22 11:00:00	QQQ	ETF	267.13	268.94	266.54	268.85	3487279.0
2020-09-22 12:00:00	QQQ	ETF	268.84	269.93	268.52	268.94	2568422.0
2020-09-22 13:00:00	QQQ	ETF	268.9106	270.98	268.78	270.95	2760924.0
2020-09-22 14:00:00	QQQ	ETF	270.9601	271.88	270.71	271.03	3760651.0
2020-09-22 15:00:00	QQQ	ETF	271.0501	273.08	270.72	272.45	7635173.0
2020-09-22 16:00:00	QQQ	ETF	272.44	272.95	271.85	272.17	1668095.0
2020-09-22 17:00:00	QQQ	ETF	272.06	272.48	272.01	272.31	256028.0
2020-09-22 18:00:00	QQQ	ETF	272.29	272.42	271.15	271.19	106768.0
2020-09-22 19:00:00	QQQ	ETF	271.2	271.4	270.77	271.4	99042.0
2020-09-22 04:00:00	IWM	ETF	147.88	148.13	147.88	148.02	900.0
2020-09-22 05:00:00	IWM	ETF	147.95	148.3	147.95	148.01	3850.0
2020-09-22 06:00:00	IWM	ETF	148.04	148.38	148.02	148.38	12169.0
2020-09-22 07:00:00	IWM	ETF	148.25	148.7	147.69	147.7	113068.0
2020-09-22 08:00:00	IWM	ETF	148.5599	148.6101	147.73	148.16	58030.0
2020-09-22 09:00:00	IWM	ETF	148.25	149.05	147.41	147.55	2882199.0
2020-09-22 10:00:00	IWM	ETF	147.53	148.43	146.79	146.805	2843658.0
2020-09-22 11:00:00	IWM	ETF	146.81	147.63	146.56	147.5925	1880984.0
2020-09-22 12:00:00	IWM	ETF	147.59	147.99	147.37	147.5	1201459.0
2020-09-22 13:00:00	IWM	ETF	147.5	148.72	147.34	148.65	1367165.0
2020-09-22 14:00:00	IWM	ETF	148.67	149.21	148.57	148.89	1490662.0
2020-09-22 15:00:00	IWM	ETF	148.89	149.3	148.44	149.05	3025886.0
2020-09-22 16:00:00	IWM	ETF	149.06	149.08	148.65	148.83	427855.0
2020-09-22 17:00:00	IWM	ETF	148.97	149.03	148.88	148.88	1006471.0
2020-09-22 18:00:00	IWM	ETF	148.97	148.97	148.63	148.63	21383.0
2020-09-22 19:00:00	IWM	ETF	148.62	149.02	148.62	149.01	7499.0
2020-09-22 04:00:00	DIA	ETF	271.26	271.26	270.93	270.93	1100.0
2020-09-22 05:00:00	DIA	ETF	271.46	271.46	271.46	271.46	100.0

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

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