PREVIEW / etf_1hour / 2020-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-13.parquet
  size:    366 KB
  rows:    12,413

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-13 04:00:00	SPY	ETF	336.98	337.13	336.53	337.09	54619.0
2020-08-13 05:00:00	SPY	ETF	337.03	337.03	336.61	336.75	3961.0
2020-08-13 06:00:00	SPY	ETF	336.72	336.93	336.72	336.79	10481.0
2020-08-13 07:00:00	SPY	ETF	336.67	336.93	336.54	336.66	98323.0
2020-08-13 08:00:00	SPY	ETF	336.61	337.48	336.52	337.2	421601.0
2020-08-13 09:00:00	SPY	ETF	337.2	337.93	336.46	337.91	4900234.0
2020-08-13 10:00:00	SPY	ETF	337.9	337.98	337.28	337.82	4207481.0
2020-08-13 11:00:00	SPY	ETF	337.82	338.12	337.49	337.68	3668518.0
2020-08-13 12:00:00	SPY	ETF	337.7	338.15	337.69	338.11	2209446.0
2020-08-13 13:00:00	SPY	ETF	338.1	338.2514	337.06	337.6	5068288.0
2020-08-13 14:00:00	SPY	ETF	337.605	337.72	335.83	336.25	7823733.0
2020-08-13 15:00:00	SPY	ETF	336.26	337.35	335.96	336.86	9339730.0
2020-08-13 16:00:00	SPY	ETF	336.84	337.14	336.47	337.06	3263046.0
2020-08-13 17:00:00	SPY	ETF	337.06	337.06	336.84	336.98	64369.0
2020-08-13 18:00:00	SPY	ETF	336.97	337.35	336.97	337.33	96918.0
2020-08-13 19:00:00	SPY	ETF	337.35	337.74	337.35	337.62	69905.0
2020-08-13 04:00:00	QQQ	ETF	271.59	271.59	270.73	271.34	8404.0
2020-08-13 05:00:00	QQQ	ETF	271.25	271.45	271.01	271.12	6409.0
2020-08-13 06:00:00	QQQ	ETF	271.1	271.38	271.1	271.19	9114.0
2020-08-13 07:00:00	QQQ	ETF	271.25	271.95	271.23	271.84	84889.0
2020-08-13 08:00:00	QQQ	ETF	271.7301	273.21	270.77	273.06	696499.0
2020-08-13 09:00:00	QQQ	ETF	273.05	273.96	272.39	273.62	4577467.0
2020-08-13 10:00:00	QQQ	ETF	273.61	274.44	272.68	274.17	4090866.0
2020-08-13 11:00:00	QQQ	ETF	274.17	274.68	273.6437	274.049	2375475.0
2020-08-13 12:00:00	QQQ	ETF	274.04	274.7	274.0	274.6712	1432181.0
2020-08-13 13:00:00	QQQ	ETF	274.68	274.83	272.77	273.48	3103698.0
2020-08-13 14:00:00	QQQ	ETF	273.48	273.59	271.51	272.04	4796027.0
2020-08-13 15:00:00	QQQ	ETF	272.06	273.205	271.77	272.48	4786732.0
2020-08-13 16:00:00	QQQ	ETF	272.5	272.88	272.22	272.76	500363.0
2020-08-13 17:00:00	QQQ	ETF	272.82	272.83	272.52	272.69	47710.0
2020-08-13 18:00:00	QQQ	ETF	272.69	273.08	272.69	273.02	61229.0
2020-08-13 19:00:00	QQQ	ETF	273.05	273.5	273.05	273.31	47757.0
2020-08-13 04:00:00	IWM	ETF	157.23	157.23	157.23	157.23	1000.0
2020-08-13 05:00:00	IWM	ETF	157.26	157.26	157.18	157.18	300.0
2020-08-13 06:00:00	IWM	ETF	157.08	157.22	157.04	157.22	2843.0
2020-08-13 07:00:00	IWM	ETF	157.06	157.21	156.93	157.0	14173.0
2020-08-13 08:00:00	IWM	ETF	157.0	157.65	156.92	157.37	69722.0
2020-08-13 09:00:00	IWM	ETF	157.29	158.2	156.65	158.14	1473187.0
2020-08-13 10:00:00	IWM	ETF	158.14	158.53	157.43	157.72	2043121.0
2020-08-13 11:00:00	IWM	ETF	157.7	158.15	157.3	158.0	1789814.0
2020-08-13 12:00:00	IWM	ETF	158.0	158.17	157.735	158.015	765125.0
2020-08-13 13:00:00	IWM	ETF	158.02	158.07	157.37	157.76	1215844.0
2020-08-13 14:00:00	IWM	ETF	157.76	157.85	156.675	156.85	2173505.0
2020-08-13 15:00:00	IWM	ETF	156.82	157.52	156.65	157.22	2923964.0
2020-08-13 16:00:00	IWM	ETF	157.19	157.33	156.96	157.29	314112.0
2020-08-13 17:00:00	IWM	ETF	157.43	157.43	157.12	157.16	32986.0
2020-08-13 18:00:00	IWM	ETF	157.16	157.48	157.16	157.45	39333.0
2020-08-13 19:00:00	IWM	ETF	157.47	157.79	157.47	157.69	20708.0
2020-08-13 04:00:00	DIA	ETF	279.78	279.8	279.61	279.61	324.0
2020-08-13 06:00:00	DIA	ETF	279.66	279.66	279.66	279.66	1500.0

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

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