PREVIEW / etf_1hour / 2011-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-12.parquet
  size:    176 KB
  rows:    5,479

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
2011-01-12 04:00:00	SPY	ETF	127.92	128.33	127.92	128.33	28900.0
2011-01-12 05:00:00	SPY	ETF	128.35	128.36	128.17	128.17	5100.0
2011-01-12 06:00:00	SPY	ETF	128.12	128.2	128.0	128.12	59750.0
2011-01-12 07:00:00	SPY	ETF	128.16	128.21	128.07	128.18	521267.0
2011-01-12 08:00:00	SPY	ETF	128.18	128.38	127.62	128.21	2488214.0
2011-01-12 09:00:00	SPY	ETF	128.21	128.26	127.99	128.1	11533993.0
2011-01-12 10:00:00	SPY	ETF	128.09	128.44	128.04	128.425	14943155.0
2011-01-12 11:00:00	SPY	ETF	128.425	128.67	128.4	128.56	16199922.0
2011-01-12 12:00:00	SPY	ETF	128.56	128.72	128.51	128.51	11873913.0
2011-01-12 13:00:00	SPY	ETF	128.51	128.62	128.46	128.61	6638062.0
2011-01-12 14:00:00	SPY	ETF	128.61	128.62	128.48	128.55	10898296.0
2011-01-12 15:00:00	SPY	ETF	128.55	128.6	128.3	128.6	23100313.0
2011-01-12 16:00:00	SPY	ETF	128.6	128.8	128.065	128.66	7786787.0
2011-01-12 17:00:00	SPY	ETF	128.67	128.73	128.66	128.69	174064.0
2011-01-12 18:00:00	SPY	ETF	128.69	128.69	128.59	128.63	549883.0
2011-01-12 19:00:00	SPY	ETF	128.66	128.69	128.62	128.68	34812.0
2011-01-12 04:00:00	QQQ	ETF	56.27	56.5	56.27	56.5	600.0
2011-01-12 05:00:00	QQQ	ETF	56.48	56.48	56.45	56.46	3500.0
2011-01-12 06:00:00	QQQ	ETF	56.42	56.46	56.42	56.43	13950.0
2011-01-12 07:00:00	QQQ	ETF	56.43	56.47	56.39	56.44	60109.0
2011-01-12 08:00:00	QQQ	ETF	56.43	56.52	56.41	56.42	333023.0
2011-01-12 09:00:00	QQQ	ETF	56.42	56.45	56.2	56.29	7051100.0
2011-01-12 10:00:00	QQQ	ETF	56.3	56.4	56.24	56.39	6537070.0
2011-01-12 11:00:00	QQQ	ETF	56.39	56.52	56.38	56.46	7114514.0
2011-01-12 12:00:00	QQQ	ETF	56.46	56.51	56.42	56.4299	3672522.0
2011-01-12 13:00:00	QQQ	ETF	56.42	56.55	56.42	56.535	5620715.0
2011-01-12 14:00:00	QQQ	ETF	56.53	56.54	56.46	56.49	3884040.0
2011-01-12 15:00:00	QQQ	ETF	56.485	56.56	56.43	56.559	6610909.0
2011-01-12 16:00:00	QQQ	ETF	56.56	56.66	56.4399	56.58	1430881.0
2011-01-12 17:00:00	QQQ	ETF	56.58	56.6	56.57	56.58	27276.0
2011-01-12 18:00:00	QQQ	ETF	56.58	56.6	56.57	56.57	20474.0
2011-01-12 19:00:00	QQQ	ETF	56.6	56.61	56.57	56.57	26942.0
2011-01-12 04:00:00	IWM	ETF	79.98	80.02	79.98	80.02	700.0
2011-01-12 05:00:00	IWM	ETF	80.0	80.0	79.97	79.97	1100.0
2011-01-12 06:00:00	IWM	ETF	79.96	79.96	79.91	79.91	10000.0
2011-01-12 07:00:00	IWM	ETF	79.94	79.98	79.84	79.93	102662.0
2011-01-12 08:00:00	IWM	ETF	79.94	80.08	79.91	79.92	411605.0
2011-01-12 09:00:00	IWM	ETF	79.92	80.02	79.51	79.67	5960689.0
2011-01-12 10:00:00	IWM	ETF	79.67	79.9301	79.55	79.902	5695770.0
2011-01-12 11:00:00	IWM	ETF	79.91	80.13	79.85	80.04	4979209.0
2011-01-12 12:00:00	IWM	ETF	80.04	80.1	79.89	79.94	3032628.0
2011-01-12 13:00:00	IWM	ETF	79.95	80.04	79.9	80.025	1905111.0
2011-01-12 14:00:00	IWM	ETF	80.02	80.05	79.905	79.99	3380656.0
2011-01-12 15:00:00	IWM	ETF	79.98	80.03	79.66	79.94	9556231.0
2011-01-12 16:00:00	IWM	ETF	79.95	80.1	79.8936	80.04	595016.0
2011-01-12 17:00:00	IWM	ETF	80.06	80.08	80.04	80.05	11983.0
2011-01-12 18:00:00	IWM	ETF	80.08	80.08	79.99	79.99	2000.0
2011-01-12 19:00:00	IWM	ETF	80.03	80.08	80.0	80.04	3000.0
2011-01-12 04:00:00	DIA	ETF	117.21	117.27	117.21	117.27	6000.0
2011-01-12 05:00:00	DIA	ETF	117.23	117.23	117.23	117.23	3200.0

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

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