PREVIEW / etf_1hour / 2012-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-17.parquet
  size:    183 KB
  rows:    5,644

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-17 04:00:00	SPY	ETF	137.23	137.46	137.17	137.46	8800.0
2012-04-17 05:00:00	SPY	ETF	137.47	137.71	137.44	137.44	55350.0
2012-04-17 06:00:00	SPY	ETF	137.45	137.78	137.44	137.66	195630.0
2012-04-17 07:00:00	SPY	ETF	137.62	137.85	137.54	137.59	661403.0
2012-04-17 08:00:00	SPY	ETF	137.6	137.81	136.975	137.79	1933830.0
2012-04-17 09:00:00	SPY	ETF	137.78	138.15	137.75	137.95	19267578.0
2012-04-17 10:00:00	SPY	ETF	137.94	138.65	137.698	138.578	24304293.0
2012-04-17 11:00:00	SPY	ETF	138.58	138.93	138.58	138.82	18317591.0
2012-04-17 12:00:00	SPY	ETF	138.82	139.2	138.82	139.1	12321945.0
2012-04-17 13:00:00	SPY	ETF	139.11	139.25	139.06	139.172	8421169.0
2012-04-17 14:00:00	SPY	ETF	139.18	139.36	139.12	139.23	12890089.0
2012-04-17 15:00:00	SPY	ETF	139.23	139.35	139.06	139.09	26858748.0
2012-04-17 16:00:00	SPY	ETF	139.08	139.1791	137.02	138.85	16714908.0
2012-04-17 17:00:00	SPY	ETF	138.83	139.1398	138.78	138.84	3902586.0
2012-04-17 18:00:00	SPY	ETF	138.82	138.93	138.81	138.89	170038.0
2012-04-17 19:00:00	SPY	ETF	138.87	138.98	138.87	138.98	80471.0
2012-04-17 05:00:00	QQQ	ETF	65.7	65.72	65.66	65.72	60100.0
2012-04-17 06:00:00	QQQ	ETF	65.65	65.7	65.65	65.7	300.0
2012-04-17 07:00:00	QQQ	ETF	65.69	65.73	65.63	65.63	61150.0
2012-04-17 08:00:00	QQQ	ETF	65.72	65.8	65.6	65.76	817658.0
2012-04-17 09:00:00	QQQ	ETF	65.77	66.12	65.47	66.08	7027963.0
2012-04-17 10:00:00	QQQ	ETF	66.09	66.4	65.95	66.36	6600449.0
2012-04-17 11:00:00	QQQ	ETF	66.362	66.58	66.36	66.52	6205444.0
2012-04-17 12:00:00	QQQ	ETF	66.51	66.8	66.51	66.749	5306678.0
2012-04-17 13:00:00	QQQ	ETF	66.75	66.87	66.69	66.835	3777637.0
2012-04-17 14:00:00	QQQ	ETF	66.83	66.94	66.83	66.885	3975423.0
2012-04-17 15:00:00	QQQ	ETF	66.89	66.99	66.77	66.78	8650875.0
2012-04-17 16:00:00	QQQ	ETF	66.77	66.904	66.58	66.65	2244830.0
2012-04-17 17:00:00	QQQ	ETF	66.64	66.66	66.59	66.64	59570.0
2012-04-17 18:00:00	QQQ	ETF	66.65	66.7	66.65	66.69	17030.0
2012-04-17 19:00:00	QQQ	ETF	66.67	66.73	66.67	66.73	11178.0
2012-04-17 04:00:00	IWM	ETF	79.72	79.72	79.72	79.72	100.0
2012-04-17 05:00:00	IWM	ETF	80.01	80.01	80.01	80.01	100.0
2012-04-17 06:00:00	IWM	ETF	80.15	80.15	80.15	80.15	600.0
2012-04-17 07:00:00	IWM	ETF	80.12	80.29	80.11	80.15	127350.0
2012-04-17 08:00:00	IWM	ETF	80.16	80.35	80.04	80.32	500108.0
2012-04-17 09:00:00	IWM	ETF	80.33	80.82	80.25	80.68	5103912.0
2012-04-17 10:00:00	IWM	ETF	80.68	81.07	80.43	81.05	6306794.0
2012-04-17 11:00:00	IWM	ETF	81.05	81.27	81.03	81.09	4694654.0
2012-04-17 12:00:00	IWM	ETF	81.08	81.33	81.08	81.225	3203370.0
2012-04-17 13:00:00	IWM	ETF	81.21	81.43	81.17	81.395	3178257.0
2012-04-17 14:00:00	IWM	ETF	81.4	81.55	81.27	81.32	3140692.0
2012-04-17 15:00:00	IWM	ETF	81.32	81.45	80.84	80.84	9265258.0
2012-04-17 16:00:00	IWM	ETF	80.84	81.295	80.63	80.63	3096164.0
2012-04-17 17:00:00	IWM	ETF	80.67	80.69	80.62	80.62	79625.0
2012-04-17 19:00:00	IWM	ETF	80.78	80.78	80.78	80.78	100.0
2012-04-17 05:00:00	DIA	ETF	129.48	129.48	129.48	129.48	100.0
2012-04-17 07:00:00	DIA	ETF	129.64	129.64	129.54	129.54	3100.0
2012-04-17 08:00:00	DIA	ETF	129.6	129.68	129.5	129.67	4600.0
2012-04-17 09:00:00	DIA	ETF	129.7	130.4	129.7	130.03	1057602.0

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

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