PREVIEW / etf_1hour / 2016-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-08.parquet
  size:    251 KB
  rows:    8,052

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
2016-03-08 04:00:00	SPY	ETF	199.24	199.54	199.06	199.08	216577.0
2016-03-08 05:00:00	SPY	ETF	199.08	199.16	198.73	198.97	90957.0
2016-03-08 06:00:00	SPY	ETF	198.9	199.38	198.86	199.36	66292.0
2016-03-08 07:00:00	SPY	ETF	199.43	200.05	199.42	199.84	367551.0
2016-03-08 08:00:00	SPY	ETF	199.5	200.0	199.0	199.73	929682.0
2016-03-08 09:00:00	SPY	ETF	199.72	199.72	198.82	199.05	12362585.0
2016-03-08 10:00:00	SPY	ETF	199.05	199.35	198.39	198.58	15131052.0
2016-03-08 11:00:00	SPY	ETF	198.59	199.46	198.545	199.28	11075708.0
2016-03-08 12:00:00	SPY	ETF	199.28	199.8	199.13	199.455	11239617.0
2016-03-08 13:00:00	SPY	ETF	199.455	199.92	199.21	199.66	11331788.0
2016-03-08 14:00:00	SPY	ETF	199.66	199.92	198.96	199.13	14009770.0
2016-03-08 15:00:00	SPY	ETF	199.135	199.27	198.21	198.36	31213567.0
2016-03-08 16:00:00	SPY	ETF	198.36	199.2715	198.34	198.87	9317440.0
2016-03-08 17:00:00	SPY	ETF	198.84	198.88	198.75	198.76	116551.0
2016-03-08 18:00:00	SPY	ETF	198.77	198.9923	198.63	198.71	143075.0
2016-03-08 19:00:00	SPY	ETF	198.72	198.86	198.5	198.65	130198.0
2016-03-08 04:00:00	QQQ	ETF	104.15	104.15	104.03	104.06	4798.0
2016-03-08 05:00:00	QQQ	ETF	103.96	103.96	103.96	103.96	300.0
2016-03-08 06:00:00	QQQ	ETF	103.96	104.24	103.91	104.2	4492.0
2016-03-08 07:00:00	QQQ	ETF	104.45	104.67	104.43	104.62	34882.0
2016-03-08 08:00:00	QQQ	ETF	104.57	104.71	104.38	104.52	84141.0
2016-03-08 09:00:00	QQQ	ETF	104.55	104.87	104.03	104.6	4826284.0
2016-03-08 10:00:00	QQQ	ETF	104.59	104.8099	104.1599	104.41	4448121.0
2016-03-08 11:00:00	QQQ	ETF	104.42	104.94	104.37	104.89	4226036.0
2016-03-08 12:00:00	QQQ	ETF	104.8875	105.2	104.76	104.86	2875563.0
2016-03-08 13:00:00	QQQ	ETF	104.87	105.2138	104.71	105.0665	1687838.0
2016-03-08 14:00:00	QQQ	ETF	105.06	105.1151	104.53	104.635	2176182.0
2016-03-08 15:00:00	QQQ	ETF	104.63	104.72	103.97	104.13	6047198.0
2016-03-08 16:00:00	QQQ	ETF	104.15	104.4	104.13	104.34	836875.0
2016-03-08 17:00:00	QQQ	ETF	104.36	104.39	104.31	104.31	14227.0
2016-03-08 18:00:00	QQQ	ETF	104.31	104.4	104.21	104.28	18049.0
2016-03-08 19:00:00	QQQ	ETF	104.21	104.32	104.14	104.22	13274.0
2016-03-08 04:00:00	IWM	ETF	108.18	108.34	108.18	108.18	1900.0
2016-03-08 05:00:00	IWM	ETF	108.02	108.04	107.99	108.04	2800.0
2016-03-08 06:00:00	IWM	ETF	108.04	108.2	108.02	108.16	9009.0
2016-03-08 07:00:00	IWM	ETF	108.56	108.57	108.4	108.51	14600.0
2016-03-08 08:00:00	IWM	ETF	108.51	108.63	108.42	108.46	75407.0
2016-03-08 09:00:00	IWM	ETF	108.45	108.45	107.6	107.605	5371200.0
2016-03-08 10:00:00	IWM	ETF	107.6	107.75	106.7	106.8	10017866.0
2016-03-08 11:00:00	IWM	ETF	106.8	107.24	106.74	107.035	4330569.0
2016-03-08 12:00:00	IWM	ETF	107.035	107.31	106.88	107.08	3376787.0
2016-03-08 13:00:00	IWM	ETF	107.08	107.51	106.91	107.32	2750831.0
2016-03-08 14:00:00	IWM	ETF	107.31	107.46	106.875	107.01	2952839.0
2016-03-08 15:00:00	IWM	ETF	107.0	107.07	106.14	106.26	8575324.0
2016-03-08 16:00:00	IWM	ETF	106.26	107.95	106.24	106.45	2057300.0
2016-03-08 17:00:00	IWM	ETF	106.5	106.53	106.47	106.47	3129.0
2016-03-08 18:00:00	IWM	ETF	106.45	106.47	106.4	106.41	3110.0
2016-03-08 19:00:00	IWM	ETF	106.45	106.5	106.37	106.42	2600.0
2016-03-08 05:00:00	DIA	ETF	169.44	169.44	169.44	169.44	100.0
2016-03-08 06:00:00	DIA	ETF	169.54	169.54	169.54	169.54	500.0

> showing 50 of 8,052 rows — these rows as CSV

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