PREVIEW / etf_1hour / 2018-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-06.parquet
  size:    304 KB
  rows:    9,935

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
2018-09-06 04:00:00	SPY	ETF	288.75	289.29	288.54	289.29	50830.0
2018-09-06 05:00:00	SPY	ETF	289.37	289.42	289.17	289.17	9359.0
2018-09-06 06:00:00	SPY	ETF	289.17	289.29	288.89	288.89	14279.0
2018-09-06 07:00:00	SPY	ETF	288.87	289.26	288.74	289.23	93425.0
2018-09-06 08:00:00	SPY	ETF	289.21	289.42	288.41	289.3	358967.0
2018-09-06 09:00:00	SPY	ETF	289.3	289.49	288.73	289.45	4917830.0
2018-09-06 10:00:00	SPY	ETF	289.46	289.49	287.36	287.74	12891701.0
2018-09-06 11:00:00	SPY	ETF	287.74	288.055	287.1	287.88	9980802.0
2018-09-06 12:00:00	SPY	ETF	287.88	287.92	287.28	287.2885	4978501.0
2018-09-06 13:00:00	SPY	ETF	287.28	287.94	287.0	287.6415	4968438.0
2018-09-06 14:00:00	SPY	ETF	287.64	288.21	287.567	287.94	5200302.0
2018-09-06 15:00:00	SPY	ETF	287.945	288.65	287.945	288.2	13191420.0
2018-09-06 16:00:00	SPY	ETF	288.18	288.32	287.97	288.16	7907340.0
2018-09-06 17:00:00	SPY	ETF	288.02	288.16	287.52	287.97	123294.0
2018-09-06 18:00:00	SPY	ETF	287.98	288.07	287.92	288.05	33058.0
2018-09-06 19:00:00	SPY	ETF	288.07	288.09	287.91	287.94	18098.0
2018-09-06 04:00:00	QQQ	ETF	183.37	183.72	183.37	183.67	48243.0
2018-09-06 05:00:00	QQQ	ETF	183.79	183.86	183.67	183.67	23479.0
2018-09-06 06:00:00	QQQ	ETF	183.77	183.79	183.42	183.43	27506.0
2018-09-06 07:00:00	QQQ	ETF	183.43	183.76	183.26	183.71	142583.0
2018-09-06 08:00:00	QQQ	ETF	183.4	183.85	183.16	183.77	211333.0
2018-09-06 09:00:00	QQQ	ETF	183.76	183.82	182.49	183.325	4700587.0
2018-09-06 10:00:00	QQQ	ETF	183.32	183.4	181.03	181.4575	9368464.0
2018-09-06 11:00:00	QQQ	ETF	181.46	181.725	180.73	181.64	6669577.0
2018-09-06 12:00:00	QQQ	ETF	181.63	181.75	180.9	180.9	3016102.0
2018-09-06 13:00:00	QQQ	ETF	180.9	181.61	180.58	181.21	4407180.0
2018-09-06 14:00:00	QQQ	ETF	181.21	181.58	181.03	181.45	3502670.0
2018-09-06 15:00:00	QQQ	ETF	181.43	182.0799	181.43	181.8199	5832509.0
2018-09-06 16:00:00	QQQ	ETF	181.8	181.94	181.68	181.71	2345677.0
2018-09-06 17:00:00	QQQ	ETF	181.68	181.81	181.64	181.7	34692.0
2018-09-06 18:00:00	QQQ	ETF	181.66	181.73	181.65	181.7	11270.0
2018-09-06 19:00:00	QQQ	ETF	181.75	181.75	181.57	181.62	32139.0
2018-09-06 05:00:00	IWM	ETF	172.02	172.02	171.9	171.9	2500.0
2018-09-06 06:00:00	IWM	ETF	171.96	171.99	171.91	171.91	12000.0
2018-09-06 07:00:00	IWM	ETF	171.92	172.07	171.92	172.05	23888.0
2018-09-06 08:00:00	IWM	ETF	172.03	172.22	172.01	172.22	98737.0
2018-09-06 09:00:00	IWM	ETF	172.22	172.4	171.83	172.35	1358305.0
2018-09-06 10:00:00	IWM	ETF	172.36	172.48	171.41	171.58	2937141.0
2018-09-06 11:00:00	IWM	ETF	171.6	171.67	170.82	170.98	2235246.0
2018-09-06 12:00:00	IWM	ETF	170.98	170.985	170.43	170.67	1714636.0
2018-09-06 13:00:00	IWM	ETF	170.66	170.91	170.42	170.605	1751224.0
2018-09-06 14:00:00	IWM	ETF	170.6	170.88	170.575	170.6	1141925.0
2018-09-06 15:00:00	IWM	ETF	170.6	171.005	170.59	170.63	3584291.0
2018-09-06 16:00:00	IWM	ETF	170.62	170.77	170.5	170.6	686525.0
2018-09-06 17:00:00	IWM	ETF	170.51	170.6	170.5	170.5	511.0
2018-09-06 18:00:00	IWM	ETF	170.58	170.58	170.58	170.58	1000.0
2018-09-06 19:00:00	IWM	ETF	170.6	170.63	170.5	170.51	5650.0
2018-09-06 05:00:00	DIA	ETF	260.29	260.43	260.29	260.43	200.0
2018-09-06 06:00:00	DIA	ETF	259.92	259.92	259.88	259.88	1056.0
2018-09-06 07:00:00	DIA	ETF	259.84	260.03	259.78	260.03	1271.0

> showing 50 of 9,935 rows — these rows as CSV

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