PREVIEW / etf_1hour / 2019-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-18.parquet
  size:    320 KB
  rows:    10,676

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-10-18 04:00:00	SPY	ETF	299.03	299.12	298.9	299.12	5751.0
2019-10-18 05:00:00	SPY	ETF	298.95	299.33	298.95	299.3	5085.0
2019-10-18 06:00:00	SPY	ETF	299.28	299.37	299.14	299.37	36155.0
2019-10-18 07:00:00	SPY	ETF	299.35	299.57	299.31	299.51	168260.0
2019-10-18 08:00:00	SPY	ETF	299.3501	299.56	298.45	299.28	202268.0
2019-10-18 09:00:00	SPY	ETF	299.25	299.395	298.49	299.31	4219138.0
2019-10-18 10:00:00	SPY	ETF	299.3	299.31	298.13	298.63	9000209.0
2019-10-18 11:00:00	SPY	ETF	298.63	298.935	297.95	297.99	6666951.0
2019-10-18 12:00:00	SPY	ETF	297.98	298.9554	296.99	297.8416	8296448.0
2019-10-18 13:00:00	SPY	ETF	297.85	299.0496	297.82	298.57	5163803.0
2019-10-18 14:00:00	SPY	ETF	298.58	298.72	298.3	298.62	4480866.0
2019-10-18 15:00:00	SPY	ETF	298.64	298.94	297.98	297.98	14275151.0
2019-10-18 16:00:00	SPY	ETF	297.98	299.1942	297.95	298.38	8650881.0
2019-10-18 17:00:00	SPY	ETF	298.38	298.4	297.97	298.0	1907050.0
2019-10-18 18:00:00	SPY	ETF	298.06	298.14	298.02	298.09	13681.0
2019-10-18 19:00:00	SPY	ETF	298.06	298.15	298.02	298.02	22973.0
2019-10-18 04:00:00	QQQ	ETF	193.2	193.3	193.13	193.3	8140.0
2019-10-18 05:00:00	QQQ	ETF	193.23	193.4	193.19	193.37	13920.0
2019-10-18 06:00:00	QQQ	ETF	193.35	193.43	193.31	193.43	5087.0
2019-10-18 07:00:00	QQQ	ETF	193.45	193.66	193.43	193.54	127058.0
2019-10-18 08:00:00	QQQ	ETF	193.47	193.65	193.0	193.48	184862.0
2019-10-18 09:00:00	QQQ	ETF	193.4799	193.67	193.12	193.48	1938702.0
2019-10-18 10:00:00	QQQ	ETF	193.48	193.49	192.2	192.59	3223356.0
2019-10-18 11:00:00	QQQ	ETF	192.58	192.7	191.4	191.43	2936779.0
2019-10-18 12:00:00	QQQ	ETF	191.42	191.75	190.705	191.455	4091243.0
2019-10-18 13:00:00	QQQ	ETF	191.46	192.16	191.42	192.05	2026400.0
2019-10-18 14:00:00	QQQ	ETF	192.07	192.255	191.89	192.18	1395608.0
2019-10-18 15:00:00	QQQ	ETF	192.19	192.5352	191.68	191.68	5433123.0
2019-10-18 16:00:00	QQQ	ETF	191.68	193.5106	191.63	191.85	2090698.0
2019-10-18 17:00:00	QQQ	ETF	192.0	192.0	191.71	191.71	167419.0
2019-10-18 18:00:00	QQQ	ETF	191.78	191.8	191.73	191.8	8212.0
2019-10-18 19:00:00	QQQ	ETF	191.8	191.81	191.74	191.74	11558.0
2019-10-18 06:00:00	IWM	ETF	153.26	153.26	153.26	153.26	500.0
2019-10-18 07:00:00	IWM	ETF	153.33	153.51	153.33	153.37	14638.0
2019-10-18 08:00:00	IWM	ETF	153.36	153.41	153.14	153.15	34583.0
2019-10-18 09:00:00	IWM	ETF	153.13	153.41	152.75	153.25	2123883.0
2019-10-18 10:00:00	IWM	ETF	153.24	153.5	152.46	152.9	1667008.0
2019-10-18 11:00:00	IWM	ETF	152.91	153.0561	152.2	152.22	1137639.0
2019-10-18 12:00:00	IWM	ETF	152.23	152.47	151.45	152.25	1364947.0
2019-10-18 13:00:00	IWM	ETF	152.25	152.895	152.22	152.83	796992.0
2019-10-18 14:00:00	IWM	ETF	152.83	152.98	152.76	152.85	656765.0
2019-10-18 15:00:00	IWM	ETF	152.855	152.97	152.6	152.63	2680403.0
2019-10-18 16:00:00	IWM	ETF	152.64	152.84	152.57	152.7	1426345.0
2019-10-18 17:00:00	IWM	ETF	152.7	152.75	152.6	152.6043	605022.0
2019-10-18 18:00:00	IWM	ETF	152.61	152.61	152.61	152.61	300.0
2019-10-18 19:00:00	IWM	ETF	152.6999	152.84	152.6999	152.84	304.0
2019-10-18 04:00:00	DIA	ETF	269.9	269.9	269.9	269.9	100.0
2019-10-18 06:00:00	DIA	ETF	270.2	270.2	270.2	270.2	1500.0
2019-10-18 07:00:00	DIA	ETF	270.3	270.3	270.3	270.3	100.0
2019-10-18 08:00:00	DIA	ETF	270.3	270.5	270.27	270.27	2930.0

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

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