PREVIEW / etf_1hour / 2015-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-11.parquet
  size:    235 KB
  rows:    7,550

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-06-11 04:00:00	SPY	ETF	211.19	211.27	211.04	211.11	26395.0
2015-06-11 05:00:00	SPY	ETF	211.2	211.26	211.14	211.14	9201.0
2015-06-11 06:00:00	SPY	ETF	211.19	211.24	211.09	211.24	11100.0
2015-06-11 07:00:00	SPY	ETF	211.21	211.53	211.13	211.48	192663.0
2015-06-11 08:00:00	SPY	ETF	211.48	211.59	211.19	211.48	707689.0
2015-06-11 09:00:00	SPY	ETF	211.48	211.975	211.38	211.93	10289074.0
2015-06-11 10:00:00	SPY	ETF	211.93	212.09	211.2	211.305	15032709.0
2015-06-11 11:00:00	SPY	ETF	211.3046	211.72	211.22	211.55	7338425.0
2015-06-11 12:00:00	SPY	ETF	211.56	211.7	211.38	211.62	5699172.0
2015-06-11 13:00:00	SPY	ETF	211.621	211.87	211.49	211.755	4402195.0
2015-06-11 14:00:00	SPY	ETF	211.765	211.82	211.56	211.64	6250647.0
2015-06-11 15:00:00	SPY	ETF	211.6384	211.76	211.29	211.6	16443260.0
2015-06-11 16:00:00	SPY	ETF	211.59	211.74	211.4614	211.59	6446330.0
2015-06-11 17:00:00	SPY	ETF	211.6	211.65	211.55	211.55	66792.0
2015-06-11 18:00:00	SPY	ETF	211.55	211.55	211.36	211.44	55794.0
2015-06-11 19:00:00	SPY	ETF	211.44	211.45	211.37	211.39	38476.0
2015-06-11 06:00:00	QQQ	ETF	109.59	109.6	109.55	109.58	3400.0
2015-06-11 07:00:00	QQQ	ETF	109.6	109.76	109.58	109.75	75803.0
2015-06-11 08:00:00	QQQ	ETF	109.75	109.86	109.75	109.75	95537.0
2015-06-11 09:00:00	QQQ	ETF	109.79	110.15	109.75	110.1	2745690.0
2015-06-11 10:00:00	QQQ	ETF	110.1	110.15	109.54	109.65	3485125.0
2015-06-11 11:00:00	QQQ	ETF	109.645	109.87	109.59	109.67	2042241.0
2015-06-11 12:00:00	QQQ	ETF	109.67	109.755	109.46	109.67	1164518.0
2015-06-11 13:00:00	QQQ	ETF	109.65	109.83	109.57	109.75	1738497.0
2015-06-11 14:00:00	QQQ	ETF	109.7499	109.79	109.63	109.66	769363.0
2015-06-11 15:00:00	QQQ	ETF	109.665	109.74	109.52	109.64	2771770.0
2015-06-11 16:00:00	QQQ	ETF	109.65	109.71	109.58	109.68	1143099.0
2015-06-11 17:00:00	QQQ	ETF	109.66	109.69	109.64	109.65	3534.0
2015-06-11 18:00:00	QQQ	ETF	109.64	109.65	109.5	109.55	39322.0
2015-06-11 19:00:00	QQQ	ETF	109.55	109.55	109.54	109.55	10800.0
2015-06-11 07:00:00	IWM	ETF	126.26	126.26	126.03	126.25	39200.0
2015-06-11 08:00:00	IWM	ETF	126.28	126.32	126.14	126.2	93171.0
2015-06-11 09:00:00	IWM	ETF	126.23	126.45	125.97	126.42	2958211.0
2015-06-11 10:00:00	IWM	ETF	126.42	126.54	125.91	126.0	3631234.0
2015-06-11 11:00:00	IWM	ETF	125.99	126.21	125.93	126.145	1443621.0
2015-06-11 12:00:00	IWM	ETF	126.14	126.18	125.97	126.09	885059.0
2015-06-11 13:00:00	IWM	ETF	126.09	126.33	126.03	126.25	1153048.0
2015-06-11 14:00:00	IWM	ETF	126.25	126.3	126.05	126.09	1107797.0
2015-06-11 15:00:00	IWM	ETF	126.09	126.32	126.03	126.32	3119846.0
2015-06-11 16:00:00	IWM	ETF	126.32	126.44	126.12	126.25	2437274.0
2015-06-11 17:00:00	IWM	ETF	126.24	126.32	126.24	126.32	2200.0
2015-06-11 18:00:00	IWM	ETF	126.34	126.34	126.34	126.34	100.0
2015-06-11 07:00:00	DIA	ETF	180.35	180.45	180.35	180.45	4200.0
2015-06-11 08:00:00	DIA	ETF	180.44	180.44	180.44	180.44	100.0
2015-06-11 09:00:00	DIA	ETF	180.63	181.11	180.51	181.05	696257.0
2015-06-11 10:00:00	DIA	ETF	181.05	181.26	180.47	180.5	825627.0
2015-06-11 11:00:00	DIA	ETF	180.48	180.9	180.4	180.66	345715.0
2015-06-11 12:00:00	DIA	ETF	180.68	180.84	180.565	180.76	236829.0
2015-06-11 13:00:00	DIA	ETF	180.76	180.92	180.62	180.85	181730.0
2015-06-11 14:00:00	DIA	ETF	180.86	180.89	180.68	180.73	170651.0

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

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