PREVIEW / etf_1hour / 2021-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-03.parquet
  size:    428 KB
  rows:    14,840

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
2021-05-03 04:00:00	SPY	ETF	419.2	419.21	418.91	418.91	9783.0
2021-05-03 05:00:00	SPY	ETF	418.94	418.94	417.95	418.38	88791.0
2021-05-03 06:00:00	SPY	ETF	418.38	419.33	418.36	419.01	240436.0
2021-05-03 07:00:00	SPY	ETF	418.93	419.44	418.93	419.15	198590.0
2021-05-03 08:00:00	SPY	ETF	419.33	419.6	418.88	418.89	451071.0
2021-05-03 09:00:00	SPY	ETF	418.85	419.84	418.62	419.49	5748517.0
2021-05-03 10:00:00	SPY	ETF	419.48	419.74	418.59	418.799	7351256.0
2021-05-03 11:00:00	SPY	ETF	418.793	418.96	418.14	418.8119	6000851.0
2021-05-03 12:00:00	SPY	ETF	418.793	418.81	418.18	418.47	3269542.0
2021-05-03 13:00:00	SPY	ETF	418.48	418.71	418.26	418.57	2620047.0
2021-05-03 14:00:00	SPY	ETF	418.57	419.27	418.57	419.115	4531358.0
2021-05-03 15:00:00	SPY	ETF	419.12	419.135	417.665	418.1699	13464870.0
2021-05-03 16:00:00	SPY	ETF	418.17	418.3	417.82	417.95	2224878.0
2021-05-03 17:00:00	SPY	ETF	418.02	418.2	417.76	417.98	135126.0
2021-05-03 18:00:00	SPY	ETF	417.97	418.2	417.9	417.95	24188.0
2021-05-03 19:00:00	SPY	ETF	417.94	417.95	417.48	417.61	36889.0
2021-05-03 04:00:00	QQQ	ETF	338.61	338.97	338.33	338.36	50986.0
2021-05-03 05:00:00	QQQ	ETF	338.27	338.32	337.52	337.9	43610.0
2021-05-03 06:00:00	QQQ	ETF	337.9	338.64	337.87	338.24	68676.0
2021-05-03 07:00:00	QQQ	ETF	338.29	338.86	338.29	338.63	170480.0
2021-05-03 08:00:00	QQQ	ETF	338.43	339.19	338.11	338.85	204462.0
2021-05-03 09:00:00	QQQ	ETF	338.91	339.24	337.67	338.24	3929695.0
2021-05-03 10:00:00	QQQ	ETF	338.24	340.0	337.3399	337.5799	5389182.0
2021-05-03 11:00:00	QQQ	ETF	337.56	337.565	335.85	336.74	3751262.0
2021-05-03 12:00:00	QQQ	ETF	336.73	336.93	335.73	336.19	2053439.0
2021-05-03 13:00:00	QQQ	ETF	336.18	336.65	335.76	336.2765	1809565.0
2021-05-03 14:00:00	QQQ	ETF	336.28	336.9	336.28	336.72	2052526.0
2021-05-03 15:00:00	QQQ	ETF	336.71	336.85	335.76	336.132	4514376.0
2021-05-03 16:00:00	QQQ	ETF	336.16	336.3	335.89	336.03	899360.0
2021-05-03 17:00:00	QQQ	ETF	335.95	336.19	335.52	336.0	149439.0
2021-05-03 18:00:00	QQQ	ETF	336.04	336.17	335.86	336.0	40870.0
2021-05-03 19:00:00	QQQ	ETF	336.03	336.03	335.51	335.64	41742.0
2021-05-03 04:00:00	IWM	ETF	226.86	227.0	226.71	226.86	37096.0
2021-05-03 05:00:00	IWM	ETF	226.92	226.92	226.05	226.32	27896.0
2021-05-03 06:00:00	IWM	ETF	226.34	227.35	226.33	226.9	54283.0
2021-05-03 07:00:00	IWM	ETF	226.89	227.36	226.87	227.0	73607.0
2021-05-03 08:00:00	IWM	ETF	227.0	228.5	226.2	226.8	276617.0
2021-05-03 09:00:00	IWM	ETF	226.76	227.407	225.88	226.4	2395867.0
2021-05-03 10:00:00	IWM	ETF	226.37	226.49	224.93	225.32	2862392.0
2021-05-03 11:00:00	IWM	ETF	225.29	226.44	224.92	225.94	1784689.0
2021-05-03 12:00:00	IWM	ETF	225.94	226.757	225.84	226.22	1186475.0
2021-05-03 13:00:00	IWM	ETF	226.22	226.69	226.15	226.52	1014858.0
2021-05-03 14:00:00	IWM	ETF	226.53	227.15	226.455	227.015	1379096.0
2021-05-03 15:00:00	IWM	ETF	227.03	227.03	225.88	226.04	2688325.0
2021-05-03 16:00:00	IWM	ETF	225.99	226.19	225.71	225.8	782359.0
2021-05-03 17:00:00	IWM	ETF	225.57	225.99	225.54	225.86	69180.0
2021-05-03 18:00:00	IWM	ETF	225.86	225.88	225.73	225.77	6254.0
2021-05-03 19:00:00	IWM	ETF	225.77	225.77	225.47	225.53	20074.0
2021-05-03 04:00:00	DIA	ETF	340.0	340.61	340.0	340.61	3271.0
2021-05-03 05:00:00	DIA	ETF	339.89	340.02	339.88	340.02	900.0

> showing 50 of 14,840 rows — these rows as CSV

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