PREVIEW / etf_1hour / 2012-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-16.parquet
  size:    182 KB
  rows:    5,667

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-04-16 04:00:00	SPY	ETF	137.0	137.29	136.87	137.29	58520.0
2012-04-16 05:00:00	SPY	ETF	137.24	137.43	137.17	137.43	63899.0
2012-04-16 06:00:00	SPY	ETF	137.49	137.59	137.42	137.45	71794.0
2012-04-16 07:00:00	SPY	ETF	137.43	137.5	137.11	137.17	669562.0
2012-04-16 08:00:00	SPY	ETF	137.17	137.84	136.65	137.7	3692591.0
2012-04-16 09:00:00	SPY	ETF	137.71	138.04	137.21	137.27	22167625.0
2012-04-16 10:00:00	SPY	ETF	137.27	137.3	136.58	137.035	35336692.0
2012-04-16 11:00:00	SPY	ETF	137.035	137.22	136.72	136.78	15375166.0
2012-04-16 12:00:00	SPY	ETF	136.77	137.18	136.68	137.15	14351294.0
2012-04-16 13:00:00	SPY	ETF	137.15	137.68	136.94	137.5686	15137871.0
2012-04-16 14:00:00	SPY	ETF	137.56	137.6	137.28	137.31	12774874.0
2012-04-16 15:00:00	SPY	ETF	137.31	137.36	136.98	136.99	21981005.0
2012-04-16 16:00:00	SPY	ETF	136.98	137.0972	136.78	136.99	3999105.0
2012-04-16 17:00:00	SPY	ETF	136.99	136.99	136.93	136.97	82968.0
2012-04-16 18:00:00	SPY	ETF	136.94	136.95	136.9	136.95	103349.0
2012-04-16 19:00:00	SPY	ETF	136.94	136.96	136.89	136.94	58740.0
2012-04-16 04:00:00	QQQ	ETF	66.19	66.19	66.19	66.19	700.0
2012-04-16 06:00:00	QQQ	ETF	66.37	66.37	66.32	66.33	28500.0
2012-04-16 07:00:00	QQQ	ETF	66.34	66.35	66.2	66.2	111600.0
2012-04-16 08:00:00	QQQ	ETF	66.23	66.54	66.21	66.5	371708.0
2012-04-16 09:00:00	QQQ	ETF	66.49	66.56	65.45	65.53	11436557.0
2012-04-16 10:00:00	QQQ	ETF	65.52	65.78	65.24	65.67	14860484.0
2012-04-16 11:00:00	QQQ	ETF	65.66	65.72	65.4	65.42	4406431.0
2012-04-16 12:00:00	QQQ	ETF	65.41	65.6	65.34	65.55	3301562.0
2012-04-16 13:00:00	QQQ	ETF	65.545	65.74	65.39	65.67	4780259.0
2012-04-16 14:00:00	QQQ	ETF	65.67	65.84	65.55	65.65	3702259.0
2012-04-16 15:00:00	QQQ	ETF	65.65	65.67	65.37	65.48	8586796.0
2012-04-16 16:00:00	QQQ	ETF	65.47	66.1902	65.43	65.46	2748682.0
2012-04-16 17:00:00	QQQ	ETF	65.47	65.47	65.44	65.46	23850.0
2012-04-16 18:00:00	QQQ	ETF	65.46	65.46	65.42	65.43	11951.0
2012-04-16 19:00:00	QQQ	ETF	65.43	65.43	65.4	65.41	14599.0
2012-04-16 07:00:00	IWM	ETF	79.74	79.76	79.44	79.46	118200.0
2012-04-16 08:00:00	IWM	ETF	79.45	79.88	79.32	79.77	1188019.0
2012-04-16 09:00:00	IWM	ETF	79.77	80.12	79.31	79.34	6753454.0
2012-04-16 10:00:00	IWM	ETF	79.34	79.56	78.88	79.39	8981078.0
2012-04-16 11:00:00	IWM	ETF	79.39	79.54	79.26	79.35	3783203.0
2012-04-16 12:00:00	IWM	ETF	79.34	79.73	79.31	79.71	3378560.0
2012-04-16 13:00:00	IWM	ETF	79.7004	80.2	79.53	80.1	4808709.0
2012-04-16 14:00:00	IWM	ETF	80.11	80.1477	79.86	79.94	3385696.0
2012-04-16 15:00:00	IWM	ETF	79.94	79.97	79.51	79.65	4785296.0
2012-04-16 16:00:00	IWM	ETF	79.66	79.69	79.3368	79.68	3486537.0
2012-04-16 17:00:00	IWM	ETF	79.65	79.65	79.6	79.62	23283.0
2012-04-16 18:00:00	IWM	ETF	79.57	79.57	79.57	79.57	300.0
2012-04-16 19:00:00	IWM	ETF	79.58	79.61	79.58	79.61	3100.0
2012-04-16 04:00:00	DIA	ETF	127.99	127.99	127.99	127.99	150.0
2012-04-16 07:00:00	DIA	ETF	128.81	128.81	128.65	128.65	1300.0
2012-04-16 08:00:00	DIA	ETF	128.6	129.15	128.6	129.1	8400.0
2012-04-16 09:00:00	DIA	ETF	129.14	129.58	129.14	129.27	873345.0
2012-04-16 10:00:00	DIA	ETF	129.27	129.3	128.675	128.955	1705500.0
2012-04-16 11:00:00	DIA	ETF	128.96	129.15	128.75	128.77	776130.0

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

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