PREVIEW / etf_1hour / 2016-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-22.parquet
  size:    260 KB
  rows:    8,453

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-09-22 04:00:00	SPY	ETF	215.82	216.01	215.82	216.0	8841.0
2016-09-22 05:00:00	SPY	ETF	216.13	216.48	216.13	216.46	23499.0
2016-09-22 06:00:00	SPY	ETF	216.48	216.66	216.43	216.43	47678.0
2016-09-22 07:00:00	SPY	ETF	216.45	216.72	216.45	216.71	347373.0
2016-09-22 08:00:00	SPY	ETF	216.72	216.91	216.44	216.81	986083.0
2016-09-22 09:00:00	SPY	ETF	216.81	217.42	216.8	217.3	12161504.0
2016-09-22 10:00:00	SPY	ETF	217.295	217.53	217.02	217.135	10808437.0
2016-09-22 11:00:00	SPY	ETF	217.135	217.2691	216.84	216.965	7534085.0
2016-09-22 12:00:00	SPY	ETF	216.965	217.21	216.89	217.2	4875443.0
2016-09-22 13:00:00	SPY	ETF	217.2001	217.42	217.165	217.27	5032673.0
2016-09-22 14:00:00	SPY	ETF	217.27	217.35	216.71	217.29	9401411.0
2016-09-22 15:00:00	SPY	ETF	217.2889	217.49	217.13	217.16	18991247.0
2016-09-22 16:00:00	SPY	ETF	217.16	217.24	216.94	217.13	4512494.0
2016-09-22 17:00:00	SPY	ETF	217.1	217.13	217.07	217.07	165011.0
2016-09-22 18:00:00	SPY	ETF	217.07	217.1	217.02	217.05	58517.0
2016-09-22 19:00:00	SPY	ETF	217.06	217.07	216.94	217.04	67324.0
2016-09-22 04:00:00	QQQ	ETF	118.29	118.29	118.29	118.29	100.0
2016-09-22 05:00:00	QQQ	ETF	118.44	118.58	118.44	118.58	1100.0
2016-09-22 06:00:00	QQQ	ETF	118.61	118.67	118.55	118.55	7469.0
2016-09-22 07:00:00	QQQ	ETF	118.56	118.71	118.54	118.71	12246.0
2016-09-22 08:00:00	QQQ	ETF	118.71	118.8	118.56	118.8	135575.0
2016-09-22 09:00:00	QQQ	ETF	118.8	118.96	118.7177	118.8601	3371539.0
2016-09-22 10:00:00	QQQ	ETF	118.87	119.12	118.76	118.87	2084864.0
2016-09-22 11:00:00	QQQ	ETF	118.865	118.99	118.82	118.94	1937490.0
2016-09-22 12:00:00	QQQ	ETF	118.95	119.0601	118.92	119.0601	1039274.0
2016-09-22 13:00:00	QQQ	ETF	119.06	119.22	119.04	119.12	1893935.0
2016-09-22 14:00:00	QQQ	ETF	119.11	119.18	118.77	119.08	3012204.0
2016-09-22 15:00:00	QQQ	ETF	119.09	119.21	119.025	119.09	3717413.0
2016-09-22 16:00:00	QQQ	ETF	119.09	119.14	119.01	119.13	954298.0
2016-09-22 17:00:00	QQQ	ETF	119.15	119.16	119.12	119.12	3621.0
2016-09-22 18:00:00	QQQ	ETF	119.1	119.1	119.06	119.09	11830.0
2016-09-22 19:00:00	QQQ	ETF	119.07	119.08	119.02	119.05	26861.0
2016-09-22 04:00:00	IWM	ETF	123.9	124.1	123.9	124.1	1190.0
2016-09-22 05:00:00	IWM	ETF	124.25	124.35	124.25	124.35	323.0
2016-09-22 06:00:00	IWM	ETF	124.47	124.51	124.42	124.42	2065.0
2016-09-22 07:00:00	IWM	ETF	124.4	124.58	124.4	124.54	78912.0
2016-09-22 08:00:00	IWM	ETF	124.58	124.67	124.49	124.57	170568.0
2016-09-22 09:00:00	IWM	ETF	124.57	125.15	124.55	125.03	4614093.0
2016-09-22 10:00:00	IWM	ETF	125.04	125.23	124.8	125.0	3656203.0
2016-09-22 11:00:00	IWM	ETF	125.0	125.16	124.865	125.09	1608836.0
2016-09-22 12:00:00	IWM	ETF	125.09	125.31	125.0	125.3088	1488173.0
2016-09-22 13:00:00	IWM	ETF	125.3	125.65	125.26	125.53	2215609.0
2016-09-22 14:00:00	IWM	ETF	125.52	125.64	125.06	125.57	2988680.0
2016-09-22 15:00:00	IWM	ETF	125.58	125.8	125.5	125.73	5698644.0
2016-09-22 16:00:00	IWM	ETF	125.7	125.76	125.65	125.66	3006105.0
2016-09-22 17:00:00	IWM	ETF	125.67	125.76	125.64	125.75	5294.0
2016-09-22 18:00:00	IWM	ETF	125.67	125.69	125.67	125.69	1000.0
2016-09-22 07:00:00	DIA	ETF	183.21	183.29	183.21	183.29	600.0
2016-09-22 08:00:00	DIA	ETF	183.24	183.6	183.24	183.6	10914.0
2016-09-22 09:00:00	DIA	ETF	183.67	184.21	183.65	184.11	634965.0

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

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