PREVIEW / etf_1hour / 2020-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-19.parquet
  size:    368 KB
  rows:    12,421

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-19 04:00:00	SPY	ETF	339.13	339.29	339.03	339.05	43877.0
2020-08-19 05:00:00	SPY	ETF	339.15	339.35	339.15	339.32	23544.0
2020-08-19 06:00:00	SPY	ETF	339.33	339.33	339.13	339.31	72512.0
2020-08-19 07:00:00	SPY	ETF	339.34	339.37	339.0	339.12	39463.0
2020-08-19 08:00:00	SPY	ETF	339.3596	339.4	338.67	338.9	197674.0
2020-08-19 09:00:00	SPY	ETF	338.86	339.197	338.62	338.7763	3490666.0
2020-08-19 10:00:00	SPY	ETF	338.78	339.33	338.73	339.235	4587000.0
2020-08-19 11:00:00	SPY	ETF	339.24	339.61	339.0	339.5015	6041403.0
2020-08-19 12:00:00	SPY	ETF	339.51	339.52	339.04	339.18	4598962.0
2020-08-19 13:00:00	SPY	ETF	339.18	339.43	339.11	339.37	2472184.0
2020-08-19 14:00:00	SPY	ETF	339.37	339.59	337.8	338.635	12754681.0
2020-08-19 15:00:00	SPY	ETF	338.64	338.79	336.62	337.22	24554483.0
2020-08-19 16:00:00	SPY	ETF	337.22	337.52	336.86	337.01	8254839.0
2020-08-19 17:00:00	SPY	ETF	337.03	337.23	336.91	337.1	126778.0
2020-08-19 18:00:00	SPY	ETF	337.01	337.1	336.85	336.86	155569.0
2020-08-19 19:00:00	SPY	ETF	336.87	336.94	336.21	336.27	116262.0
2020-08-19 04:00:00	QQQ	ETF	278.65	278.78	278.51	278.58	10840.0
2020-08-19 05:00:00	QQQ	ETF	278.54	278.79	278.54	278.74	5905.0
2020-08-19 06:00:00	QQQ	ETF	278.66	278.75	278.57	278.7	13929.0
2020-08-19 07:00:00	QQQ	ETF	278.7	278.75	278.01	278.12	150478.0
2020-08-19 08:00:00	QQQ	ETF	278.74	278.74	277.46	277.65	258758.0
2020-08-19 09:00:00	QQQ	ETF	277.66	278.46	276.45	276.96	3967579.0
2020-08-19 10:00:00	QQQ	ETF	276.95	278.4001	276.8	278.27	3324764.0
2020-08-19 11:00:00	QQQ	ETF	278.27	278.88	277.78	278.85	2181361.0
2020-08-19 12:00:00	QQQ	ETF	278.86	279.02	278.31	278.65	1627022.0
2020-08-19 13:00:00	QQQ	ETF	278.67	278.8854	278.42	278.73	1127902.0
2020-08-19 14:00:00	QQQ	ETF	278.7201	278.85	275.965	277.45	6419621.0
2020-08-19 15:00:00	QQQ	ETF	277.42	277.86	275.57	276.14	5570880.0
2020-08-19 16:00:00	QQQ	ETF	276.13	276.61	275.99	276.17	625280.0
2020-08-19 17:00:00	QQQ	ETF	276.28	276.37	276.15	276.36	20387.0
2020-08-19 18:00:00	QQQ	ETF	276.36	276.41	276.05	276.1	48497.0
2020-08-19 19:00:00	QQQ	ETF	276.09	276.2	275.35	275.44	92463.0
2020-08-19 04:00:00	IWM	ETF	156.49	156.5	156.34	156.46	6500.0
2020-08-19 05:00:00	IWM	ETF	156.51	156.51	156.51	156.51	639.0
2020-08-19 06:00:00	IWM	ETF	156.52	156.74	156.45	156.7	67496.0
2020-08-19 07:00:00	IWM	ETF	156.7	156.77	156.64	156.77	48539.0
2020-08-19 08:00:00	IWM	ETF	156.72	156.89	156.38	156.69	125978.0
2020-08-19 09:00:00	IWM	ETF	156.7	157.49	156.39	157.39	2122527.0
2020-08-19 10:00:00	IWM	ETF	157.4	157.53	156.62	157.18	1314948.0
2020-08-19 11:00:00	IWM	ETF	157.16	158.04	157.02	157.8	1598784.0
2020-08-19 12:00:00	IWM	ETF	157.82	157.885	157.35	157.48	969611.0
2020-08-19 13:00:00	IWM	ETF	157.47	157.68	157.295	157.625	778780.0
2020-08-19 14:00:00	IWM	ETF	157.63	157.77	156.97	157.365	1913213.0
2020-08-19 15:00:00	IWM	ETF	157.365	157.58	156.19	156.39	2674072.0
2020-08-19 16:00:00	IWM	ETF	156.4	156.5	156.1	156.18	662481.0
2020-08-19 17:00:00	IWM	ETF	156.0	156.3	156.0	156.27	16345.0
2020-08-19 18:00:00	IWM	ETF	156.25	156.3	156.15	156.2	11259.0
2020-08-19 19:00:00	IWM	ETF	156.15	156.15	155.73	155.98	25397.0
2020-08-19 06:00:00	DIA	ETF	278.75	278.9	278.75	278.9	1195.0
2020-08-19 07:00:00	DIA	ETF	278.85	278.9	278.67	278.78	5299.0

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

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