PREVIEW / etf_1hour / 2019-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-06.parquet
  size:    319 KB
  rows:    10,615

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
2019-03-06 04:00:00	SPY	ETF	278.67	278.9	278.67	278.77	4825.0
2019-03-06 05:00:00	SPY	ETF	278.7	278.81	278.65	278.8	6425.0
2019-03-06 06:00:00	SPY	ETF	278.79	278.92	278.79	278.88	9488.0
2019-03-06 07:00:00	SPY	ETF	278.83	278.86	278.61	278.64	147625.0
2019-03-06 08:00:00	SPY	ETF	278.66	279.07	278.31	278.9701	360208.0
2019-03-06 09:00:00	SPY	ETF	279.0	279.35	278.23	278.57	6837443.0
2019-03-06 10:00:00	SPY	ETF	278.57	278.74	277.67	278.1499	10461092.0
2019-03-06 11:00:00	SPY	ETF	278.145	278.53	277.34	277.6	7914692.0
2019-03-06 12:00:00	SPY	ETF	277.59	278.11	277.2	277.25	7475578.0
2019-03-06 13:00:00	SPY	ETF	277.24	277.84	277.06	277.8	6597101.0
2019-03-06 14:00:00	SPY	ETF	277.8	277.97	277.41	277.57	5367777.0
2019-03-06 15:00:00	SPY	ETF	277.56	277.79	276.97	277.3	17673800.0
2019-03-06 16:00:00	SPY	ETF	277.29	277.6038	277.15	277.24	8424736.0
2019-03-06 17:00:00	SPY	ETF	277.26	277.29	277.1	277.13	351442.0
2019-03-06 18:00:00	SPY	ETF	277.16	277.33	276.72	276.94	92567.0
2019-03-06 19:00:00	SPY	ETF	276.97	276.97	276.73	276.76	85281.0
2019-03-06 04:00:00	QQQ	ETF	174.48	174.58	174.44	174.57	4241.0
2019-03-06 05:00:00	QQQ	ETF	174.49	174.57	174.49	174.54	13669.0
2019-03-06 06:00:00	QQQ	ETF	174.55	174.62	174.54	174.55	5369.0
2019-03-06 07:00:00	QQQ	ETF	174.57	174.57	174.27	174.31	127842.0
2019-03-06 08:00:00	QQQ	ETF	174.57	174.66	174.16	174.63	179857.0
2019-03-06 09:00:00	QQQ	ETF	174.63	174.8	174.12	174.46	3242002.0
2019-03-06 10:00:00	QQQ	ETF	174.45	174.61	173.54	173.98	3412535.0
2019-03-06 11:00:00	QQQ	ETF	173.98	174.2685	173.38	173.65	2494415.0
2019-03-06 12:00:00	QQQ	ETF	173.65	173.98	173.43	173.4799	2840821.0
2019-03-06 13:00:00	QQQ	ETF	173.4879	173.82	173.29	173.8025	2572534.0
2019-03-06 14:00:00	QQQ	ETF	173.81	173.9799	173.55	173.72	2226141.0
2019-03-06 15:00:00	QQQ	ETF	173.72	173.88	173.28	173.52	5064250.0
2019-03-06 16:00:00	QQQ	ETF	173.53	173.669	173.29	173.35	1796526.0
2019-03-06 17:00:00	QQQ	ETF	173.4	173.4	173.31	173.33	10069.0
2019-03-06 18:00:00	QQQ	ETF	173.31	173.42	173.13	173.25	28428.0
2019-03-06 19:00:00	QQQ	ETF	173.2	173.22	173.0	173.06	65409.0
2019-03-06 04:00:00	IWM	ETF	155.94	155.94	155.94	155.94	540.0
2019-03-06 07:00:00	IWM	ETF	155.89	155.89	155.79	155.8	13500.0
2019-03-06 08:00:00	IWM	ETF	155.8001	156.08	155.73	156.02	108600.0
2019-03-06 09:00:00	IWM	ETF	156.11	156.21	155.21	155.54	2527921.0
2019-03-06 10:00:00	IWM	ETF	155.53	155.54	154.62	154.78	3598307.0
2019-03-06 11:00:00	IWM	ETF	154.78	155.04	154.21	154.325	2843845.0
2019-03-06 12:00:00	IWM	ETF	154.32	154.74	153.74	153.76	3356446.0
2019-03-06 13:00:00	IWM	ETF	153.76	153.83	153.14	153.73	4013296.0
2019-03-06 14:00:00	IWM	ETF	153.74	153.86	153.19	153.36	2708767.0
2019-03-06 15:00:00	IWM	ETF	153.35	153.47	152.88	153.02	6129677.0
2019-03-06 16:00:00	IWM	ETF	153.03	153.6994	152.93	153.05	1278144.0
2019-03-06 17:00:00	IWM	ETF	152.97	153.01	152.95	152.99	3366.0
2019-03-06 18:00:00	IWM	ETF	153.01	153.04	152.81	152.89	20023.0
2019-03-06 19:00:00	IWM	ETF	152.82	152.94	152.73	152.73	9017.0
2019-03-06 08:00:00	DIA	ETF	257.79	258.23	257.79	257.99	1409.0
2019-03-06 09:00:00	DIA	ETF	258.23	258.46	257.86	257.98	279022.0
2019-03-06 10:00:00	DIA	ETF	257.99	258.23	257.14	257.42	345280.0
2019-03-06 11:00:00	DIA	ETF	257.38	257.78	256.58	256.81	292721.0

> showing 50 of 10,615 rows — these rows as CSV

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