PREVIEW / etf_1hour / 2018-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-26.parquet
  size:    303 KB
  rows:    10,006

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-06-26 04:00:00	SPY	ETF	271.0	271.43	271.0	271.28	11025.0
2018-06-26 05:00:00	SPY	ETF	271.35	271.35	271.1	271.1	7670.0
2018-06-26 06:00:00	SPY	ETF	271.12	271.12	270.56	270.96	80620.0
2018-06-26 07:00:00	SPY	ETF	271.0	271.09	270.76	270.96	250201.0
2018-06-26 08:00:00	SPY	ETF	270.96	271.69	270.78	271.49	315903.0
2018-06-26 09:00:00	SPY	ETF	271.45	271.85	270.91	271.53	8089568.0
2018-06-26 10:00:00	SPY	ETF	271.5362	272.09	270.79	271.3	9086169.0
2018-06-26 11:00:00	SPY	ETF	271.29	271.73	271.1699	271.68	6229259.0
2018-06-26 12:00:00	SPY	ETF	271.67	272.2	271.67	272.03	6849139.0
2018-06-26 13:00:00	SPY	ETF	272.03	272.56	271.96	272.355	6152251.0
2018-06-26 14:00:00	SPY	ETF	272.36	272.52	272.1	272.2385	5719400.0
2018-06-26 15:00:00	SPY	ETF	272.22	272.3	271.38	271.55	18732463.0
2018-06-26 16:00:00	SPY	ETF	271.55	271.96	271.48	271.54	4476817.0
2018-06-26 17:00:00	SPY	ETF	271.58	271.72	271.55	271.69	91496.0
2018-06-26 18:00:00	SPY	ETF	271.69	271.92	271.69	271.84	81054.0
2018-06-26 19:00:00	SPY	ETF	271.83	272.02	271.57	271.96	53681.0
2018-06-26 04:00:00	QQQ	ETF	171.37	171.81	171.36	171.74	40753.0
2018-06-26 05:00:00	QQQ	ETF	171.89	172.0	171.62	171.74	43687.0
2018-06-26 06:00:00	QQQ	ETF	171.77	171.94	171.42	171.92	73246.0
2018-06-26 07:00:00	QQQ	ETF	171.88	171.93	171.58	171.75	128302.0
2018-06-26 08:00:00	QQQ	ETF	171.75	172.16	171.59	172.0	368389.0
2018-06-26 09:00:00	QQQ	ETF	171.9699	172.5534	171.38	172.28	5073004.0
2018-06-26 10:00:00	QQQ	ETF	172.285	172.64	171.37	171.79	4916221.0
2018-06-26 11:00:00	QQQ	ETF	171.78	172.15	171.63	172.05	2793190.0
2018-06-26 12:00:00	QQQ	ETF	172.05	172.68	172.03	172.57	3235005.0
2018-06-26 13:00:00	QQQ	ETF	172.5899	173.0585	172.51	172.79	2885210.0
2018-06-26 14:00:00	QQQ	ETF	172.78	172.84	172.4	172.49	2006736.0
2018-06-26 15:00:00	QQQ	ETF	172.48	172.53	171.86	172.07	5450835.0
2018-06-26 16:00:00	QQQ	ETF	172.06	172.42	172.06	172.14	1448947.0
2018-06-26 17:00:00	QQQ	ETF	172.1	172.23	172.1	172.23	5614.0
2018-06-26 18:00:00	QQQ	ETF	172.26	172.4	172.18	172.22	33274.0
2018-06-26 19:00:00	QQQ	ETF	172.24	172.43	172.24	172.4	11890.0
2018-06-26 04:00:00	IWM	ETF	165.16	165.18	165.15	165.16	3680.0
2018-06-26 05:00:00	IWM	ETF	165.19	165.23	165.0	165.03	7503.0
2018-06-26 06:00:00	IWM	ETF	165.08	165.08	164.73	164.97	12700.0
2018-06-26 07:00:00	IWM	ETF	164.95	164.99	164.72	164.81	25250.0
2018-06-26 08:00:00	IWM	ETF	165.08	165.1	164.75	165.01	59317.0
2018-06-26 09:00:00	IWM	ETF	164.98	165.39	164.85	165.17	2192975.0
2018-06-26 10:00:00	IWM	ETF	165.175	165.52	164.87	165.34	3019145.0
2018-06-26 11:00:00	IWM	ETF	165.33	165.76	165.26	165.61	2374833.0
2018-06-26 12:00:00	IWM	ETF	165.6	166.4	165.595	166.32	2023732.0
2018-06-26 13:00:00	IWM	ETF	166.33	166.66	166.22	166.41	2011890.0
2018-06-26 14:00:00	IWM	ETF	166.42	166.54	166.26	166.3	1532814.0
2018-06-26 15:00:00	IWM	ETF	166.29	166.52	166.02	166.09	3020159.0
2018-06-26 16:00:00	IWM	ETF	166.1	166.4	166.03	166.11	1032789.0
2018-06-26 17:00:00	IWM	ETF	166.17	166.17	166.17	166.17	400.0
2018-06-26 18:00:00	IWM	ETF	166.17	166.29	166.17	166.27	4620.0
2018-06-26 19:00:00	IWM	ETF	166.22	166.3	166.21	166.3	12986.0
2018-06-26 04:00:00	DIA	ETF	242.74	242.9	242.68	242.9	600.0
2018-06-26 05:00:00	DIA	ETF	242.7	242.7	242.7	242.7	250.0

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

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