PREVIEW / etf_1hour / 2020-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-09.parquet
  size:    379 KB
  rows:    12,936

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-09 04:00:00	SPY	ETF	335.45	336.83	335.36	335.86	162268.0
2020-09-09 05:00:00	SPY	ETF	335.7	336.83	335.23	336.83	33953.0
2020-09-09 06:00:00	SPY	ETF	336.77	337.01	335.65	335.92	152697.0
2020-09-09 07:00:00	SPY	ETF	335.93	336.48	335.15	336.3	1073564.0
2020-09-09 08:00:00	SPY	ETF	336.3	337.08	332.0	336.4	803140.0
2020-09-09 09:00:00	SPY	ETF	336.35	338.16	336.29	338.158	11532601.0
2020-09-09 10:00:00	SPY	ETF	338.16	339.87	338.11	339.37	17008609.0
2020-09-09 11:00:00	SPY	ETF	339.39	340.56	338.92	340.25	7086654.0
2020-09-09 12:00:00	SPY	ETF	340.27	341.39	337.14	341.15	6522657.0
2020-09-09 13:00:00	SPY	ETF	341.16	342.23	341.04	341.14	8436717.0
2020-09-09 14:00:00	SPY	ETF	341.1502	341.99	340.7	341.68	7586800.0
2020-09-09 15:00:00	SPY	ETF	341.67	342.46	339.63	339.76	20887066.0
2020-09-09 16:00:00	SPY	ETF	339.75	340.2	338.99	339.62	6467645.0
2020-09-09 17:00:00	SPY	ETF	339.62	339.79	339.31	339.5	254826.0
2020-09-09 18:00:00	SPY	ETF	339.56	341.0	339.56	340.84	420407.0
2020-09-09 19:00:00	SPY	ETF	340.77	341.12	339.87	340.9	554270.0
2020-09-09 04:00:00	QQQ	ETF	272.98	274.79	272.98	274.16	114062.0
2020-09-09 05:00:00	QQQ	ETF	274.24	275.28	273.6	275.28	76842.0
2020-09-09 06:00:00	QQQ	ETF	275.27	275.52	274.23	274.61	151134.0
2020-09-09 07:00:00	QQQ	ETF	274.67	274.72	272.96	274.12	766912.0
2020-09-09 08:00:00	QQQ	ETF	273.9001	275.07	270.05	273.3	877120.0
2020-09-09 09:00:00	QQQ	ETF	273.25	275.84	273.0	274.76	10394356.0
2020-09-09 10:00:00	QQQ	ETF	274.78	277.74	274.14	277.39	9222635.0
2020-09-09 11:00:00	QQQ	ETF	277.42	278.35	276.01	277.72	4689215.0
2020-09-09 12:00:00	QQQ	ETF	277.73	279.285	277.53	279.245	3055755.0
2020-09-09 13:00:00	QQQ	ETF	279.255	280.045	277.62	277.79	4858163.0
2020-09-09 14:00:00	QQQ	ETF	277.81	279.13	277.36	278.76	3495036.0
2020-09-09 15:00:00	QQQ	ETF	278.71	279.97	277.7	277.78	8278249.0
2020-09-09 16:00:00	QQQ	ETF	277.78	278.05	276.9298	277.4	1390813.0
2020-09-09 17:00:00	QQQ	ETF	277.37	277.6599	277.15	277.63	35796.0
2020-09-09 18:00:00	QQQ	ETF	277.63	279.11	277.63	278.99	921001.0
2020-09-09 19:00:00	QQQ	ETF	278.99	279.25	278.77	279.19	200078.0
2020-09-09 04:00:00	IWM	ETF	150.54	151.33	150.54	150.81	30261.0
2020-09-09 05:00:00	IWM	ETF	150.55	151.24	150.48	151.24	3630.0
2020-09-09 06:00:00	IWM	ETF	151.32	151.39	150.58	150.58	44180.0
2020-09-09 07:00:00	IWM	ETF	150.67	151.0	150.27	150.99	102626.0
2020-09-09 08:00:00	IWM	ETF	150.7899	151.54	149.26	151.12	159582.0
2020-09-09 09:00:00	IWM	ETF	151.0	151.96	150.98	151.95	2180743.0
2020-09-09 10:00:00	IWM	ETF	151.96	152.12	150.57	150.94	2851406.0
2020-09-09 11:00:00	IWM	ETF	150.95	151.82	150.93	151.34	1749501.0
2020-09-09 12:00:00	IWM	ETF	151.35	151.92	151.27	151.795	1353286.0
2020-09-09 13:00:00	IWM	ETF	151.81	152.48	151.81	152.06	1489245.0
2020-09-09 14:00:00	IWM	ETF	152.07	152.39	151.72	152.27	1885747.0
2020-09-09 15:00:00	IWM	ETF	152.28	152.7787	151.91	152.11	3066161.0
2020-09-09 16:00:00	IWM	ETF	152.13	152.14	151.71	151.71	667681.0
2020-09-09 17:00:00	IWM	ETF	151.72	152.13	151.71	151.79	15265.0
2020-09-09 18:00:00	IWM	ETF	151.71	152.29	151.71	152.29	28672.0
2020-09-09 19:00:00	IWM	ETF	152.3	152.35	152.13	152.25	13994.0
2020-09-09 04:00:00	DIA	ETF	276.14	278.15	276.14	277.2	14900.0
2020-09-09 05:00:00	DIA	ETF	276.7	277.52	276.61	277.52	7800.0

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

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