PREVIEW / etf_1hour / 2020-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-04.parquet
  size:    369 KB
  rows:    12,686

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-04 04:00:00	SPY	ETF	328.11	328.35	327.52	328.15	52532.0
2020-08-04 05:00:00	SPY	ETF	328.04	328.41	327.8	328.17	38085.0
2020-08-04 06:00:00	SPY	ETF	328.18	328.24	327.82	328.1	57734.0
2020-08-04 07:00:00	SPY	ETF	328.06	328.35	327.25	327.45	317895.0
2020-08-04 08:00:00	SPY	ETF	327.4	329.5	327.15	327.56	337651.0
2020-08-04 09:00:00	SPY	ETF	327.49	328.77	327.36	328.65	4444536.0
2020-08-04 10:00:00	SPY	ETF	328.64	329.64	328.55	329.3744	5767290.0
2020-08-04 11:00:00	SPY	ETF	329.38	329.66	329.15	329.43	5367751.0
2020-08-04 12:00:00	SPY	ETF	329.4276	329.52	328.75	328.93	5014391.0
2020-08-04 13:00:00	SPY	ETF	328.92	329.42	328.64	329.335	2575734.0
2020-08-04 14:00:00	SPY	ETF	329.34	329.46	327.95	328.99	5847454.0
2020-08-04 15:00:00	SPY	ETF	328.99	330.06	328.82	330.02	8772242.0
2020-08-04 16:00:00	SPY	ETF	330.01	330.07	329.69	329.97	2360327.0
2020-08-04 17:00:00	SPY	ETF	329.99	330.1	329.74	330.09	105719.0
2020-08-04 18:00:00	SPY	ETF	330.0	330.1	329.85	330.03	115889.0
2020-08-04 19:00:00	SPY	ETF	330.03	330.08	329.98	330.0	126172.0
2020-08-04 04:00:00	QQQ	ETF	268.77	268.9	268.09	268.56	47491.0
2020-08-04 05:00:00	QQQ	ETF	268.59	268.82	268.44	268.58	32579.0
2020-08-04 06:00:00	QQQ	ETF	268.59	268.73	268.33	268.67	69312.0
2020-08-04 07:00:00	QQQ	ETF	268.68	269.06	268.22	268.3	341904.0
2020-08-04 08:00:00	QQQ	ETF	268.4	270.32	267.98	268.49	299636.0
2020-08-04 09:00:00	QQQ	ETF	268.4899	269.99	268.35	269.85	3157838.0
2020-08-04 10:00:00	QQQ	ETF	269.86	270.38	269.535	269.58	3621458.0
2020-08-04 11:00:00	QQQ	ETF	269.61	269.79	268.8	269.43	3080320.0
2020-08-04 12:00:00	QQQ	ETF	269.455	269.525	268.58	269.05	1936015.0
2020-08-04 13:00:00	QQQ	ETF	269.04	269.91	268.71	269.769	1796294.0
2020-08-04 14:00:00	QQQ	ETF	269.78	269.93	268.09	269.05	3026632.0
2020-08-04 15:00:00	QQQ	ETF	269.03	270.44	268.83	270.44	3266461.0
2020-08-04 16:00:00	QQQ	ETF	270.44	270.67	266.4479	270.291	633739.0
2020-08-04 17:00:00	QQQ	ETF	270.32	270.35	270.1	270.16	27509.0
2020-08-04 18:00:00	QQQ	ETF	270.3	270.33	270.09	270.28	24192.0
2020-08-04 19:00:00	QQQ	ETF	270.3	270.38	270.16	270.23	52611.0
2020-08-04 04:00:00	IWM	ETF	149.7	149.83	149.35	149.73	6220.0
2020-08-04 05:00:00	IWM	ETF	149.65	149.8	149.43	149.56	10250.0
2020-08-04 06:00:00	IWM	ETF	149.5	149.62	149.35	149.62	4150.0
2020-08-04 07:00:00	IWM	ETF	149.65	149.73	148.92	149.03	59161.0
2020-08-04 08:00:00	IWM	ETF	149.6701	149.73	148.88	149.32	75456.0
2020-08-04 09:00:00	IWM	ETF	149.29	150.15	149.27	149.58	1828860.0
2020-08-04 10:00:00	IWM	ETF	149.59	150.47	149.045	150.02	2910832.0
2020-08-04 11:00:00	IWM	ETF	150.03	150.6	149.9	149.99	1985164.0
2020-08-04 12:00:00	IWM	ETF	149.985	150.4	149.63	150.37	1261584.0
2020-08-04 13:00:00	IWM	ETF	150.365	150.78	150.0	150.76	1560133.0
2020-08-04 14:00:00	IWM	ETF	150.76	150.93	150.02	150.58	1757756.0
2020-08-04 15:00:00	IWM	ETF	150.57	150.93	150.52	150.81	3122792.0
2020-08-04 16:00:00	IWM	ETF	150.79	151.1136	150.65	150.83	1923621.0
2020-08-04 17:00:00	IWM	ETF	150.73	150.84	150.73	150.84	4939.0
2020-08-04 18:00:00	IWM	ETF	150.77	150.93	150.7	150.9	27287.0
2020-08-04 19:00:00	IWM	ETF	150.85	150.99	150.84	150.84	12365.0
2020-08-04 04:00:00	DIA	ETF	266.52	266.56	266.02	266.31	2900.0
2020-08-04 05:00:00	DIA	ETF	266.2	266.2	266.2	266.2	1000.0

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

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