PREVIEW / etf_1hour / 2018-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-20.parquet
  size:    292 KB
  rows:    9,561

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-04-20 04:00:00	SPY	ETF	268.1	268.5	268.1	268.5	8904.0
2018-04-20 05:00:00	SPY	ETF	268.52	268.78	268.03	268.77	21615.0
2018-04-20 06:00:00	SPY	ETF	268.77	269.24	268.62	269.23	81152.0
2018-04-20 07:00:00	SPY	ETF	269.21	269.43	268.98	269.03	103195.0
2018-04-20 08:00:00	SPY	ETF	269.08	269.11	268.05	268.96	339377.0
2018-04-20 09:00:00	SPY	ETF	268.98	269.18	268.17	268.42	7874486.0
2018-04-20 10:00:00	SPY	ETF	268.42	268.44	267.22	267.48	17360494.0
2018-04-20 11:00:00	SPY	ETF	267.46	268.9024	266.42	267.025	10936139.0
2018-04-20 12:00:00	SPY	ETF	267.03	267.07	266.08	266.37	7947550.0
2018-04-20 13:00:00	SPY	ETF	266.35	267.3	266.21	266.9508	8298414.0
2018-04-20 14:00:00	SPY	ETF	266.95	267.0866	266.27	266.5592	7721943.0
2018-04-20 15:00:00	SPY	ETF	266.55	266.63	265.61	266.63	25389377.0
2018-04-20 16:00:00	SPY	ETF	266.62	266.89	266.53	266.68	11389471.0
2018-04-20 17:00:00	SPY	ETF	266.68	266.79	266.67	266.74	47645.0
2018-04-20 18:00:00	SPY	ETF	266.73	267.01	266.61	267.01	421797.0
2018-04-20 19:00:00	SPY	ETF	266.98	267.18	266.9	267.11	48404.0
2018-04-20 04:00:00	QQQ	ETF	164.32	164.42	164.07	164.41	24126.0
2018-04-20 05:00:00	QQQ	ETF	164.48	164.61	164.12	164.61	26090.0
2018-04-20 06:00:00	QQQ	ETF	164.56	164.94	164.47	164.92	39450.0
2018-04-20 07:00:00	QQQ	ETF	164.93	165.13	164.78	164.89	59654.0
2018-04-20 08:00:00	QQQ	ETF	164.88	165.1	164.3	164.65	292506.0
2018-04-20 09:00:00	QQQ	ETF	164.68	164.79	163.49	163.76	3481268.0
2018-04-20 10:00:00	QQQ	ETF	163.77	164.07	163.05	163.26	5404159.0
2018-04-20 11:00:00	QQQ	ETF	163.26	163.32	162.3738	162.7032	6119889.0
2018-04-20 12:00:00	QQQ	ETF	162.72	162.81	162.08	162.24	3237243.0
2018-04-20 13:00:00	QQQ	ETF	162.22	162.99	162.11	162.73	3921893.0
2018-04-20 14:00:00	QQQ	ETF	162.735	162.83	162.15	162.39	3311926.0
2018-04-20 15:00:00	QQQ	ETF	162.38	162.42	161.73	162.39	9000532.0
2018-04-20 16:00:00	QQQ	ETF	162.38	162.61	162.27	162.47	4291544.0
2018-04-20 17:00:00	QQQ	ETF	162.5	162.5	162.32	162.37	27346.0
2018-04-20 18:00:00	QQQ	ETF	162.39	162.5	162.36	162.5	4372.0
2018-04-20 19:00:00	QQQ	ETF	162.3	162.7	162.3	162.6	265485.0
2018-04-20 04:00:00	IWM	ETF	156.16	156.17	156.16	156.17	700.0
2018-04-20 05:00:00	IWM	ETF	156.14	156.14	156.14	156.14	500.0
2018-04-20 06:00:00	IWM	ETF	156.44	156.55	156.41	156.55	5300.0
2018-04-20 07:00:00	IWM	ETF	156.74	156.74	156.59	156.6	7068.0
2018-04-20 08:00:00	IWM	ETF	156.75	156.75	156.33	156.5	37125.0
2018-04-20 09:00:00	IWM	ETF	156.52	156.52	155.94	156.08	1361599.0
2018-04-20 10:00:00	IWM	ETF	156.09	156.72	155.53	155.817	2870045.0
2018-04-20 11:00:00	IWM	ETF	155.81	156.21	155.19	155.98	2541183.0
2018-04-20 12:00:00	IWM	ETF	156.01	156.1	155.4	155.59	1209636.0
2018-04-20 13:00:00	IWM	ETF	155.583	156.06	155.46	155.89	1667096.0
2018-04-20 14:00:00	IWM	ETF	155.9	155.93	155.5	155.61	694716.0
2018-04-20 15:00:00	IWM	ETF	155.62	155.62	155.15	155.56	4018491.0
2018-04-20 16:00:00	IWM	ETF	155.56	155.72	155.46	155.52	2068932.0
2018-04-20 17:00:00	IWM	ETF	155.52	155.57	155.47	155.57	27618.0
2018-04-20 18:00:00	IWM	ETF	155.6	155.68	155.6	155.62	1600.0
2018-04-20 19:00:00	IWM	ETF	155.75	155.8	155.75	155.8	1700.0
2018-04-20 05:00:00	DIA	ETF	245.85	245.85	245.85	245.85	200.0
2018-04-20 06:00:00	DIA	ETF	246.2	246.37	246.1	246.37	1000.0

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

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