PREVIEW / etf_1hour / 2017-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-01.parquet
  size:    280 KB
  rows:    9,088

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-01 04:00:00	SPY	ETF	241.64	241.78	241.64	241.75	15458.0
2017-06-01 05:00:00	SPY	ETF	241.74	241.75	241.6	241.6	15645.0
2017-06-01 06:00:00	SPY	ETF	241.65	241.67	241.57	241.65	5620.0
2017-06-01 07:00:00	SPY	ETF	241.65	241.7	241.51	241.56	130061.0
2017-06-01 08:00:00	SPY	ETF	241.51	241.87	241.44	241.85	392117.0
2017-06-01 09:00:00	SPY	ETF	241.86	242.11	241.64	241.96	7751992.0
2017-06-01 10:00:00	SPY	ETF	241.955	242.06	241.7	241.84	7676812.0
2017-06-01 11:00:00	SPY	ETF	241.84	242.35	241.79	242.33	6319041.0
2017-06-01 12:00:00	SPY	ETF	242.335	242.72	242.315	242.66	6808735.0
2017-06-01 13:00:00	SPY	ETF	242.665	242.93	242.66	242.82	6154689.0
2017-06-01 14:00:00	SPY	ETF	242.82	243.03	242.785	242.8	5883399.0
2017-06-01 15:00:00	SPY	ETF	242.8	243.34	242.72	243.32	14271707.0
2017-06-01 16:00:00	SPY	ETF	243.32	243.43	241.44	243.31	8753568.0
2017-06-01 17:00:00	SPY	ETF	243.31	243.36	243.24	243.28	652170.0
2017-06-01 18:00:00	SPY	ETF	243.28	243.48	243.27	243.34	148054.0
2017-06-01 19:00:00	SPY	ETF	243.34	243.37	243.27	243.37	78053.0
2017-06-01 04:00:00	QQQ	ETF	141.6	141.6	141.6	141.6	100.0
2017-06-01 06:00:00	QQQ	ETF	141.53	141.56	141.53	141.54	1000.0
2017-06-01 07:00:00	QQQ	ETF	141.53	141.53	141.39	141.42	9256.0
2017-06-01 08:00:00	QQQ	ETF	141.42	141.57	141.29	141.55	109783.0
2017-06-01 09:00:00	QQQ	ETF	141.57	141.76	141.38	141.481	2304464.0
2017-06-01 10:00:00	QQQ	ETF	141.48	141.5499	140.98	141.15	3306071.0
2017-06-01 11:00:00	QQQ	ETF	141.15	141.51	141.12	141.5	1716226.0
2017-06-01 12:00:00	QQQ	ETF	141.49	141.69	141.43	141.62	2332109.0
2017-06-01 13:00:00	QQQ	ETF	141.625	141.69	141.54	141.585	1617839.0
2017-06-01 14:00:00	QQQ	ETF	141.58	141.69	141.521	141.54	1881731.0
2017-06-01 15:00:00	QQQ	ETF	141.53	141.89	141.53	141.89	3887402.0
2017-06-01 16:00:00	QQQ	ETF	141.88	142.02	141.82	142.01	768086.0
2017-06-01 17:00:00	QQQ	ETF	141.97	142.01	141.88	142.0	440700.0
2017-06-01 18:00:00	QQQ	ETF	142.0	142.13	141.84	142.05	14988.0
2017-06-01 19:00:00	QQQ	ETF	142.05	142.05	142.01	142.04	3129.0
2017-06-01 04:00:00	IWM	ETF	136.37	136.37	136.37	136.37	2500.0
2017-06-01 05:00:00	IWM	ETF	136.36	136.36	136.23	136.23	4405.0
2017-06-01 06:00:00	IWM	ETF	136.32	136.32	136.32	136.32	600.0
2017-06-01 07:00:00	IWM	ETF	136.35	136.39	136.21	136.23	15000.0
2017-06-01 08:00:00	IWM	ETF	136.23	136.6	136.22	136.59	84047.0
2017-06-01 09:00:00	IWM	ETF	136.6	137.24	136.27	137.07	3700320.0
2017-06-01 10:00:00	IWM	ETF	137.0632	137.43	136.79	136.995	4274221.0
2017-06-01 11:00:00	IWM	ETF	136.9999	137.94	136.97	137.85	4777548.0
2017-06-01 12:00:00	IWM	ETF	137.8473	138.3	137.76	138.15	4265309.0
2017-06-01 13:00:00	IWM	ETF	138.145	138.39	138.1	138.1964	3171998.0
2017-06-01 14:00:00	IWM	ETF	138.2	138.76	138.185	138.45	3910481.0
2017-06-01 15:00:00	IWM	ETF	138.44	139.0	138.38	138.98	7850822.0
2017-06-01 16:00:00	IWM	ETF	138.98	139.21	136.3878	139.12	4050466.0
2017-06-01 17:00:00	IWM	ETF	139.07	139.15	138.95	139.1	177659.0
2017-06-01 18:00:00	IWM	ETF	139.14	139.16	139.11	139.15	2200.0
2017-06-01 19:00:00	IWM	ETF	139.11	139.16	138.9635	138.97	354348.0
2017-06-01 07:00:00	DIA	ETF	209.9	209.9	209.9	209.9	104.0
2017-06-01 08:00:00	DIA	ETF	210.0	210.22	210.0	210.0	2955.0
2017-06-01 09:00:00	DIA	ETF	210.3	210.3	209.91	210.17	108618.0

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

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