PREVIEW / etf_1hour / 2017-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-30.parquet
  size:    269 KB
  rows:    8,739

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-03-30 04:00:00	SPY	ETF	235.67	235.67	235.25	235.27	17428.0
2017-03-30 05:00:00	SPY	ETF	235.27	235.36	235.27	235.34	15806.0
2017-03-30 06:00:00	SPY	ETF	235.29	235.29	235.21	235.26	11731.0
2017-03-30 07:00:00	SPY	ETF	235.24	235.35	235.2	235.31	134591.0
2017-03-30 08:00:00	SPY	ETF	235.31	235.55	235.21	235.42	375466.0
2017-03-30 09:00:00	SPY	ETF	235.42	235.8	235.27	235.73	6719462.0
2017-03-30 10:00:00	SPY	ETF	235.73	236.49	235.71	236.44	8238620.0
2017-03-30 11:00:00	SPY	ETF	236.4399	236.52	236.05	236.05	5261592.0
2017-03-30 12:00:00	SPY	ETF	236.06	236.19	235.76	235.91	5471699.0
2017-03-30 13:00:00	SPY	ETF	235.91	236.365	235.88	236.22	4233148.0
2017-03-30 14:00:00	SPY	ETF	236.2201	236.48	236.08	236.2	5707252.0
2017-03-30 15:00:00	SPY	ETF	236.2	236.42	236.13	236.27	10782607.0
2017-03-30 16:00:00	SPY	ETF	236.26	236.35	236.2	236.35	8470007.0
2017-03-30 17:00:00	SPY	ETF	236.36	236.36	236.25	236.34	329312.0
2017-03-30 18:00:00	SPY	ETF	236.36	236.39	236.24	236.26	39102.0
2017-03-30 19:00:00	SPY	ETF	236.26	236.27	236.18	236.21	33690.0
2017-03-30 04:00:00	QQQ	ETF	132.18	132.18	132.18	132.18	600.0
2017-03-30 05:00:00	QQQ	ETF	132.21	132.24	132.21	132.23	28817.0
2017-03-30 06:00:00	QQQ	ETF	132.2	132.2	132.2	132.2	454.0
2017-03-30 07:00:00	QQQ	ETF	132.15	132.22	132.14	132.2	17952.0
2017-03-30 08:00:00	QQQ	ETF	132.21	132.27	132.17	132.22	42452.0
2017-03-30 09:00:00	QQQ	ETF	132.2	132.47	132.08	132.415	2385390.0
2017-03-30 10:00:00	QQQ	ETF	132.4	132.5973	132.35	132.575	2229105.0
2017-03-30 11:00:00	QQQ	ETF	132.58	132.61	132.26	132.26	1418025.0
2017-03-30 12:00:00	QQQ	ETF	132.261	132.4	132.12	132.25	1816885.0
2017-03-30 13:00:00	QQQ	ETF	132.248	132.53	132.21	132.415	1319177.0
2017-03-30 14:00:00	QQQ	ETF	132.42	132.53	132.3	132.38	1514532.0
2017-03-30 15:00:00	QQQ	ETF	132.37	132.51	132.345	132.46	2531080.0
2017-03-30 16:00:00	QQQ	ETF	132.46	132.5	132.37	132.44	284346.0
2017-03-30 17:00:00	QQQ	ETF	132.45	132.5	132.43	132.47	8886.0
2017-03-30 18:00:00	QQQ	ETF	132.47	132.47	132.39	132.39	10260.0
2017-03-30 19:00:00	QQQ	ETF	132.36	132.39	132.3	132.31	8523.0
2017-03-30 04:00:00	IWM	ETF	136.34	136.34	136.34	136.34	2000.0
2017-03-30 05:00:00	IWM	ETF	136.11	136.11	136.11	136.11	100.0
2017-03-30 07:00:00	IWM	ETF	136.11	136.13	136.02	136.07	34203.0
2017-03-30 08:00:00	IWM	ETF	136.02	136.32	136.01	136.24	237799.0
2017-03-30 09:00:00	IWM	ETF	136.24	136.85	136.16	136.68	2432844.0
2017-03-30 10:00:00	IWM	ETF	136.68	136.96	136.36	136.9	2922899.0
2017-03-30 11:00:00	IWM	ETF	136.91	136.99	136.72	136.76	2085933.0
2017-03-30 12:00:00	IWM	ETF	136.77	136.95	136.61	136.87	2130203.0
2017-03-30 13:00:00	IWM	ETF	136.87	137.21	136.84	137.0925	1876007.0
2017-03-30 14:00:00	IWM	ETF	137.11	137.28	137.0501	137.14	1413755.0
2017-03-30 15:00:00	IWM	ETF	137.13	137.38	137.13	137.29	4816786.0
2017-03-30 16:00:00	IWM	ETF	137.26	137.34	137.21	137.3	3093014.0
2017-03-30 17:00:00	IWM	ETF	137.3	137.3	137.15	137.26	1320548.0
2017-03-30 19:00:00	IWM	ETF	137.25	137.3	137.25	137.29	1348.0
2017-03-30 09:00:00	DIA	ETF	206.21	206.52	206.15	206.47	274947.0
2017-03-30 10:00:00	DIA	ETF	206.46	207.26	206.46	207.19	442162.0
2017-03-30 11:00:00	DIA	ETF	207.21	207.25	206.75	206.75	275431.0
2017-03-30 12:00:00	DIA	ETF	206.75	206.87	206.4201	206.62	266079.0

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

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