PREVIEW / etf_1hour / 2020-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-17.parquet
  size:    369 KB
  rows:    12,596

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-17 04:00:00	SPY	ETF	334.42	335.59	334.42	335.3	121853.0
2020-09-17 05:00:00	SPY	ETF	335.42	335.8	335.0	335.79	52400.0
2020-09-17 06:00:00	SPY	ETF	335.65	335.86	334.74	334.8	91368.0
2020-09-17 07:00:00	SPY	ETF	334.84	335.64	334.58	334.64	384429.0
2020-09-17 08:00:00	SPY	ETF	334.8301	336.64	333.18	333.3701	1126859.0
2020-09-17 09:00:00	SPY	ETF	333.37	335.36	332.77	335.16	11984330.0
2020-09-17 10:00:00	SPY	ETF	335.165	337.25	334.84	336.32	15616457.0
2020-09-17 11:00:00	SPY	ETF	336.33	337.6996	334.91	335.19	10617945.0
2020-09-17 12:00:00	SPY	ETF	335.16	335.46	332.991	334.515	12334292.0
2020-09-17 13:00:00	SPY	ETF	334.51	334.95	333.57	334.38	8408591.0
2020-09-17 14:00:00	SPY	ETF	334.415	335.31	333.32	334.02	6388946.0
2020-09-17 15:00:00	SPY	ETF	334.03	336.04	333.0	335.86	17252261.0
2020-09-17 16:00:00	SPY	ETF	335.87	338.6783	335.79	335.91	5692382.0
2020-09-17 17:00:00	SPY	ETF	335.91	335.93	335.6	335.75	231616.0
2020-09-17 18:00:00	SPY	ETF	335.73	336.68	335.73	336.65	124366.0
2020-09-17 19:00:00	SPY	ETF	336.67	336.95	335.99	336.02	144973.0
2020-09-17 04:00:00	QQQ	ETF	270.45	271.61	270.42	271.48	160055.0
2020-09-17 05:00:00	QQQ	ETF	271.6	272.91	271.22	272.68	78433.0
2020-09-17 06:00:00	QQQ	ETF	272.68	272.7	270.5	270.51	210012.0
2020-09-17 07:00:00	QQQ	ETF	270.52	271.3	269.34	269.62	603144.0
2020-09-17 08:00:00	QQQ	ETF	269.62	272.23	268.0	268.17	1193334.0
2020-09-17 09:00:00	QQQ	ETF	268.21	270.41	266.44	270.28	11855278.0
2020-09-17 10:00:00	QQQ	ETF	270.28	271.88	268.89	270.78	8813706.0
2020-09-17 11:00:00	QQQ	ETF	270.79	272.37	268.74	268.89	6585190.0
2020-09-17 12:00:00	QQQ	ETF	268.87	269.48	266.68	268.39	8933953.0
2020-09-17 13:00:00	QQQ	ETF	268.37	269.68	267.56	268.922	5020342.0
2020-09-17 14:00:00	QQQ	ETF	268.97	269.85	267.63	268.5006	4391150.0
2020-09-17 15:00:00	QQQ	ETF	268.51	270.51	267.47	270.37	9636615.0
2020-09-17 16:00:00	QQQ	ETF	270.35	271.22	269.5355	270.39	1695636.0
2020-09-17 17:00:00	QQQ	ETF	270.42	270.42	270.0	270.26	138817.0
2020-09-17 18:00:00	QQQ	ETF	270.16	271.12	270.12	271.08	144488.0
2020-09-17 19:00:00	QQQ	ETF	271.12	271.54	270.45	270.45	171439.0
2020-09-17 04:00:00	IWM	ETF	152.76	153.22	152.75	153.08	47775.0
2020-09-17 05:00:00	IWM	ETF	153.14	153.19	152.82	153.0	48750.0
2020-09-17 06:00:00	IWM	ETF	152.93	153.11	152.78	152.78	79077.0
2020-09-17 07:00:00	IWM	ETF	152.79	153.34	152.78	153.05	99064.0
2020-09-17 08:00:00	IWM	ETF	152.9796	153.44	152.36	152.4	116778.0
2020-09-17 09:00:00	IWM	ETF	152.41	153.14	151.75	153.12	2592719.0
2020-09-17 10:00:00	IWM	ETF	153.13	154.12	153.021	153.68	2643049.0
2020-09-17 11:00:00	IWM	ETF	153.68	154.4	153.39	153.43	1459174.0
2020-09-17 12:00:00	IWM	ETF	153.43	153.59	152.579	153.54	1975447.0
2020-09-17 13:00:00	IWM	ETF	153.51	153.97	153.18	153.81	1150096.0
2020-09-17 14:00:00	IWM	ETF	153.83	154.23	153.39	153.6699	1449837.0
2020-09-17 15:00:00	IWM	ETF	153.66	153.89	153.0	153.71	3936227.0
2020-09-17 16:00:00	IWM	ETF	153.69	153.88	153.55	153.55	844310.0
2020-09-17 17:00:00	IWM	ETF	153.13	153.67	153.13	153.52	1731.0
2020-09-17 18:00:00	IWM	ETF	153.45	154.0	153.45	154.0	20004.0
2020-09-17 19:00:00	IWM	ETF	154.0	154.11	153.66	153.66	18264.0
2020-09-17 04:00:00	DIA	ETF	279.5	279.5	277.92	278.75	2146.0
2020-09-17 05:00:00	DIA	ETF	278.6	278.6	278.6	278.6	120.0

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

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