PREVIEW / etf_1hour / 2016-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-07-15.parquet
  size:    254 KB
  rows:    8,080

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-07-15 04:00:00	SPY	ETF	215.94	216.07	215.69	215.8	17823.0
2016-07-15 05:00:00	SPY	ETF	215.86	215.99	215.56	215.89	50100.0
2016-07-15 06:00:00	SPY	ETF	215.89	216.09	215.75	215.77	46611.0
2016-07-15 07:00:00	SPY	ETF	215.79	216.32	215.79	216.3	204656.0
2016-07-15 08:00:00	SPY	ETF	216.04	216.57	215.9	216.46	766324.0
2016-07-15 09:00:00	SPY	ETF	216.5	216.85	216.21	216.29	12121234.0
2016-07-15 10:00:00	SPY	ETF	216.29	217.0125	216.07	216.2838	16962119.0
2016-07-15 11:00:00	SPY	ETF	216.285	216.33	215.53	215.63	10769455.0
2016-07-15 12:00:00	SPY	ETF	215.63	215.76	215.308	215.42	7950954.0
2016-07-15 13:00:00	SPY	ETF	215.42	215.82	215.42	215.705	8602217.0
2016-07-15 14:00:00	SPY	ETF	215.705	215.87	215.54	215.8	8744861.0
2016-07-15 15:00:00	SPY	ETF	215.79	216.09	215.71	215.81	23097108.0
2016-07-15 16:00:00	SPY	ETF	215.82	215.93	214.73	214.98	10331414.0
2016-07-15 17:00:00	SPY	ETF	214.99	215.84	214.95	215.06	2418597.0
2016-07-15 18:00:00	SPY	ETF	215.06	215.83	214.69	214.69	896437.0
2016-07-15 19:00:00	SPY	ETF	214.75	214.75	214.0	214.55	454668.0
2016-07-15 04:00:00	QQQ	ETF	111.92	111.99	111.84	111.84	2300.0
2016-07-15 05:00:00	QQQ	ETF	111.88	111.89	111.87	111.87	1300.0
2016-07-15 06:00:00	QQQ	ETF	111.94	111.98	111.94	111.98	1200.0
2016-07-15 07:00:00	QQQ	ETF	111.87	112.02	111.86	112.02	12600.0
2016-07-15 08:00:00	QQQ	ETF	111.97	112.13	111.95	112.06	51800.0
2016-07-15 09:00:00	QQQ	ETF	112.0	112.3	111.96	112.06	2809980.0
2016-07-15 10:00:00	QQQ	ETF	112.05	112.1	111.83	111.985	2368362.0
2016-07-15 11:00:00	QQQ	ETF	112.0	112.03	111.635	111.7	2336849.0
2016-07-15 12:00:00	QQQ	ETF	111.71	111.75	111.55	111.61	1237573.0
2016-07-15 13:00:00	QQQ	ETF	111.61	111.8	111.61	111.72	926814.0
2016-07-15 14:00:00	QQQ	ETF	111.72	111.8	111.641	111.735	856529.0
2016-07-15 15:00:00	QQQ	ETF	111.74	111.91	111.695	111.79	2713932.0
2016-07-15 16:00:00	QQQ	ETF	111.77	111.84	111.19	111.28	1043631.0
2016-07-15 17:00:00	QQQ	ETF	111.28	111.44	111.28	111.4	102772.0
2016-07-15 18:00:00	QQQ	ETF	111.4	111.4	111.0	111.31	490045.0
2016-07-15 19:00:00	QQQ	ETF	111.22	111.26	110.93	111.09	46561.0
2016-07-15 04:00:00	IWM	ETF	119.28	119.28	119.28	119.28	200.0
2016-07-15 05:00:00	IWM	ETF	119.16	119.16	119.16	119.16	100.0
2016-07-15 06:00:00	IWM	ETF	119.27	119.5	119.27	119.39	2000.0
2016-07-15 07:00:00	IWM	ETF	119.29	119.6	119.29	119.59	114980.0
2016-07-15 08:00:00	IWM	ETF	119.4756	119.83	119.4756	119.77	444307.0
2016-07-15 09:00:00	IWM	ETF	119.69	120.04	119.3	119.48	3556754.0
2016-07-15 10:00:00	IWM	ETF	119.48	119.96	119.37	119.85	3301124.0
2016-07-15 11:00:00	IWM	ETF	119.855	119.9	119.43	119.56	2022559.0
2016-07-15 12:00:00	IWM	ETF	119.56	119.69	119.28	119.35	1319909.0
2016-07-15 13:00:00	IWM	ETF	119.36	119.62	119.35	119.6	1072358.0
2016-07-15 14:00:00	IWM	ETF	119.6	119.66	119.48	119.56	1423564.0
2016-07-15 15:00:00	IWM	ETF	119.56	119.86	119.54	119.7	4151652.0
2016-07-15 16:00:00	IWM	ETF	119.71	119.75	119.05	119.15	957641.0
2016-07-15 17:00:00	IWM	ETF	119.18	119.4	119.18	119.3	211024.0
2016-07-15 18:00:00	IWM	ETF	119.25	119.25	119.0	119.04	20826.0
2016-07-15 19:00:00	IWM	ETF	119.14	119.14	118.91	119.14	6413.0
2016-07-15 07:00:00	DIA	ETF	184.94	184.94	184.94	184.94	1000.0
2016-07-15 08:00:00	DIA	ETF	184.94	184.95	184.94	184.95	760.0

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

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