PREVIEW / etf_1hour / 2015-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-02.parquet
  size:    247 KB
  rows:    7,917

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-09-02 04:00:00	SPY	ETF	193.91	194.1	192.84	193.2	127337.0
2015-09-02 05:00:00	SPY	ETF	193.18	193.65	192.92	193.65	42424.0
2015-09-02 06:00:00	SPY	ETF	193.7	194.1	193.04	193.25	108561.0
2015-09-02 07:00:00	SPY	ETF	193.22	193.83	193.13	193.76	611418.0
2015-09-02 08:00:00	SPY	ETF	193.74	194.39	193.22	194.33	2216423.0
2015-09-02 09:00:00	SPY	ETF	194.33	194.93	193.51	193.6	17951812.0
2015-09-02 10:00:00	SPY	ETF	193.6	194.16	192.42	193.02	23470998.0
2015-09-02 11:00:00	SPY	ETF	193.02	193.71	192.51	192.81	15621859.0
2015-09-02 12:00:00	SPY	ETF	192.83	194.07	192.5	193.96	13454764.0
2015-09-02 13:00:00	SPY	ETF	193.95	194.35	193.64	193.87	12277080.0
2015-09-02 14:00:00	SPY	ETF	193.88	194.5	193.4	194.07	21569598.0
2015-09-02 15:00:00	SPY	ETF	194.0629	195.46	193.38	195.46	35383732.0
2015-09-02 16:00:00	SPY	ETF	195.45	195.64	191.9119	195.58	9458914.0
2015-09-02 17:00:00	SPY	ETF	195.56	195.75	195.51	195.68	295195.0
2015-09-02 18:00:00	SPY	ETF	195.61	196.5	195.55	196.16	302902.0
2015-09-02 19:00:00	SPY	ETF	196.16	196.16	195.82	196.08	462160.0
2015-09-02 04:00:00	QQQ	ETF	102.3	102.3	101.9	102.15	2730.0
2015-09-02 05:00:00	QQQ	ETF	102.2	102.2	102.19	102.2	800.0
2015-09-02 06:00:00	QQQ	ETF	102.44	102.53	101.97	102.01	15100.0
2015-09-02 07:00:00	QQQ	ETF	102.05	102.41	102.01	102.38	73545.0
2015-09-02 08:00:00	QQQ	ETF	102.36	102.76	101.05	102.73	388880.0
2015-09-02 09:00:00	QQQ	ETF	102.72	102.91	102.147	102.32	6739796.0
2015-09-02 10:00:00	QQQ	ETF	102.32	102.77	101.7	102.16	7084748.0
2015-09-02 11:00:00	QQQ	ETF	102.17	102.58	101.99	102.18	5023914.0
2015-09-02 12:00:00	QQQ	ETF	102.19	102.83	101.881	102.79	3362396.0
2015-09-02 13:00:00	QQQ	ETF	102.77	103.07	102.59	102.78	2867308.0
2015-09-02 14:00:00	QQQ	ETF	102.79	103.25	102.45	102.93	4261285.0
2015-09-02 15:00:00	QQQ	ETF	102.93	103.91	102.55	103.91	6909383.0
2015-09-02 16:00:00	QQQ	ETF	103.92	104.16	102.6301	104.1	1828630.0
2015-09-02 17:00:00	QQQ	ETF	104.13	104.14	104.05	104.08	70183.0
2015-09-02 18:00:00	QQQ	ETF	104.08	104.67	104.08	104.47	237513.0
2015-09-02 19:00:00	QQQ	ETF	104.42	104.42	104.29	104.39	31001.0
2015-09-02 06:00:00	IWM	ETF	113.27	113.27	112.84	112.89	2100.0
2015-09-02 07:00:00	IWM	ETF	113.0	113.26	112.95	113.26	30425.0
2015-09-02 08:00:00	IWM	ETF	113.26	113.48	112.91	113.45	326160.0
2015-09-02 09:00:00	IWM	ETF	113.46	113.6	112.57	112.62	3716595.0
2015-09-02 10:00:00	IWM	ETF	112.63	113.09	112.15	112.555	4411525.0
2015-09-02 11:00:00	IWM	ETF	112.57	112.89	112.16	112.42	2573093.0
2015-09-02 12:00:00	IWM	ETF	112.42	113.04	112.075	112.96	2790255.0
2015-09-02 13:00:00	IWM	ETF	112.96	113.11	112.7	112.7754	1997606.0
2015-09-02 14:00:00	IWM	ETF	112.78	113.32	112.69	113.26	2948336.0
2015-09-02 15:00:00	IWM	ETF	113.26	113.96	113.02	113.94	4975431.0
2015-09-02 16:00:00	IWM	ETF	113.93	114.07	113.4	114.03	1342675.0
2015-09-02 17:00:00	IWM	ETF	114.04	114.05	113.91	113.91	168705.0
2015-09-02 18:00:00	IWM	ETF	114.03	114.24	113.92	114.24	4250.0
2015-09-02 19:00:00	IWM	ETF	114.18	114.29	114.12	114.29	2500.0
2015-09-02 04:00:00	DIA	ETF	162.28	162.3	161.7	161.7	2299.0
2015-09-02 06:00:00	DIA	ETF	162.18	162.18	162.18	162.18	100.0
2015-09-02 07:00:00	DIA	ETF	161.9	162.13	161.86	162.11	4350.0
2015-09-02 08:00:00	DIA	ETF	162.15	162.66	161.84	162.66	21475.0

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

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