PREVIEW / etf_1hour / 2015-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-10.parquet
  size:    242 KB
  rows:    7,704

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
2015-08-10 04:00:00	SPY	ETF	208.21	208.6	208.21	208.6	5011.0
2015-08-10 05:00:00	SPY	ETF	208.55	208.64	208.43	208.52	28934.0
2015-08-10 06:00:00	SPY	ETF	208.44	208.73	208.42	208.62	13757.0
2015-08-10 07:00:00	SPY	ETF	208.58	209.02	208.58	208.85	294684.0
2015-08-10 08:00:00	SPY	ETF	208.84	209.54	208.6	209.35	1148800.0
2015-08-10 09:00:00	SPY	ETF	209.35	210.09	208.0123	209.865	14791328.0
2015-08-10 10:00:00	SPY	ETF	209.865	210.14	209.75	210.02	11444955.0
2015-08-10 11:00:00	SPY	ETF	210.02	210.33	210.02	210.185	9993053.0
2015-08-10 12:00:00	SPY	ETF	210.195	210.37	210.17	210.335	4970420.0
2015-08-10 13:00:00	SPY	ETF	210.335	210.475	210.29	210.455	4792659.0
2015-08-10 14:00:00	SPY	ETF	210.46	210.67	210.37	210.47	7444650.0
2015-08-10 15:00:00	SPY	ETF	210.465	210.59	210.3	210.58	16528603.0
2015-08-10 16:00:00	SPY	ETF	210.58	210.71	210.17	210.66	5734104.0
2015-08-10 17:00:00	SPY	ETF	210.67	210.73	210.57	210.69	247294.0
2015-08-10 18:00:00	SPY	ETF	210.68	210.8	210.57	210.62	529573.0
2015-08-10 19:00:00	SPY	ETF	210.65	210.68	210.6	210.68	41021.0
2015-08-10 07:00:00	QQQ	ETF	110.62	110.81	110.62	110.77	36500.0
2015-08-10 08:00:00	QQQ	ETF	110.76	111.09	110.76	111.01	161201.0
2015-08-10 09:00:00	QQQ	ETF	110.99	111.64	110.96	111.34	4411783.0
2015-08-10 10:00:00	QQQ	ETF	111.35	111.5	111.08	111.23	3682762.0
2015-08-10 11:00:00	QQQ	ETF	111.24	111.63	111.2343	111.5	2344929.0
2015-08-10 12:00:00	QQQ	ETF	111.5	111.58	111.41	111.4694	1480149.0
2015-08-10 13:00:00	QQQ	ETF	111.47	111.62	111.46	111.605	839765.0
2015-08-10 14:00:00	QQQ	ETF	111.6	111.81	111.53	111.5865	1941480.0
2015-08-10 15:00:00	QQQ	ETF	111.59	111.6558	111.41	111.56	3308310.0
2015-08-10 16:00:00	QQQ	ETF	111.55	111.75	111.45	111.74	1055237.0
2015-08-10 17:00:00	QQQ	ETF	111.73	111.83	111.72	111.83	54616.0
2015-08-10 18:00:00	QQQ	ETF	111.83	111.92	111.79	111.81	26540.0
2015-08-10 19:00:00	QQQ	ETF	111.82	111.87	111.8	111.87	6650.0
2015-08-10 04:00:00	IWM	ETF	119.99	119.99	119.99	119.99	200.0
2015-08-10 06:00:00	IWM	ETF	120.2	120.2	120.2	120.2	100.0
2015-08-10 07:00:00	IWM	ETF	120.28	120.35	120.25	120.29	804.0
2015-08-10 08:00:00	IWM	ETF	120.29	120.65	120.25	120.56	181021.0
2015-08-10 09:00:00	IWM	ETF	120.6	121.52	120.31	121.17	4251378.0
2015-08-10 10:00:00	IWM	ETF	121.18	121.37	120.68	120.98	4567895.0
2015-08-10 11:00:00	IWM	ETF	120.99	121.19	120.86	120.94	2798717.0
2015-08-10 12:00:00	IWM	ETF	120.94	121.2	120.92	121.16	1011375.0
2015-08-10 13:00:00	IWM	ETF	121.16	121.46	121.11	121.38	1267674.0
2015-08-10 14:00:00	IWM	ETF	121.38	121.48	121.18	121.22	1486016.0
2015-08-10 15:00:00	IWM	ETF	121.23	121.36	121.06	121.27	4716467.0
2015-08-10 16:00:00	IWM	ETF	121.28	121.3941	121.18	121.2	1503208.0
2015-08-10 17:00:00	IWM	ETF	121.29	121.36	121.29	121.36	2115.0
2015-08-10 18:00:00	IWM	ETF	121.29	121.29	121.28	121.28	240.0
2015-08-10 19:00:00	IWM	ETF	121.3	121.3	121.3	121.3	1080.0
2015-08-10 07:00:00	DIA	ETF	174.17	174.44	174.17	174.35	5155.0
2015-08-10 08:00:00	DIA	ETF	174.44	175.14	174.44	175.14	4994.0
2015-08-10 09:00:00	DIA	ETF	174.97	175.59	174.8	175.47	759009.0
2015-08-10 10:00:00	DIA	ETF	175.48	175.71	175.43	175.68	737437.0
2015-08-10 11:00:00	DIA	ETF	175.69	176.05	175.67	175.88	695773.0
2015-08-10 12:00:00	DIA	ETF	175.89	176.01	175.86	175.995	182253.0

> showing 50 of 7,704 rows — these rows as CSV

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