PREVIEW / etf_1hour / 2017-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-27.parquet
  size:    287 KB
  rows:    9,373

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-09-27 04:00:00	SPY	ETF	249.52	249.54	249.37	249.37	28085.0
2017-09-27 05:00:00	SPY	ETF	249.37	249.47	249.24	249.3	14700.0
2017-09-27 06:00:00	SPY	ETF	249.24	249.47	249.24	249.45	41435.0
2017-09-27 07:00:00	SPY	ETF	249.45	249.6	249.42	249.6	85183.0
2017-09-27 08:00:00	SPY	ETF	249.08	249.65	249.08	249.63	247861.0
2017-09-27 09:00:00	SPY	ETF	249.63	250.05	249.6	249.755	7097860.0
2017-09-27 10:00:00	SPY	ETF	249.75	249.86	248.87	249.11	8696194.0
2017-09-27 11:00:00	SPY	ETF	249.1	249.4	249.03	249.3	6079831.0
2017-09-27 12:00:00	SPY	ETF	249.29	249.49	249.13	249.485	5077511.0
2017-09-27 13:00:00	SPY	ETF	249.48	249.775	249.44	249.736	3619881.0
2017-09-27 14:00:00	SPY	ETF	249.74	250.35	249.7399	250.2262	11222187.0
2017-09-27 15:00:00	SPY	ETF	250.22	250.49	249.965	250.02	18668542.0
2017-09-27 16:00:00	SPY	ETF	250.02	250.1012	249.6453	249.93	13735328.0
2017-09-27 17:00:00	SPY	ETF	249.94	250.05	249.4559	249.92	3521537.0
2017-09-27 18:00:00	SPY	ETF	249.92	249.92	249.75	249.82	211925.0
2017-09-27 19:00:00	SPY	ETF	249.82	249.88	249.81	249.86	19549.0
2017-09-27 04:00:00	QQQ	ETF	143.6	143.69	143.57	143.57	17700.0
2017-09-27 05:00:00	QQQ	ETF	143.59	143.62	143.48	143.48	12530.0
2017-09-27 06:00:00	QQQ	ETF	143.5	143.68	143.5	143.67	4696.0
2017-09-27 07:00:00	QQQ	ETF	143.61	143.7	143.51	143.67	60895.0
2017-09-27 08:00:00	QQQ	ETF	143.63	143.79	143.62	143.72	105721.0
2017-09-27 09:00:00	QQQ	ETF	143.72	144.38	143.67	144.105	4009785.0
2017-09-27 10:00:00	QQQ	ETF	144.1	144.25	143.57	143.75	6677568.0
2017-09-27 11:00:00	QQQ	ETF	143.75	144.07	143.63	143.86	2282078.0
2017-09-27 12:00:00	QQQ	ETF	143.86	144.025	143.71	144.0215	1043249.0
2017-09-27 13:00:00	QQQ	ETF	144.03	144.29	143.97	144.26	1769008.0
2017-09-27 14:00:00	QQQ	ETF	144.27	144.79	144.27	144.675	4302132.0
2017-09-27 15:00:00	QQQ	ETF	144.68	145.0	144.45	144.49	7224898.0
2017-09-27 16:00:00	QQQ	ETF	144.485	144.54	143.9221	144.4	1362426.0
2017-09-27 17:00:00	QQQ	ETF	144.48	144.54	144.45	144.45	5548.0
2017-09-27 18:00:00	QQQ	ETF	144.38	144.46	144.3	144.39	35888.0
2017-09-27 19:00:00	QQQ	ETF	144.37	144.43	144.36	144.39	17558.0
2017-09-27 04:00:00	IWM	ETF	145.01	145.06	144.93	144.93	1880.0
2017-09-27 05:00:00	IWM	ETF	144.91	144.98	144.9	144.93	3912.0
2017-09-27 06:00:00	IWM	ETF	145.0	145.17	145.0	145.17	16401.0
2017-09-27 07:00:00	IWM	ETF	145.16	145.23	145.14	145.22	92984.0
2017-09-27 08:00:00	IWM	ETF	145.23	145.44	145.16	145.41	161462.0
2017-09-27 09:00:00	IWM	ETF	145.39	145.92	145.34	145.56	4709385.0
2017-09-27 10:00:00	IWM	ETF	145.565	145.75	145.16	145.3	4896817.0
2017-09-27 11:00:00	IWM	ETF	145.3	145.61	145.26	145.52	2654545.0
2017-09-27 12:00:00	IWM	ETF	145.52	146.52	145.37	146.48	5208411.0
2017-09-27 13:00:00	IWM	ETF	146.49	147.79	146.49	147.77	9350697.0
2017-09-27 14:00:00	IWM	ETF	147.78	147.82	147.34	147.59	8802723.0
2017-09-27 15:00:00	IWM	ETF	147.6	147.86	147.39	147.45	8578358.0
2017-09-27 16:00:00	IWM	ETF	147.44	147.68	145.35	147.52	1378004.0
2017-09-27 17:00:00	IWM	ETF	147.51	147.6	146.4282	147.55	1324635.0
2017-09-27 18:00:00	IWM	ETF	147.51	147.51	147.3906	147.5	474315.0
2017-09-27 19:00:00	IWM	ETF	147.46	147.54	147.45	147.54	10893.0
2017-09-27 04:00:00	DIA	ETF	222.8	222.8	222.8	222.8	122.0
2017-09-27 08:00:00	DIA	ETF	223.11	223.2	223.1	223.2	2200.0

> showing 50 of 9,373 rows — these rows as CSV

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