PREVIEW / etf_1hour / 2020-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-28.parquet
  size:    368 KB
  rows:    12,583

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-08-28 04:00:00	SPY	ETF	349.26	350.07	349.26	349.92	36770.0
2020-08-28 05:00:00	SPY	ETF	349.79	350.07	349.55	349.88	32435.0
2020-08-28 06:00:00	SPY	ETF	349.89	349.89	349.0	349.41	28344.0
2020-08-28 07:00:00	SPY	ETF	349.4	349.97	349.4	349.89	99393.0
2020-08-28 08:00:00	SPY	ETF	349.8601	350.58	348.89	349.36	212982.0
2020-08-28 09:00:00	SPY	ETF	349.35	349.68	348.61	349.29	4255862.0
2020-08-28 10:00:00	SPY	ETF	349.295	349.35	348.15	348.4	6523805.0
2020-08-28 11:00:00	SPY	ETF	348.41	349.44	348.26	349.3	4859042.0
2020-08-28 12:00:00	SPY	ETF	349.29	349.71	349.07	349.67	3508702.0
2020-08-28 13:00:00	SPY	ETF	349.68	349.68	348.75	349.25	5061404.0
2020-08-28 14:00:00	SPY	ETF	349.26	349.92	348.994	349.78	4435418.0
2020-08-28 15:00:00	SPY	ETF	349.7777	350.72	349.69	350.54	13293316.0
2020-08-28 16:00:00	SPY	ETF	350.53	350.72	348.2234	350.67	2818929.0
2020-08-28 17:00:00	SPY	ETF	350.61	350.84	350.58	350.8	372834.0
2020-08-28 18:00:00	SPY	ETF	350.79	351.07	350.78	350.94	80283.0
2020-08-28 19:00:00	SPY	ETF	350.94	351.03	350.88	350.98	35404.0
2020-08-28 04:00:00	QQQ	ETF	291.6	291.9	291.33	291.33	30980.0
2020-08-28 05:00:00	QQQ	ETF	291.36	291.63	291.17	291.48	15671.0
2020-08-28 06:00:00	QQQ	ETF	291.45	291.47	290.82	291.2	42180.0
2020-08-28 07:00:00	QQQ	ETF	291.42	292.2	291.4	292.1	147788.0
2020-08-28 08:00:00	QQQ	ETF	292.1	293.3	290.95	291.85	225027.0
2020-08-28 09:00:00	QQQ	ETF	291.83	292.88	291.47	292.88	3214879.0
2020-08-28 10:00:00	QQQ	ETF	292.875	293.18	291.465	291.7	4289913.0
2020-08-28 11:00:00	QQQ	ETF	291.7	292.83	291.45	292.5827	2428660.0
2020-08-28 12:00:00	QQQ	ETF	292.59	292.8399	291.8	292.27	2182723.0
2020-08-28 13:00:00	QQQ	ETF	292.285	292.32	290.93	291.895	3086240.0
2020-08-28 14:00:00	QQQ	ETF	291.9	292.38	291.6	291.85	2531619.0
2020-08-28 15:00:00	QQQ	ETF	291.86	293.03	291.7467	292.5	4158866.0
2020-08-28 16:00:00	QQQ	ETF	292.5	292.8	292.43	292.7	1075912.0
2020-08-28 17:00:00	QQQ	ETF	292.61	292.77	292.6	292.67	8793.0
2020-08-28 18:00:00	QQQ	ETF	292.66	292.88	292.66	292.82	30708.0
2020-08-28 19:00:00	QQQ	ETF	292.82	292.85	292.67	292.82	37320.0
2020-08-28 04:00:00	IWM	ETF	156.68	157.16	156.64	157.16	20610.0
2020-08-28 05:00:00	IWM	ETF	157.08	157.37	156.9	157.15	11253.0
2020-08-28 06:00:00	IWM	ETF	157.08	157.08	156.6	156.94	8220.0
2020-08-28 07:00:00	IWM	ETF	156.89	157.16	156.88	157.05	32628.0
2020-08-28 08:00:00	IWM	ETF	156.8804	157.63	156.5	156.66	81074.0
2020-08-28 09:00:00	IWM	ETF	156.79	156.82	155.73	156.29	1478429.0
2020-08-28 10:00:00	IWM	ETF	156.3	156.57	155.8	155.97	1505541.0
2020-08-28 11:00:00	IWM	ETF	155.96	156.62	155.845	156.24	918529.0
2020-08-28 12:00:00	IWM	ETF	156.23	156.67	156.16	156.5	666428.0
2020-08-28 13:00:00	IWM	ETF	156.51	156.55	156.162	156.37	942665.0
2020-08-28 14:00:00	IWM	ETF	156.37	156.78	156.255	156.63	1137608.0
2020-08-28 15:00:00	IWM	ETF	156.63	157.2	156.47	157.14	3431449.0
2020-08-28 16:00:00	IWM	ETF	157.12	157.21	156.9	157.04	630157.0
2020-08-28 17:00:00	IWM	ETF	157.15	157.25	157.09	157.25	5273.0
2020-08-28 18:00:00	IWM	ETF	157.29	157.34	157.22	157.22	8660.0
2020-08-28 19:00:00	IWM	ETF	157.28	157.28	157.16	157.16	2864.0
2020-08-28 06:00:00	DIA	ETF	286.17	286.17	286.17	286.17	100.0
2020-08-28 07:00:00	DIA	ETF	286.33	286.75	286.33	286.75	9423.0

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

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