PREVIEW / etf_1hour / 2015-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-17.parquet
  size:    245 KB
  rows:    7,751

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-11-17 04:00:00	SPY	ETF	205.75	206.42	205.6	206.27	25796.0
2015-11-17 05:00:00	SPY	ETF	206.34	206.54	206.19	206.41	33803.0
2015-11-17 06:00:00	SPY	ETF	206.46	206.61	206.23	206.26	118064.0
2015-11-17 07:00:00	SPY	ETF	206.24	206.37	206.01	206.19	316377.0
2015-11-17 08:00:00	SPY	ETF	206.18	206.42	205.97	206.33	1010843.0
2015-11-17 09:00:00	SPY	ETF	206.31	206.32	205.26	205.755	13289415.0
2015-11-17 10:00:00	SPY	ETF	205.76	206.74	205.42	206.54	17403210.0
2015-11-17 11:00:00	SPY	ETF	206.54	207.04	206.32	206.75	11544975.0
2015-11-17 12:00:00	SPY	ETF	206.76	206.98	205.97	206.34	10704126.0
2015-11-17 13:00:00	SPY	ETF	206.34	206.57	205.6968	206.32	10379875.0
2015-11-17 14:00:00	SPY	ETF	206.31	206.52	205.04	205.65	19574578.0
2015-11-17 15:00:00	SPY	ETF	205.64	206.1566	204.88	205.38	26237024.0
2015-11-17 16:00:00	SPY	ETF	205.38	205.9	205.3791	205.69	9569954.0
2015-11-17 17:00:00	SPY	ETF	205.71	205.73	205.65	205.65	172092.0
2015-11-17 18:00:00	SPY	ETF	205.69	205.7	205.5	205.5	72002.0
2015-11-17 19:00:00	SPY	ETF	205.5	205.6	205.32	205.45	84311.0
2015-11-17 04:00:00	QQQ	ETF	111.22	111.77	111.22	111.77	19100.0
2015-11-17 05:00:00	QQQ	ETF	111.84	111.93	111.82	111.87	7074.0
2015-11-17 06:00:00	QQQ	ETF	111.98	111.98	111.81	111.85	1481.0
2015-11-17 07:00:00	QQQ	ETF	111.79	111.84	111.71	111.78	32596.0
2015-11-17 08:00:00	QQQ	ETF	111.8	111.86	111.68	111.75	94448.0
2015-11-17 09:00:00	QQQ	ETF	111.75	111.75	111.33	111.59	4052978.0
2015-11-17 10:00:00	QQQ	ETF	111.59	112.06	111.34	111.97	4713880.0
2015-11-17 11:00:00	QQQ	ETF	111.97	112.29	111.79	112.13	3144233.0
2015-11-17 12:00:00	QQQ	ETF	112.13	112.23	111.7366	111.99	3329426.0
2015-11-17 13:00:00	QQQ	ETF	111.98	112.155	111.4778	111.975	3547370.0
2015-11-17 14:00:00	QQQ	ETF	111.98	112.12	111.23	111.65	3605251.0
2015-11-17 15:00:00	QQQ	ETF	111.655	111.66	111.2099	111.47	5419802.0
2015-11-17 16:00:00	QQQ	ETF	111.49	111.73	111.48	111.64	1339645.0
2015-11-17 17:00:00	QQQ	ETF	111.64	111.67	111.64	111.66	33831.0
2015-11-17 18:00:00	QQQ	ETF	111.65	111.65	111.52	111.52	81804.0
2015-11-17 19:00:00	QQQ	ETF	111.51	111.51	111.44	111.49	7536.0
2015-11-17 04:00:00	IWM	ETF	115.1	115.1	115.1	115.1	100.0
2015-11-17 06:00:00	IWM	ETF	115.37	115.37	115.36	115.36	200.0
2015-11-17 07:00:00	IWM	ETF	115.38	115.77	115.2	115.2	56698.0
2015-11-17 08:00:00	IWM	ETF	115.22	115.41	115.16	115.32	31229.0
2015-11-17 09:00:00	IWM	ETF	115.28	115.28	114.45	114.822	3005167.0
2015-11-17 10:00:00	IWM	ETF	114.86	115.475	114.56	115.32	3231837.0
2015-11-17 11:00:00	IWM	ETF	115.32	116.06	115.23	115.95	4257356.0
2015-11-17 12:00:00	IWM	ETF	115.95	116.15	115.32	115.49	3033872.0
2015-11-17 13:00:00	IWM	ETF	115.49	115.575	114.68	115.055	3876805.0
2015-11-17 14:00:00	IWM	ETF	115.05	115.295	114.55	114.89	3069458.0
2015-11-17 15:00:00	IWM	ETF	114.89	114.97	114.51	114.6	5263791.0
2015-11-17 16:00:00	IWM	ETF	114.6	114.87	114.59	114.72	1608978.0
2015-11-17 17:00:00	IWM	ETF	114.74	114.75	114.74	114.75	1100.0
2015-11-17 18:00:00	IWM	ETF	114.65	114.65	114.65	114.65	280.0
2015-11-17 04:00:00	DIA	ETF	175.5	175.5	175.5	175.5	100.0
2015-11-17 05:00:00	DIA	ETF	175.57	175.77	175.57	175.77	11000.0
2015-11-17 06:00:00	DIA	ETF	175.75	175.91	175.75	175.91	26000.0
2015-11-17 07:00:00	DIA	ETF	175.65	175.71	175.53	175.57	6800.0

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

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