PREVIEW / etf_1hour / 2015-05-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-15.parquet
  size:    237 KB
  rows:    7,590

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-15 04:00:00	SPY	ETF	212.45	212.79	212.45	212.72	20990.0
2015-05-15 05:00:00	SPY	ETF	212.74	212.76	212.7	212.72	27850.0
2015-05-15 06:00:00	SPY	ETF	212.74	212.81	212.6	212.6	80594.0
2015-05-15 07:00:00	SPY	ETF	212.56	212.69	212.47	212.69	143728.0
2015-05-15 08:00:00	SPY	ETF	212.66	212.72	212.45	212.48	553624.0
2015-05-15 09:00:00	SPY	ETF	212.48	212.61	212.12	212.27	11547740.0
2015-05-15 10:00:00	SPY	ETF	212.26	212.37	211.86	212.29	14824282.0
2015-05-15 11:00:00	SPY	ETF	212.285	212.42	211.94	212.075	7486221.0
2015-05-15 12:00:00	SPY	ETF	212.08	212.22	211.94	212.16	5610983.0
2015-05-15 13:00:00	SPY	ETF	212.16	212.23	212.04	212.09	4257303.0
2015-05-15 14:00:00	SPY	ETF	212.09	212.39	211.97	212.32	6442824.0
2015-05-15 15:00:00	SPY	ETF	212.32	212.48	212.22	212.47	14453039.0
2015-05-15 16:00:00	SPY	ETF	212.47	212.56	212.0	212.56	7967369.0
2015-05-15 17:00:00	SPY	ETF	212.56	212.56	212.48	212.54	289612.0
2015-05-15 18:00:00	SPY	ETF	212.54	212.59	212.48	212.5	63370.0
2015-05-15 19:00:00	SPY	ETF	212.5	212.56	212.47	212.56	45917.0
2015-05-15 04:00:00	QQQ	ETF	109.79	109.95	109.79	109.89	1650.0
2015-05-15 05:00:00	QQQ	ETF	110.0	110.0	110.0	110.0	200.0
2015-05-15 06:00:00	QQQ	ETF	110.01	110.01	109.92	109.92	52600.0
2015-05-15 07:00:00	QQQ	ETF	109.93	109.96	109.89	109.96	69043.0
2015-05-15 08:00:00	QQQ	ETF	109.94	109.95	109.8	109.84	209529.0
2015-05-15 09:00:00	QQQ	ETF	109.82	110.01	109.53	109.6199	4256846.0
2015-05-15 10:00:00	QQQ	ETF	109.59	109.6899	109.36	109.66	4443024.0
2015-05-15 11:00:00	QQQ	ETF	109.65	109.72	109.37	109.49	2349337.0
2015-05-15 12:00:00	QQQ	ETF	109.49	109.56	109.4056	109.4813	1454779.0
2015-05-15 13:00:00	QQQ	ETF	109.485	109.56	109.39	109.41	1033326.0
2015-05-15 14:00:00	QQQ	ETF	109.405	109.61	109.31	109.57	1214710.0
2015-05-15 15:00:00	QQQ	ETF	109.56	109.61	109.46	109.59	4031777.0
2015-05-15 16:00:00	QQQ	ETF	109.59	109.6524	109.52	109.63	636965.0
2015-05-15 17:00:00	QQQ	ETF	109.63	109.63	109.58	109.58	25013.0
2015-05-15 18:00:00	QQQ	ETF	109.53	109.59	109.53	109.56	3698.0
2015-05-15 19:00:00	QQQ	ETF	109.59	109.59	109.5	109.5	17313.0
2015-05-15 04:00:00	IWM	ETF	124.0	124.0	124.0	124.0	100.0
2015-05-15 07:00:00	IWM	ETF	123.73	123.82	123.68	123.82	8000.0
2015-05-15 08:00:00	IWM	ETF	123.82	123.82	123.65	123.68	23355.0
2015-05-15 09:00:00	IWM	ETF	123.63	123.7	122.94	123.34	3797540.0
2015-05-15 10:00:00	IWM	ETF	123.29	123.645	122.99	123.58	3661906.0
2015-05-15 11:00:00	IWM	ETF	123.58	123.72	123.27	123.43	2325233.0
2015-05-15 12:00:00	IWM	ETF	123.44	123.5	123.27	123.39	1275390.0
2015-05-15 13:00:00	IWM	ETF	123.4	123.44	123.275	123.35	1137236.0
2015-05-15 14:00:00	IWM	ETF	123.35	123.56	123.21	123.515	1578520.0
2015-05-15 15:00:00	IWM	ETF	123.515	123.7	123.51	123.67	3932351.0
2015-05-15 16:00:00	IWM	ETF	123.67	123.7	123.6	123.62	667739.0
2015-05-15 17:00:00	IWM	ETF	123.62	123.66	123.61	123.66	5100.0
2015-05-15 18:00:00	IWM	ETF	123.68	123.68	123.68	123.68	309.0
2015-05-15 07:00:00	DIA	ETF	182.3	182.3	182.3	182.3	1800.0
2015-05-15 08:00:00	DIA	ETF	182.55	182.58	182.3	182.34	2200.0
2015-05-15 09:00:00	DIA	ETF	182.3	182.51	182.16	182.21	1621578.0
2015-05-15 10:00:00	DIA	ETF	182.18	182.31	181.89	182.24	751467.0
2015-05-15 11:00:00	DIA	ETF	182.23	182.4	182.0	182.08	543813.0

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

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