PREVIEW / etf_1hour / 2015-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-15.parquet
  size:    244 KB
  rows:    7,676

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-04-15 04:00:00	SPY	ETF	209.49	210.07	209.49	209.94	25006.0
2015-04-15 05:00:00	SPY	ETF	209.94	209.99	209.84	209.9	18077.0
2015-04-15 06:00:00	SPY	ETF	209.9	210.19	209.9	210.05	42079.0
2015-04-15 07:00:00	SPY	ETF	210.06	210.13	209.99	210.13	121236.0
2015-04-15 08:00:00	SPY	ETF	210.12	210.27	210.02	210.16	373210.0
2015-04-15 09:00:00	SPY	ETF	210.14	210.71	209.95	210.451	11228444.0
2015-04-15 10:00:00	SPY	ETF	210.45	210.65	210.26	210.63	10459964.0
2015-04-15 11:00:00	SPY	ETF	210.64	210.66	210.06	210.405	8993314.0
2015-04-15 12:00:00	SPY	ETF	210.41	210.54	210.225	210.51	5057143.0
2015-04-15 13:00:00	SPY	ETF	210.515	210.98	210.46	210.8	11113544.0
2015-04-15 14:00:00	SPY	ETF	210.8	211.04	210.73	210.91	14173154.0
2015-04-15 15:00:00	SPY	ETF	210.91	210.96	210.41	210.45	19388128.0
2015-04-15 16:00:00	SPY	ETF	210.47	210.95	210.44	210.57	11521892.0
2015-04-15 17:00:00	SPY	ETF	210.59	210.67	210.57	210.65	44619.0
2015-04-15 18:00:00	SPY	ETF	210.61	210.68	210.52	210.52	65748.0
2015-04-15 19:00:00	SPY	ETF	210.531	210.55	210.47	210.54	41522.0
2015-04-15 06:00:00	QQQ	ETF	107.54	107.58	107.54	107.58	27536.0
2015-04-15 07:00:00	QQQ	ETF	107.51	107.58	107.51	107.56	40612.0
2015-04-15 08:00:00	QQQ	ETF	107.56	107.62	107.5	107.57	67621.0
2015-04-15 09:00:00	QQQ	ETF	107.54	107.68	107.335	107.559	3438201.0
2015-04-15 10:00:00	QQQ	ETF	107.55	107.62	107.41	107.62	1912932.0
2015-04-15 11:00:00	QQQ	ETF	107.63	107.66	107.321	107.595	1772543.0
2015-04-15 12:00:00	QQQ	ETF	107.6	107.64	107.4701	107.63	817773.0
2015-04-15 13:00:00	QQQ	ETF	107.626	107.925	107.58	107.85	1462051.0
2015-04-15 14:00:00	QQQ	ETF	107.847	108.07	107.81	108.005	2259555.0
2015-04-15 15:00:00	QQQ	ETF	108.0	108.06	107.78	107.82	4836467.0
2015-04-15 16:00:00	QQQ	ETF	107.82	108.01	107.1392	107.97	763253.0
2015-04-15 17:00:00	QQQ	ETF	107.94	108.0	107.93	107.97	18465.0
2015-04-15 18:00:00	QQQ	ETF	107.96	107.96	107.93	107.93	6065.0
2015-04-15 19:00:00	QQQ	ETF	107.93	107.94	107.9	107.94	11730.0
2015-04-15 06:00:00	IWM	ETF	126.24	126.24	126.2	126.23	5000.0
2015-04-15 07:00:00	IWM	ETF	126.23	126.24	126.17	126.23	9200.0
2015-04-15 08:00:00	IWM	ETF	126.23	126.27	126.14	126.15	178370.0
2015-04-15 09:00:00	IWM	ETF	126.16	126.36	125.92	126.22	2279733.0
2015-04-15 10:00:00	IWM	ETF	126.22	126.45	126.1	126.411	2303712.0
2015-04-15 11:00:00	IWM	ETF	126.42	126.55	126.27	126.54	2272230.0
2015-04-15 12:00:00	IWM	ETF	126.54	126.8	126.5	126.78	2066201.0
2015-04-15 13:00:00	IWM	ETF	126.78	127.13	126.78	126.91	2664456.0
2015-04-15 14:00:00	IWM	ETF	126.91	127.075	126.85	126.901	2618345.0
2015-04-15 15:00:00	IWM	ETF	126.9	126.98	126.6	126.63	6569151.0
2015-04-15 16:00:00	IWM	ETF	126.64	126.73	125.6788	126.71	4329030.0
2015-04-15 18:00:00	IWM	ETF	126.64	126.76	126.64	126.76	450.0
2015-04-15 19:00:00	IWM	ETF	126.76	126.76	126.72	126.72	500.0
2015-04-15 07:00:00	DIA	ETF	180.64	180.7	180.64	180.65	300.0
2015-04-15 08:00:00	DIA	ETF	180.75	180.76	179.8681	180.75	22600.0
2015-04-15 09:00:00	DIA	ETF	180.79	181.25	180.68	181.04	908737.0
2015-04-15 10:00:00	DIA	ETF	181.04	181.19	180.89	181.13	638720.0
2015-04-15 11:00:00	DIA	ETF	181.14	181.15	180.45	180.73	447560.0
2015-04-15 12:00:00	DIA	ETF	180.74	180.89	180.595	180.88	209146.0
2015-04-15 13:00:00	DIA	ETF	180.88	181.22	180.83	181.08	393089.0

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

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