PREVIEW / etf_1hour / 2015-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-07.parquet
  size:    247 KB
  rows:    7,932

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-10-07 04:00:00	SPY	ETF	198.82	199.29	198.79	199.05	73353.0
2015-10-07 05:00:00	SPY	ETF	199.03	199.05	198.47	198.55	23299.0
2015-10-07 06:00:00	SPY	ETF	198.57	198.74	198.3	198.5	66446.0
2015-10-07 07:00:00	SPY	ETF	198.48	199.01	198.48	198.82	460416.0
2015-10-07 08:00:00	SPY	ETF	198.79	198.97	198.61	198.73	954495.0
2015-10-07 09:00:00	SPY	ETF	198.74	199.59	198.74	199.43	12397252.0
2015-10-07 10:00:00	SPY	ETF	199.445	199.825	198.38	198.82	21528483.0
2015-10-07 11:00:00	SPY	ETF	198.82	199.07	197.48	198.42	23456289.0
2015-10-07 12:00:00	SPY	ETF	198.41	199.0	197.7	198.11	11307898.0
2015-10-07 13:00:00	SPY	ETF	198.11	199.26	197.99	199.1	10942489.0
2015-10-07 14:00:00	SPY	ETF	199.1	199.48	198.44	198.53	15067941.0
2015-10-07 15:00:00	SPY	ETF	198.54	199.47	198.47	199.45	20124124.0
2015-10-07 16:00:00	SPY	ETF	199.45	199.6	198.28	199.56	6059830.0
2015-10-07 17:00:00	SPY	ETF	199.56	199.61	199.41	199.48	498511.0
2015-10-07 18:00:00	SPY	ETF	199.47	199.62	199.44	199.5	112876.0
2015-10-07 19:00:00	SPY	ETF	199.51	199.55	199.37	199.38	88348.0
2015-10-07 04:00:00	QQQ	ETF	105.6	105.86	105.52	105.68	3771.0
2015-10-07 05:00:00	QQQ	ETF	105.7	105.7	105.62	105.68	2300.0
2015-10-07 06:00:00	QQQ	ETF	105.55	105.56	105.43	105.49	3010.0
2015-10-07 07:00:00	QQQ	ETF	105.48	105.77	105.48	105.68	34695.0
2015-10-07 08:00:00	QQQ	ETF	105.66	105.77	105.6	105.64	139948.0
2015-10-07 09:00:00	QQQ	ETF	105.65	105.83	105.25	105.72	4601567.0
2015-10-07 10:00:00	QQQ	ETF	105.73	105.86	104.74	104.99	6031464.0
2015-10-07 11:00:00	QQQ	ETF	104.99	105.04	104.29	104.99	6548425.0
2015-10-07 12:00:00	QQQ	ETF	104.98	105.02	104.5	104.68	3707880.0
2015-10-07 13:00:00	QQQ	ETF	104.69	105.47	104.62	105.34	3655626.0
2015-10-07 14:00:00	QQQ	ETF	105.35	105.5652	104.98	105.06	4769542.0
2015-10-07 15:00:00	QQQ	ETF	105.0669	105.64	105.0301	105.595	4100308.0
2015-10-07 16:00:00	QQQ	ETF	105.64	105.76	105.595	105.71	581712.0
2015-10-07 17:00:00	QQQ	ETF	105.7	105.7	105.65	105.65	10322.0
2015-10-07 18:00:00	QQQ	ETF	105.66	105.74	105.65	105.74	22550.0
2015-10-07 19:00:00	QQQ	ETF	105.7	105.72	105.63	105.63	70800.0
2015-10-07 04:00:00	IWM	ETF	112.86	113.21	112.86	113.21	400.0
2015-10-07 05:00:00	IWM	ETF	113.03	113.04	113.03	113.04	300.0
2015-10-07 06:00:00	IWM	ETF	113.01	113.01	113.01	113.01	100.0
2015-10-07 07:00:00	IWM	ETF	112.97	113.13	112.97	113.13	3999.0
2015-10-07 08:00:00	IWM	ETF	113.11	113.21	112.98	113.1	81180.0
2015-10-07 09:00:00	IWM	ETF	113.15	113.6731	113.06	113.59	4531509.0
2015-10-07 10:00:00	IWM	ETF	113.59	113.9	113.01	113.345	5926320.0
2015-10-07 11:00:00	IWM	ETF	113.34	113.54	112.63	113.49	4907916.0
2015-10-07 12:00:00	IWM	ETF	113.48	113.5299	113.01	113.3	2962791.0
2015-10-07 13:00:00	IWM	ETF	113.31	114.4	113.26	114.27	5556912.0
2015-10-07 14:00:00	IWM	ETF	114.28	114.5	113.75	113.84	3917628.0
2015-10-07 15:00:00	IWM	ETF	113.84	114.48	113.8	114.47	5986867.0
2015-10-07 16:00:00	IWM	ETF	114.47	114.67	113.0746	114.65	1048840.0
2015-10-07 17:00:00	IWM	ETF	114.69	114.69	114.54	114.55	7529.0
2015-10-07 18:00:00	IWM	ETF	114.64	114.64	114.54	114.55	1478.0
2015-10-07 04:00:00	DIA	ETF	168.79	168.79	168.79	168.79	396.0
2015-10-07 07:00:00	DIA	ETF	168.68	168.68	168.54	168.58	3600.0
2015-10-07 08:00:00	DIA	ETF	168.51	168.65	168.49	168.49	12100.0

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

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