PREVIEW / etf_1hour / 2016-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-25.parquet
  size:    248 KB
  rows:    7,977

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
2016-01-25 04:00:00	SPY	ETF	189.7	190.18	189.37	189.87	15910.0
2016-01-25 05:00:00	SPY	ETF	189.99	190.5	189.82	190.22	11832.0
2016-01-25 06:00:00	SPY	ETF	190.13	190.29	189.84	190.08	46562.0
2016-01-25 07:00:00	SPY	ETF	190.09	190.37	190.01	190.31	166402.0
2016-01-25 08:00:00	SPY	ETF	190.28	190.52	189.25	189.35	1485760.0
2016-01-25 09:00:00	SPY	ETF	189.36	190.12	189.27	189.62	14420192.0
2016-01-25 10:00:00	SPY	ETF	189.615	190.15	189.04	189.26	18763541.0
2016-01-25 11:00:00	SPY	ETF	189.25	189.5	188.75	189.29	14407390.0
2016-01-25 12:00:00	SPY	ETF	189.29	189.66	189.045	189.6111	8043088.0
2016-01-25 13:00:00	SPY	ETF	189.62	190.11	189.14	189.15	11011676.0
2016-01-25 14:00:00	SPY	ETF	189.15	189.41	188.79	188.98	11751760.0
2016-01-25 15:00:00	SPY	ETF	188.98	189.21	187.41	187.66	32781216.0
2016-01-25 16:00:00	SPY	ETF	187.66	188.61	187.33	187.75	11730396.0
2016-01-25 17:00:00	SPY	ETF	187.71	187.71	187.52	187.64	415583.0
2016-01-25 18:00:00	SPY	ETF	187.68	187.78	187.11	187.29	427037.0
2016-01-25 19:00:00	SPY	ETF	187.33	187.49	187.1	187.27	389539.0
2016-01-25 04:00:00	QQQ	ETF	103.25	103.5	103.08	103.4	10241.0
2016-01-25 05:00:00	QQQ	ETF	103.38	103.54	103.38	103.48	897.0
2016-01-25 06:00:00	QQQ	ETF	103.48	103.51	103.39	103.39	1400.0
2016-01-25 07:00:00	QQQ	ETF	103.45	103.58	103.45	103.57	12300.0
2016-01-25 08:00:00	QQQ	ETF	103.57	103.59	103.1	103.13	125370.0
2016-01-25 09:00:00	QQQ	ETF	103.14	103.69	103.14	103.48	4775626.0
2016-01-25 10:00:00	QQQ	ETF	103.47	103.8	103.31	103.47	6048228.0
2016-01-25 11:00:00	QQQ	ETF	103.46	103.53	103.13	103.36	4621112.0
2016-01-25 12:00:00	QQQ	ETF	103.36	103.74	103.25	103.7	2068641.0
2016-01-25 13:00:00	QQQ	ETF	103.7	103.99	103.3799	103.3799	2863152.0
2016-01-25 14:00:00	QQQ	ETF	103.37	103.48	103.13	103.28	2727238.0
2016-01-25 15:00:00	QQQ	ETF	103.26	103.43	102.14	102.26	8500621.0
2016-01-25 16:00:00	QQQ	ETF	102.27	102.34	102.03	102.29	917824.0
2016-01-25 17:00:00	QQQ	ETF	102.28	102.28	102.18	102.25	2927.0
2016-01-25 18:00:00	QQQ	ETF	102.25	102.31	102.0	102.04	23099.0
2016-01-25 19:00:00	QQQ	ETF	102.06	102.1	101.9	102.02	20394.0
2016-01-25 04:00:00	IWM	ETF	100.64	100.81	100.63	100.81	2776.0
2016-01-25 05:00:00	IWM	ETF	100.92	101.03	100.92	101.03	1500.0
2016-01-25 06:00:00	IWM	ETF	100.9	100.9	100.62	100.71	8699.0
2016-01-25 07:00:00	IWM	ETF	100.81	100.93	100.8	100.93	6145.0
2016-01-25 08:00:00	IWM	ETF	100.91	100.91	100.38	100.42	148438.0
2016-01-25 09:00:00	IWM	ETF	100.44	100.93	100.37	100.81	3827381.0
2016-01-25 10:00:00	IWM	ETF	100.8	101.08	100.16	100.32	5426473.0
2016-01-25 11:00:00	IWM	ETF	100.3	100.33	99.855	100.1726	4219088.0
2016-01-25 12:00:00	IWM	ETF	100.17	100.33	99.95	100.12	2501977.0
2016-01-25 13:00:00	IWM	ETF	100.12	100.53	99.62	99.63	3006972.0
2016-01-25 14:00:00	IWM	ETF	99.62	99.91	99.43	99.73	3225455.0
2016-01-25 15:00:00	IWM	ETF	99.72	99.91	98.85	99.13	8204905.0
2016-01-25 16:00:00	IWM	ETF	99.12	99.33	98.93	99.12	1692498.0
2016-01-25 17:00:00	IWM	ETF	99.12	99.19	99.12	99.13	7901.0
2016-01-25 18:00:00	IWM	ETF	99.11	99.11	99.1	99.1	2130.0
2016-01-25 19:00:00	IWM	ETF	99.17	99.17	98.9	98.9	2300.0
2016-01-25 07:00:00	DIA	ETF	160.46	160.46	160.46	160.46	335.0
2016-01-25 08:00:00	DIA	ETF	160.43	160.43	159.89	159.96	15200.0

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

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