PREVIEW / etf_1hour / 2019-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-26.parquet
  size:    341 KB
  rows:    11,314

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-11-26 04:00:00	SPY	ETF	313.26	313.29	312.89	313.1	19105.0
2019-11-26 05:00:00	SPY	ETF	313.13	313.33	313.05	313.29	20420.0
2019-11-26 06:00:00	SPY	ETF	313.28	313.39	313.23	313.26	29468.0
2019-11-26 07:00:00	SPY	ETF	313.24	313.41	313.2	313.34	56723.0
2019-11-26 08:00:00	SPY	ETF	313.2499	313.6	313.2	313.41	286434.0
2019-11-26 09:00:00	SPY	ETF	313.38	313.81	313.06	313.74	3638736.0
2019-11-26 10:00:00	SPY	ETF	313.75	313.87	313.41	313.7	5356720.0
2019-11-26 11:00:00	SPY	ETF	313.7	313.97	313.55	313.915	4869887.0
2019-11-26 12:00:00	SPY	ETF	313.92	314.18	313.8	314.03	2743692.0
2019-11-26 13:00:00	SPY	ETF	314.035	314.08	313.53	313.67	3766052.0
2019-11-26 14:00:00	SPY	ETF	313.675	313.85	313.62	313.78	2742556.0
2019-11-26 15:00:00	SPY	ETF	313.78	314.28	313.46	314.02	8846460.0
2019-11-26 16:00:00	SPY	ETF	314.03	314.5	313.98	314.46	3837685.0
2019-11-26 17:00:00	SPY	ETF	314.47	314.47	313.353	314.41	307507.0
2019-11-26 18:00:00	SPY	ETF	314.42	314.42	314.3	314.39	126937.0
2019-11-26 19:00:00	SPY	ETF	314.38	314.59	314.26	314.42	81400.0
2019-11-26 04:00:00	QQQ	ETF	204.28	204.28	204.01	204.16	11110.0
2019-11-26 05:00:00	QQQ	ETF	204.07	204.28	204.07	204.28	5450.0
2019-11-26 06:00:00	QQQ	ETF	204.29	204.35	204.18	204.21	15712.0
2019-11-26 07:00:00	QQQ	ETF	204.2	204.33	204.2	204.28	20893.0
2019-11-26 08:00:00	QQQ	ETF	204.27	204.58	204.11	204.28	109210.0
2019-11-26 09:00:00	QQQ	ETF	204.26	205.26	204.05	204.5	1639722.0
2019-11-26 10:00:00	QQQ	ETF	204.52	204.6494	204.18	204.56	1861279.0
2019-11-26 11:00:00	QQQ	ETF	204.56	204.74	204.38	204.631	1512260.0
2019-11-26 12:00:00	QQQ	ETF	204.64	204.87	204.54	204.83	925095.0
2019-11-26 13:00:00	QQQ	ETF	204.83	204.87	204.58	204.635	703171.0
2019-11-26 14:00:00	QQQ	ETF	204.646	204.75	204.54	204.65	869908.0
2019-11-26 15:00:00	QQQ	ETF	204.65	204.83	204.42	204.6	3514217.0
2019-11-26 16:00:00	QQQ	ETF	204.56	204.9	204.51	204.84	1096589.0
2019-11-26 17:00:00	QQQ	ETF	204.87	204.88	204.76	204.85	9664.0
2019-11-26 18:00:00	QQQ	ETF	204.84	204.85	204.75	204.83	16085.0
2019-11-26 19:00:00	QQQ	ETF	204.85	205.0	204.75	204.86	21543.0
2019-11-26 04:00:00	IWM	ETF	161.57	161.57	161.41	161.5	6075.0
2019-11-26 05:00:00	IWM	ETF	161.51	161.65	161.46	161.59	10800.0
2019-11-26 06:00:00	IWM	ETF	161.59	161.72	161.58	161.72	9200.0
2019-11-26 07:00:00	IWM	ETF	161.61	161.71	161.55	161.55	21410.0
2019-11-26 08:00:00	IWM	ETF	161.67	161.72	161.5	161.58	56431.0
2019-11-26 09:00:00	IWM	ETF	161.57	162.28	161.29	162.06	1641473.0
2019-11-26 10:00:00	IWM	ETF	162.07	162.54	162.035	162.25	3220040.0
2019-11-26 11:00:00	IWM	ETF	162.26	162.33	161.9	162.07	1469245.0
2019-11-26 12:00:00	IWM	ETF	162.07	162.4	161.95	162.17	833565.0
2019-11-26 13:00:00	IWM	ETF	162.175	162.2	161.8	161.85	1158062.0
2019-11-26 14:00:00	IWM	ETF	161.8589	162.06	161.79	162.01	1237268.0
2019-11-26 15:00:00	IWM	ETF	162.0	162.01	161.64	161.69	3340135.0
2019-11-26 16:00:00	IWM	ETF	161.7	162.08	161.65	162.0	774433.0
2019-11-26 17:00:00	IWM	ETF	162.04	162.04	161.95	162.04	3923.0
2019-11-26 18:00:00	IWM	ETF	162.0	162.0	161.9	161.99	4780.0
2019-11-26 19:00:00	IWM	ETF	162.02	162.14	161.93	162.02	17781.0
2019-11-26 04:00:00	DIA	ETF	280.78	280.78	280.46	280.46	400.0
2019-11-26 07:00:00	DIA	ETF	280.88	280.88	280.88	280.88	400.0

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

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