PREVIEW / etf_1hour / 2015-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-01.parquet
  size:    244 KB
  rows:    7,770

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-01 04:00:00	SPY	ETF	211.75	211.89	211.43	211.6	25385.0
2015-06-01 05:00:00	SPY	ETF	211.55	211.55	211.06	211.14	44632.0
2015-06-01 06:00:00	SPY	ETF	211.09	211.7	211.07	211.14	149863.0
2015-06-01 07:00:00	SPY	ETF	211.13	212.17	211.1	211.95	665852.0
2015-06-01 08:00:00	SPY	ETF	211.94	212.14	211.19	211.8	748329.0
2015-06-01 09:00:00	SPY	ETF	211.78	212.11	210.94	211.3	12857469.0
2015-06-01 10:00:00	SPY	ETF	211.3	211.73	210.62	211.31	19171355.0
2015-06-01 11:00:00	SPY	ETF	211.305	211.59	211.03	211.1499	8307704.0
2015-06-01 12:00:00	SPY	ETF	211.15	212.01	211.115	211.98	7768999.0
2015-06-01 13:00:00	SPY	ETF	211.99	212.09	211.83	212.035	7005910.0
2015-06-01 14:00:00	SPY	ETF	212.035	212.34	211.98	212.16	7656629.0
2015-06-01 15:00:00	SPY	ETF	212.16	212.26	211.46	211.57	21767776.0
2015-06-01 16:00:00	SPY	ETF	211.56	211.69	211.49	211.69	4859640.0
2015-06-01 17:00:00	SPY	ETF	211.65	211.71	211.63	211.68	160071.0
2015-06-01 18:00:00	SPY	ETF	211.68	211.75	211.6	211.64	81988.0
2015-06-01 19:00:00	SPY	ETF	211.66	211.7	211.65	211.69	19117.0
2015-06-01 04:00:00	QQQ	ETF	110.55	110.55	110.31	110.31	9320.0
2015-06-01 05:00:00	QQQ	ETF	110.19	110.19	110.0	110.0	20200.0
2015-06-01 06:00:00	QQQ	ETF	110.1	110.44	110.1	110.31	15500.0
2015-06-01 07:00:00	QQQ	ETF	110.14	110.76	110.14	110.69	112796.0
2015-06-01 08:00:00	QQQ	ETF	110.72	110.74	110.59	110.63	280435.0
2015-06-01 09:00:00	QQQ	ETF	110.05	110.72	109.78	109.9501	3528630.0
2015-06-01 10:00:00	QQQ	ETF	109.97	110.2	109.52	110.09	5704726.0
2015-06-01 11:00:00	QQQ	ETF	110.085	110.31	110.005	110.05	2246126.0
2015-06-01 12:00:00	QQQ	ETF	110.05	110.63	110.0359	110.6	2700718.0
2015-06-01 13:00:00	QQQ	ETF	110.62	110.68	110.49	110.6364	2022660.0
2015-06-01 14:00:00	QQQ	ETF	110.635	110.709	110.54	110.64	1574571.0
2015-06-01 15:00:00	QQQ	ETF	110.64	110.7	110.295	110.39	2968729.0
2015-06-01 16:00:00	QQQ	ETF	110.39	110.47	110.3	110.45	806142.0
2015-06-01 17:00:00	QQQ	ETF	110.46	110.48	110.4	110.48	1601.0
2015-06-01 18:00:00	QQQ	ETF	110.48	110.48	110.42	110.45	7708.0
2015-06-01 19:00:00	QQQ	ETF	110.45	110.49	110.45	110.47	21400.0
2015-06-01 04:00:00	IWM	ETF	124.48	124.48	124.29	124.29	700.0
2015-06-01 05:00:00	IWM	ETF	124.24	124.3	124.23	124.24	1700.0
2015-06-01 06:00:00	IWM	ETF	124.4	124.51	124.29	124.29	10500.0
2015-06-01 07:00:00	IWM	ETF	124.4	124.92	124.4	124.92	93091.0
2015-06-01 08:00:00	IWM	ETF	124.9	124.92	124.58	124.62	263847.0
2015-06-01 09:00:00	IWM	ETF	123.92	124.89	123.57	123.81	3869595.0
2015-06-01 10:00:00	IWM	ETF	123.83	124.02	123.03	123.91	6806223.0
2015-06-01 11:00:00	IWM	ETF	123.92	124.33	123.89	124.095	2516299.0
2015-06-01 12:00:00	IWM	ETF	124.11	124.81	124.1	124.78	3133756.0
2015-06-01 13:00:00	IWM	ETF	124.78	124.9	124.52	124.59	2271405.0
2015-06-01 14:00:00	IWM	ETF	124.59	124.85	124.56	124.62	1877732.0
2015-06-01 15:00:00	IWM	ETF	124.63	124.67	124.11	124.29	4253995.0
2015-06-01 16:00:00	IWM	ETF	124.29	124.5514	124.28	124.44	1526370.0
2015-06-01 17:00:00	IWM	ETF	124.4	124.4	124.4	124.4	57830.0
2015-06-01 19:00:00	IWM	ETF	124.39	124.39	124.39	124.39	100.0
2015-06-01 07:00:00	DIA	ETF	180.55	181.0	180.55	181.0	1000.0
2015-06-01 08:00:00	DIA	ETF	180.811	181.0	180.811	180.82	2050.0
2015-06-01 09:00:00	DIA	ETF	180.94	181.15	180.17	180.5	710389.0

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

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