PREVIEW / etf_1hour / 2015-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-27.parquet
  size:    241 KB
  rows:    7,634

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-05-27 04:00:00	SPY	ETF	210.9	211.03	210.74	211.03	4220.0
2015-05-27 05:00:00	SPY	ETF	211.08	211.39	211.03	211.24	102990.0
2015-05-27 06:00:00	SPY	ETF	211.25	211.27	211.08	211.24	142194.0
2015-05-27 07:00:00	SPY	ETF	211.24	211.39	211.21	211.32	310613.0
2015-05-27 08:00:00	SPY	ETF	211.29	211.53	211.22	211.28	1002393.0
2015-05-27 09:00:00	SPY	ETF	211.29	212.16	210.85	211.85	15185200.0
2015-05-27 10:00:00	SPY	ETF	211.86	212.0	211.6	211.99	11273690.0
2015-05-27 11:00:00	SPY	ETF	211.99	212.34	211.85	212.225	7838024.0
2015-05-27 12:00:00	SPY	ETF	212.225	212.33	212.07	212.175	5293533.0
2015-05-27 13:00:00	SPY	ETF	212.18	212.49	212.16	212.47	6822826.0
2015-05-27 14:00:00	SPY	ETF	212.48	212.7	212.47	212.61	9577367.0
2015-05-27 15:00:00	SPY	ETF	212.61	212.98	212.59	212.68	26991884.0
2015-05-27 16:00:00	SPY	ETF	212.68	212.7203	211.4705	212.55	6956397.0
2015-05-27 17:00:00	SPY	ETF	212.55	212.65	212.55	212.61	161434.0
2015-05-27 18:00:00	SPY	ETF	212.61	212.72	212.58	212.63	122759.0
2015-05-27 19:00:00	SPY	ETF	212.64	212.67	212.57	212.63	18570.0
2015-05-27 04:00:00	QQQ	ETF	109.1	109.5	109.1	109.5	1300.0
2015-05-27 05:00:00	QQQ	ETF	109.5	109.51	109.5	109.51	5000.0
2015-05-27 06:00:00	QQQ	ETF	109.42	109.42	109.4	109.41	12000.0
2015-05-27 07:00:00	QQQ	ETF	109.44	109.49	109.42	109.47	19894.0
2015-05-27 08:00:00	QQQ	ETF	109.45	109.61	109.45	109.49	211815.0
2015-05-27 09:00:00	QQQ	ETF	109.49	110.2	109.29	110.04	5505375.0
2015-05-27 10:00:00	QQQ	ETF	110.04	110.32	109.955	110.3	3790311.0
2015-05-27 11:00:00	QQQ	ETF	110.3	110.48	110.23	110.411	2295226.0
2015-05-27 12:00:00	QQQ	ETF	110.42	110.44	110.28	110.36	1130729.0
2015-05-27 13:00:00	QQQ	ETF	110.37	110.7	110.35	110.67	1900751.0
2015-05-27 14:00:00	QQQ	ETF	110.665	110.89	110.65	110.89	2907293.0
2015-05-27 15:00:00	QQQ	ETF	110.88	111.08	110.86	110.96	5531296.0
2015-05-27 16:00:00	QQQ	ETF	110.98	110.98	110.83	110.83	1807517.0
2015-05-27 17:00:00	QQQ	ETF	110.83	110.9	110.83	110.85	23917.0
2015-05-27 18:00:00	QQQ	ETF	110.88	110.88	110.83	110.85	7098.0
2015-05-27 19:00:00	QQQ	ETF	110.87	110.89	110.85	110.87	14300.0
2015-05-27 05:00:00	IWM	ETF	123.6	123.6	123.6	123.6	1200.0
2015-05-27 07:00:00	IWM	ETF	123.49	123.55	123.49	123.55	24200.0
2015-05-27 08:00:00	IWM	ETF	123.51	123.62	123.36	123.36	230719.0
2015-05-27 09:00:00	IWM	ETF	123.39	123.68	122.79	123.44	4472427.0
2015-05-27 10:00:00	IWM	ETF	123.44	123.57	123.18	123.53	3379542.0
2015-05-27 11:00:00	IWM	ETF	123.53	123.75	123.47	123.7	2453963.0
2015-05-27 12:00:00	IWM	ETF	123.7	123.97	123.675	123.94	1564246.0
2015-05-27 13:00:00	IWM	ETF	123.935	124.48	123.93	124.41	2474325.0
2015-05-27 14:00:00	IWM	ETF	124.41	124.68	124.405	124.58	2374730.0
2015-05-27 15:00:00	IWM	ETF	124.575	124.87	124.46	124.775	4702290.0
2015-05-27 16:00:00	IWM	ETF	124.77	124.83	123.48	124.75	1423766.0
2015-05-27 17:00:00	IWM	ETF	124.73	124.75	124.72	124.74	9942.0
2015-05-27 18:00:00	IWM	ETF	124.67	124.67	124.67	124.67	500.0
2015-05-27 04:00:00	DIA	ETF	180.41	180.41	180.41	180.41	100.0
2015-05-27 07:00:00	DIA	ETF	180.75	180.75	180.75	180.75	100.0
2015-05-27 08:00:00	DIA	ETF	180.99	181.03	180.85	180.85	4920.0
2015-05-27 09:00:00	DIA	ETF	180.83	181.51	180.45	181.34	891533.0
2015-05-27 10:00:00	DIA	ETF	181.34	181.42	181.04	181.3879	562867.0

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

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