PREVIEW / etf_1hour / 2019-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-16.parquet
  size:    341 KB
  rows:    11,130

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-09-16 04:00:00	SPY	ETF	299.69	299.98	299.58	299.7	18531.0
2019-09-16 05:00:00	SPY	ETF	299.58	299.83	299.3	299.62	38192.0
2019-09-16 06:00:00	SPY	ETF	299.72	299.86	299.53	299.79	72271.0
2019-09-16 07:00:00	SPY	ETF	299.8	300.07	299.54	300.0	410129.0
2019-09-16 08:00:00	SPY	ETF	299.84	300.22	299.0	299.915	524027.0
2019-09-16 09:00:00	SPY	ETF	299.93	300.56	299.7	300.51	6049107.0
2019-09-16 10:00:00	SPY	ETF	300.5	300.65	299.79	300.0001	5477205.0
2019-09-16 11:00:00	SPY	ETF	300.025	300.555	299.45	299.53	6173403.0
2019-09-16 12:00:00	SPY	ETF	299.53	300.02	299.48	299.89	8440687.0
2019-09-16 13:00:00	SPY	ETF	299.895	301.1378	299.79	300.26	4931539.0
2019-09-16 14:00:00	SPY	ETF	300.26	300.38	300.03	300.24	5820240.0
2019-09-16 15:00:00	SPY	ETF	300.24	301.1378	299.97	300.16	11168226.0
2019-09-16 16:00:00	SPY	ETF	300.18	300.58	300.14	300.58	6632232.0
2019-09-16 17:00:00	SPY	ETF	300.52	300.6	300.4	300.49	238114.0
2019-09-16 18:00:00	SPY	ETF	300.49	300.8	300.41	300.57	204654.0
2019-09-16 19:00:00	SPY	ETF	300.57	300.74	300.49	300.5	39336.0
2019-09-16 04:00:00	QQQ	ETF	191.64	191.64	190.95	191.04	37572.0
2019-09-16 05:00:00	QQQ	ETF	191.04	191.26	190.75	191.1	40880.0
2019-09-16 06:00:00	QQQ	ETF	191.09	191.29	191.05	191.22	27710.0
2019-09-16 07:00:00	QQQ	ETF	191.26	191.34	190.94	191.31	83205.0
2019-09-16 08:00:00	QQQ	ETF	191.25	191.56	190.55	191.22	170673.0
2019-09-16 09:00:00	QQQ	ETF	191.24	192.05	191.14	192.002	2493334.0
2019-09-16 10:00:00	QQQ	ETF	192.0	192.08	191.27	191.45	2512985.0
2019-09-16 11:00:00	QQQ	ETF	191.46	191.94	191.12	191.16	1937785.0
2019-09-16 12:00:00	QQQ	ETF	191.14	191.45	191.11	191.3098	1922658.0
2019-09-16 13:00:00	QQQ	ETF	191.28	191.7	191.22	191.65	1126180.0
2019-09-16 14:00:00	QQQ	ETF	191.64	191.75	191.43	191.62	998468.0
2019-09-16 15:00:00	QQQ	ETF	191.62	191.801	191.46	191.64	2717727.0
2019-09-16 16:00:00	QQQ	ETF	191.65	191.92	191.4111	191.86	848642.0
2019-09-16 17:00:00	QQQ	ETF	191.83	191.83	191.8	191.8	500.0
2019-09-16 18:00:00	QQQ	ETF	191.83	192.11	191.83	191.96	24187.0
2019-09-16 19:00:00	QQQ	ETF	191.9	192.08	191.86	191.86	21232.0
2019-09-16 04:00:00	IWM	ETF	156.8	156.8	156.74	156.74	548.0
2019-09-16 05:00:00	IWM	ETF	156.71	156.83	156.62	156.83	30085.0
2019-09-16 06:00:00	IWM	ETF	156.75	156.77	156.75	156.76	6675.0
2019-09-16 07:00:00	IWM	ETF	156.8	156.94	156.68	156.91	57605.0
2019-09-16 08:00:00	IWM	ETF	156.95	157.0	156.77	156.8	199451.0
2019-09-16 09:00:00	IWM	ETF	156.81	158.1023	156.7	157.8461	3378345.0
2019-09-16 10:00:00	IWM	ETF	157.84	158.42	157.66	158.33	2507487.0
2019-09-16 11:00:00	IWM	ETF	158.345	158.75	157.44	157.49	2195293.0
2019-09-16 12:00:00	IWM	ETF	157.48	158.33	157.45	158.32	2242326.0
2019-09-16 13:00:00	IWM	ETF	158.31	158.53	158.195	158.46	1533891.0
2019-09-16 14:00:00	IWM	ETF	158.47	158.57	158.12	158.26	2075292.0
2019-09-16 15:00:00	IWM	ETF	158.26	158.365	157.81	157.88	3884573.0
2019-09-16 16:00:00	IWM	ETF	157.88	158.14	157.84	158.09	684070.0
2019-09-16 17:00:00	IWM	ETF	157.94	158.06	157.9	157.9	48990.0
2019-09-16 18:00:00	IWM	ETF	158.1	158.25	158.1	158.18	1900.0
2019-09-16 19:00:00	IWM	ETF	158.15	158.24	158.15	158.15	3850.0
2019-09-16 05:00:00	DIA	ETF	271.56	271.56	271.36	271.44	600.0
2019-09-16 06:00:00	DIA	ETF	271.58	271.58	271.44	271.44	300.0

> showing 50 of 11,130 rows — these rows as CSV

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