PREVIEW / etf_1hour / 2015-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-20.parquet
  size:    243 KB
  rows:    7,680

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-03-20 04:00:00	SPY	ETF	209.27	209.36	209.05	209.05	62147.0
2015-03-20 05:00:00	SPY	ETF	209.05	209.17	209.05	209.09	1570.0
2015-03-20 06:00:00	SPY	ETF	209.12	209.4	209.05	209.21	35575.0
2015-03-20 07:00:00	SPY	ETF	209.21	209.66	209.21	209.63	135014.0
2015-03-20 08:00:00	SPY	ETF	209.64	210.05	209.21	209.96	1514015.0
2015-03-20 09:00:00	SPY	ETF	209.95	210.12	209.59	209.82	21296893.0
2015-03-20 10:00:00	SPY	ETF	209.82	210.35	209.75	210.25	32158942.0
2015-03-20 11:00:00	SPY	ETF	210.26	210.61	210.24	210.47	13495982.0
2015-03-20 12:00:00	SPY	ETF	210.47	210.84	210.43	210.77	13763289.0
2015-03-20 13:00:00	SPY	ETF	210.775	211.02	210.72	210.865	12484996.0
2015-03-20 14:00:00	SPY	ETF	210.8606	210.98	210.66	210.95	14832080.0
2015-03-20 15:00:00	SPY	ETF	210.96	210.995	210.36	210.42	36660553.0
2015-03-20 16:00:00	SPY	ETF	210.42	210.5	208.5168	210.29	26259246.0
2015-03-20 17:00:00	SPY	ETF	210.3	210.47	210.22	210.46	1959610.0
2015-03-20 18:00:00	SPY	ETF	210.46	210.5	210.4	210.5	132138.0
2015-03-20 19:00:00	SPY	ETF	210.48	210.5	210.47	210.47	22033.0
2015-03-20 04:00:00	QQQ	ETF	108.0	108.2	108.0	108.16	1006.0
2015-03-20 06:00:00	QQQ	ETF	108.2	108.2	108.18	108.18	3100.0
2015-03-20 07:00:00	QQQ	ETF	108.29	108.59	108.27	108.59	16242.0
2015-03-20 08:00:00	QQQ	ETF	108.37	108.75	108.28	108.7	424647.0
2015-03-20 09:00:00	QQQ	ETF	108.71	108.82	108.53	108.65	4825128.0
2015-03-20 10:00:00	QQQ	ETF	108.66	108.83	108.51	108.65	3885975.0
2015-03-20 11:00:00	QQQ	ETF	108.66	108.94	108.655	108.82	2193336.0
2015-03-20 12:00:00	QQQ	ETF	108.81	108.96	108.7542	108.905	1445344.0
2015-03-20 13:00:00	QQQ	ETF	108.91	109.07	108.91	108.98	2166265.0
2015-03-20 14:00:00	QQQ	ETF	108.98	109.0166	108.82	108.96	1450737.0
2015-03-20 15:00:00	QQQ	ETF	108.97	109.0	108.58	108.58	6714242.0
2015-03-20 16:00:00	QQQ	ETF	108.59	108.6475	107.803	108.48	3950990.0
2015-03-20 17:00:00	QQQ	ETF	108.48	108.57	108.44	108.48	128496.0
2015-03-20 18:00:00	QQQ	ETF	108.55	108.58	108.53	108.53	16799.0
2015-03-20 19:00:00	QQQ	ETF	108.51	108.55	108.49	108.54	7810.0
2015-03-20 04:00:00	IWM	ETF	125.14	125.3	125.14	125.3	200.0
2015-03-20 07:00:00	IWM	ETF	125.68	125.72	125.23	125.72	21500.0
2015-03-20 08:00:00	IWM	ETF	125.68	125.83	125.6	125.72	131944.0
2015-03-20 09:00:00	IWM	ETF	125.71	125.74	125.28	125.56	4083511.0
2015-03-20 10:00:00	IWM	ETF	125.565	125.79	125.46	125.68	4577146.0
2015-03-20 11:00:00	IWM	ETF	125.69	125.95	125.55	125.94	2292696.0
2015-03-20 12:00:00	IWM	ETF	125.94	126.16	125.84	126.02	2133882.0
2015-03-20 13:00:00	IWM	ETF	126.02	126.08	125.9	125.98	1905519.0
2015-03-20 14:00:00	IWM	ETF	125.99	126.09	125.79	125.98	2199813.0
2015-03-20 15:00:00	IWM	ETF	125.98	126.15	125.72	126.0	5535983.0
2015-03-20 16:00:00	IWM	ETF	126.0	126.09	124.8935	126.0	3760616.0
2015-03-20 17:00:00	IWM	ETF	126.0	126.06	125.49	126.06	61244.0
2015-03-20 18:00:00	IWM	ETF	126.04	126.04	126.03	126.03	300.0
2015-03-20 19:00:00	IWM	ETF	126.0	126.0	126.0	126.0	100.0
2015-03-20 07:00:00	DIA	ETF	180.4	180.5	180.4	180.5	1100.0
2015-03-20 08:00:00	DIA	ETF	180.62	180.84	180.51	180.84	1870.0
2015-03-20 09:00:00	DIA	ETF	180.94	180.94	180.17	180.43	732635.0
2015-03-20 10:00:00	DIA	ETF	180.46	181.031	180.42	180.96	1085188.0
2015-03-20 11:00:00	DIA	ETF	180.96	181.25	180.95	181.16	677972.0

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

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