PREVIEW / etf_1hour / 2019-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-13.parquet
  size:    333 KB
  rows:    10,823

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-13 04:00:00	SPY	ETF	302.01	302.27	301.94	301.94	9792.0
2019-09-13 05:00:00	SPY	ETF	302.07	302.34	302.07	302.34	12900.0
2019-09-13 06:00:00	SPY	ETF	302.27	302.56	302.27	302.56	42124.0
2019-09-13 07:00:00	SPY	ETF	302.59	302.68	302.26	302.33	175598.0
2019-09-13 08:00:00	SPY	ETF	302.33	302.62	301.97	301.99	209974.0
2019-09-13 09:00:00	SPY	ETF	301.97	302.01	301.42	301.68	6746339.0
2019-09-13 10:00:00	SPY	ETF	301.65	301.95	301.26	301.84	7551173.0
2019-09-13 11:00:00	SPY	ETF	301.84	302.17	301.51	301.565	9190324.0
2019-09-13 12:00:00	SPY	ETF	301.57	301.86	301.2975	301.395	6887188.0
2019-09-13 13:00:00	SPY	ETF	301.39	301.61	301.02	301.1436	6985294.0
2019-09-13 14:00:00	SPY	ETF	301.14	301.4	301.05	301.23	4314490.0
2019-09-13 15:00:00	SPY	ETF	301.24	301.42	300.68	301.05	11622755.0
2019-09-13 16:00:00	SPY	ETF	301.04	301.34	300.88	301.03	6982949.0
2019-09-13 17:00:00	SPY	ETF	301.03	301.09	300.89	301.06	287544.0
2019-09-13 18:00:00	SPY	ETF	301.06	301.1	301.01	301.01	22234.0
2019-09-13 19:00:00	SPY	ETF	301.04	301.3	301.03	301.1	25216.0
2019-09-13 04:00:00	QQQ	ETF	193.68	193.81	193.55	193.58	11407.0
2019-09-13 05:00:00	QQQ	ETF	193.56	193.91	193.56	193.89	11960.0
2019-09-13 06:00:00	QQQ	ETF	193.93	194.05	193.83	194.0	80247.0
2019-09-13 07:00:00	QQQ	ETF	194.08	194.11	193.75	193.77	64660.0
2019-09-13 08:00:00	QQQ	ETF	194.06	194.1	193.22	193.23	293802.0
2019-09-13 09:00:00	QQQ	ETF	193.23	193.27	192.42	192.9	4383105.0
2019-09-13 10:00:00	QQQ	ETF	192.89	193.25	192.39	193.07	3806522.0
2019-09-13 11:00:00	QQQ	ETF	193.06	193.4	192.7	192.79	3478133.0
2019-09-13 12:00:00	QQQ	ETF	192.79	193.05	192.48	192.58	1588754.0
2019-09-13 13:00:00	QQQ	ETF	192.59	192.81	192.37	192.43	1456674.0
2019-09-13 14:00:00	QQQ	ETF	192.42	192.83	192.42	192.73	1277547.0
2019-09-13 15:00:00	QQQ	ETF	192.73	192.86	192.29	192.58	4564229.0
2019-09-13 16:00:00	QQQ	ETF	192.59	192.8663	192.38	192.44	971398.0
2019-09-13 17:00:00	QQQ	ETF	192.54	192.54	192.3999	192.48	75506.0
2019-09-13 18:00:00	QQQ	ETF	192.48	192.55	192.48	192.52	5855.0
2019-09-13 19:00:00	QQQ	ETF	192.52	192.53	192.4	192.49	8323.0
2019-09-13 04:00:00	IWM	ETF	157.64	157.8	157.62	157.62	1600.0
2019-09-13 05:00:00	IWM	ETF	157.67	157.84	157.67	157.84	1800.0
2019-09-13 06:00:00	IWM	ETF	157.97	158.0	157.97	158.0	7244.0
2019-09-13 07:00:00	IWM	ETF	158.02	158.1	157.95	158.02	74667.0
2019-09-13 08:00:00	IWM	ETF	158.02	158.13	157.55	157.93	190609.0
2019-09-13 09:00:00	IWM	ETF	157.94	158.92	157.78	157.84	3645216.0
2019-09-13 10:00:00	IWM	ETF	157.84	158.26	157.13	158.13	4568912.0
2019-09-13 11:00:00	IWM	ETF	158.13	158.32	157.65	157.68	2665840.0
2019-09-13 12:00:00	IWM	ETF	157.68	158.22	157.63	157.855	1501562.0
2019-09-13 13:00:00	IWM	ETF	157.86	157.87	157.22	157.45	1639001.0
2019-09-13 14:00:00	IWM	ETF	157.44	157.785	157.42	157.52	1651097.0
2019-09-13 15:00:00	IWM	ETF	157.52	157.72	157.27	157.3	3018162.0
2019-09-13 16:00:00	IWM	ETF	157.31	157.57	157.24	157.45	2629442.0
2019-09-13 17:00:00	IWM	ETF	157.44	157.48	157.36	157.45	21870.0
2019-09-13 18:00:00	IWM	ETF	157.45	157.45	157.35	157.44	12350.0
2019-09-13 19:00:00	IWM	ETF	157.35	157.35	157.35	157.35	900.0
2019-09-13 04:00:00	DIA	ETF	273.0	273.0	273.0	273.0	208.0
2019-09-13 06:00:00	DIA	ETF	273.32	273.32	273.32	273.32	1000.0

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

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