PREVIEW / etf_1hour / 2015-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-24.parquet
  size:    241 KB
  rows:    7,725

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-24 04:00:00	SPY	ETF	212.0	212.0	211.8	211.86	7898.0
2015-06-24 05:00:00	SPY	ETF	211.8	212.0	211.3	211.3	58931.0
2015-06-24 06:00:00	SPY	ETF	211.37	211.72	211.36	211.69	84766.0
2015-06-24 07:00:00	SPY	ETF	211.69	211.79	211.6	211.65	121961.0
2015-06-24 08:00:00	SPY	ETF	211.65	211.97	211.39	211.6	802156.0
2015-06-24 09:00:00	SPY	ETF	211.59	211.92	211.51	211.75	5943310.0
2015-06-24 10:00:00	SPY	ETF	211.74	212.17	211.64	211.87	10769237.0
2015-06-24 11:00:00	SPY	ETF	211.87	211.88	211.36	211.43	10073686.0
2015-06-24 12:00:00	SPY	ETF	211.44	211.44	210.95	211.07	9385729.0
2015-06-24 13:00:00	SPY	ETF	211.07	211.19	210.61	210.8336	12340371.0
2015-06-24 14:00:00	SPY	ETF	210.84	211.3858	210.58	210.87	9455837.0
2015-06-24 15:00:00	SPY	ETF	210.88	210.97	210.48	210.49	19306126.0
2015-06-24 16:00:00	SPY	ETF	210.48	211.9506	210.36	210.51	11192090.0
2015-06-24 17:00:00	SPY	ETF	210.51	211.22	210.5	210.54	1619972.0
2015-06-24 18:00:00	SPY	ETF	210.55	210.67	210.55	210.62	90748.0
2015-06-24 19:00:00	SPY	ETF	210.63	210.65	210.6	210.65	28420.0
2015-06-24 04:00:00	QQQ	ETF	110.74	110.79	110.73	110.73	22320.0
2015-06-24 05:00:00	QQQ	ETF	110.56	110.56	110.46	110.46	2100.0
2015-06-24 06:00:00	QQQ	ETF	110.44	110.44	110.44	110.44	400.0
2015-06-24 07:00:00	QQQ	ETF	110.62	110.67	110.58	110.65	45500.0
2015-06-24 08:00:00	QQQ	ETF	110.61	110.62	110.5	110.55	85007.0
2015-06-24 09:00:00	QQQ	ETF	110.58	110.82	110.52	110.7997	1634499.0
2015-06-24 10:00:00	QQQ	ETF	110.79	111.13	110.76	111.0	2248084.0
2015-06-24 11:00:00	QQQ	ETF	111.0	111.0	110.7	110.75	1545426.0
2015-06-24 12:00:00	QQQ	ETF	110.74	110.74	110.47	110.55	1778161.0
2015-06-24 13:00:00	QQQ	ETF	110.55	110.64	110.24	110.3774	1703744.0
2015-06-24 14:00:00	QQQ	ETF	110.37	110.49	110.22	110.388	1579638.0
2015-06-24 15:00:00	QQQ	ETF	110.39	110.45	110.19	110.22	3193067.0
2015-06-24 16:00:00	QQQ	ETF	110.22	110.557	110.17	110.29	738307.0
2015-06-24 17:00:00	QQQ	ETF	110.28	110.3	110.26	110.26	39154.0
2015-06-24 18:00:00	QQQ	ETF	110.3	110.32	110.3	110.32	3150.0
2015-06-24 19:00:00	QQQ	ETF	110.3	110.33	110.3	110.33	7850.0
2015-06-24 05:00:00	IWM	ETF	128.84	128.84	128.65	128.65	300.0
2015-06-24 06:00:00	IWM	ETF	128.65	128.86	128.65	128.86	10400.0
2015-06-24 08:00:00	IWM	ETF	128.8	128.85	128.7	128.76	136292.0
2015-06-24 09:00:00	IWM	ETF	128.77	129.1	128.59	128.72	2463226.0
2015-06-24 10:00:00	IWM	ETF	128.72	128.755	128.51	128.565	2267486.0
2015-06-24 11:00:00	IWM	ETF	128.565	128.6	128.39	128.41	1734612.0
2015-06-24 12:00:00	IWM	ETF	128.41	128.48	128.17	128.19	2001346.0
2015-06-24 13:00:00	IWM	ETF	128.19	128.22	127.84	127.98	2195530.0
2015-06-24 14:00:00	IWM	ETF	127.98	128.02	127.765	127.9	2295284.0
2015-06-24 15:00:00	IWM	ETF	127.9	128.02	127.73	127.93	4538160.0
2015-06-24 16:00:00	IWM	ETF	127.92	128.04	127.86	128.02	621334.0
2015-06-24 17:00:00	IWM	ETF	128.05	128.08	127.827	128.05	3085000.0
2015-06-24 18:00:00	IWM	ETF	128.05	128.05	128.0	128.0	1600.0
2015-06-24 08:00:00	DIA	ETF	180.81	180.81	180.4	180.4	6850.0
2015-06-24 09:00:00	DIA	ETF	180.52	180.71	180.2899	180.48	345943.0
2015-06-24 10:00:00	DIA	ETF	180.48	180.97	180.43	180.8	471991.0
2015-06-24 11:00:00	DIA	ETF	180.84	180.84	180.33	180.4	547323.0
2015-06-24 12:00:00	DIA	ETF	180.41	180.41	179.855	179.9271	583298.0

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

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