PREVIEW / etf_1hour / 2015-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-24.parquet
  size:    245 KB
  rows:    7,838

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-24 04:00:00	SPY	ETF	193.37	194.37	193.37	193.77	22650.0
2015-09-24 05:00:00	SPY	ETF	193.9	193.9	193.0	193.25	20051.0
2015-09-24 06:00:00	SPY	ETF	193.28	193.32	192.09	192.43	252729.0
2015-09-24 07:00:00	SPY	ETF	192.42	192.43	191.68	192.15	864688.0
2015-09-24 08:00:00	SPY	ETF	192.17	192.9792	191.65	192.16	1576405.0
2015-09-24 09:00:00	SPY	ETF	192.16	192.43	191.08	191.42	16337128.0
2015-09-24 10:00:00	SPY	ETF	191.43	191.79	190.76	190.86	24710282.0
2015-09-24 11:00:00	SPY	ETF	190.8601	191.54	190.56	191.45	19690754.0
2015-09-24 12:00:00	SPY	ETF	191.46	192.2	191.309	191.31	14504356.0
2015-09-24 13:00:00	SPY	ETF	191.3	191.91	191.04	191.67	12194633.0
2015-09-24 14:00:00	SPY	ETF	191.66	193.45	191.48	193.12	23722288.0
2015-09-24 15:00:00	SPY	ETF	193.13	193.41	192.23	192.93	30463156.0
2015-09-24 16:00:00	SPY	ETF	192.93	193.07	192.54	192.74	8135536.0
2015-09-24 17:00:00	SPY	ETF	192.75	192.85	192.22	192.25	455558.0
2015-09-24 18:00:00	SPY	ETF	192.27	193.52	192.2	193.26	593948.0
2015-09-24 19:00:00	SPY	ETF	193.25	193.31	192.8	193.27	141508.0
2015-09-24 04:00:00	QQQ	ETF	103.89	104.28	103.89	104.19	7700.0
2015-09-24 05:00:00	QQQ	ETF	104.22	104.27	103.73	103.83	23311.0
2015-09-24 06:00:00	QQQ	ETF	103.86	103.89	103.2	103.38	29210.0
2015-09-24 07:00:00	QQQ	ETF	103.28	103.28	102.78	103.08	70415.0
2015-09-24 08:00:00	QQQ	ETF	103.13	103.29	102.85	103.2	321877.0
2015-09-24 09:00:00	QQQ	ETF	103.21	103.45	102.64	102.91	5353103.0
2015-09-24 10:00:00	QQQ	ETF	102.92	103.1	102.36	102.485	5394009.0
2015-09-24 11:00:00	QQQ	ETF	102.48	102.79	102.27	102.7482	4333591.0
2015-09-24 12:00:00	QQQ	ETF	102.73	103.27	102.67	102.76	2766097.0
2015-09-24 13:00:00	QQQ	ETF	102.76	103.03	102.5799	102.87	2598122.0
2015-09-24 14:00:00	QQQ	ETF	102.88	104.19	102.79	103.93	4715641.0
2015-09-24 15:00:00	QQQ	ETF	103.936	104.07	103.42	103.815	6644268.0
2015-09-24 16:00:00	QQQ	ETF	103.82	103.92	103.65	103.75	1038784.0
2015-09-24 17:00:00	QQQ	ETF	103.73	103.81	103.55	103.6	28866.0
2015-09-24 18:00:00	QQQ	ETF	103.55	104.15	103.47	104.0	127234.0
2015-09-24 19:00:00	QQQ	ETF	103.96	104.05	103.74	104.02	47989.0
2015-09-24 04:00:00	IWM	ETF	113.42	113.42	113.42	113.42	100.0
2015-09-24 06:00:00	IWM	ETF	113.07	113.07	112.71	112.71	1225.0
2015-09-24 07:00:00	IWM	ETF	112.55	112.6	112.33	112.55	83940.0
2015-09-24 08:00:00	IWM	ETF	112.59	112.73	112.31	112.67	139984.0
2015-09-24 09:00:00	IWM	ETF	112.64	112.95	112.17	112.46	3483860.0
2015-09-24 10:00:00	IWM	ETF	112.46	112.6499	112.01	112.065	6023833.0
2015-09-24 11:00:00	IWM	ETF	112.06	112.3	111.87	112.23	3961850.0
2015-09-24 12:00:00	IWM	ETF	112.23	112.75	112.11	112.325	2787620.0
2015-09-24 13:00:00	IWM	ETF	112.32	112.53	112.08	112.34	2178038.0
2015-09-24 14:00:00	IWM	ETF	112.35	113.34	112.23	113.06	4427217.0
2015-09-24 15:00:00	IWM	ETF	113.0635	113.42	112.76	113.21	8345517.0
2015-09-24 16:00:00	IWM	ETF	113.19	113.31	113.0	113.25	1748175.0
2015-09-24 17:00:00	IWM	ETF	113.16	113.27	113.11	113.12	91474.0
2015-09-24 18:00:00	IWM	ETF	113.35	113.46	113.27	113.46	1588.0
2015-09-24 19:00:00	IWM	ETF	113.47	113.47	113.36	113.45	700.0
2015-09-24 06:00:00	DIA	ETF	162.37	162.37	161.48	161.53	900.0
2015-09-24 07:00:00	DIA	ETF	161.4	161.4	161.01	161.35	42834.0
2015-09-24 08:00:00	DIA	ETF	161.29	161.45	160.97	161.35	69990.0

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

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