PREVIEW / etf_1hour / 2014-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-09.parquet
  size:    218 KB
  rows:    6,841

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
2014-01-09 04:00:00	SPY	ETF	183.57	184.13	183.57	184.13	47668.0
2014-01-09 05:00:00	SPY	ETF	184.14	184.21	184.09	184.14	77197.0
2014-01-09 06:00:00	SPY	ETF	184.17	184.17	184.06	184.08	13653.0
2014-01-09 07:00:00	SPY	ETF	184.03	184.15	184.03	184.06	44421.0
2014-01-09 08:00:00	SPY	ETF	184.07	184.12	183.88	183.92	955678.0
2014-01-09 09:00:00	SPY	ETF	183.91	184.13	183.77	184.03	7844039.0
2014-01-09 10:00:00	SPY	ETF	184.03	184.1	182.93	183.12	18935795.0
2014-01-09 11:00:00	SPY	ETF	183.12	183.22	182.795	183.18	16305455.0
2014-01-09 12:00:00	SPY	ETF	183.18	183.59	183.13	183.59	7116498.0
2014-01-09 13:00:00	SPY	ETF	183.58	183.61	183.23	183.27	7363249.0
2014-01-09 14:00:00	SPY	ETF	183.27	183.55	182.98	183.42	8007029.0
2014-01-09 15:00:00	SPY	ETF	183.41	183.77	183.37	183.63	14459534.0
2014-01-09 16:00:00	SPY	ETF	183.64	184.03	183.5478	184.03	8266171.0
2014-01-09 17:00:00	SPY	ETF	184.04	184.04	183.67	183.71	99063.0
2014-01-09 18:00:00	SPY	ETF	183.71	183.71	183.63	183.67	38289.0
2014-01-09 19:00:00	SPY	ETF	183.67	183.73	183.67	183.69	95300.0
2014-01-09 04:00:00	QQQ	ETF	87.5	87.66	87.5	87.66	7940.0
2014-01-09 05:00:00	QQQ	ETF	87.67	87.69	87.66	87.69	3100.0
2014-01-09 06:00:00	QQQ	ETF	87.69	87.69	87.62	87.62	5300.0
2014-01-09 07:00:00	QQQ	ETF	87.63	87.67	87.61	87.62	20350.0
2014-01-09 08:00:00	QQQ	ETF	87.63	87.64	87.52	87.55	229595.0
2014-01-09 09:00:00	QQQ	ETF	87.55	87.66	87.439	87.56	2713033.0
2014-01-09 10:00:00	QQQ	ETF	87.56	87.61	86.87	86.96	5454002.0
2014-01-09 11:00:00	QQQ	ETF	86.95	86.98	86.76	86.93	3610529.0
2014-01-09 12:00:00	QQQ	ETF	86.93	87.15	86.88	87.12	2012941.0
2014-01-09 13:00:00	QQQ	ETF	87.12	87.13	86.88	86.8999	1746479.0
2014-01-09 14:00:00	QQQ	ETF	86.89	87.03	86.72	86.95	2602636.0
2014-01-09 15:00:00	QQQ	ETF	86.95	87.1	86.91	87.01	3442432.0
2014-01-09 16:00:00	QQQ	ETF	87.01	87.556	86.97	87.05	627130.0
2014-01-09 17:00:00	QQQ	ETF	87.04	87.07	87.04	87.06	7550.0
2014-01-09 18:00:00	QQQ	ETF	87.06	87.07	87.04	87.04	1998.0
2014-01-09 19:00:00	QQQ	ETF	87.05	87.1	87.05	87.09	16785.0
2014-01-09 04:00:00	IWM	ETF	115.15	115.15	115.15	115.15	100.0
2014-01-09 06:00:00	IWM	ETF	115.38	115.38	115.31	115.31	5700.0
2014-01-09 07:00:00	IWM	ETF	115.27	115.33	115.26	115.3	26100.0
2014-01-09 08:00:00	IWM	ETF	115.29	115.36	115.16	115.17	277409.0
2014-01-09 09:00:00	IWM	ETF	115.18	115.39	115.02	115.29	2694585.0
2014-01-09 10:00:00	IWM	ETF	115.29	115.34	114.3	114.43	5313731.0
2014-01-09 11:00:00	IWM	ETF	114.43	114.55	114.16	114.52	3443732.0
2014-01-09 12:00:00	IWM	ETF	114.51	115.08	114.44	114.98	3026510.0
2014-01-09 13:00:00	IWM	ETF	114.98	114.99	114.67	114.7	1967871.0
2014-01-09 14:00:00	IWM	ETF	114.6901	114.77	114.28	114.65	4059426.0
2014-01-09 15:00:00	IWM	ETF	114.65	114.95	114.53	114.87	5722648.0
2014-01-09 16:00:00	IWM	ETF	114.88	114.92	114.66	114.82	1240178.0
2014-01-09 17:00:00	IWM	ETF	115.38	115.38	114.88	114.88	6000.0
2014-01-09 18:00:00	IWM	ETF	114.79	114.79	114.79	114.79	100.0
2014-01-09 19:00:00	IWM	ETF	114.85	114.85	114.84	114.84	400.0
2014-01-09 06:00:00	DIA	ETF	165.2	165.2	165.18	165.18	500.0
2014-01-09 07:00:00	DIA	ETF	164.9	164.92	164.9	164.92	4100.0
2014-01-09 08:00:00	DIA	ETF	164.9	164.96	164.8	164.82	13455.0

> showing 50 of 6,841 rows — these rows as CSV

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