PREVIEW / etf_1hour / 2020-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-03.parquet
  size:    394 KB
  rows:    13,545

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-12-03 04:00:00	SPY	ETF	366.28	366.72	365.8	366.38	18794.0
2020-12-03 05:00:00	SPY	ETF	366.25	366.5	366.18	366.5	3745.0
2020-12-03 06:00:00	SPY	ETF	366.57	366.8	366.49	366.68	76302.0
2020-12-03 07:00:00	SPY	ETF	366.69	366.96	366.41	366.96	303980.0
2020-12-03 08:00:00	SPY	ETF	366.5701	367.01	366.2	366.69	311161.0
2020-12-03 09:00:00	SPY	ETF	366.65	367.278	366.65	367.01	3613140.0
2020-12-03 10:00:00	SPY	ETF	367.0	367.99	366.96	367.5001	5002474.0
2020-12-03 11:00:00	SPY	ETF	367.5	367.88	366.91	367.6182	3558353.0
2020-12-03 12:00:00	SPY	ETF	367.62	367.89	367.05	367.45	4105467.0
2020-12-03 13:00:00	SPY	ETF	367.44	367.495	366.39	366.52	3837831.0
2020-12-03 14:00:00	SPY	ETF	366.52	367.63	366.47	367.59	6076448.0
2020-12-03 15:00:00	SPY	ETF	367.571	368.19	365.5	366.6698	25147615.0
2020-12-03 16:00:00	SPY	ETF	366.67	367.08	366.25	366.76	8450626.0
2020-12-03 17:00:00	SPY	ETF	366.89	367.0	366.72	366.87	132201.0
2020-12-03 18:00:00	SPY	ETF	366.87	367.28	366.58	366.93	229149.0
2020-12-03 19:00:00	SPY	ETF	367.0	367.4	367.0	367.28	78551.0
2020-12-03 04:00:00	QQQ	ETF	304.4	304.5	303.91	304.43	7290.0
2020-12-03 05:00:00	QQQ	ETF	304.48	304.49	304.15	304.25	5153.0
2020-12-03 06:00:00	QQQ	ETF	304.28	304.46	304.24	304.36	5236.0
2020-12-03 07:00:00	QQQ	ETF	304.38	304.73	304.34	304.65	97407.0
2020-12-03 08:00:00	QQQ	ETF	304.45	304.7	303.85	304.25	218299.0
2020-12-03 09:00:00	QQQ	ETF	304.22	304.99	304.04	304.75	2193696.0
2020-12-03 10:00:00	QQQ	ETF	304.79	305.88	304.38	304.4299	2919578.0
2020-12-03 11:00:00	QQQ	ETF	304.431	305.235	303.67	305.14	2401500.0
2020-12-03 12:00:00	QQQ	ETF	305.16	305.48	304.29	304.58	1710686.0
2020-12-03 13:00:00	QQQ	ETF	304.58	304.82	304.03	304.1379	1527607.0
2020-12-03 14:00:00	QQQ	ETF	304.14	304.99	304.11	304.98	1491305.0
2020-12-03 15:00:00	QQQ	ETF	304.98	305.23	303.531	304.19	4528862.0
2020-12-03 16:00:00	QQQ	ETF	304.22	305.1368	303.95	304.58	714967.0
2020-12-03 17:00:00	QQQ	ETF	304.6	304.63	304.45	304.5	26274.0
2020-12-03 18:00:00	QQQ	ETF	304.62	304.77	304.3	304.51	93968.0
2020-12-03 19:00:00	QQQ	ETF	304.55	304.79	304.47	304.7	52554.0
2020-12-03 04:00:00	IWM	ETF	182.65	182.82	182.22	182.4	11747.0
2020-12-03 05:00:00	IWM	ETF	182.38	182.62	182.32	182.62	5133.0
2020-12-03 06:00:00	IWM	ETF	182.66	182.78	182.6	182.74	3722.0
2020-12-03 07:00:00	IWM	ETF	182.78	183.06	182.58	183.03	27216.0
2020-12-03 08:00:00	IWM	ETF	182.98	183.1	182.44	183.02	58911.0
2020-12-03 09:00:00	IWM	ETF	183.01	183.6618	182.94	183.55	1653310.0
2020-12-03 10:00:00	IWM	ETF	183.55	184.74	183.52	184.67	2875065.0
2020-12-03 11:00:00	IWM	ETF	184.68	185.02	184.45	184.8	1982154.0
2020-12-03 12:00:00	IWM	ETF	184.8	185.18	184.58	184.88	1439089.0
2020-12-03 13:00:00	IWM	ETF	184.88	185.08	184.33	184.43	1165606.0
2020-12-03 14:00:00	IWM	ETF	184.44	184.89	184.295	184.68	1279352.0
2020-12-03 15:00:00	IWM	ETF	184.66	185.01	183.15	183.92	6055927.0
2020-12-03 16:00:00	IWM	ETF	183.92	184.43	183.84	184.16	780135.0
2020-12-03 17:00:00	IWM	ETF	184.2	184.32	184.16	184.3	8625.0
2020-12-03 18:00:00	IWM	ETF	184.24	184.5	184.0	184.28	30865.0
2020-12-03 19:00:00	IWM	ETF	184.32	184.54	184.18	184.32	24845.0
2020-12-03 04:00:00	DIA	ETF	299.09	299.09	298.14	298.37	1700.0
2020-12-03 05:00:00	DIA	ETF	298.5	298.67	298.5	298.67	800.0

> showing 50 of 13,545 rows — these rows as CSV

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