PREVIEW / etf_1hour / 2017-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-15.parquet
  size:    278 KB
  rows:    8,969

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-15 04:00:00	SPY	ETF	237.32	237.64	237.32	237.64	15645.0
2017-03-15 05:00:00	SPY	ETF	237.63	237.63	237.47	237.47	19667.0
2017-03-15 06:00:00	SPY	ETF	237.49	237.5	237.4	237.4	6180.0
2017-03-15 07:00:00	SPY	ETF	237.48	237.6	237.42	237.45	65062.0
2017-03-15 08:00:00	SPY	ETF	237.44	237.6	237.4	237.6	332842.0
2017-03-15 09:00:00	SPY	ETF	237.58	237.63	237.29	237.555	5043762.0
2017-03-15 10:00:00	SPY	ETF	237.56	237.76	237.435	237.58	6060488.0
2017-03-15 11:00:00	SPY	ETF	237.57	237.82	237.57	237.745	4816090.0
2017-03-15 12:00:00	SPY	ETF	237.745	238.15	237.74	238.075	5491396.0
2017-03-15 13:00:00	SPY	ETF	238.08	238.15	237.75	237.79	4839706.0
2017-03-15 14:00:00	SPY	ETF	237.81	239.05	237.77	238.83	20777207.0
2017-03-15 15:00:00	SPY	ETF	238.83	239.44	238.71	238.89	28676804.0
2017-03-15 16:00:00	SPY	ETF	238.88	238.95	238.52	238.65	11666070.0
2017-03-15 17:00:00	SPY	ETF	238.66	238.95	238.64	238.72	774501.0
2017-03-15 18:00:00	SPY	ETF	238.72	238.8	238.56	238.79	792500.0
2017-03-15 19:00:00	SPY	ETF	238.8	238.92	238.74	238.92	61308.0
2017-03-15 04:00:00	QQQ	ETF	131.42	131.58	131.39	131.56	1250.0
2017-03-15 05:00:00	QQQ	ETF	131.55	131.57	131.51	131.57	19127.0
2017-03-15 06:00:00	QQQ	ETF	131.51	131.52	131.45	131.47	3223.0
2017-03-15 07:00:00	QQQ	ETF	131.49	131.58	131.49	131.49	27650.0
2017-03-15 08:00:00	QQQ	ETF	131.49	131.57	131.49	131.52	38092.0
2017-03-15 09:00:00	QQQ	ETF	131.54	131.6	131.26	131.33	1122581.0
2017-03-15 10:00:00	QQQ	ETF	131.34	131.36	131.14	131.23	2018472.0
2017-03-15 11:00:00	QQQ	ETF	131.23	131.4	131.22	131.38	1072867.0
2017-03-15 12:00:00	QQQ	ETF	131.38	131.68	131.37	131.64	1370712.0
2017-03-15 13:00:00	QQQ	ETF	131.64	131.68	131.49	131.52	1261666.0
2017-03-15 14:00:00	QQQ	ETF	131.55	132.2	131.53	132.1	6588968.0
2017-03-15 15:00:00	QQQ	ETF	132.1	132.405	132.05	132.1	6757232.0
2017-03-15 16:00:00	QQQ	ETF	132.09	132.15	131.95	132.05	1489066.0
2017-03-15 17:00:00	QQQ	ETF	132.0	132.07	131.85	132.07	5847.0
2017-03-15 18:00:00	QQQ	ETF	132.05	132.1	132.0	132.1	8454.0
2017-03-15 19:00:00	QQQ	ETF	132.1	132.14	132.08	132.13	2203.0
2017-03-15 04:00:00	IWM	ETF	136.0	136.12	136.0	136.12	800.0
2017-03-15 05:00:00	IWM	ETF	136.09	136.16	136.09	136.14	6800.0
2017-03-15 06:00:00	IWM	ETF	136.17	136.18	136.08	136.14	1666.0
2017-03-15 07:00:00	IWM	ETF	136.18	136.27	136.15	136.17	40427.0
2017-03-15 08:00:00	IWM	ETF	136.14	136.24	136.07	136.23	32287.0
2017-03-15 09:00:00	IWM	ETF	136.25	136.52	135.97	136.47	1914271.0
2017-03-15 10:00:00	IWM	ETF	136.47	136.76	136.35	136.66	3241833.0
2017-03-15 11:00:00	IWM	ETF	136.67	136.99	136.65	136.73	2429483.0
2017-03-15 12:00:00	IWM	ETF	136.72	137.04	136.72	136.92	1897637.0
2017-03-15 13:00:00	IWM	ETF	136.92	136.99	136.465	136.6528	2969412.0
2017-03-15 14:00:00	IWM	ETF	136.7	137.735	136.7	137.48	6543095.0
2017-03-15 15:00:00	IWM	ETF	137.48	138.02	137.46	137.68	7582338.0
2017-03-15 16:00:00	IWM	ETF	137.73	137.805	137.48	137.55	1502540.0
2017-03-15 17:00:00	IWM	ETF	137.55	137.61	137.55	137.57	1800.0
2017-03-15 18:00:00	IWM	ETF	137.57	137.68	137.56	137.58	1212.0
2017-03-15 19:00:00	IWM	ETF	137.64	137.7	137.64	137.7	24518.0
2017-03-15 04:00:00	DIA	ETF	208.75	208.75	208.75	208.75	250.0
2017-03-15 07:00:00	DIA	ETF	208.88	208.88	208.88	208.88	100.0

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

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