PREVIEW / etf_1hour / 2017-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-12.parquet
  size:    278 KB
  rows:    9,171

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-07-12 04:00:00	SPY	ETF	242.33	242.33	242.33	242.33	600.0
2017-07-12 05:00:00	SPY	ETF	242.33	242.64	242.28	242.62	12660.0
2017-07-12 06:00:00	SPY	ETF	242.62	242.73	242.55	242.7	64750.0
2017-07-12 07:00:00	SPY	ETF	242.65	242.76	242.61	242.62	71099.0
2017-07-12 08:00:00	SPY	ETF	242.19	243.46	242.19	243.36	512247.0
2017-07-12 09:00:00	SPY	ETF	243.37	244.03	242.4923	243.87	7814724.0
2017-07-12 10:00:00	SPY	ETF	243.87	244.1	243.62	243.645	8052797.0
2017-07-12 11:00:00	SPY	ETF	243.6401	243.89	243.5627	243.799	4049377.0
2017-07-12 12:00:00	SPY	ETF	243.8	243.965	243.52	243.86	4785960.0
2017-07-12 13:00:00	SPY	ETF	243.87	244.08	243.755	244.07	3768682.0
2017-07-12 14:00:00	SPY	ETF	244.06	244.2	243.945	244.06	6160828.0
2017-07-12 15:00:00	SPY	ETF	244.06	244.2	243.88	243.98	10757120.0
2017-07-12 16:00:00	SPY	ETF	243.97	244.06	243.81	243.94	11385931.0
2017-07-12 17:00:00	SPY	ETF	243.94	244.1	243.93	244.0	496209.0
2017-07-12 18:00:00	SPY	ETF	244.0	244.02	243.92	244.02	235721.0
2017-07-12 19:00:00	SPY	ETF	244.02	244.04	243.95	244.04	69521.0
2017-07-12 04:00:00	QQQ	ETF	139.18	139.2	139.16	139.18	4399.0
2017-07-12 05:00:00	QQQ	ETF	139.25	139.43	139.22	139.43	9077.0
2017-07-12 06:00:00	QQQ	ETF	139.45	139.66	139.45	139.58	17000.0
2017-07-12 07:00:00	QQQ	ETF	139.59	139.67	139.53	139.53	72632.0
2017-07-12 08:00:00	QQQ	ETF	139.54	140.31	139.52	140.3	723042.0
2017-07-12 09:00:00	QQQ	ETF	140.28	140.39	139.955	140.0801	5915996.0
2017-07-12 10:00:00	QQQ	ETF	140.1	140.46	140.01	140.16	5272897.0
2017-07-12 11:00:00	QQQ	ETF	140.155	140.44	140.14	140.37	2000515.0
2017-07-12 12:00:00	QQQ	ETF	140.38	140.51	140.22	140.43	2234993.0
2017-07-12 13:00:00	QQQ	ETF	140.44	140.62	140.34	140.6	2026912.0
2017-07-12 14:00:00	QQQ	ETF	140.59	140.73	140.505	140.65	2753091.0
2017-07-12 15:00:00	QQQ	ETF	140.66	140.86	140.63	140.72	10009405.0
2017-07-12 16:00:00	QQQ	ETF	140.72	140.87	140.2353	140.86	2923051.0
2017-07-12 17:00:00	QQQ	ETF	140.88	140.89	140.7	140.85	75114.0
2017-07-12 18:00:00	QQQ	ETF	140.83	140.86	140.79	140.86	9922.0
2017-07-12 19:00:00	QQQ	ETF	140.84	140.93	140.79	140.93	34809.0
2017-07-12 05:00:00	IWM	ETF	140.49	140.49	140.49	140.49	100.0
2017-07-12 06:00:00	IWM	ETF	140.53	140.57	140.53	140.57	6950.0
2017-07-12 07:00:00	IWM	ETF	140.53	140.6	140.53	140.6	6000.0
2017-07-12 08:00:00	IWM	ETF	140.29	141.22	140.29	141.2	129968.0
2017-07-12 09:00:00	IWM	ETF	141.17	142.13	140.93	141.89	3817492.0
2017-07-12 10:00:00	IWM	ETF	141.89	142.22	141.48	141.49	3433703.0
2017-07-12 11:00:00	IWM	ETF	141.5	141.62	141.19	141.47	1987849.0
2017-07-12 12:00:00	IWM	ETF	141.47	141.6255	141.18	141.505	1422141.0
2017-07-12 13:00:00	IWM	ETF	141.52	141.5466	141.01	141.29	1209951.0
2017-07-12 14:00:00	IWM	ETF	141.28	141.42	141.18	141.28	1213331.0
2017-07-12 15:00:00	IWM	ETF	141.28	141.54	141.22	141.37	3645046.0
2017-07-12 16:00:00	IWM	ETF	141.37	141.42	136.37	141.25	692864.0
2017-07-12 17:00:00	IWM	ETF	141.16	141.2	141.12	141.15	3148.0
2017-07-12 18:00:00	IWM	ETF	141.22	141.22	141.21	141.22	300.0
2017-07-12 19:00:00	IWM	ETF	141.2	141.24	141.2	141.24	2271.0
2017-07-12 08:00:00	DIA	ETF	214.4	215.15	214.36	215.15	1167.0
2017-07-12 09:00:00	DIA	ETF	215.15	215.7	214.92	215.43	453421.0
2017-07-12 10:00:00	DIA	ETF	215.44	215.64	215.27	215.35	325273.0

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

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