PREVIEW / etf_1hour / 2015-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-26.parquet
  size:    237 KB
  rows:    7,571

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-02-26 04:00:00	SPY	ETF	211.63	211.96	211.63	211.88	5398.0
2015-02-26 05:00:00	SPY	ETF	211.85	211.93	211.75	211.8	5929.0
2015-02-26 06:00:00	SPY	ETF	211.87	211.94	211.84	211.88	4600.0
2015-02-26 07:00:00	SPY	ETF	211.88	211.91	211.68	211.71	69159.0
2015-02-26 08:00:00	SPY	ETF	211.73	211.85	211.34	211.46	637504.0
2015-02-26 09:00:00	SPY	ETF	211.45	211.65	210.86	210.9	9405430.0
2015-02-26 10:00:00	SPY	ETF	210.9	211.48	210.88	211.43	8696207.0
2015-02-26 11:00:00	SPY	ETF	211.42	211.71	211.42	211.51	9509071.0
2015-02-26 12:00:00	SPY	ETF	211.5	211.65	211.12	211.564	5888858.0
2015-02-26 13:00:00	SPY	ETF	211.57	211.6	211.2	211.35	4408522.0
2015-02-26 14:00:00	SPY	ETF	211.36	211.47	210.84	210.97	8543323.0
2015-02-26 15:00:00	SPY	ETF	210.97	211.49	210.65	211.41	16573168.0
2015-02-26 16:00:00	SPY	ETF	211.39	211.635	211.3	211.48	5932337.0
2015-02-26 17:00:00	SPY	ETF	211.46	211.47	211.37	211.42	21118.0
2015-02-26 18:00:00	SPY	ETF	211.41	211.42	211.3	211.31	43685.0
2015-02-26 19:00:00	SPY	ETF	211.25	211.25	211.14	211.17	74330.0
2015-02-26 04:00:00	QQQ	ETF	108.43	108.43	108.4	108.4	459.0
2015-02-26 06:00:00	QQQ	ETF	108.49	108.52	108.49	108.52	300.0
2015-02-26 07:00:00	QQQ	ETF	108.49	108.49	108.42	108.46	10950.0
2015-02-26 08:00:00	QQQ	ETF	108.41	108.46	108.31	108.4	118095.0
2015-02-26 09:00:00	QQQ	ETF	108.39	108.59	108.135	108.18	3014867.0
2015-02-26 10:00:00	QQQ	ETF	108.18	108.66	108.16	108.6	2840155.0
2015-02-26 11:00:00	QQQ	ETF	108.6	108.819	108.595	108.75	2286243.0
2015-02-26 12:00:00	QQQ	ETF	108.75	108.87	108.46	108.81	1673033.0
2015-02-26 13:00:00	QQQ	ETF	108.81	108.85	108.655	108.74	1310590.0
2015-02-26 14:00:00	QQQ	ETF	108.74	108.8	108.36	108.58	1957421.0
2015-02-26 15:00:00	QQQ	ETF	108.58	108.94	108.38	108.87	4369499.0
2015-02-26 16:00:00	QQQ	ETF	108.88	108.94	108.66	108.9	2003159.0
2015-02-26 17:00:00	QQQ	ETF	108.87	108.87	108.87	108.87	200.0
2015-02-26 18:00:00	QQQ	ETF	108.89	108.89	108.82	108.82	12783.0
2015-02-26 19:00:00	QQQ	ETF	108.8	108.8	108.73	108.73	22300.0
2015-02-26 06:00:00	IWM	ETF	122.95	122.95	122.95	122.95	10000.0
2015-02-26 07:00:00	IWM	ETF	122.73	122.81	122.73	122.74	5200.0
2015-02-26 08:00:00	IWM	ETF	122.75	122.83	122.53	122.59	44824.0
2015-02-26 09:00:00	IWM	ETF	122.58	123.069	122.35	122.38	2258895.0
2015-02-26 10:00:00	IWM	ETF	122.38	123.08	122.33	122.98	2903926.0
2015-02-26 11:00:00	IWM	ETF	122.97	123.2	122.96	123.06	2382673.0
2015-02-26 12:00:00	IWM	ETF	123.06	123.27	122.82	123.18	1632907.0
2015-02-26 13:00:00	IWM	ETF	123.19	123.3	123.07	123.19	1263057.0
2015-02-26 14:00:00	IWM	ETF	123.19	123.26	122.83	122.93	1573022.0
2015-02-26 15:00:00	IWM	ETF	122.93	123.26	122.66	123.21	4159200.0
2015-02-26 16:00:00	IWM	ETF	123.21	123.25	123.14	123.2	1063040.0
2015-02-26 18:00:00	IWM	ETF	123.15	123.15	123.15	123.15	1850.0
2015-02-26 06:00:00	DIA	ETF	182.19	182.19	182.19	182.19	200.0
2015-02-26 07:00:00	DIA	ETF	182.2	182.2	182.04	182.04	3400.0
2015-02-26 08:00:00	DIA	ETF	182.11	182.11	181.77	181.82	9150.0
2015-02-26 09:00:00	DIA	ETF	181.78	182.005	181.62	181.66	473879.0
2015-02-26 10:00:00	DIA	ETF	181.67	182.04	181.62	182.02	373125.0
2015-02-26 11:00:00	DIA	ETF	182.02	182.24	181.95	181.96	334305.0
2015-02-26 12:00:00	DIA	ETF	181.95	182.13	181.76	182.0299	203657.0

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

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