PREVIEW / etf_1hour / 2017-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-21.parquet
  size:    277 KB
  rows:    9,056

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-21 04:00:00	SPY	ETF	242.75	242.91	242.46	242.76	73359.0
2017-06-21 05:00:00	SPY	ETF	242.76	242.86	242.54	242.72	23460.0
2017-06-21 06:00:00	SPY	ETF	242.72	243.01	242.72	243.01	125240.0
2017-06-21 07:00:00	SPY	ETF	243.06	243.12	242.8	242.88	332555.0
2017-06-21 08:00:00	SPY	ETF	242.88	243.28	242.86	243.22	374517.0
2017-06-21 09:00:00	SPY	ETF	243.23	243.46	243.05	243.1	5691037.0
2017-06-21 10:00:00	SPY	ETF	243.085	243.59	243.06	243.23	8322000.0
2017-06-21 11:00:00	SPY	ETF	243.225	243.23	242.66	243.17	7174883.0
2017-06-21 12:00:00	SPY	ETF	243.18	243.1899	242.66	242.6744	3851226.0
2017-06-21 13:00:00	SPY	ETF	242.675	242.87	242.41	242.56	4818882.0
2017-06-21 14:00:00	SPY	ETF	242.56	243.06	242.44	242.94	6246113.0
2017-06-21 15:00:00	SPY	ETF	242.94	243.04	242.68	242.95	12055971.0
2017-06-21 16:00:00	SPY	ETF	242.94	243.02	242.5	242.85	5011785.0
2017-06-21 17:00:00	SPY	ETF	242.83	242.85	242.75	242.77	170996.0
2017-06-21 18:00:00	SPY	ETF	242.77	242.79	242.57	242.63	119181.0
2017-06-21 19:00:00	SPY	ETF	242.63	242.8	242.57	242.63	56214.0
2017-06-21 04:00:00	QQQ	ETF	139.04	139.04	138.58	139.0	25381.0
2017-06-21 05:00:00	QQQ	ETF	138.95	138.95	138.73	138.86	28685.0
2017-06-21 06:00:00	QQQ	ETF	138.95	139.18	138.9	139.18	63785.0
2017-06-21 07:00:00	QQQ	ETF	139.2	139.24	139.01	139.13	131683.0
2017-06-21 08:00:00	QQQ	ETF	139.05	139.6	139.05	139.55	104585.0
2017-06-21 09:00:00	QQQ	ETF	139.55	139.96	139.55	139.67	3839099.0
2017-06-21 10:00:00	QQQ	ETF	139.662	140.41	139.66	140.24	6974204.0
2017-06-21 11:00:00	QQQ	ETF	140.235	140.38	139.88	140.37	3687604.0
2017-06-21 12:00:00	QQQ	ETF	140.36	140.5	140.12	140.16	3139799.0
2017-06-21 13:00:00	QQQ	ETF	140.15	140.44	140.15	140.3	2083675.0
2017-06-21 14:00:00	QQQ	ETF	140.29	140.71	140.17	140.615	3888713.0
2017-06-21 15:00:00	QQQ	ETF	140.61	140.81	140.53	140.74	6164952.0
2017-06-21 16:00:00	QQQ	ETF	140.72	140.98	140.101	140.94	1469362.0
2017-06-21 17:00:00	QQQ	ETF	140.94	140.96	140.87	140.87	5012.0
2017-06-21 18:00:00	QQQ	ETF	140.81	140.85	140.74	140.8	1108205.0
2017-06-21 19:00:00	QQQ	ETF	140.8	140.9	140.75	140.85	22509.0
2017-06-21 04:00:00	IWM	ETF	139.35	139.4	139.35	139.4	3000.0
2017-06-21 05:00:00	IWM	ETF	139.43	139.43	139.25	139.25	350.0
2017-06-21 06:00:00	IWM	ETF	139.6	139.6	139.52	139.6	2500.0
2017-06-21 07:00:00	IWM	ETF	139.62	139.62	139.55	139.55	300.0
2017-06-21 08:00:00	IWM	ETF	139.49	139.93	139.47	139.8	74013.0
2017-06-21 09:00:00	IWM	ETF	139.89	140.29	139.72	140.19	1967126.0
2017-06-21 10:00:00	IWM	ETF	140.19	140.8	140.01	140.4	3948185.0
2017-06-21 11:00:00	IWM	ETF	140.4	140.42	139.79	140.13	2817139.0
2017-06-21 12:00:00	IWM	ETF	140.13	140.16	139.5	139.55	1629831.0
2017-06-21 13:00:00	IWM	ETF	139.55	139.72	139.36	139.455	2096366.0
2017-06-21 14:00:00	IWM	ETF	139.45	139.66	139.3599	139.38	2453884.0
2017-06-21 15:00:00	IWM	ETF	139.39	139.52	139.22	139.44	4362303.0
2017-06-21 16:00:00	IWM	ETF	139.45	139.7544	139.27	139.31	714096.0
2017-06-21 17:00:00	IWM	ETF	139.38	139.39	139.26	139.37	22750.0
2017-06-21 18:00:00	IWM	ETF	139.3	139.33	139.27	139.29	6863.0
2017-06-21 19:00:00	IWM	ETF	139.28	139.37	139.28	139.37	5178.0
2017-06-21 04:00:00	DIA	ETF	214.36	214.36	214.24	214.24	1400.0
2017-06-21 07:00:00	DIA	ETF	214.43	214.43	214.43	214.43	364.0

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

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