PREVIEW / etf_1hour / 2015-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-16.parquet
  size:    240 KB
  rows:    7,599

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-16 04:00:00	SPY	ETF	208.0	208.41	207.48	208.29	25368.0
2015-06-16 05:00:00	SPY	ETF	208.2	208.2	207.92	207.96	12721.0
2015-06-16 06:00:00	SPY	ETF	207.99	208.11	207.87	208.07	42715.0
2015-06-16 07:00:00	SPY	ETF	208.15	208.77	208.13	208.49	360418.0
2015-06-16 08:00:00	SPY	ETF	208.2	208.89	208.18	208.71	930421.0
2015-06-16 09:00:00	SPY	ETF	208.71	209.72	208.55	209.415	14554048.0
2015-06-16 10:00:00	SPY	ETF	209.41	209.56	208.87	209.26	15865481.0
2015-06-16 11:00:00	SPY	ETF	209.26	209.87	209.2	209.67	10508251.0
2015-06-16 12:00:00	SPY	ETF	209.67	210.03	209.59	209.99	6556488.0
2015-06-16 13:00:00	SPY	ETF	209.99	210.23	209.92	210.1101	6360953.0
2015-06-16 14:00:00	SPY	ETF	210.12	210.35	210.12	210.269	7673396.0
2015-06-16 15:00:00	SPY	ETF	210.265	210.34	210.12	210.26	15089438.0
2015-06-16 16:00:00	SPY	ETF	210.27	210.45	210.175	210.4	6747939.0
2015-06-16 17:00:00	SPY	ETF	210.43	210.43	210.38	210.43	75967.0
2015-06-16 18:00:00	SPY	ETF	210.43	210.5	210.4	210.45	54876.0
2015-06-16 19:00:00	SPY	ETF	210.44	210.45	210.4	210.43	90770.0
2015-06-16 04:00:00	QQQ	ETF	107.63	107.77	107.63	107.71	12450.0
2015-06-16 05:00:00	QQQ	ETF	107.66	107.66	107.66	107.66	300.0
2015-06-16 06:00:00	QQQ	ETF	107.58	107.7	107.58	107.63	35349.0
2015-06-16 07:00:00	QQQ	ETF	107.75	108.04	107.71	107.98	28550.0
2015-06-16 08:00:00	QQQ	ETF	107.92	108.03	107.73	108.03	101732.0
2015-06-16 09:00:00	QQQ	ETF	108.02	108.59	107.95	108.38	2921082.0
2015-06-16 10:00:00	QQQ	ETF	108.36	108.52	108.05	108.27	2454926.0
2015-06-16 11:00:00	QQQ	ETF	108.265	108.6	108.26	108.4401	1601749.0
2015-06-16 12:00:00	QQQ	ETF	108.45	108.75	108.4	108.73	1379835.0
2015-06-16 13:00:00	QQQ	ETF	108.74	108.89	108.67	108.82	1637537.0
2015-06-16 14:00:00	QQQ	ETF	108.82	108.9799	108.815	108.92	1292634.0
2015-06-16 15:00:00	QQQ	ETF	108.93	108.95	108.73	108.78	2508201.0
2015-06-16 16:00:00	QQQ	ETF	108.8	108.88	108.77	108.86	417805.0
2015-06-16 17:00:00	QQQ	ETF	108.88	108.89	108.88	108.88	13560.0
2015-06-16 18:00:00	QQQ	ETF	108.87	108.89	108.85	108.89	16850.0
2015-06-16 19:00:00	QQQ	ETF	108.85	108.85	108.85	108.85	300.0
2015-06-16 04:00:00	IWM	ETF	124.8	124.8	124.63	124.63	464.0
2015-06-16 05:00:00	IWM	ETF	124.69	124.69	124.63	124.63	200.0
2015-06-16 06:00:00	IWM	ETF	124.57	124.8	124.57	124.72	2100.0
2015-06-16 07:00:00	IWM	ETF	125.09	125.3	124.95	125.08	26600.0
2015-06-16 08:00:00	IWM	ETF	125.09	125.19	124.96	125.18	47595.0
2015-06-16 09:00:00	IWM	ETF	125.09	125.95	125.09	125.75	2596051.0
2015-06-16 10:00:00	IWM	ETF	125.75	125.98	125.43	125.66	3149081.0
2015-06-16 11:00:00	IWM	ETF	125.66	126.23	125.63	126.1	3002524.0
2015-06-16 12:00:00	IWM	ETF	126.1	126.4	125.98	126.33	2223006.0
2015-06-16 13:00:00	IWM	ETF	126.33	126.44	126.22	126.42	2308080.0
2015-06-16 14:00:00	IWM	ETF	126.43	126.65	126.38	126.425	3128786.0
2015-06-16 15:00:00	IWM	ETF	126.425	126.49	126.275	126.4	4784981.0
2015-06-16 16:00:00	IWM	ETF	126.41	126.61	126.35	126.61	708588.0
2015-06-16 17:00:00	IWM	ETF	126.57	126.59	126.42	126.5	198079.0
2015-06-16 18:00:00	IWM	ETF	126.5	126.57	126.5	126.57	4350.0
2015-06-16 19:00:00	IWM	ETF	126.57	126.57	126.51	126.51	1300.0
2015-06-16 05:00:00	DIA	ETF	177.21	177.21	177.21	177.21	1000.0
2015-06-16 08:00:00	DIA	ETF	177.61	177.61	177.61	177.61	100.0

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

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