PREVIEW / etf_1hour / 2015-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-06.parquet
  size:    245 KB
  rows:    7,743

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-06 04:00:00	SPY	ETF	210.4	210.51	210.4	210.45	1300.0
2015-03-06 05:00:00	SPY	ETF	210.42	210.42	210.42	210.42	200.0
2015-03-06 06:00:00	SPY	ETF	210.43	210.45	210.34	210.37	3163.0
2015-03-06 07:00:00	SPY	ETF	210.35	210.79	210.32	210.77	53178.0
2015-03-06 08:00:00	SPY	ETF	210.74	210.89	209.73	209.82	4631838.0
2015-03-06 09:00:00	SPY	ETF	209.82	209.99	209.15	209.8301	15330617.0
2015-03-06 10:00:00	SPY	ETF	209.85	209.94	209.26	209.365	16158843.0
2015-03-06 11:00:00	SPY	ETF	209.36	209.37	208.16	208.45	26419820.0
2015-03-06 12:00:00	SPY	ETF	208.45	208.62	207.84	208.09	18079337.0
2015-03-06 13:00:00	SPY	ETF	208.085	208.21	207.5801	207.94	16736665.0
2015-03-06 14:00:00	SPY	ETF	207.9401	208.225	207.3	207.4	19344000.0
2015-03-06 15:00:00	SPY	ETF	207.4	207.92	207.1	207.48	40462222.0
2015-03-06 16:00:00	SPY	ETF	207.47	210.4965	207.39	207.7	21587131.0
2015-03-06 17:00:00	SPY	ETF	207.71	207.8	207.5	207.7	5698986.0
2015-03-06 18:00:00	SPY	ETF	207.7	207.72	207.63	207.72	559230.0
2015-03-06 19:00:00	SPY	ETF	207.72	207.78	207.72	207.76	54767.0
2015-03-06 06:00:00	QQQ	ETF	108.6	108.65	108.6	108.63	700.0
2015-03-06 07:00:00	QQQ	ETF	108.68	108.81	108.68	108.81	14200.0
2015-03-06 08:00:00	QQQ	ETF	108.82	108.84	108.44	108.48	361108.0
2015-03-06 09:00:00	QQQ	ETF	108.53	108.71	108.22	108.56	3184626.0
2015-03-06 10:00:00	QQQ	ETF	108.58	108.71	108.37	108.45	2779720.0
2015-03-06 11:00:00	QQQ	ETF	108.45	108.45	107.6	107.77	5408608.0
2015-03-06 12:00:00	QQQ	ETF	107.77	107.94	107.47	107.6	3492239.0
2015-03-06 13:00:00	QQQ	ETF	107.61	107.68	107.39	107.545	2334872.0
2015-03-06 14:00:00	QQQ	ETF	107.54	107.72	107.27	107.2999	2811779.0
2015-03-06 15:00:00	QQQ	ETF	107.28	107.53	107.14	107.37	6879272.0
2015-03-06 16:00:00	QQQ	ETF	107.36	107.786	107.2838	107.58	978350.0
2015-03-06 17:00:00	QQQ	ETF	107.59	107.64	107.55	107.55	16163.0
2015-03-06 18:00:00	QQQ	ETF	107.57	107.58	107.52	107.52	7303.0
2015-03-06 19:00:00	QQQ	ETF	107.55	107.55	107.46	107.5	6012.0
2015-03-06 07:00:00	IWM	ETF	122.62	122.76	122.61	122.76	6000.0
2015-03-06 08:00:00	IWM	ETF	122.79	122.99	122.19	122.19	385442.0
2015-03-06 09:00:00	IWM	ETF	122.2	122.685	121.87	122.33	2841847.0
2015-03-06 10:00:00	IWM	ETF	122.34	122.45	122.0	122.02	2812643.0
2015-03-06 11:00:00	IWM	ETF	122.02	122.07	121.0687	121.29	6752002.0
2015-03-06 12:00:00	IWM	ETF	121.29	121.49	121.1	121.3	2578302.0
2015-03-06 13:00:00	IWM	ETF	121.305	121.45	121.1	121.29	1856697.0
2015-03-06 14:00:00	IWM	ETF	121.29	121.35	121.031	121.07	2396178.0
2015-03-06 15:00:00	IWM	ETF	121.06	121.32	120.88	121.13	6192345.0
2015-03-06 16:00:00	IWM	ETF	121.12	122.7732	121.12	121.35	1661576.0
2015-03-06 17:00:00	IWM	ETF	121.37	121.42	121.29	121.29	14242.0
2015-03-06 18:00:00	IWM	ETF	121.3	121.3	121.3	121.3	157.0
2015-03-06 19:00:00	IWM	ETF	121.3	121.3	121.28	121.28	797.0
2015-03-06 08:00:00	DIA	ETF	181.34	181.5	180.61	180.65	15072.0
2015-03-06 09:00:00	DIA	ETF	180.68	180.84	179.84	180.55	797159.0
2015-03-06 10:00:00	DIA	ETF	180.56	180.62	179.94	180.03	874492.0
2015-03-06 11:00:00	DIA	ETF	180.02	180.02	179.14	179.3201	1195805.0
2015-03-06 12:00:00	DIA	ETF	179.32	179.45	178.71	178.84	802619.0
2015-03-06 13:00:00	DIA	ETF	178.8453	178.9453	178.45	178.8	925013.0
2015-03-06 14:00:00	DIA	ETF	178.79	179.04	178.28	178.37	727600.0

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

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