PREVIEW / etf_1hour / 2015-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-30.parquet
  size:    249 KB
  rows:    8,032

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-30 04:00:00	SPY	ETF	189.58	190.35	189.53	190.27	131773.0
2015-09-30 05:00:00	SPY	ETF	190.25	190.52	190.25	190.42	33979.0
2015-09-30 06:00:00	SPY	ETF	190.47	190.65	190.35	190.5	104723.0
2015-09-30 07:00:00	SPY	ETF	190.54	190.78	190.34	190.39	696612.0
2015-09-30 08:00:00	SPY	ETF	190.38	190.67	189.25	190.35	1708118.0
2015-09-30 09:00:00	SPY	ETF	190.35	191.21	190.13	190.55	17053289.0
2015-09-30 10:00:00	SPY	ETF	190.539	191.47	190.46	190.975	19894061.0
2015-09-30 11:00:00	SPY	ETF	190.975	191.16	190.24	190.4696	12480176.0
2015-09-30 12:00:00	SPY	ETF	190.47	190.571	189.44	189.7599	16601532.0
2015-09-30 13:00:00	SPY	ETF	189.76	190.9731	189.73	190.845	11470032.0
2015-09-30 14:00:00	SPY	ETF	190.85	191.18	190.401	191.12	14704486.0
2015-09-30 15:00:00	SPY	ETF	191.1	191.825	190.69	191.67	46057716.0
2015-09-30 16:00:00	SPY	ETF	191.67	191.7906	190.95	191.07	19611385.0
2015-09-30 17:00:00	SPY	ETF	191.06	191.06	190.98	191.03	564240.0
2015-09-30 18:00:00	SPY	ETF	191.0	191.24	190.97	191.2	436179.0
2015-09-30 19:00:00	SPY	ETF	191.17	191.25	191.16	191.21	98054.0
2015-09-30 04:00:00	QQQ	ETF	100.33	100.75	100.33	100.7	8784.0
2015-09-30 05:00:00	QQQ	ETF	100.77	100.84	100.72	100.79	15700.0
2015-09-30 06:00:00	QQQ	ETF	100.84	100.94	100.79	100.88	15950.0
2015-09-30 07:00:00	QQQ	ETF	100.87	101.1	100.87	100.88	100883.0
2015-09-30 08:00:00	QQQ	ETF	100.89	101.1	100.81	100.9	325999.0
2015-09-30 09:00:00	QQQ	ETF	100.92	101.4625	100.78	101.01	6407291.0
2015-09-30 10:00:00	QQQ	ETF	101.01	101.87	100.96	101.49	6203886.0
2015-09-30 11:00:00	QQQ	ETF	101.49	101.58	100.99	101.19	3832141.0
2015-09-30 12:00:00	QQQ	ETF	101.19	101.27	100.5	100.7101	3695145.0
2015-09-30 13:00:00	QQQ	ETF	100.7	101.62	100.7	101.53	3086094.0
2015-09-30 14:00:00	QQQ	ETF	101.53	101.59	101.06	101.54	3332638.0
2015-09-30 15:00:00	QQQ	ETF	101.54	101.85	101.2	101.73	9357838.0
2015-09-30 16:00:00	QQQ	ETF	101.73	101.79	101.43	101.49	1413373.0
2015-09-30 17:00:00	QQQ	ETF	101.47	101.76	101.38	101.41	199494.0
2015-09-30 18:00:00	QQQ	ETF	101.47	101.59	101.44	101.48	48494.0
2015-09-30 19:00:00	QQQ	ETF	101.55	101.59	101.52	101.52	55050.0
2015-09-30 04:00:00	IWM	ETF	108.2	108.29	108.11	108.29	820.0
2015-09-30 06:00:00	IWM	ETF	108.52	108.52	108.52	108.52	100.0
2015-09-30 07:00:00	IWM	ETF	108.6	108.82	108.6	108.61	67964.0
2015-09-30 08:00:00	IWM	ETF	108.79	108.82	108.57	108.62	248704.0
2015-09-30 09:00:00	IWM	ETF	108.63	109.04	108.375	108.42	4529321.0
2015-09-30 10:00:00	IWM	ETF	108.43	109.11	108.4211	108.66	5936902.0
2015-09-30 11:00:00	IWM	ETF	108.67	108.81	108.2	108.33	5207832.0
2015-09-30 12:00:00	IWM	ETF	108.35	108.439	107.91	108.23	4158980.0
2015-09-30 13:00:00	IWM	ETF	108.23	108.85	108.215	108.755	3172463.0
2015-09-30 14:00:00	IWM	ETF	108.75	109.01	108.49	108.95	3525286.0
2015-09-30 15:00:00	IWM	ETF	108.94	109.43	108.76	109.2	13035500.0
2015-09-30 16:00:00	IWM	ETF	109.2	109.32	108.6948	109.05	2665175.0
2015-09-30 17:00:00	IWM	ETF	109.13	109.2	109.11	109.12	633077.0
2015-09-30 18:00:00	IWM	ETF	109.16	109.16	109.1	109.1	1000.0
2015-09-30 19:00:00	IWM	ETF	109.1	109.1	109.05	109.05	600.0
2015-09-30 04:00:00	DIA	ETF	161.83	162.03	161.83	162.03	600.0
2015-09-30 06:00:00	DIA	ETF	161.97	161.97	161.97	161.97	100.0
2015-09-30 07:00:00	DIA	ETF	162.2	162.27	162.08	162.08	2100.0

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

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