PREVIEW / etf_1hour / 2012-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-07.parquet
  size:    185 KB
  rows:    5,732

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-03-07 04:00:00	SPY	ETF	135.09	135.28	135.02	135.19	7160.0
2012-03-07 05:00:00	SPY	ETF	135.17	135.37	135.17	135.35	29100.0
2012-03-07 06:00:00	SPY	ETF	135.24	135.32	135.24	135.31	55502.0
2012-03-07 07:00:00	SPY	ETF	135.26	135.34	135.13	135.25	313523.0
2012-03-07 08:00:00	SPY	ETF	135.25	135.39	135.0	135.36	1468737.0
2012-03-07 09:00:00	SPY	ETF	135.37	135.41	134.93	135.1585	17912201.0
2012-03-07 10:00:00	SPY	ETF	135.16	135.24	134.96	135.142	18017098.0
2012-03-07 11:00:00	SPY	ETF	135.15	135.68	135.15	135.64	25575573.0
2012-03-07 12:00:00	SPY	ETF	135.63	135.75	135.51	135.69	9729607.0
2012-03-07 13:00:00	SPY	ETF	135.69	135.72	135.47	135.581	12289933.0
2012-03-07 14:00:00	SPY	ETF	135.5801	135.78	135.53	135.73	14499673.0
2012-03-07 15:00:00	SPY	ETF	135.72	135.91	135.55	135.72	26819442.0
2012-03-07 16:00:00	SPY	ETF	135.71	135.81	134.7574	135.67	10047212.0
2012-03-07 17:00:00	SPY	ETF	134.7588	135.72	134.7588	135.65	1152452.0
2012-03-07 18:00:00	SPY	ETF	135.65	135.73	135.65	135.67	41879.0
2012-03-07 19:00:00	SPY	ETF	135.68	135.7	135.57	135.67	68311.0
2012-03-07 04:00:00	QQQ	ETF	63.83	63.83	63.81	63.81	500.0
2012-03-07 05:00:00	QQQ	ETF	63.89	63.89	63.89	63.89	150.0
2012-03-07 06:00:00	QQQ	ETF	63.85	63.89	63.85	63.89	8400.0
2012-03-07 07:00:00	QQQ	ETF	63.91	63.93	63.85	63.88	78620.0
2012-03-07 08:00:00	QQQ	ETF	63.87	63.95	63.84	63.93	312224.0
2012-03-07 09:00:00	QQQ	ETF	63.93	63.96	63.77	63.92	6554157.0
2012-03-07 10:00:00	QQQ	ETF	63.915	63.95	63.79	63.89	4972979.0
2012-03-07 11:00:00	QQQ	ETF	63.89	64.1	63.882	64.0979	4843232.0
2012-03-07 12:00:00	QQQ	ETF	64.1	64.21	64.085	64.1885	4151664.0
2012-03-07 13:00:00	QQQ	ETF	64.18	64.205	63.93	64.05	6308907.0
2012-03-07 14:00:00	QQQ	ETF	64.05	64.16	63.91	63.98	4747868.0
2012-03-07 15:00:00	QQQ	ETF	63.99	64.18	63.83	64.07	7632718.0
2012-03-07 16:00:00	QQQ	ETF	64.07	64.13	64.01	64.02	1170315.0
2012-03-07 17:00:00	QQQ	ETF	64.01	64.06	63.5821	64.03	1003050.0
2012-03-07 18:00:00	QQQ	ETF	64.03	64.04	64.0	64.0	4342.0
2012-03-07 19:00:00	QQQ	ETF	64.01	64.02	63.95	64.01	26720.0
2012-03-07 06:00:00	IWM	ETF	79.21	79.21	79.19	79.19	1200.0
2012-03-07 07:00:00	IWM	ETF	79.12	79.18	79.06	79.13	40636.0
2012-03-07 08:00:00	IWM	ETF	79.13	79.23	79.0	79.15	374613.0
2012-03-07 09:00:00	IWM	ETF	79.15	79.19	78.78	79.0	5253321.0
2012-03-07 10:00:00	IWM	ETF	79.0014	79.1	78.82	79.05	5456116.0
2012-03-07 11:00:00	IWM	ETF	79.06	79.45	79.06	79.3871	6034466.0
2012-03-07 12:00:00	IWM	ETF	79.38	79.48	79.25	79.38	2772115.0
2012-03-07 13:00:00	IWM	ETF	79.39	79.42	79.22	79.32	2425265.0
2012-03-07 14:00:00	IWM	ETF	79.33	79.51	79.24	79.42	3465954.0
2012-03-07 15:00:00	IWM	ETF	79.43	79.56	79.29	79.5	8775657.0
2012-03-07 16:00:00	IWM	ETF	79.5	79.55	79.42	79.42	1197861.0
2012-03-07 17:00:00	IWM	ETF	79.41	79.46	79.41	79.41	21500.0
2012-03-07 18:00:00	IWM	ETF	79.43	79.5	79.4	79.46	1950.0
2012-03-07 19:00:00	IWM	ETF	79.46	79.46	79.4	79.42	1500.0
2012-03-07 07:00:00	DIA	ETF	127.95	127.97	127.95	127.97	2200.0
2012-03-07 08:00:00	DIA	ETF	127.88	128.0	127.82	127.97	9200.0
2012-03-07 09:00:00	DIA	ETF	128.02	128.02	127.53	127.77	1111577.0
2012-03-07 10:00:00	DIA	ETF	127.7764	127.85	127.46	127.72	721319.0

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

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