PREVIEW / etf_1hour / 2015-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-23.parquet
  size:    240 KB
  rows:    7,721

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-23 04:00:00	SPY	ETF	212.14	212.18	212.06	212.06	5400.0
2015-06-23 05:00:00	SPY	ETF	212.07	212.1	211.95	212.02	24550.0
2015-06-23 06:00:00	SPY	ETF	212.03	212.19	211.91	212.08	80118.0
2015-06-23 07:00:00	SPY	ETF	212.07	212.28	211.95	212.24	232223.0
2015-06-23 08:00:00	SPY	ETF	212.24	212.35	211.84	211.93	516857.0
2015-06-23 09:00:00	SPY	ETF	211.92	212.31	211.87	212.255	6928743.0
2015-06-23 10:00:00	SPY	ETF	212.255	212.44	211.7	211.86	12391344.0
2015-06-23 11:00:00	SPY	ETF	211.85	212.02	211.71	211.84	9386190.0
2015-06-23 12:00:00	SPY	ETF	211.8488	211.86	211.57	211.68	6828374.0
2015-06-23 13:00:00	SPY	ETF	211.68	211.94	211.59	211.89	4869339.0
2015-06-23 14:00:00	SPY	ETF	211.89	212.15	211.83	212.07	5828837.0
2015-06-23 15:00:00	SPY	ETF	212.06	212.17	211.93	212.03	11768809.0
2015-06-23 16:00:00	SPY	ETF	212.03	212.24	211.95	212.12	6673638.0
2015-06-23 17:00:00	SPY	ETF	212.13	212.2	211.97	212.16	101835.0
2015-06-23 18:00:00	SPY	ETF	212.13	212.23	212.13	212.16	125226.0
2015-06-23 19:00:00	SPY	ETF	212.16	212.19	212.07	212.19	102015.0
2015-06-23 04:00:00	QQQ	ETF	110.81	110.81	110.8	110.8	741.0
2015-06-23 06:00:00	QQQ	ETF	110.8	110.85	110.8	110.8	600.0
2015-06-23 07:00:00	QQQ	ETF	110.8	110.89	110.76	110.88	54797.0
2015-06-23 08:00:00	QQQ	ETF	110.87	110.95	110.7	110.72	65576.0
2015-06-23 09:00:00	QQQ	ETF	110.73	110.89	110.61	110.649	2251821.0
2015-06-23 10:00:00	QQQ	ETF	110.638	110.79	110.33	110.4986	3319080.0
2015-06-23 11:00:00	QQQ	ETF	110.49	110.67	110.45	110.61	1564890.0
2015-06-23 12:00:00	QQQ	ETF	110.6	110.62	110.44	110.5	1099598.0
2015-06-23 13:00:00	QQQ	ETF	110.495	110.68	110.44	110.635	1312034.0
2015-06-23 14:00:00	QQQ	ETF	110.63	110.79	110.6	110.76	1283211.0
2015-06-23 15:00:00	QQQ	ETF	110.76	110.86	110.69	110.79	2395408.0
2015-06-23 16:00:00	QQQ	ETF	110.78	110.88	110.71	110.85	695682.0
2015-06-23 17:00:00	QQQ	ETF	110.83	110.85	110.83	110.85	800.0
2015-06-23 18:00:00	QQQ	ETF	110.82	110.82	110.82	110.82	2450.0
2015-06-23 19:00:00	QQQ	ETF	110.82	110.82	110.803	110.82	14305.0
2015-06-23 07:00:00	IWM	ETF	128.85	128.85	128.82	128.85	40900.0
2015-06-23 08:00:00	IWM	ETF	128.85	128.92	128.6	128.6	131258.0
2015-06-23 09:00:00	IWM	ETF	128.62	128.91	128.53	128.69	1831474.0
2015-06-23 10:00:00	IWM	ETF	128.69	128.867	128.395	128.57	3701299.0
2015-06-23 11:00:00	IWM	ETF	128.56	128.67	128.5268	128.58	1686249.0
2015-06-23 12:00:00	IWM	ETF	128.575	128.72	128.43	128.71	2327697.0
2015-06-23 13:00:00	IWM	ETF	128.71	128.96	128.615	128.87	2546907.0
2015-06-23 14:00:00	IWM	ETF	128.86	129.01	128.845	128.935	1908887.0
2015-06-23 15:00:00	IWM	ETF	128.93	129.09	128.85	128.99	3572915.0
2015-06-23 16:00:00	IWM	ETF	128.99	129.12	128.809	129.04	673879.0
2015-06-23 17:00:00	IWM	ETF	129.05	129.13	129.05	129.13	999.0
2015-06-23 18:00:00	IWM	ETF	129.08	129.08	129.08	129.08	400.0
2015-06-23 07:00:00	DIA	ETF	180.96	181.16	180.96	181.12	660.0
2015-06-23 08:00:00	DIA	ETF	181.227	181.227	180.83	180.83	8800.0
2015-06-23 09:00:00	DIA	ETF	180.95	181.44	180.88	181.39	362282.0
2015-06-23 10:00:00	DIA	ETF	181.3801	181.57	180.97	181.07	616828.0
2015-06-23 11:00:00	DIA	ETF	181.05	181.18	180.87	180.96	500778.0
2015-06-23 12:00:00	DIA	ETF	180.95	180.96	180.75	180.86	207509.0
2015-06-23 13:00:00	DIA	ETF	180.87	181.05	180.8	181.05	121746.0

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

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