PREVIEW / etf_1hour / 2020-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-20.parquet
  size:    365 KB
  rows:    12,542

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-07-20 04:00:00	SPY	ETF	319.92	320.91	319.62	320.85	30082.0
2020-07-20 05:00:00	SPY	ETF	321.0	321.43	320.8	320.88	106350.0
2020-07-20 06:00:00	SPY	ETF	320.96	321.03	320.46	320.67	41759.0
2020-07-20 07:00:00	SPY	ETF	320.68	321.48	320.68	321.24	184434.0
2020-07-20 08:00:00	SPY	ETF	321.2	321.65	320.0	321.51	949665.0
2020-07-20 09:00:00	SPY	ETF	321.49	322.14	320.62	321.13	6705887.0
2020-07-20 10:00:00	SPY	ETF	321.145	323.02	320.93	322.49	9307414.0
2020-07-20 11:00:00	SPY	ETF	322.49	323.14	322.33	322.86	3638690.0
2020-07-20 12:00:00	SPY	ETF	322.86	323.09	322.46	323.02	4748348.0
2020-07-20 13:00:00	SPY	ETF	323.03	323.81	322.86	323.71	4012928.0
2020-07-20 14:00:00	SPY	ETF	323.7098	323.98	323.5172	323.78	5240516.0
2020-07-20 15:00:00	SPY	ETF	323.77	325.13	323.64	324.36	15066870.0
2020-07-20 16:00:00	SPY	ETF	324.34	324.67	324.26	324.45	4710392.0
2020-07-20 17:00:00	SPY	ETF	324.45	324.49	324.28	324.28	59832.0
2020-07-20 18:00:00	SPY	ETF	324.32	324.62	324.2	324.31	103072.0
2020-07-20 19:00:00	SPY	ETF	324.3	324.69	324.3	324.4	49739.0
2020-07-20 04:00:00	QQQ	ETF	258.01	258.78	257.79	258.76	74889.0
2020-07-20 05:00:00	QQQ	ETF	258.8	259.49	258.8	259.42	57593.0
2020-07-20 06:00:00	QQQ	ETF	259.44	259.44	259.07	259.37	33786.0
2020-07-20 07:00:00	QQQ	ETF	259.47	260.24	259.32	259.99	187702.0
2020-07-20 08:00:00	QQQ	ETF	259.39	260.37	257.48	260.25	587579.0
2020-07-20 09:00:00	QQQ	ETF	260.3	260.96	258.79	260.65	4661755.0
2020-07-20 10:00:00	QQQ	ETF	260.69	262.91	260.36	262.4	5115832.0
2020-07-20 11:00:00	QQQ	ETF	262.4	263.81	262.205	263.63	3025342.0
2020-07-20 12:00:00	QQQ	ETF	263.64	264.3	263.15	264.25	2918581.0
2020-07-20 13:00:00	QQQ	ETF	264.27	265.05	264.17	264.6173	3227679.0
2020-07-20 14:00:00	QQQ	ETF	264.6101	266.13	264.55	265.7174	3196399.0
2020-07-20 15:00:00	QQQ	ETF	265.72	267.43	265.64	266.79	8369203.0
2020-07-20 16:00:00	QQQ	ETF	266.8	267.2	266.77	267.04	1076711.0
2020-07-20 17:00:00	QQQ	ETF	267.09	267.09	266.8	267.0	43260.0
2020-07-20 18:00:00	QQQ	ETF	267.07	267.59	266.75	266.86	369332.0
2020-07-20 19:00:00	QQQ	ETF	266.88	267.32	266.83	267.15	64966.0
2020-07-20 04:00:00	IWM	ETF	145.49	146.08	145.4	146.08	8492.0
2020-07-20 05:00:00	IWM	ETF	146.23	146.23	145.9	145.9	23000.0
2020-07-20 06:00:00	IWM	ETF	145.75	145.86	145.63	145.65	14875.0
2020-07-20 07:00:00	IWM	ETF	145.83	146.27	145.77	146.2	50182.0
2020-07-20 08:00:00	IWM	ETF	146.23	146.35	145.18	146.3	157615.0
2020-07-20 09:00:00	IWM	ETF	146.3001	146.85	145.37	145.61	2790655.0
2020-07-20 10:00:00	IWM	ETF	145.645	146.4	145.32	145.89	3060771.0
2020-07-20 11:00:00	IWM	ETF	145.9	146.2	145.65	145.75	1769812.0
2020-07-20 12:00:00	IWM	ETF	145.75	145.76	145.15	145.68	2629553.0
2020-07-20 13:00:00	IWM	ETF	145.69	146.29	145.53	146.07	1878362.0
2020-07-20 14:00:00	IWM	ETF	146.06	146.32	145.95	146.165	1197206.0
2020-07-20 15:00:00	IWM	ETF	146.16	146.32	145.92	145.95	2571286.0
2020-07-20 16:00:00	IWM	ETF	145.96	146.11	145.57	145.85	463052.0
2020-07-20 17:00:00	IWM	ETF	145.82	146.06	145.82	145.92	17370.0
2020-07-20 18:00:00	IWM	ETF	145.93	145.96	145.72	145.95	43762.0
2020-07-20 19:00:00	IWM	ETF	146.03	146.07	145.93	145.98	14774.0
2020-07-20 04:00:00	DIA	ETF	265.15	265.91	264.93	265.91	6620.0
2020-07-20 05:00:00	DIA	ETF	266.34	266.54	266.01	266.01	3392.0

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

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