PREVIEW / etf_1hour / 2020-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-20.parquet
  size:    364 KB
  rows:    12,285

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-20 04:00:00	SPY	ETF	336.54	336.54	335.03	336.07	45530.0
2020-08-20 05:00:00	SPY	ETF	335.91	336.23	335.82	336.1	20742.0
2020-08-20 06:00:00	SPY	ETF	336.13	336.87	336.08	336.87	45177.0
2020-08-20 07:00:00	SPY	ETF	336.76	336.83	336.15	336.27	138239.0
2020-08-20 08:00:00	SPY	ETF	336.5699	336.79	335.3	335.88	476708.0
2020-08-20 09:00:00	SPY	ETF	335.88	336.78	335.22	336.74	6504225.0
2020-08-20 10:00:00	SPY	ETF	336.75	337.53	336.52	337.16	5907556.0
2020-08-20 11:00:00	SPY	ETF	337.16	337.82	336.76	337.69	3947935.0
2020-08-20 12:00:00	SPY	ETF	337.69	337.86	337.25	337.32	2853375.0
2020-08-20 13:00:00	SPY	ETF	337.33	337.75	337.13	337.5823	2152938.0
2020-08-20 14:00:00	SPY	ETF	337.58	338.24	337.53	338.22	4123433.0
2020-08-20 15:00:00	SPY	ETF	338.22	338.8	337.77	338.25	12182116.0
2020-08-20 16:00:00	SPY	ETF	338.31	338.73	338.01	338.35	2595088.0
2020-08-20 17:00:00	SPY	ETF	338.35	338.38	338.17	338.35	414629.0
2020-08-20 18:00:00	SPY	ETF	338.33	338.85	338.33	338.65	127173.0
2020-08-20 19:00:00	SPY	ETF	338.68	339.0	338.64	338.96	59850.0
2020-08-20 20:00:00	SPY	ETF	338.97	338.97	338.97	338.97	510.0
2020-08-20 04:00:00	QQQ	ETF	275.5	275.57	274.76	275.56	28623.0
2020-08-20 05:00:00	QQQ	ETF	275.49	276.08	275.4	275.95	26468.0
2020-08-20 06:00:00	QQQ	ETF	275.88	276.57	275.88	276.52	50809.0
2020-08-20 07:00:00	QQQ	ETF	276.47	276.5	275.96	276.17	100391.0
2020-08-20 08:00:00	QQQ	ETF	276.25	276.46	274.67	275.79	199155.0
2020-08-20 09:00:00	QQQ	ETF	275.71	277.55	274.86	277.34	3548538.0
2020-08-20 10:00:00	QQQ	ETF	277.34	278.11	276.87	277.955	4073823.0
2020-08-20 11:00:00	QQQ	ETF	277.96	278.71	277.29	278.61	2619112.0
2020-08-20 12:00:00	QQQ	ETF	278.605	278.72	278.0014	278.0901	1661045.0
2020-08-20 13:00:00	QQQ	ETF	278.11	278.74	277.86	278.668	1525392.0
2020-08-20 14:00:00	QQQ	ETF	278.66	279.66	278.58	279.64	2492432.0
2020-08-20 15:00:00	QQQ	ETF	279.64	280.43	279.32	279.88	5643636.0
2020-08-20 16:00:00	QQQ	ETF	279.88	280.23	279.76	280.04	729401.0
2020-08-20 17:00:00	QQQ	ETF	280.01	280.2	279.93	280.07	66130.0
2020-08-20 18:00:00	QQQ	ETF	280.07	280.47	280.07	280.31	50052.0
2020-08-20 19:00:00	QQQ	ETF	280.33	280.56	280.26	280.52	48110.0
2020-08-20 04:00:00	IWM	ETF	155.5	155.5	155.0	155.32	2215.0
2020-08-20 05:00:00	IWM	ETF	155.49	155.54	155.43	155.54	3000.0
2020-08-20 06:00:00	IWM	ETF	155.56	155.9	155.56	155.9	2783.0
2020-08-20 07:00:00	IWM	ETF	155.85	155.87	155.5	155.55	20705.0
2020-08-20 08:00:00	IWM	ETF	155.6196	155.8499	154.99	155.27	182770.0
2020-08-20 09:00:00	IWM	ETF	155.21	155.66	154.54	155.48	2348440.0
2020-08-20 10:00:00	IWM	ETF	155.47	156.35	155.31	155.77	2231163.0
2020-08-20 11:00:00	IWM	ETF	155.76	156.485	155.66	156.27	1228426.0
2020-08-20 12:00:00	IWM	ETF	156.26	156.26	155.56	155.64	1313053.0
2020-08-20 13:00:00	IWM	ETF	155.62	155.795	155.47	155.645	837044.0
2020-08-20 14:00:00	IWM	ETF	155.64	155.93	155.61	155.883	1203921.0
2020-08-20 15:00:00	IWM	ETF	155.88	156.24	155.62	155.74	2878546.0
2020-08-20 16:00:00	IWM	ETF	155.72	155.77	155.4	155.7	663506.0
2020-08-20 17:00:00	IWM	ETF	155.7	155.7	155.55	155.6	7708.0
2020-08-20 18:00:00	IWM	ETF	155.67	155.92	155.55	155.92	10967.0
2020-08-20 19:00:00	IWM	ETF	155.82	156.08	155.71	156.05	40658.0
2020-08-20 04:00:00	DIA	ETF	276.5	276.5	276.09	276.09	300.0

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

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