PREVIEW / etf_1hour / 2015-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-09.parquet
  size:    246 KB
  rows:    7,824

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-09 04:00:00	SPY	ETF	206.89	206.89	206.0	206.45	61643.0
2015-12-09 05:00:00	SPY	ETF	206.43	206.48	206.03	206.05	17508.0
2015-12-09 06:00:00	SPY	ETF	206.15	206.87	206.13	206.78	68631.0
2015-12-09 07:00:00	SPY	ETF	206.71	206.71	206.14	206.29	247550.0
2015-12-09 08:00:00	SPY	ETF	206.29	207.05	206.02	206.06	752744.0
2015-12-09 09:00:00	SPY	ETF	206.09	207.64	205.71	207.3401	13796260.0
2015-12-09 10:00:00	SPY	ETF	207.35	208.68	207.19	208.15	21933775.0
2015-12-09 11:00:00	SPY	ETF	208.15	208.23	206.07	206.3	18976630.0
2015-12-09 12:00:00	SPY	ETF	206.33	206.56	204.32	204.61	26896627.0
2015-12-09 13:00:00	SPY	ETF	204.6	205.31	204.18	205.0	26776974.0
2015-12-09 14:00:00	SPY	ETF	205.0	205.2	204.63	204.69	14246253.0
2015-12-09 15:00:00	SPY	ETF	204.68	205.84	204.6	205.36	23218443.0
2015-12-09 16:00:00	SPY	ETF	205.37	208.26	204.93	205.3	7704584.0
2015-12-09 17:00:00	SPY	ETF	205.28	205.35	205.23	205.29	248273.0
2015-12-09 18:00:00	SPY	ETF	205.36	205.49	205.26	205.47	196377.0
2015-12-09 19:00:00	SPY	ETF	205.49	205.72	205.42	205.42	132116.0
2015-12-09 04:00:00	QQQ	ETF	114.41	114.41	114.01	114.05	20400.0
2015-12-09 06:00:00	QQQ	ETF	114.2	114.51	114.13	114.45	1600.0
2015-12-09 07:00:00	QQQ	ETF	114.29	114.29	114.08	114.18	137727.0
2015-12-09 08:00:00	QQQ	ETF	114.26	114.34	114.09	114.1	140343.0
2015-12-09 09:00:00	QQQ	ETF	114.12	114.453	113.82	114.18	4234175.0
2015-12-09 10:00:00	QQQ	ETF	114.17	114.76	114.125	114.48	6253660.0
2015-12-09 11:00:00	QQQ	ETF	114.48	114.5	113.35	113.46	5332184.0
2015-12-09 12:00:00	QQQ	ETF	113.465	113.61	112.31	112.43	9771291.0
2015-12-09 13:00:00	QQQ	ETF	112.43	112.7626	112.2	112.58	7169002.0
2015-12-09 14:00:00	QQQ	ETF	112.59	112.65	112.27	112.36	4142048.0
2015-12-09 15:00:00	QQQ	ETF	112.37	113.07	112.32	112.89	6912216.0
2015-12-09 16:00:00	QQQ	ETF	112.9	112.98	112.75	112.95	919139.0
2015-12-09 17:00:00	QQQ	ETF	112.89	112.95	112.89	112.95	5900.0
2015-12-09 18:00:00	QQQ	ETF	112.97	113.04	112.9	113.04	54328.0
2015-12-09 19:00:00	QQQ	ETF	113.04	113.18	113.04	113.06	75649.0
2015-12-09 04:00:00	IWM	ETF	115.03	115.03	115.03	115.03	100.0
2015-12-09 06:00:00	IWM	ETF	115.34	115.38	115.34	115.38	22000.0
2015-12-09 07:00:00	IWM	ETF	115.2	115.3	115.09	115.1	112000.0
2015-12-09 08:00:00	IWM	ETF	115.09	115.18	114.93	114.99	84478.0
2015-12-09 09:00:00	IWM	ETF	114.99	115.78	114.75	115.64	3063883.0
2015-12-09 10:00:00	IWM	ETF	115.64	116.17	115.52	115.72	5731472.0
2015-12-09 11:00:00	IWM	ETF	115.74	115.755	114.72	114.84	4737985.0
2015-12-09 12:00:00	IWM	ETF	114.84	114.97	113.6	113.93	6883287.0
2015-12-09 13:00:00	IWM	ETF	113.92	114.36	113.77	114.23	5725252.0
2015-12-09 14:00:00	IWM	ETF	114.24	114.29	113.82	114.014	2882408.0
2015-12-09 15:00:00	IWM	ETF	114.015	114.39	113.94	114.05	6486792.0
2015-12-09 16:00:00	IWM	ETF	114.04	114.16	113.8	113.92	2389451.0
2015-12-09 17:00:00	IWM	ETF	113.97	114.05	113.9	114.05	21662.0
2015-12-09 18:00:00	IWM	ETF	113.9	114.01	113.85	113.98	22856.0
2015-12-09 19:00:00	IWM	ETF	114.11	114.11	114.05	114.05	1935.0
2015-12-09 06:00:00	DIA	ETF	175.5	175.5	175.5	175.5	100.0
2015-12-09 07:00:00	DIA	ETF	175.6	175.6	175.54	175.54	1100.0
2015-12-09 08:00:00	DIA	ETF	175.5	175.5	175.26	175.26	500.0
2015-12-09 09:00:00	DIA	ETF	175.26	176.6798	175.0	176.51	786117.0

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

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