PREVIEW / etf_1hour / 2015-09-08

all etf 1-hour files

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

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-08 04:00:00	SPY	ETF	196.09	196.41	195.38	196.36	89398.0
2015-09-08 05:00:00	SPY	ETF	196.45	196.85	196.41	196.73	48460.0
2015-09-08 06:00:00	SPY	ETF	196.73	196.86	196.6	196.68	230547.0
2015-09-08 07:00:00	SPY	ETF	196.68	196.68	196.01	196.19	659202.0
2015-09-08 08:00:00	SPY	ETF	196.18	196.66	195.79	196.11	1640626.0
2015-09-08 09:00:00	SPY	ETF	196.09	196.67	195.85	195.9499	15319385.0
2015-09-08 10:00:00	SPY	ETF	195.945	196.02	195.17	195.7	15983119.0
2015-09-08 11:00:00	SPY	ETF	195.69	195.88	195.32	195.44	9203955.0
2015-09-08 12:00:00	SPY	ETF	195.44	196.36	195.32	195.8164	8271142.0
2015-09-08 13:00:00	SPY	ETF	195.82	196.34	195.51	196.32	6856768.0
2015-09-08 14:00:00	SPY	ETF	196.33	197.14	196.21	196.9499	14443175.0
2015-09-08 15:00:00	SPY	ETF	196.95	197.61	196.72	197.51	30745246.0
2015-09-08 16:00:00	SPY	ETF	197.49	197.55	195.581	197.29	7423987.0
2015-09-08 17:00:00	SPY	ETF	197.29	197.45	197.27	197.38	586856.0
2015-09-08 18:00:00	SPY	ETF	197.37	197.4	197.18	197.21	70742.0
2015-09-08 19:00:00	SPY	ETF	197.24	197.52	197.18	197.52	110107.0
2015-09-08 04:00:00	QQQ	ETF	104.03	104.25	104.0	104.19	20162.0
2015-09-08 05:00:00	QQQ	ETF	104.36	104.48	104.33	104.48	19725.0
2015-09-08 06:00:00	QQQ	ETF	104.46	104.5	104.35	104.4	19668.0
2015-09-08 07:00:00	QQQ	ETF	104.43	104.43	104.08	104.1	53060.0
2015-09-08 08:00:00	QQQ	ETF	104.16	104.4	103.94	104.04	119184.0
2015-09-08 09:00:00	QQQ	ETF	104.06	104.83	104.06	104.47	6307579.0
2015-09-08 10:00:00	QQQ	ETF	104.47	104.5285	103.855	104.18	7232685.0
2015-09-08 11:00:00	QQQ	ETF	104.185	104.27	103.895	103.94	3661032.0
2015-09-08 12:00:00	QQQ	ETF	103.93	104.42	103.84	104.05	3471231.0
2015-09-08 13:00:00	QQQ	ETF	104.04	104.3	103.69	104.29	2590082.0
2015-09-08 14:00:00	QQQ	ETF	104.295	104.81	104.245	104.67	4589182.0
2015-09-08 15:00:00	QQQ	ETF	104.67	105.165	104.56	105.05	6140208.0
2015-09-08 16:00:00	QQQ	ETF	105.05	105.11	104.9	105.03	956031.0
2015-09-08 17:00:00	QQQ	ETF	105.04	105.1	105.0	105.01	15320.0
2015-09-08 18:00:00	QQQ	ETF	105.06	105.06	104.91	104.95	18322.0
2015-09-08 19:00:00	QQQ	ETF	104.94	105.1	104.92	105.09	14530.0
2015-09-08 04:00:00	IWM	ETF	114.8	115.1	114.64	115.0	1989.0
2015-09-08 05:00:00	IWM	ETF	115.12	115.21	115.0	115.21	997.0
2015-09-08 06:00:00	IWM	ETF	115.2	115.25	115.16	115.25	21100.0
2015-09-08 07:00:00	IWM	ETF	115.19	115.24	114.82	114.86	74099.0
2015-09-08 08:00:00	IWM	ETF	114.86	114.9	114.67	114.68	101669.0
2015-09-08 09:00:00	IWM	ETF	114.68	114.81	114.32	114.45	3794055.0
2015-09-08 10:00:00	IWM	ETF	114.46	114.63	114.11	114.5305	4039931.0
2015-09-08 11:00:00	IWM	ETF	114.53	115.041	114.335	114.83	2912995.0
2015-09-08 12:00:00	IWM	ETF	114.83	115.3	114.76	115.04	2132786.0
2015-09-08 13:00:00	IWM	ETF	115.03	115.2	114.78	115.17	1618630.0
2015-09-08 14:00:00	IWM	ETF	115.175	115.5	115.05	115.33	2574155.0
2015-09-08 15:00:00	IWM	ETF	115.34	115.57	115.215	115.41	5346823.0
2015-09-08 16:00:00	IWM	ETF	115.43	115.51	115.3	115.37	1920202.0
2015-09-08 17:00:00	IWM	ETF	115.37	115.37	115.37	115.37	14343.0
2015-09-08 04:00:00	DIA	ETF	162.21	163.87	162.21	163.87	400.0
2015-09-08 06:00:00	DIA	ETF	164.27	164.27	164.27	164.27	600.0
2015-09-08 07:00:00	DIA	ETF	164.25	164.25	163.9	163.9	9638.0
2015-09-08 08:00:00	DIA	ETF	163.9	164.04	163.61	163.95	17751.0

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

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