PREVIEW / etf_1hour / 2016-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-27.parquet
  size:    255 KB
  rows:    8,224

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
2016-09-27 04:00:00	SPY	ETF	215.02	215.26	214.81	214.81	48899.0
2016-09-27 05:00:00	SPY	ETF	214.8	214.85	214.45	214.69	22042.0
2016-09-27 06:00:00	SPY	ETF	214.62	214.84	214.57	214.84	75610.0
2016-09-27 07:00:00	SPY	ETF	214.84	214.93	214.6	214.69	286616.0
2016-09-27 08:00:00	SPY	ETF	214.61	214.82	214.15	214.3	752604.0
2016-09-27 09:00:00	SPY	ETF	214.3	214.71	213.62	214.69	11258871.0
2016-09-27 10:00:00	SPY	ETF	214.69	215.13	214.16	214.265	11950375.0
2016-09-27 11:00:00	SPY	ETF	214.26	215.11	214.26	215.0	8318251.0
2016-09-27 12:00:00	SPY	ETF	214.99	215.5707	214.85	215.49	9253163.0
2016-09-27 13:00:00	SPY	ETF	215.49	215.68	215.34	215.47	6411084.0
2016-09-27 14:00:00	SPY	ETF	215.47	215.58	215.29	215.37	7225641.0
2016-09-27 15:00:00	SPY	ETF	215.38	215.55	215.17	215.55	13540852.0
2016-09-27 16:00:00	SPY	ETF	215.56	215.67	215.3415	215.47	7581010.0
2016-09-27 17:00:00	SPY	ETF	215.46	215.49	215.42	215.49	92358.0
2016-09-27 18:00:00	SPY	ETF	215.48	215.57	215.36	215.52	67931.0
2016-09-27 19:00:00	SPY	ETF	215.53	215.6	215.32	215.44	534394.0
2016-09-27 04:00:00	QQQ	ETF	117.69	117.82	117.67	117.67	25900.0
2016-09-27 05:00:00	QQQ	ETF	117.57	117.59	117.52	117.55	11449.0
2016-09-27 06:00:00	QQQ	ETF	117.54	117.65	117.54	117.65	17749.0
2016-09-27 07:00:00	QQQ	ETF	117.7	117.7	117.52	117.52	4728.0
2016-09-27 08:00:00	QQQ	ETF	117.58	117.64	117.34	117.43	194836.0
2016-09-27 09:00:00	QQQ	ETF	117.38	117.98	117.15	117.955	2873598.0
2016-09-27 10:00:00	QQQ	ETF	117.96	118.205	117.73	117.77	2580524.0
2016-09-27 11:00:00	QQQ	ETF	117.78	118.19	117.735	118.12	1402289.0
2016-09-27 12:00:00	QQQ	ETF	118.12	118.44	118.03	118.36	1575051.0
2016-09-27 13:00:00	QQQ	ETF	118.3689	118.51	118.25	118.445	1311793.0
2016-09-27 14:00:00	QQQ	ETF	118.44	118.5552	118.35	118.41	1083375.0
2016-09-27 15:00:00	QQQ	ETF	118.4095	118.54	118.29	118.51	2857476.0
2016-09-27 16:00:00	QQQ	ETF	118.49	118.55	118.3	118.44	608836.0
2016-09-27 17:00:00	QQQ	ETF	118.45	118.45	118.39	118.39	3258.0
2016-09-27 18:00:00	QQQ	ETF	118.39	118.52	118.36	118.51	74171.0
2016-09-27 19:00:00	QQQ	ETF	118.53	118.53	118.42	118.49	1490086.0
2016-09-27 04:00:00	IWM	ETF	123.91	123.98	123.91	123.97	1267.0
2016-09-27 06:00:00	IWM	ETF	123.52	123.52	123.43	123.43	556.0
2016-09-27 07:00:00	IWM	ETF	123.6	123.62	123.42	123.44	17496.0
2016-09-27 08:00:00	IWM	ETF	123.63	123.63	123.13	123.21	69371.0
2016-09-27 09:00:00	IWM	ETF	123.2	123.48	122.81	123.46	2424568.0
2016-09-27 10:00:00	IWM	ETF	123.47	123.78	123.03	123.045	2594704.0
2016-09-27 11:00:00	IWM	ETF	123.05	123.46	122.98	123.2	1214943.0
2016-09-27 12:00:00	IWM	ETF	123.2	123.66	123.1	123.66	1292906.0
2016-09-27 13:00:00	IWM	ETF	123.66	123.88	123.57	123.67	1317026.0
2016-09-27 14:00:00	IWM	ETF	123.66	123.83	123.57	123.62	814362.0
2016-09-27 15:00:00	IWM	ETF	123.62	123.755	123.375	123.75	2916745.0
2016-09-27 16:00:00	IWM	ETF	123.76	123.9	123.73	123.76	701453.0
2016-09-27 17:00:00	IWM	ETF	123.75	123.75	123.75	123.75	498.0
2016-09-27 18:00:00	IWM	ETF	123.73	123.73	123.73	123.73	175293.0
2016-09-27 19:00:00	IWM	ETF	123.76	123.76	123.73	123.76	1138545.0
2016-09-27 04:00:00	DIA	ETF	181.33	181.33	181.33	181.33	100.0
2016-09-27 07:00:00	DIA	ETF	181.0	181.0	181.0	181.0	1000.0
2016-09-27 08:00:00	DIA	ETF	181.11	181.27	180.81	180.81	840.0

> showing 50 of 8,224 rows — these rows as CSV

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