PREVIEW / etf_1hour / 2020-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-12.parquet
  size:    375 KB
  rows:    12,866

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-12 04:00:00	SPY	ETF	335.4	335.66	335.12	335.32	47429.0
2020-08-12 05:00:00	SPY	ETF	335.44	335.89	335.4	335.5	13495.0
2020-08-12 06:00:00	SPY	ETF	335.42	336.06	335.42	335.6	56162.0
2020-08-12 07:00:00	SPY	ETF	335.56	335.56	335.15	335.37	270573.0
2020-08-12 08:00:00	SPY	ETF	335.5	335.72	333.0	335.54	696686.0
2020-08-12 09:00:00	SPY	ETF	335.53	336.47	335.35	336.39	6317102.0
2020-08-12 10:00:00	SPY	ETF	336.39	337.495	336.12	337.265	5998508.0
2020-08-12 11:00:00	SPY	ETF	337.26	337.64	336.9066	337.23	4919679.0
2020-08-12 12:00:00	SPY	ETF	337.23	337.81	337.01	337.07	5268716.0
2020-08-12 13:00:00	SPY	ETF	337.07	337.92	336.56	337.89	5298751.0
2020-08-12 14:00:00	SPY	ETF	337.88	337.98	337.555	337.87	4941976.0
2020-08-12 15:00:00	SPY	ETF	337.87	338.28	337.25	337.42	13767213.0
2020-08-12 16:00:00	SPY	ETF	337.41	337.4863	336.9	337.01	4399332.0
2020-08-12 17:00:00	SPY	ETF	336.95	337.44	336.9	336.92	138883.0
2020-08-12 18:00:00	SPY	ETF	336.88	337.19	336.69	337.06	72715.0
2020-08-12 19:00:00	SPY	ETF	337.03	337.22	336.93	337.11	35157.0
2020-08-12 04:00:00	QQQ	ETF	267.62	267.99	267.4	267.61	62045.0
2020-08-12 05:00:00	QQQ	ETF	267.6	268.02	267.59	267.69	14408.0
2020-08-12 06:00:00	QQQ	ETF	267.7	268.14	267.69	267.94	46359.0
2020-08-12 07:00:00	QQQ	ETF	267.9	268.0	267.33	267.45	134784.0
2020-08-12 08:00:00	QQQ	ETF	267.48	268.0204	266.07	267.15	449361.0
2020-08-12 09:00:00	QQQ	ETF	267.11	269.98	266.83	269.87	4962399.0
2020-08-12 10:00:00	QQQ	ETF	269.88	271.16	269.6	270.96	5250336.0
2020-08-12 11:00:00	QQQ	ETF	270.94	271.67	270.725	271.56	2745423.0
2020-08-12 12:00:00	QQQ	ETF	271.57	272.37	271.41	271.48	3284350.0
2020-08-12 13:00:00	QQQ	ETF	271.48	272.71	271.175	272.6701	3521413.0
2020-08-12 14:00:00	QQQ	ETF	272.665	272.84	271.93	272.145	3152974.0
2020-08-12 15:00:00	QQQ	ETF	272.15	272.595	271.345	271.93	5988831.0
2020-08-12 16:00:00	QQQ	ETF	271.94	271.94	271.17	271.22	1012415.0
2020-08-12 17:00:00	QQQ	ETF	271.24	271.43	271.19	271.23	150366.0
2020-08-12 18:00:00	QQQ	ETF	271.08	271.5	271.03	271.36	68718.0
2020-08-12 19:00:00	QQQ	ETF	271.38	271.64	271.28	271.57	73442.0
2020-08-12 04:00:00	IWM	ETF	158.86	159.0	158.52	158.73	13021.0
2020-08-12 05:00:00	IWM	ETF	158.74	158.96	158.55	158.71	7300.0
2020-08-12 06:00:00	IWM	ETF	158.66	158.95	158.66	158.75	10634.0
2020-08-12 07:00:00	IWM	ETF	158.71	158.78	158.55	158.61	61361.0
2020-08-12 08:00:00	IWM	ETF	158.73	159.055	158.37	158.8	94452.0
2020-08-12 09:00:00	IWM	ETF	159.01	159.01	157.98	158.02	2194184.0
2020-08-12 10:00:00	IWM	ETF	158.03	158.7	157.79	158.39	2542600.0
2020-08-12 11:00:00	IWM	ETF	158.37	158.58	157.62	157.64	2443995.0
2020-08-12 12:00:00	IWM	ETF	157.63	157.84	157.17	157.175	1587530.0
2020-08-12 13:00:00	IWM	ETF	157.17	157.285	156.49	157.22	2416762.0
2020-08-12 14:00:00	IWM	ETF	157.235	157.71	157.02	157.47	1127587.0
2020-08-12 15:00:00	IWM	ETF	157.47	157.7099	157.14	157.53	3131930.0
2020-08-12 16:00:00	IWM	ETF	157.52	157.63	157.23	157.23	390528.0
2020-08-12 17:00:00	IWM	ETF	157.41	157.43	157.35	157.43	400.0
2020-08-12 18:00:00	IWM	ETF	157.24	157.4	157.2	157.32	14116.0
2020-08-12 19:00:00	IWM	ETF	157.31	157.31	157.15	157.22	22778.0
2020-08-12 04:00:00	DIA	ETF	279.99	279.99	279.57	279.57	1261.0
2020-08-12 05:00:00	DIA	ETF	279.77	279.8	279.76	279.8	900.0

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

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