PREVIEW / etf_1hour / 2015-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-28.parquet
  size:    248 KB
  rows:    7,949

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-28 04:00:00	SPY	ETF	193.02	193.28	192.16	192.35	242821.0
2015-09-28 05:00:00	SPY	ETF	192.4	192.45	191.67	191.7	154003.0
2015-09-28 06:00:00	SPY	ETF	191.79	191.99	191.1	191.29	516657.0
2015-09-28 07:00:00	SPY	ETF	191.32	191.89	190.98	191.27	560969.0
2015-09-28 08:00:00	SPY	ETF	191.28	192.85	191.16	191.72	1476147.0
2015-09-28 09:00:00	SPY	ETF	191.74	191.99	190.685	190.69	16253443.0
2015-09-28 10:00:00	SPY	ETF	190.69	190.84	190.01	190.567	22807821.0
2015-09-28 11:00:00	SPY	ETF	190.553	190.89	189.39	189.44	18143049.0
2015-09-28 12:00:00	SPY	ETF	189.43	189.5	188.64	188.67	14618950.0
2015-09-28 13:00:00	SPY	ETF	188.67	189.24	188.35	188.37	16242824.0
2015-09-28 14:00:00	SPY	ETF	188.36	188.85	187.76	188.155	20151175.0
2015-09-28 15:00:00	SPY	ETF	188.16	188.67	187.64	187.93	40772345.0
2015-09-28 16:00:00	SPY	ETF	187.92	189.2	187.84	188.25	8363799.0
2015-09-28 17:00:00	SPY	ETF	188.27	188.4	187.933	188.4	14458575.0
2015-09-28 18:00:00	SPY	ETF	188.35	188.71	188.29	188.53	104330.0
2015-09-28 19:00:00	SPY	ETF	188.5	188.59	188.44	188.53	58671.0
2015-09-28 04:00:00	QQQ	ETF	103.0	103.0	102.55	102.62	2280.0
2015-09-28 05:00:00	QQQ	ETF	102.4	102.45	102.31	102.42	16600.0
2015-09-28 06:00:00	QQQ	ETF	102.45	102.52	102.11	102.22	6955.0
2015-09-28 07:00:00	QQQ	ETF	102.29	102.48	102.06	102.17	61640.0
2015-09-28 08:00:00	QQQ	ETF	102.15	102.5	102.11	102.41	248511.0
2015-09-28 09:00:00	QQQ	ETF	102.43	102.6	101.55	101.57	5662958.0
2015-09-28 10:00:00	QQQ	ETF	101.56	101.7	101.15	101.57	5790768.0
2015-09-28 11:00:00	QQQ	ETF	101.56	101.78	100.805	100.805	4862277.0
2015-09-28 12:00:00	QQQ	ETF	100.8	100.91	100.41	100.42	3831916.0
2015-09-28 13:00:00	QQQ	ETF	100.42	100.82	100.1	100.12	4551351.0
2015-09-28 14:00:00	QQQ	ETF	100.13	100.49	99.69	100.06	6094884.0
2015-09-28 15:00:00	QQQ	ETF	100.07	100.46	99.78	99.98	8712925.0
2015-09-28 16:00:00	QQQ	ETF	99.98	100.27	99.97	100.22	1301182.0
2015-09-28 17:00:00	QQQ	ETF	100.22	100.23	99.99	100.23	453135.0
2015-09-28 18:00:00	QQQ	ETF	100.25	100.38	100.21	100.35	71748.0
2015-09-28 19:00:00	QQQ	ETF	100.31	100.34	100.2	100.28	14736.0
2015-09-28 04:00:00	IWM	ETF	110.86	110.9	110.86	110.9	200.0
2015-09-28 06:00:00	IWM	ETF	110.96	110.96	110.56	110.77	4899.0
2015-09-28 07:00:00	IWM	ETF	110.78	111.04	110.61	110.75	11007.0
2015-09-28 08:00:00	IWM	ETF	110.65	110.99	110.58	110.94	158949.0
2015-09-28 09:00:00	IWM	ETF	110.98	111.15	109.97	110.0499	5349358.0
2015-09-28 10:00:00	IWM	ETF	110.04	110.12	109.3	109.74	7212660.0
2015-09-28 11:00:00	IWM	ETF	109.74	110.0	109.28	109.3	6353438.0
2015-09-28 12:00:00	IWM	ETF	109.3	109.42	108.5	108.58	6187721.0
2015-09-28 13:00:00	IWM	ETF	108.59	108.89	108.23	108.45	6890598.0
2015-09-28 14:00:00	IWM	ETF	108.46	108.67	107.88	108.38	8482425.0
2015-09-28 15:00:00	IWM	ETF	108.38	108.7	108.13	108.28	10580874.0
2015-09-28 16:00:00	IWM	ETF	108.28	109.4789	108.1	108.27	1646235.0
2015-09-28 17:00:00	IWM	ETF	108.3	108.35	108.25	108.27	576356.0
2015-09-28 18:00:00	IWM	ETF	108.21	108.42	108.21	108.36	3299.0
2015-09-28 19:00:00	IWM	ETF	108.36	108.41	108.35	108.35	1500.0
2015-09-28 04:00:00	DIA	ETF	163.17	163.17	163.17	163.17	100.0
2015-09-28 05:00:00	DIA	ETF	162.21	162.3	162.21	162.3	200.0
2015-09-28 06:00:00	DIA	ETF	162.0	162.0	161.89	161.89	400.0

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

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