PREVIEW / etf_1hour / 2019-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-22.parquet
  size:    336 KB
  rows:    10,899

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-22 04:00:00	SPY	ETF	299.95	299.95	299.55	299.85	18064.0
2019-10-22 05:00:00	SPY	ETF	299.85	300.19	299.85	300.15	11230.0
2019-10-22 06:00:00	SPY	ETF	300.2	300.22	299.98	300.2	28822.0
2019-10-22 07:00:00	SPY	ETF	300.25	300.49	300.18	300.48	152369.0
2019-10-22 08:00:00	SPY	ETF	300.2301	300.69	299.85	300.54	336462.0
2019-10-22 09:00:00	SPY	ETF	300.55	300.8	300.315	300.67	3321621.0
2019-10-22 10:00:00	SPY	ETF	300.68	300.89	300.25	300.655	6015272.0
2019-10-22 11:00:00	SPY	ETF	300.66	300.89	300.17	300.29	4686856.0
2019-10-22 12:00:00	SPY	ETF	300.29	300.9	300.22	300.7551	4206769.0
2019-10-22 13:00:00	SPY	ETF	300.76	300.79	300.33	300.5	6143757.0
2019-10-22 14:00:00	SPY	ETF	300.495	300.77	299.45	299.68	9069369.0
2019-10-22 15:00:00	SPY	ETF	299.68	299.97	298.91	299.03	11109331.0
2019-10-22 16:00:00	SPY	ETF	299.02	299.814	298.31	298.55	3013864.0
2019-10-22 17:00:00	SPY	ETF	298.48	299.01	298.43	298.55	51154.0
2019-10-22 18:00:00	SPY	ETF	298.64	299.01	298.57	298.75	60611.0
2019-10-22 19:00:00	SPY	ETF	298.82	298.84	298.53	298.59	34785.0
2019-10-22 04:00:00	QQQ	ETF	193.32	193.36	193.14	193.34	8346.0
2019-10-22 05:00:00	QQQ	ETF	193.41	193.64	193.41	193.61	5450.0
2019-10-22 06:00:00	QQQ	ETF	193.61	193.8	193.51	193.8	16255.0
2019-10-22 07:00:00	QQQ	ETF	193.78	194.04	193.69	194.04	66413.0
2019-10-22 08:00:00	QQQ	ETF	193.7199	194.18	193.39	194.05	79062.0
2019-10-22 09:00:00	QQQ	ETF	194.05	194.42	193.75	193.99	1892066.0
2019-10-22 10:00:00	QQQ	ETF	193.995	194.1499	193.66	193.68	1727169.0
2019-10-22 11:00:00	QQQ	ETF	193.66	193.76	192.7751	192.8644	1994790.0
2019-10-22 12:00:00	QQQ	ETF	192.865	193.32	192.8	193.26	1257135.0
2019-10-22 13:00:00	QQQ	ETF	193.26	193.26	192.6724	192.83	1533033.0
2019-10-22 14:00:00	QQQ	ETF	192.81	193.11	192.19	192.355	1938167.0
2019-10-22 15:00:00	QQQ	ETF	192.36	192.526	191.79	191.87	3877394.0
2019-10-22 16:00:00	QQQ	ETF	191.86	193.4648	190.75	190.88	3018724.0
2019-10-22 17:00:00	QQQ	ETF	190.88	191.04	190.83	191.01	40976.0
2019-10-22 18:00:00	QQQ	ETF	191.01	191.24	190.95	191.15	51899.0
2019-10-22 19:00:00	QQQ	ETF	191.15	191.18	190.85	190.91	36686.0
2019-10-22 04:00:00	IWM	ETF	154.04	154.04	154.04	154.04	100.0
2019-10-22 06:00:00	IWM	ETF	154.29	154.29	154.24	154.24	3420.0
2019-10-22 07:00:00	IWM	ETF	154.21	154.39	154.19	154.3	7900.0
2019-10-22 08:00:00	IWM	ETF	154.21	154.31	154.13	154.17	18337.0
2019-10-22 09:00:00	IWM	ETF	154.14	154.49	153.86	154.05	1404416.0
2019-10-22 10:00:00	IWM	ETF	154.07	154.28	153.74	153.94	1365816.0
2019-10-22 11:00:00	IWM	ETF	153.94	154.26	153.83	154.08	1120616.0
2019-10-22 12:00:00	IWM	ETF	154.095	154.8996	154.06	154.64	990704.0
2019-10-22 13:00:00	IWM	ETF	154.63	154.785	154.502	154.73	834041.0
2019-10-22 14:00:00	IWM	ETF	154.74	155.05	154.32	154.42	1584181.0
2019-10-22 15:00:00	IWM	ETF	154.43	154.5751	154.11	154.16	2319351.0
2019-10-22 16:00:00	IWM	ETF	154.15	154.21	153.93	154.05	343113.0
2019-10-22 17:00:00	IWM	ETF	154.01	154.16	154.01	154.16	3250.0
2019-10-22 18:00:00	IWM	ETF	154.1	154.19	154.1	154.16	4650.0
2019-10-22 19:00:00	IWM	ETF	154.15	154.15	154.05	154.12	3100.0
2019-10-22 07:00:00	DIA	ETF	268.47	268.6	268.39	268.39	1850.0
2019-10-22 08:00:00	DIA	ETF	268.6182	268.6182	268.1	268.26	5230.0
2019-10-22 09:00:00	DIA	ETF	268.41	268.78	267.97	268.34	370031.0

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

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