PREVIEW / etf_1hour / 2015-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-04.parquet
  size:    244 KB
  rows:    7,769

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-04 04:00:00	SPY	ETF	194.68	194.68	193.36	193.66	85578.0
2015-09-04 05:00:00	SPY	ETF	193.62	194.03	193.42	193.52	96102.0
2015-09-04 06:00:00	SPY	ETF	193.53	193.81	192.98	193.44	180643.0
2015-09-04 07:00:00	SPY	ETF	193.4	193.64	193.26	193.5	709074.0
2015-09-04 08:00:00	SPY	ETF	193.5	194.49	191.88	192.53	7698399.0
2015-09-04 09:00:00	SPY	ETF	192.53	193.8	191.89	192.88	30263845.0
2015-09-04 10:00:00	SPY	ETF	192.88	193.86	192.63	193.055	25065951.0
2015-09-04 11:00:00	SPY	ETF	193.05	193.34	192.65	192.92	16199344.0
2015-09-04 12:00:00	SPY	ETF	192.93	193.0	192.22	192.32	15042361.0
2015-09-04 13:00:00	SPY	ETF	192.32	192.46	191.85	192.13	18522546.0
2015-09-04 14:00:00	SPY	ETF	192.125	192.44	191.61	192.435	24373069.0
2015-09-04 15:00:00	SPY	ETF	192.435	193.72	192.1601	192.56	35335810.0
2015-09-04 16:00:00	SPY	ETF	192.6	193.03	192.54	192.85	27271882.0
2015-09-04 17:00:00	SPY	ETF	192.82	192.83	192.36	192.38	4389717.0
2015-09-04 18:00:00	SPY	ETF	192.38	192.44	192.23	192.35	62701.0
2015-09-04 19:00:00	SPY	ETF	192.35	192.37	192.2	192.2	38485.0
2015-09-04 04:00:00	QQQ	ETF	102.8	102.8	102.19	102.27	35576.0
2015-09-04 05:00:00	QQQ	ETF	102.33	102.5	102.33	102.35	18550.0
2015-09-04 06:00:00	QQQ	ETF	102.41	102.43	102.1	102.34	107478.0
2015-09-04 07:00:00	QQQ	ETF	102.32	102.41	102.23	102.33	83171.0
2015-09-04 08:00:00	QQQ	ETF	102.33	102.79	101.54	101.91	1277466.0
2015-09-04 09:00:00	QQQ	ETF	101.88	102.69	101.54	102.19	8375346.0
2015-09-04 10:00:00	QQQ	ETF	102.18	102.845	102.01	102.32	7127261.0
2015-09-04 11:00:00	QQQ	ETF	102.34	102.56	102.09	102.3801	3194850.0
2015-09-04 12:00:00	QQQ	ETF	102.39	102.42	101.89	101.945	3029549.0
2015-09-04 13:00:00	QQQ	ETF	101.95	102.11	101.74	101.87	2919857.0
2015-09-04 14:00:00	QQQ	ETF	101.86	102.12	101.59	102.11	2902600.0
2015-09-04 15:00:00	QQQ	ETF	102.11	102.64	101.9059	102.15	8033243.0
2015-09-04 16:00:00	QQQ	ETF	102.14	102.49	102.13	102.38	1502436.0
2015-09-04 17:00:00	QQQ	ETF	102.32	102.34	102.21	102.21	24290.0
2015-09-04 18:00:00	QQQ	ETF	102.21	102.25	102.11	102.2	13068.0
2015-09-04 19:00:00	QQQ	ETF	102.2	102.23	102.16	102.16	18665.0
2015-09-04 04:00:00	IWM	ETF	113.3	113.3	113.3	113.3	1200.0
2015-09-04 05:00:00	IWM	ETF	113.13	113.13	112.75	112.75	10900.0
2015-09-04 06:00:00	IWM	ETF	112.75	112.96	112.57	112.75	17250.0
2015-09-04 07:00:00	IWM	ETF	112.73	112.86	112.7	112.74	48399.0
2015-09-04 08:00:00	IWM	ETF	112.79	113.48	112.08	112.43	393405.0
2015-09-04 09:00:00	IWM	ETF	112.28	113.38	112.08	112.99	4901036.0
2015-09-04 10:00:00	IWM	ETF	112.99	113.7	112.76	113.2	4985978.0
2015-09-04 11:00:00	IWM	ETF	113.21	113.36	112.8	112.98	3073230.0
2015-09-04 12:00:00	IWM	ETF	112.98	113.15	112.64	112.74	2134628.0
2015-09-04 13:00:00	IWM	ETF	112.75	112.82	112.44	112.6	2170961.0
2015-09-04 14:00:00	IWM	ETF	112.59	112.875	112.28	112.86	2993913.0
2015-09-04 15:00:00	IWM	ETF	112.865	113.32	112.7	112.86	6658655.0
2015-09-04 16:00:00	IWM	ETF	112.85	113.11	112.84	112.98	1531621.0
2015-09-04 17:00:00	IWM	ETF	113.0	113.03	112.91	112.91	84676.0
2015-09-04 19:00:00	IWM	ETF	112.87	112.87	112.87	112.87	148.0
2015-09-04 04:00:00	DIA	ETF	162.09	162.09	162.09	162.09	100.0
2015-09-04 06:00:00	DIA	ETF	161.9	161.9	161.9	161.9	100.0
2015-09-04 07:00:00	DIA	ETF	161.91	162.0	161.84	161.95	9568.0

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

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