PREVIEW / etf_1hour / 2019-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-26.parquet
  size:    320 KB
  rows:    10,615

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-07-26 04:00:00	SPY	ETF	300.33	300.63	300.33	300.57	9338.0
2019-07-26 05:00:00	SPY	ETF	300.52	300.92	300.52	300.85	5065.0
2019-07-26 06:00:00	SPY	ETF	300.95	301.0	300.83	300.83	31437.0
2019-07-26 07:00:00	SPY	ETF	300.82	300.88	300.74	300.8	142219.0
2019-07-26 08:00:00	SPY	ETF	300.82	300.86	300.0	300.73	448416.0
2019-07-26 09:00:00	SPY	ETF	300.74	301.37	300.56	301.23	5211069.0
2019-07-26 10:00:00	SPY	ETF	301.23	301.33	300.9023	301.1699	5529424.0
2019-07-26 11:00:00	SPY	ETF	301.16	301.75	301.0915	301.73	3730823.0
2019-07-26 12:00:00	SPY	ETF	301.735	301.8	301.59	301.705	3137205.0
2019-07-26 13:00:00	SPY	ETF	301.705	301.86	301.62	301.775	1810855.0
2019-07-26 14:00:00	SPY	ETF	301.77	302.09	301.66	302.08	2622048.0
2019-07-26 15:00:00	SPY	ETF	302.0801	302.23	301.97	301.99	11109266.0
2019-07-26 16:00:00	SPY	ETF	301.97	302.05	301.6	301.6	7213258.0
2019-07-26 17:00:00	SPY	ETF	301.6	302.01	301.4	301.41	300927.0
2019-07-26 18:00:00	SPY	ETF	301.41	301.45	301.21	301.3	122623.0
2019-07-26 19:00:00	SPY	ETF	301.33	301.4	301.2	301.35	33684.0
2019-07-26 04:00:00	QQQ	ETF	194.71	194.81	194.63	194.75	12505.0
2019-07-26 05:00:00	QQQ	ETF	194.76	195.01	194.73	194.96	12500.0
2019-07-26 06:00:00	QQQ	ETF	194.98	195.08	194.95	194.95	7751.0
2019-07-26 07:00:00	QQQ	ETF	194.92	194.95	194.83	194.9	58910.0
2019-07-26 08:00:00	QQQ	ETF	194.86	195.04	194.33	194.64	408591.0
2019-07-26 09:00:00	QQQ	ETF	194.68	195.39	194.43	195.2	2852554.0
2019-07-26 10:00:00	QQQ	ETF	195.19	195.3	194.552	194.775	2933239.0
2019-07-26 11:00:00	QQQ	ETF	194.77	195.355	194.65	195.33	2280950.0
2019-07-26 12:00:00	QQQ	ETF	195.34	195.37	195.08	195.2285	1477810.0
2019-07-26 13:00:00	QQQ	ETF	195.225	195.42	195.14	195.36	817061.0
2019-07-26 14:00:00	QQQ	ETF	195.36	195.44	195.19	195.42	1124653.0
2019-07-26 15:00:00	QQQ	ETF	195.43	195.55	195.26	195.26	3806730.0
2019-07-26 16:00:00	QQQ	ETF	195.26	195.3099	194.98	194.98	1671213.0
2019-07-26 17:00:00	QQQ	ETF	194.93	195.08	194.83	195.01	17768.0
2019-07-26 18:00:00	QQQ	ETF	195.01	195.05	194.93	194.96	4314.0
2019-07-26 19:00:00	QQQ	ETF	195.0	195.02	194.98	195.02	10118.0
2019-07-26 04:00:00	IWM	ETF	155.56	155.56	155.56	155.56	400.0
2019-07-26 05:00:00	IWM	ETF	155.77	155.77	155.77	155.77	100.0
2019-07-26 06:00:00	IWM	ETF	155.83	155.83	155.83	155.83	5000.0
2019-07-26 07:00:00	IWM	ETF	155.62	155.62	155.55	155.55	2200.0
2019-07-26 08:00:00	IWM	ETF	155.6101	155.67	155.23	155.45	125065.0
2019-07-26 09:00:00	IWM	ETF	155.48	156.34	155.42	156.175	2343684.0
2019-07-26 10:00:00	IWM	ETF	156.18	156.52	155.93	156.405	1819195.0
2019-07-26 11:00:00	IWM	ETF	156.4	156.62	156.37	156.585	1180720.0
2019-07-26 12:00:00	IWM	ETF	156.58	156.61	156.22	156.52	805448.0
2019-07-26 13:00:00	IWM	ETF	156.53	156.76	156.48	156.6182	638924.0
2019-07-26 14:00:00	IWM	ETF	156.61	157.15	156.54	157.125	1116023.0
2019-07-26 15:00:00	IWM	ETF	157.135	157.415	157.04	157.16	4058595.0
2019-07-26 16:00:00	IWM	ETF	157.16	157.3	156.97	157.04	925099.0
2019-07-26 17:00:00	IWM	ETF	157.03	157.03	156.92	156.99	3310.0
2019-07-26 18:00:00	IWM	ETF	156.99	156.99	156.81	156.81	1000.0
2019-07-26 19:00:00	IWM	ETF	156.83	156.83	156.83	156.83	300.0
2019-07-26 04:00:00	DIA	ETF	271.5	271.54	271.5	271.54	560.0
2019-07-26 05:00:00	DIA	ETF	271.86	271.86	271.86	271.86	1000.0

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

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