PREVIEW / etf_1hour / 2015-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-10.parquet
  size:    243 KB
  rows:    7,722

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-10 04:00:00	SPY	ETF	205.55	206.1	205.55	205.73	15529.0
2015-12-10 05:00:00	SPY	ETF	205.78	206.11	205.78	205.94	29760.0
2015-12-10 06:00:00	SPY	ETF	205.93	206.03	205.42	205.5	38985.0
2015-12-10 07:00:00	SPY	ETF	205.67	205.73	205.18	205.58	127124.0
2015-12-10 08:00:00	SPY	ETF	205.38	205.79	205.21	205.22	1377725.0
2015-12-10 09:00:00	SPY	ETF	205.21	206.2	205.2	205.4801	12299606.0
2015-12-10 10:00:00	SPY	ETF	205.46	206.99	205.14	206.48	19567619.0
2015-12-10 11:00:00	SPY	ETF	206.475	206.73	205.89	206.095	12042867.0
2015-12-10 12:00:00	SPY	ETF	206.09	206.55	205.5505	206.45	10946846.0
2015-12-10 13:00:00	SPY	ETF	206.46	206.715	206.135	206.487	9256710.0
2015-12-10 14:00:00	SPY	ETF	206.5088	207.43	206.45	206.93	14205994.0
2015-12-10 15:00:00	SPY	ETF	206.93	207.01	205.61	205.82	23723129.0
2015-12-10 16:00:00	SPY	ETF	205.83	205.91	205.55	205.8	4015623.0
2015-12-10 17:00:00	SPY	ETF	205.81	205.97	205.75	205.85	361471.0
2015-12-10 18:00:00	SPY	ETF	205.81	205.94	205.75	205.82	53747.0
2015-12-10 19:00:00	SPY	ETF	205.86	206.23	205.86	206.13	125087.0
2015-12-10 20:00:00	SPY	ETF	205.8419	205.8419	205.8419	205.8419	1000000.0
2015-12-10 04:00:00	QQQ	ETF	113.33	113.33	113.17	113.17	900.0
2015-12-10 05:00:00	QQQ	ETF	113.33	113.33	113.33	113.33	6250.0
2015-12-10 06:00:00	QQQ	ETF	113.29	113.29	113.01	113.11	6550.0
2015-12-10 07:00:00	QQQ	ETF	113.09	113.13	112.87	113.09	30472.0
2015-12-10 08:00:00	QQQ	ETF	113.0	113.17	112.98	113.06	84416.0
2015-12-10 09:00:00	QQQ	ETF	113.09	113.5265	112.84	113.05	4592488.0
2015-12-10 10:00:00	QQQ	ETF	113.04	113.82	112.811	113.51	5827410.0
2015-12-10 11:00:00	QQQ	ETF	113.505	113.6874	113.3	113.4	2616315.0
2015-12-10 12:00:00	QQQ	ETF	113.405	113.64	113.1	113.58	2308610.0
2015-12-10 13:00:00	QQQ	ETF	113.59	113.74	113.48	113.59	1609573.0
2015-12-10 14:00:00	QQQ	ETF	113.58	114.16	113.56	113.91	2955709.0
2015-12-10 15:00:00	QQQ	ETF	113.91	113.95	113.18	113.39	4833768.0
2015-12-10 16:00:00	QQQ	ETF	113.39	113.51	113.33	113.47	696020.0
2015-12-10 17:00:00	QQQ	ETF	113.41	113.47	113.39	113.41	13947.0
2015-12-10 18:00:00	QQQ	ETF	113.46	113.53	113.46	113.51	9918.0
2015-12-10 19:00:00	QQQ	ETF	113.52	113.7	113.52	113.67	26290.0
2015-12-10 05:00:00	IWM	ETF	114.15	114.38	114.15	114.38	330.0
2015-12-10 07:00:00	IWM	ETF	114.09	114.09	113.85	114.05	15156.0
2015-12-10 08:00:00	IWM	ETF	114.04	114.15	113.89	113.94	111152.0
2015-12-10 09:00:00	IWM	ETF	114.01	114.48	113.65	114.06	4517981.0
2015-12-10 10:00:00	IWM	ETF	114.07	114.69	113.82	114.25	4953500.0
2015-12-10 11:00:00	IWM	ETF	114.25	114.46	114.11	114.28	2223672.0
2015-12-10 12:00:00	IWM	ETF	114.28	114.7	114.01	114.655	2280794.0
2015-12-10 13:00:00	IWM	ETF	114.66	114.75	114.455	114.605	2230431.0
2015-12-10 14:00:00	IWM	ETF	114.61	115.08	114.58	114.755	3139064.0
2015-12-10 15:00:00	IWM	ETF	114.76	114.78	114.08	114.46	5122886.0
2015-12-10 16:00:00	IWM	ETF	114.47	114.48	114.25	114.29	934299.0
2015-12-10 17:00:00	IWM	ETF	114.4	114.4	114.4	114.4	100.0
2015-12-10 18:00:00	IWM	ETF	114.3	114.38	114.11	114.23	5799.0
2015-12-10 04:00:00	DIA	ETF	175.17	175.17	175.17	175.17	400.0
2015-12-10 06:00:00	DIA	ETF	175.1	175.1	175.1	175.1	400.0
2015-12-10 07:00:00	DIA	ETF	175.0	175.0	175.0	175.0	100.0
2015-12-10 08:00:00	DIA	ETF	175.19	175.19	174.9	174.95	3063.0

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

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