PREVIEW / etf_1hour / 2012-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-19.parquet
  size:    191 KB
  rows:    5,836

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
2012-10-19 04:00:00	SPY	ETF	145.51	145.51	145.44	145.44	13000.0
2012-10-19 05:00:00	SPY	ETF	145.52	145.63	145.51	145.51	15800.0
2012-10-19 06:00:00	SPY	ETF	145.51	145.52	145.33	145.41	95933.0
2012-10-19 07:00:00	SPY	ETF	145.44	145.46	145.3	145.45	133455.0
2012-10-19 08:00:00	SPY	ETF	145.43	145.86	145.3	145.43	1303837.0
2012-10-19 09:00:00	SPY	ETF	145.42	145.56	144.85	145.04	20783637.0
2012-10-19 10:00:00	SPY	ETF	145.04	145.12	144.7	144.78	20022461.0
2012-10-19 11:00:00	SPY	ETF	144.78	144.81	144.0	144.16	23057751.0
2012-10-19 12:00:00	SPY	ETF	144.17	144.18	143.66	143.84	19341993.0
2012-10-19 13:00:00	SPY	ETF	143.83	144.03	143.3	143.43	16855148.0
2012-10-19 14:00:00	SPY	ETF	143.43	143.57	143.05	143.41	20897370.0
2012-10-19 15:00:00	SPY	ETF	143.41	143.71	143.18	143.35	41056940.0
2012-10-19 16:00:00	SPY	ETF	143.33	144.8	142.65	143.08	17981530.0
2012-10-19 17:00:00	SPY	ETF	143.08	143.12	143.03	143.11	1919550.0
2012-10-19 18:00:00	SPY	ETF	143.12	143.2	143.06	143.07	151993.0
2012-10-19 19:00:00	SPY	ETF	143.1	143.14	143.06	143.1	33648.0
2012-10-19 04:00:00	QQQ	ETF	67.05	67.05	67.05	67.05	400.0
2012-10-19 05:00:00	QQQ	ETF	67.06	67.06	67.06	67.06	200.0
2012-10-19 06:00:00	QQQ	ETF	67.03	67.03	67.0	67.0	17700.0
2012-10-19 07:00:00	QQQ	ETF	67.02	67.04	66.93	67.04	81150.0
2012-10-19 08:00:00	QQQ	ETF	67.07	67.1	67.02	67.07	924072.0
2012-10-19 09:00:00	QQQ	ETF	67.08	67.27	66.73	66.925	5719706.0
2012-10-19 10:00:00	QQQ	ETF	66.92	66.95	66.51	66.579	5140699.0
2012-10-19 11:00:00	QQQ	ETF	66.58	66.61	65.97	66.08	10025362.0
2012-10-19 12:00:00	QQQ	ETF	66.085	66.11	65.81	65.91	7600776.0
2012-10-19 13:00:00	QQQ	ETF	65.91	66.0381	65.69	65.77	5085135.0
2012-10-19 14:00:00	QQQ	ETF	65.77	65.85	65.6	65.73	6159670.0
2012-10-19 15:00:00	QQQ	ETF	65.73	65.86	65.61	65.68	11713461.0
2012-10-19 16:00:00	QQQ	ETF	65.68	67.294	65.49	65.6	4525273.0
2012-10-19 17:00:00	QQQ	ETF	65.6	67.294	65.51	65.55	3995251.0
2012-10-19 18:00:00	QQQ	ETF	65.55	65.59	65.53	65.57	2700.0
2012-10-19 19:00:00	QQQ	ETF	65.57	65.6	65.55	65.55	4887.0
2012-10-19 04:00:00	IWM	ETF	83.24	83.24	83.24	83.24	100.0
2012-10-19 07:00:00	IWM	ETF	82.95	82.95	82.78	82.87	17400.0
2012-10-19 08:00:00	IWM	ETF	82.89	82.93	82.78	82.88	288962.0
2012-10-19 09:00:00	IWM	ETF	82.9	82.94	82.49	82.815	7451684.0
2012-10-19 10:00:00	IWM	ETF	82.8	82.83	82.59	82.695	4341509.0
2012-10-19 11:00:00	IWM	ETF	82.7	82.72	82.1	82.16	7412642.0
2012-10-19 12:00:00	IWM	ETF	82.16	82.16	81.59	81.77	6139008.0
2012-10-19 13:00:00	IWM	ETF	81.77	82.01	81.495	81.57	3901153.0
2012-10-19 14:00:00	IWM	ETF	81.58	81.78	81.47	81.7213	5107525.0
2012-10-19 15:00:00	IWM	ETF	81.72	82.03	81.59	81.84	9417240.0
2012-10-19 16:00:00	IWM	ETF	81.83	82.1	81.46	81.62	3279836.0
2012-10-19 17:00:00	IWM	ETF	81.63	81.64	81.56	81.56	7000.0
2012-10-19 18:00:00	IWM	ETF	81.61	81.64	81.61	81.64	300.0
2012-10-19 19:00:00	IWM	ETF	81.57	81.58	81.57	81.57	2576.0
2012-10-19 06:00:00	DIA	ETF	134.9	134.9	134.9	134.9	143.0
2012-10-19 07:00:00	DIA	ETF	134.9	134.9	134.86	134.86	400.0
2012-10-19 08:00:00	DIA	ETF	134.84	135.11	134.7	134.81	118142.0
2012-10-19 09:00:00	DIA	ETF	134.81	135.1	134.13	134.31	1567755.0

> showing 50 of 5,836 rows — these rows as CSV

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