PREVIEW / etf_1hour / 2017-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-29.parquet
  size:    285 KB
  rows:    9,291

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
2017-06-29 04:00:00	SPY	ETF	243.82	243.83	243.77	243.83	9840.0
2017-06-29 05:00:00	SPY	ETF	243.8	243.8	243.59	243.7	10805.0
2017-06-29 06:00:00	SPY	ETF	243.68	243.73	243.58	243.72	31978.0
2017-06-29 07:00:00	SPY	ETF	243.79	244.14	243.69	244.06	251668.0
2017-06-29 08:00:00	SPY	ETF	243.91	244.11	243.54	243.6	605460.0
2017-06-29 09:00:00	SPY	ETF	243.6	243.72	242.77	242.92	8817523.0
2017-06-29 10:00:00	SPY	ETF	242.93	243.03	242.305	242.65	11290721.0
2017-06-29 11:00:00	SPY	ETF	242.66	242.71	241.31	241.36	13180541.0
2017-06-29 12:00:00	SPY	ETF	241.36	241.79	240.98	241.04	13397422.0
2017-06-29 13:00:00	SPY	ETF	241.04	241.29	239.955	240.87	17656564.0
2017-06-29 14:00:00	SPY	ETF	240.86	241.5901	240.58	241.42	11151970.0
2017-06-29 15:00:00	SPY	ETF	241.425	241.98	241.33	241.39	20330643.0
2017-06-29 16:00:00	SPY	ETF	241.39	241.88	240.7989	241.85	6774944.0
2017-06-29 17:00:00	SPY	ETF	241.8	241.85	241.35	241.74	950039.0
2017-06-29 18:00:00	SPY	ETF	241.75	241.89	241.47	241.47	264238.0
2017-06-29 19:00:00	SPY	ETF	241.49	241.77	241.49	241.68	56751.0
2017-06-29 04:00:00	QQQ	ETF	140.08	140.08	139.9	140.05	14422.0
2017-06-29 05:00:00	QQQ	ETF	140.05	140.05	139.83	139.89	3190.0
2017-06-29 06:00:00	QQQ	ETF	139.89	139.89	139.7	139.82	14600.0
2017-06-29 07:00:00	QQQ	ETF	139.87	140.05	139.87	139.9	88100.0
2017-06-29 08:00:00	QQQ	ETF	139.92	139.92	139.29	139.33	630620.0
2017-06-29 09:00:00	QQQ	ETF	139.32	139.49	138.43	138.6	8455280.0
2017-06-29 10:00:00	QQQ	ETF	138.61	138.75	138.015	138.24	10057028.0
2017-06-29 11:00:00	QQQ	ETF	138.24	138.35	137.095	137.3	15096557.0
2017-06-29 12:00:00	QQQ	ETF	137.31	137.79	136.95	136.98	8480144.0
2017-06-29 13:00:00	QQQ	ETF	136.97	137.17	136.25	136.71	12858835.0
2017-06-29 14:00:00	QQQ	ETF	136.71	137.32	136.5	137.16	7444720.0
2017-06-29 15:00:00	QQQ	ETF	137.15	137.95	137.14	137.58	11246356.0
2017-06-29 16:00:00	QQQ	ETF	137.58	137.8	136.3611	137.44	1559947.0
2017-06-29 17:00:00	QQQ	ETF	137.45	137.59	137.34	137.4	464011.0
2017-06-29 18:00:00	QQQ	ETF	137.42	137.53	137.1	137.1	59700.0
2017-06-29 19:00:00	QQQ	ETF	137.12	137.34	137.11	137.32	32899.0
2017-06-29 04:00:00	IWM	ETF	142.38	142.39	142.31	142.31	3700.0
2017-06-29 05:00:00	IWM	ETF	142.37	142.41	142.19	142.19	4427.0
2017-06-29 06:00:00	IWM	ETF	142.2	142.21	142.12	142.19	6700.0
2017-06-29 07:00:00	IWM	ETF	142.25	142.55	142.21	142.47	135719.0
2017-06-29 08:00:00	IWM	ETF	142.47	142.5	142.02	142.07	208064.0
2017-06-29 09:00:00	IWM	ETF	142.07	142.35	141.63	141.76	3495505.0
2017-06-29 10:00:00	IWM	ETF	141.78	142.065	141.16	141.79	4970821.0
2017-06-29 11:00:00	IWM	ETF	141.8	141.9	140.51	140.57	4754749.0
2017-06-29 12:00:00	IWM	ETF	140.59	140.91	140.4	140.47	3511524.0
2017-06-29 13:00:00	IWM	ETF	140.475	140.59	139.65	140.225	5338081.0
2017-06-29 14:00:00	IWM	ETF	140.23	140.88	140.17	140.71	3025645.0
2017-06-29 15:00:00	IWM	ETF	140.7	141.34	140.65	141.15	5473529.0
2017-06-29 16:00:00	IWM	ETF	141.14	141.39	140.693	141.34	2279933.0
2017-06-29 17:00:00	IWM	ETF	141.98	141.98	141.32	141.32	37699.0
2017-06-29 18:00:00	IWM	ETF	141.22	141.34	141.22	141.34	600.0
2017-06-29 19:00:00	IWM	ETF	141.23	141.32	141.23	141.32	300.0
2017-06-29 04:00:00	DIA	ETF	214.34	214.34	214.34	214.34	800.0
2017-06-29 05:00:00	DIA	ETF	214.5	214.5	214.5	214.5	1800.0

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

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