PREVIEW / etf_1hour / 2020-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-14.parquet
  size:    361 KB
  rows:    12,255

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-14 04:00:00	SPY	ETF	336.19	336.22	335.05	335.39	50227.0
2020-08-14 05:00:00	SPY	ETF	335.3	335.85	335.16	335.85	56957.0
2020-08-14 06:00:00	SPY	ETF	335.8	336.05	335.31	336.03	79312.0
2020-08-14 07:00:00	SPY	ETF	336.03	336.85	335.95	336.7	269685.0
2020-08-14 08:00:00	SPY	ETF	336.5801	337.89	335.5696	336.42	363279.0
2020-08-14 09:00:00	SPY	ETF	336.4	336.76	335.9	336.68	3749447.0
2020-08-14 10:00:00	SPY	ETF	336.68	337.05	336.17	336.55	4178801.0
2020-08-14 11:00:00	SPY	ETF	336.54	337.34	336.36	337.1	2982062.0
2020-08-14 12:00:00	SPY	ETF	337.105	337.3	336.88	336.98	4515935.0
2020-08-14 13:00:00	SPY	ETF	336.975	337.42	336.79	337.415	4048991.0
2020-08-14 14:00:00	SPY	ETF	337.41	337.4101	336.555	336.57	6077974.0
2020-08-14 15:00:00	SPY	ETF	336.58	336.88	335.62	336.86	14481017.0
2020-08-14 16:00:00	SPY	ETF	336.86	336.88	336.13	336.44	5701300.0
2020-08-14 17:00:00	SPY	ETF	336.3	336.84	336.3	336.4	57373.0
2020-08-14 18:00:00	SPY	ETF	336.4	336.49	336.36	336.49	10197.0
2020-08-14 19:00:00	SPY	ETF	336.49	336.6	336.43	336.6	11056.0
2020-08-14 04:00:00	QQQ	ETF	272.48	272.52	271.95	272.26	29043.0
2020-08-14 05:00:00	QQQ	ETF	272.26	272.39	272.04	272.37	19087.0
2020-08-14 06:00:00	QQQ	ETF	272.31	273.07	271.76	272.92	91549.0
2020-08-14 07:00:00	QQQ	ETF	272.92	273.59	272.72	273.41	228595.0
2020-08-14 08:00:00	QQQ	ETF	272.9001	273.66	272.22	273.2	178362.0
2020-08-14 09:00:00	QQQ	ETF	273.14	273.4	271.68	272.58	3003652.0
2020-08-14 10:00:00	QQQ	ETF	272.58	272.89	270.72	271.19	4547777.0
2020-08-14 11:00:00	QQQ	ETF	271.19	272.3832	270.94	271.75	2090177.0
2020-08-14 12:00:00	QQQ	ETF	271.7599	272.7086	271.67	272.44	1594086.0
2020-08-14 13:00:00	QQQ	ETF	272.45	272.56	271.94	272.3601	1729418.0
2020-08-14 14:00:00	QQQ	ETF	272.36	272.36	271.56	271.89	1639778.0
2020-08-14 15:00:00	QQQ	ETF	271.9	272.351	271.03	272.22	5185695.0
2020-08-14 16:00:00	QQQ	ETF	272.22	272.29	271.55	271.97	708300.0
2020-08-14 17:00:00	QQQ	ETF	271.97	271.97	271.8501	271.95	30948.0
2020-08-14 18:00:00	QQQ	ETF	271.89	272.0	271.87	271.95	3139.0
2020-08-14 19:00:00	QQQ	ETF	271.95	272.05	271.91	272.0	13729.0
2020-08-14 04:00:00	IWM	ETF	156.83	156.83	155.5	155.67	47979.0
2020-08-14 05:00:00	IWM	ETF	155.69	156.04	155.69	156.03	6469.0
2020-08-14 06:00:00	IWM	ETF	156.03	156.15	155.76	156.15	5297.0
2020-08-14 07:00:00	IWM	ETF	156.16	156.6	156.13	156.51	96712.0
2020-08-14 08:00:00	IWM	ETF	156.16	156.79	156.16	156.27	75328.0
2020-08-14 09:00:00	IWM	ETF	156.38	156.75	155.87	156.75	2400263.0
2020-08-14 10:00:00	IWM	ETF	156.74	157.44	156.19	157.175	2710487.0
2020-08-14 11:00:00	IWM	ETF	157.16	157.46	156.8901	157.09	999324.0
2020-08-14 12:00:00	IWM	ETF	157.12	157.35	156.96	157.0213	615271.0
2020-08-14 13:00:00	IWM	ETF	157.02	157.735	156.85	157.735	996425.0
2020-08-14 14:00:00	IWM	ETF	157.73	157.7585	157.01	157.01	711033.0
2020-08-14 15:00:00	IWM	ETF	157.02	157.15	156.47	157.08	2205346.0
2020-08-14 16:00:00	IWM	ETF	157.09	157.1	156.58	156.82	536066.0
2020-08-14 17:00:00	IWM	ETF	156.9	157.08	156.82	156.82	1248.0
2020-08-14 18:00:00	IWM	ETF	156.74	156.8	156.74	156.75	1303.0
2020-08-14 19:00:00	IWM	ETF	156.88	156.95	156.88	156.9	1628.0
2020-08-14 04:00:00	DIA	ETF	277.9	277.9	277.19	277.6	4958.0
2020-08-14 05:00:00	DIA	ETF	277.9	278.1	277.7	278.1	3700.0

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

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