PREVIEW / etf_1hour / 2015-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-19.parquet
  size:    237 KB
  rows:    7,506

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-19 04:00:00	SPY	ETF	212.05	212.19	211.7	211.94	39093.0
2015-06-19 05:00:00	SPY	ETF	211.92	212.16	211.88	212.01	10100.0
2015-06-19 06:00:00	SPY	ETF	212.06	212.1	211.95	212.09	15197.0
2015-06-19 07:00:00	SPY	ETF	212.1	212.17	211.95	212.08	383637.0
2015-06-19 08:00:00	SPY	ETF	212.09	212.1	211.75	211.78	908782.0
2015-06-19 09:00:00	SPY	ETF	211.77	211.77	211.09	211.35	23303923.0
2015-06-19 10:00:00	SPY	ETF	211.35	211.55	211.26	211.51	15834949.0
2015-06-19 11:00:00	SPY	ETF	211.51	211.52	211.07	211.13	11425775.0
2015-06-19 12:00:00	SPY	ETF	211.135	211.18	210.95	211.114	9091171.0
2015-06-19 13:00:00	SPY	ETF	211.12	211.31	210.99	211.21	7844624.0
2015-06-19 14:00:00	SPY	ETF	211.205	211.225	210.68	210.77	11295317.0
2015-06-19 15:00:00	SPY	ETF	210.765	211.01	210.44	210.45	25467608.0
2015-06-19 16:00:00	SPY	ETF	210.46	211.488	210.18	210.46	18514434.0
2015-06-19 17:00:00	SPY	ETF	210.49	210.81	210.18	210.35	593503.0
2015-06-19 18:00:00	SPY	ETF	210.35	210.81	210.31	210.55	140382.0
2015-06-19 19:00:00	SPY	ETF	210.56	210.6	210.39	210.57	66200.0
2015-06-19 04:00:00	QQQ	ETF	110.6	110.6	110.6	110.6	200.0
2015-06-19 07:00:00	QQQ	ETF	110.67	110.72	110.64	110.72	14960.0
2015-06-19 08:00:00	QQQ	ETF	110.66	110.72	110.58	110.6	61624.0
2015-06-19 09:00:00	QQQ	ETF	110.6	110.63	110.05	110.14	3397437.0
2015-06-19 10:00:00	QQQ	ETF	110.14	110.26	110.03	110.25	2331992.0
2015-06-19 11:00:00	QQQ	ETF	110.25	110.34	110.05	110.079	1808601.0
2015-06-19 12:00:00	QQQ	ETF	110.07	110.105	109.95	110.099	2583780.0
2015-06-19 13:00:00	QQQ	ETF	110.1	110.23	110.05	110.188	1433496.0
2015-06-19 14:00:00	QQQ	ETF	110.19	110.21	109.93	109.98	1788614.0
2015-06-19 15:00:00	QQQ	ETF	109.98	110.14	109.84	109.85	4097118.0
2015-06-19 16:00:00	QQQ	ETF	109.86	110.03	109.74	109.86	2339728.0
2015-06-19 17:00:00	QQQ	ETF	109.86	109.86	109.73	109.84	16014.0
2015-06-19 18:00:00	QQQ	ETF	109.88	109.9	109.79	109.79	203200.0
2015-06-19 19:00:00	QQQ	ETF	109.81	109.86	109.783	109.86	5768.0
2015-06-19 04:00:00	IWM	ETF	128.1	128.1	128.1	128.1	100.0
2015-06-19 07:00:00	IWM	ETF	128.23	128.24	128.14	128.14	50000.0
2015-06-19 08:00:00	IWM	ETF	128.13	128.15	127.86	127.86	24397.0
2015-06-19 09:00:00	IWM	ETF	127.84	127.99	127.6	127.74	2473530.0
2015-06-19 10:00:00	IWM	ETF	127.74	128.14	127.64	128.12	3015209.0
2015-06-19 11:00:00	IWM	ETF	128.13	128.14	127.88	127.92	1904664.0
2015-06-19 12:00:00	IWM	ETF	127.915	127.96	127.82	127.9	1665486.0
2015-06-19 13:00:00	IWM	ETF	127.91	128.16	127.87	128.11	2351906.0
2015-06-19 14:00:00	IWM	ETF	128.12	128.14	127.82	127.91	2170575.0
2015-06-19 15:00:00	IWM	ETF	127.915	128.13	127.79	127.81	4368829.0
2015-06-19 16:00:00	IWM	ETF	127.82	128.0476	127.58	127.7	3588232.0
2015-06-19 17:00:00	IWM	ETF	127.61	127.81	127.58	127.81	2112.0
2015-06-19 18:00:00	IWM	ETF	127.81	127.86	127.81	127.86	168900.0
2015-06-19 07:00:00	DIA	ETF	181.07	181.1	181.06	181.08	16500.0
2015-06-19 08:00:00	DIA	ETF	181.2	181.2	180.94	180.95	15997.0
2015-06-19 09:00:00	DIA	ETF	180.85	180.86	180.38	180.52	574816.0
2015-06-19 10:00:00	DIA	ETF	180.51	180.74	180.42	180.62	534266.0
2015-06-19 11:00:00	DIA	ETF	180.615	180.62	180.25	180.3201	503517.0
2015-06-19 12:00:00	DIA	ETF	180.33	180.38	180.19	180.26	327018.0
2015-06-19 13:00:00	DIA	ETF	180.27	180.44	180.2	180.31	239769.0

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

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