PREVIEW / etf_1hour / 2020-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-01.parquet
  size:    387 KB
  rows:    13,208

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-01 04:00:00	SPY	ETF	351.27	351.43	350.45	350.5	57137.0
2020-09-01 05:00:00	SPY	ETF	350.61	351.26	350.48	350.96	27269.0
2020-09-01 06:00:00	SPY	ETF	350.96	351.22	350.84	351.15	29224.0
2020-09-01 07:00:00	SPY	ETF	351.06	351.11	350.46	350.54	282708.0
2020-09-01 08:00:00	SPY	ETF	350.54	351.55	350.2	350.32	235415.0
2020-09-01 09:00:00	SPY	ETF	350.23	350.59	349.24	350.473	6785436.0
2020-09-01 10:00:00	SPY	ETF	350.48	351.4	350.18	350.66	8803138.0
2020-09-01 11:00:00	SPY	ETF	350.67	351.22	350.39	350.7601	5564358.0
2020-09-01 12:00:00	SPY	ETF	350.77	351.21	350.69	351.2077	3422303.0
2020-09-01 13:00:00	SPY	ETF	351.201	351.49	350.85	351.32	3520262.0
2020-09-01 14:00:00	SPY	ETF	351.33	351.91	351.25	351.84	6261766.0
2020-09-01 15:00:00	SPY	ETF	351.84	352.69	351.39	352.56	12779806.0
2020-09-01 16:00:00	SPY	ETF	352.56	353.05	351.8155	352.99	5750889.0
2020-09-01 17:00:00	SPY	ETF	353.0	353.0	352.87	352.99	91728.0
2020-09-01 18:00:00	SPY	ETF	352.92	352.97	352.74	352.93	54605.0
2020-09-01 19:00:00	SPY	ETF	352.89	353.58	352.6	353.57	65166.0
2020-09-01 04:00:00	QQQ	ETF	297.97	298.31	297.84	297.92	87732.0
2020-09-01 05:00:00	QQQ	ETF	297.94	298.81	297.94	298.54	52537.0
2020-09-01 06:00:00	QQQ	ETF	298.48	298.65	298.39	298.63	36194.0
2020-09-01 07:00:00	QQQ	ETF	298.61	298.61	297.66	297.86	231471.0
2020-09-01 08:00:00	QQQ	ETF	297.8701	298.5296	296.72	297.37	393945.0
2020-09-01 09:00:00	QQQ	ETF	297.31	297.97	295.79	297.56	4899088.0
2020-09-01 10:00:00	QQQ	ETF	297.59	299.32	297.45	298.14	5834360.0
2020-09-01 11:00:00	QQQ	ETF	298.14	298.8	297.72	298.13	4063228.0
2020-09-01 12:00:00	QQQ	ETF	298.128	299.02	298.04	298.86	2094364.0
2020-09-01 13:00:00	QQQ	ETF	298.86	299.64	298.46	299.3	2083045.0
2020-09-01 14:00:00	QQQ	ETF	299.3	299.54	298.935	299.4119	2245691.0
2020-09-01 15:00:00	QQQ	ETF	299.415	300.04	299.02	299.89	4442659.0
2020-09-01 16:00:00	QQQ	ETF	299.9	300.7	299.88	300.7	1649917.0
2020-09-01 17:00:00	QQQ	ETF	300.72	300.72	300.32	300.6	95307.0
2020-09-01 18:00:00	QQQ	ETF	300.59	300.78	300.44	300.75	51811.0
2020-09-01 19:00:00	QQQ	ETF	300.7	301.51	300.56	301.5	129388.0
2020-09-01 04:00:00	IWM	ETF	156.11	156.11	155.5	155.5	1995.0
2020-09-01 05:00:00	IWM	ETF	155.4	155.8	155.4	155.6	3600.0
2020-09-01 06:00:00	IWM	ETF	155.64	155.83	155.61	155.81	10093.0
2020-09-01 07:00:00	IWM	ETF	155.8	155.85	155.45	155.48	101329.0
2020-09-01 08:00:00	IWM	ETF	155.8004	155.8004	155.31	155.31	68972.0
2020-09-01 09:00:00	IWM	ETF	155.3	155.86	154.45	155.67	1816185.0
2020-09-01 10:00:00	IWM	ETF	155.67	156.56	155.65	156.04	2218794.0
2020-09-01 11:00:00	IWM	ETF	156.05	156.8	156.0	156.44	1626175.0
2020-09-01 12:00:00	IWM	ETF	156.45	156.79	156.34	156.66	958778.0
2020-09-01 13:00:00	IWM	ETF	156.67	156.74	156.33	156.545	1059873.0
2020-09-01 14:00:00	IWM	ETF	156.545	156.71	156.45	156.67	1340712.0
2020-09-01 15:00:00	IWM	ETF	156.68	157.31	156.57	157.22	2845261.0
2020-09-01 16:00:00	IWM	ETF	157.21	157.52	156.78	157.4	766598.0
2020-09-01 17:00:00	IWM	ETF	157.7	157.7	157.21	157.26	36480.0
2020-09-01 18:00:00	IWM	ETF	157.34	157.45	157.3	157.39	20042.0
2020-09-01 19:00:00	IWM	ETF	157.34	157.61	157.34	157.61	6454.0
2020-09-01 05:00:00	DIA	ETF	285.05	285.06	284.95	284.95	600.0
2020-09-01 06:00:00	DIA	ETF	284.78	284.78	284.77	284.77	1600.0

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

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