PREVIEW / etf_1hour / 2015-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-23.parquet
  size:    248 KB
  rows:    7,857

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-12-23 04:00:00	SPY	ETF	204.08	204.43	204.08	204.39	21914.0
2015-12-23 05:00:00	SPY	ETF	204.39	204.45	204.28	204.32	28017.0
2015-12-23 06:00:00	SPY	ETF	204.24	204.65	204.19	204.58	79868.0
2015-12-23 07:00:00	SPY	ETF	204.61	204.95	204.57	204.74	221223.0
2015-12-23 08:00:00	SPY	ETF	204.74	204.89	204.55	204.6	558316.0
2015-12-23 09:00:00	SPY	ETF	204.6	205.0	204.58	204.86	11550946.0
2015-12-23 10:00:00	SPY	ETF	204.86	205.37	204.65	205.35	16526043.0
2015-12-23 11:00:00	SPY	ETF	205.35	205.38	205.1	205.311	9834910.0
2015-12-23 12:00:00	SPY	ETF	205.32	205.7	205.3	205.47	12146643.0
2015-12-23 13:00:00	SPY	ETF	205.47	205.55	205.13	205.5062	8890040.0
2015-12-23 14:00:00	SPY	ETF	205.5	206.07	205.43	205.94	16567992.0
2015-12-23 15:00:00	SPY	ETF	205.93	206.07	205.55	206.02	24061281.0
2015-12-23 16:00:00	SPY	ETF	206.02	206.08	205.52	205.64	7490209.0
2015-12-23 17:00:00	SPY	ETF	205.64	205.73	205.5	205.63	97454.0
2015-12-23 18:00:00	SPY	ETF	205.69	205.74	205.56	205.67	49261.0
2015-12-23 19:00:00	SPY	ETF	205.68	205.94	205.61	205.89	64455.0
2015-12-23 04:00:00	QQQ	ETF	112.1	112.2	112.1	112.19	760.0
2015-12-23 05:00:00	QQQ	ETF	112.23	112.25	112.22	112.25	12800.0
2015-12-23 06:00:00	QQQ	ETF	112.27	112.32	112.27	112.32	650.0
2015-12-23 07:00:00	QQQ	ETF	112.36	112.49	112.35	112.35	90923.0
2015-12-23 08:00:00	QQQ	ETF	112.36	112.47	112.31	112.33	78085.0
2015-12-23 09:00:00	QQQ	ETF	112.34	112.52	112.21	112.468	3490618.0
2015-12-23 10:00:00	QQQ	ETF	112.46	112.59	112.2	112.41	4463288.0
2015-12-23 11:00:00	QQQ	ETF	112.41	112.43	112.17	112.38	2013636.0
2015-12-23 12:00:00	QQQ	ETF	112.37	112.48	112.23	112.29	1786339.0
2015-12-23 13:00:00	QQQ	ETF	112.29	112.43	112.16	112.4	1449458.0
2015-12-23 14:00:00	QQQ	ETF	112.4	112.69	112.35	112.62	2617382.0
2015-12-23 15:00:00	QQQ	ETF	112.62	112.66	112.395	112.63	3873497.0
2015-12-23 16:00:00	QQQ	ETF	112.62	112.64	112.34	112.38	1348807.0
2015-12-23 17:00:00	QQQ	ETF	111.7694	112.53	111.7694	112.5	232528.0
2015-12-23 18:00:00	QQQ	ETF	112.41	112.46	112.37	112.46	19980.0
2015-12-23 19:00:00	QQQ	ETF	112.52	112.56	112.52	112.55	900.0
2015-12-23 04:00:00	IWM	ETF	113.64	113.73	113.64	113.73	700.0
2015-12-23 05:00:00	IWM	ETF	113.71	113.71	113.63	113.63	500.0
2015-12-23 06:00:00	IWM	ETF	113.59	113.83	113.59	113.83	300.0
2015-12-23 07:00:00	IWM	ETF	113.83	114.0	113.83	113.93	7134.0
2015-12-23 08:00:00	IWM	ETF	113.91	113.96	113.82	113.82	32744.0
2015-12-23 09:00:00	IWM	ETF	113.83	114.1	113.725	114.0	2913206.0
2015-12-23 10:00:00	IWM	ETF	114.0	114.63	113.95	114.62	3990877.0
2015-12-23 11:00:00	IWM	ETF	114.62	114.69	114.35	114.605	2825878.0
2015-12-23 12:00:00	IWM	ETF	114.605	114.83	114.53	114.64	1888937.0
2015-12-23 13:00:00	IWM	ETF	114.64	114.71	114.44	114.637	1495594.0
2015-12-23 14:00:00	IWM	ETF	114.64	114.96	114.5801	114.88	2206266.0
2015-12-23 15:00:00	IWM	ETF	114.89	114.92	114.53	114.79	6495073.0
2015-12-23 16:00:00	IWM	ETF	114.79	114.88	114.54	114.59	2850872.0
2015-12-23 17:00:00	IWM	ETF	114.53	114.76	114.53	114.76	65015.0
2015-12-23 04:00:00	DIA	ETF	174.51	174.68	174.51	174.68	200.0
2015-12-23 07:00:00	DIA	ETF	175.21	175.21	175.21	175.21	100.0
2015-12-23 08:00:00	DIA	ETF	175.0	175.19	174.99	175.12	2435.0
2015-12-23 09:00:00	DIA	ETF	175.18	175.39	175.0	175.11	1078658.0

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

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