PREVIEW / etf_1hour / 2017-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-13.parquet
  size:    274 KB
  rows:    8,931

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
2017-04-13 04:00:00	SPY	ETF	233.9	233.9	233.54	233.78	17661.0
2017-04-13 05:00:00	SPY	ETF	233.76	233.76	233.49	233.49	12714.0
2017-04-13 06:00:00	SPY	ETF	233.45	233.59	233.28	233.4	109212.0
2017-04-13 07:00:00	SPY	ETF	233.43	233.65	233.34	233.54	381485.0
2017-04-13 08:00:00	SPY	ETF	233.58	233.76	233.35	233.52	500076.0
2017-04-13 09:00:00	SPY	ETF	233.52	234.29	233.42	234.12	8498714.0
2017-04-13 10:00:00	SPY	ETF	234.125	234.465	234.05	234.29	7525793.0
2017-04-13 11:00:00	SPY	ETF	234.29	234.49	234.15	234.285	6324587.0
2017-04-13 12:00:00	SPY	ETF	234.28	234.28	233.45	233.58	8292387.0
2017-04-13 13:00:00	SPY	ETF	233.58	234.03	233.02	233.11	11038020.0
2017-04-13 14:00:00	SPY	ETF	233.11	233.63	233.06	233.48	7525099.0
2017-04-13 15:00:00	SPY	ETF	233.48	233.56	232.54	232.54	22003611.0
2017-04-13 16:00:00	SPY	ETF	232.54	232.77	232.39	232.74	17348069.0
2017-04-13 17:00:00	SPY	ETF	232.71	232.73	232.36	232.42	1880913.0
2017-04-13 18:00:00	SPY	ETF	232.43	232.49	232.29	232.43	146620.0
2017-04-13 19:00:00	SPY	ETF	232.44	232.5486	232.39	232.42	1146462.0
2017-04-13 04:00:00	QQQ	ETF	130.71	130.71	130.69	130.69	500.0
2017-04-13 05:00:00	QQQ	ETF	130.66	130.66	130.63	130.63	212.0
2017-04-13 06:00:00	QQQ	ETF	130.5	130.52	130.49	130.52	2250.0
2017-04-13 07:00:00	QQQ	ETF	130.52	130.63	130.5	130.6	59827.0
2017-04-13 08:00:00	QQQ	ETF	130.6	130.72	130.59	130.68	50540.0
2017-04-13 09:00:00	QQQ	ETF	130.67	131.3	130.64	131.18	2860182.0
2017-04-13 10:00:00	QQQ	ETF	131.19	131.48	131.18	131.42	2257101.0
2017-04-13 11:00:00	QQQ	ETF	131.43	131.51	131.29	131.34	1070796.0
2017-04-13 12:00:00	QQQ	ETF	131.34	131.34	130.94	130.99	2448181.0
2017-04-13 13:00:00	QQQ	ETF	131.0	131.0	130.64	130.69	2382551.0
2017-04-13 14:00:00	QQQ	ETF	130.7	130.96	130.67	130.91	2144078.0
2017-04-13 15:00:00	QQQ	ETF	130.89	130.95	130.38	130.38	6368040.0
2017-04-13 16:00:00	QQQ	ETF	130.38	130.55	130.26	130.48	1456979.0
2017-04-13 17:00:00	QQQ	ETF	130.47	130.48	130.37	130.39	7961.0
2017-04-13 18:00:00	QQQ	ETF	130.4	130.4	130.34	130.4	1767.0
2017-04-13 19:00:00	QQQ	ETF	130.4	130.41	130.34	130.34	3628.0
2017-04-13 04:00:00	IWM	ETF	134.98	134.98	134.71	134.71	840.0
2017-04-13 05:00:00	IWM	ETF	134.68	134.68	134.48	134.66	7030.0
2017-04-13 06:00:00	IWM	ETF	134.54	134.78	134.52	134.62	21753.0
2017-04-13 07:00:00	IWM	ETF	134.62	134.82	134.51	134.82	99909.0
2017-04-13 08:00:00	IWM	ETF	134.84	134.99	134.7	134.75	49203.0
2017-04-13 09:00:00	IWM	ETF	134.8	135.2643	134.45	135.08	3209622.0
2017-04-13 10:00:00	IWM	ETF	135.09	135.37	134.81	135.15	3072235.0
2017-04-13 11:00:00	IWM	ETF	135.16	135.29	134.57	134.71	2363618.0
2017-04-13 12:00:00	IWM	ETF	134.7	134.7	134.06	134.3	3514064.0
2017-04-13 13:00:00	IWM	ETF	134.3	134.31	133.66	133.81	2993604.0
2017-04-13 14:00:00	IWM	ETF	133.81	134.44	133.81	134.35	2565109.0
2017-04-13 15:00:00	IWM	ETF	134.33	134.42	133.66	133.68	5889787.0
2017-04-13 16:00:00	IWM	ETF	133.68	134.0028	133.47	133.72	1688279.0
2017-04-13 17:00:00	IWM	ETF	133.72	133.79	133.68	133.68	2016.0
2017-04-13 18:00:00	IWM	ETF	133.57	133.67	133.57	133.6	1376.0
2017-04-13 19:00:00	IWM	ETF	133.61	133.65	133.61	133.65	3083.0
2017-04-13 04:00:00	DIA	ETF	205.55	205.55	205.4	205.4	1100.0
2017-04-13 05:00:00	DIA	ETF	205.39	205.39	205.3	205.3	450.0

> showing 50 of 8,931 rows — these rows as CSV

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