PREVIEW / etf_1hour / 2016-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-12-30.parquet
  size:    277 KB
  rows:    8,979

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-12-30 04:00:00	SPY	ETF	224.71	224.94	224.71	224.94	1750.0
2016-12-30 05:00:00	SPY	ETF	224.94	224.97	224.84	224.97	46063.0
2016-12-30 06:00:00	SPY	ETF	224.87	224.92	224.76	224.92	50981.0
2016-12-30 07:00:00	SPY	ETF	224.87	225.05	224.71	225.01	198332.0
2016-12-30 08:00:00	SPY	ETF	224.99	225.04	224.71	224.91	234196.0
2016-12-30 09:00:00	SPY	ETF	224.85	224.91	223.735	223.79	8182326.0
2016-12-30 10:00:00	SPY	ETF	223.77	224.0145	223.58	223.9	8187914.0
2016-12-30 11:00:00	SPY	ETF	223.89	224.18	223.735	223.98	5486677.0
2016-12-30 12:00:00	SPY	ETF	223.98	224.0	223.41	223.54	6654871.0
2016-12-30 13:00:00	SPY	ETF	223.54	223.78	223.4	223.4375	5859851.0
2016-12-30 14:00:00	SPY	ETF	223.43	223.4707	222.73	222.9	12395764.0
2016-12-30 15:00:00	SPY	ETF	222.9	223.56	222.81	223.55	36955122.0
2016-12-30 16:00:00	SPY	ETF	223.56	223.56	223.18	223.25	21744402.0
2016-12-30 17:00:00	SPY	ETF	223.25	223.35	223.24	223.35	74017.0
2016-12-30 18:00:00	SPY	ETF	223.29	223.42	223.26	223.3	42757.0
2016-12-30 19:00:00	SPY	ETF	223.32	223.53	223.3	223.42	242103.0
2016-12-30 04:00:00	QQQ	ETF	119.96	120.03	119.96	120.02	3889.0
2016-12-30 05:00:00	QQQ	ETF	120.02	120.02	120.0	120.0	1400.0
2016-12-30 06:00:00	QQQ	ETF	119.99	119.99	119.96	119.96	15053.0
2016-12-30 07:00:00	QQQ	ETF	120.0	120.02	119.92	120.02	9999.0
2016-12-30 08:00:00	QQQ	ETF	120.05	120.09	119.96	119.96	105125.0
2016-12-30 09:00:00	QQQ	ETF	119.96	119.96	118.86	118.89	3192759.0
2016-12-30 10:00:00	QQQ	ETF	118.85	118.99	118.64	118.88	4347161.0
2016-12-30 11:00:00	QQQ	ETF	118.87	118.98	118.71	118.82	1929007.0
2016-12-30 12:00:00	QQQ	ETF	118.82	118.83	118.35	118.52	3707105.0
2016-12-30 13:00:00	QQQ	ETF	118.519	118.62	118.34	118.37	2125677.0
2016-12-30 14:00:00	QQQ	ETF	118.36	118.42	118.14	118.23	3106870.0
2016-12-30 15:00:00	QQQ	ETF	118.235	118.54	118.15	118.51	6677951.0
2016-12-30 16:00:00	QQQ	ETF	118.52	118.5734	118.39	118.5	1991868.0
2016-12-30 17:00:00	QQQ	ETF	118.52	118.58	118.5	118.5	2683.0
2016-12-30 18:00:00	QQQ	ETF	118.5	118.55	118.42	118.46	9127.0
2016-12-30 19:00:00	QQQ	ETF	118.46	118.54	118.41	118.42	157501.0
2016-12-30 04:00:00	IWM	ETF	135.68	135.78	135.68	135.78	1333.0
2016-12-30 06:00:00	IWM	ETF	135.64	135.64	135.64	135.64	200.0
2016-12-30 07:00:00	IWM	ETF	135.67	135.84	135.6	135.82	26364.0
2016-12-30 08:00:00	IWM	ETF	135.84	135.84	135.71	135.71	71610.0
2016-12-30 09:00:00	IWM	ETF	135.72	135.77	134.59	134.66	3008232.0
2016-12-30 10:00:00	IWM	ETF	134.64	135.12	134.53	135.1	2717636.0
2016-12-30 11:00:00	IWM	ETF	135.09	135.31	134.9	135.1107	1622612.0
2016-12-30 12:00:00	IWM	ETF	135.1142	135.13	134.6614	134.82	1830970.0
2016-12-30 13:00:00	IWM	ETF	134.82	135.04	134.75	134.8285	1329507.0
2016-12-30 14:00:00	IWM	ETF	134.83	134.88	134.535	134.61	2937360.0
2016-12-30 15:00:00	IWM	ETF	134.61	134.89	134.4	134.88	7303408.0
2016-12-30 16:00:00	IWM	ETF	134.89	134.98	134.69	134.74	3242155.0
2016-12-30 17:00:00	IWM	ETF	134.85	134.85	134.85	134.85	6451.0
2016-12-30 18:00:00	IWM	ETF	134.8	134.85	134.71	134.71	53591.0
2016-12-30 19:00:00	IWM	ETF	134.8	134.85	134.7	134.72	297540.0
2016-12-30 07:00:00	DIA	ETF	198.19	198.21	198.19	198.21	450.0
2016-12-30 08:00:00	DIA	ETF	198.33	198.35	198.28	198.28	1060.0
2016-12-30 09:00:00	DIA	ETF	198.27	198.27	197.61	197.66	534609.0

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

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