PREVIEW / etf_1hour / 2012-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-09-24.parquet
  size:    189 KB
  rows:    5,900

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-09-24 04:00:00	SPY	ETF	145.66	145.66	145.31	145.32	16251.0
2012-09-24 05:00:00	SPY	ETF	145.3	145.31	145.07	145.1	34150.0
2012-09-24 06:00:00	SPY	ETF	145.07	145.19	145.07	145.17	24790.0
2012-09-24 07:00:00	SPY	ETF	145.17	145.35	145.14	145.27	104235.0
2012-09-24 08:00:00	SPY	ETF	145.28	145.95	145.05	145.12	1058951.0
2012-09-24 09:00:00	SPY	ETF	145.13	145.415	145.04	145.3598	15525319.0
2012-09-24 10:00:00	SPY	ETF	145.35	145.8925	145.18	145.66	17291735.0
2012-09-24 11:00:00	SPY	ETF	145.66	145.74	145.39	145.5	8731669.0
2012-09-24 12:00:00	SPY	ETF	145.49	145.53	145.27	145.42	8689941.0
2012-09-24 13:00:00	SPY	ETF	145.425	145.47	145.27	145.34	5355869.0
2012-09-24 14:00:00	SPY	ETF	145.34	145.98	145.33	145.861	10579109.0
2012-09-24 15:00:00	SPY	ETF	145.87	145.91	145.52	145.6199	16442573.0
2012-09-24 16:00:00	SPY	ETF	145.61	145.8925	145.2739	145.74	8667663.0
2012-09-24 17:00:00	SPY	ETF	145.75	145.83	145.74	145.82	88710.0
2012-09-24 18:00:00	SPY	ETF	145.81	145.84	145.71	145.79	33800.0
2012-09-24 19:00:00	SPY	ETF	145.76	145.83	145.75	145.78	25469.0
2012-09-24 06:00:00	QQQ	ETF	69.86	69.86	69.85	69.85	350.0
2012-09-24 07:00:00	QQQ	ETF	69.85	69.93	69.83	69.87	67010.0
2012-09-24 08:00:00	QQQ	ETF	69.86	69.88	69.57	69.57	837412.0
2012-09-24 09:00:00	QQQ	ETF	69.58	69.77	69.42	69.74	4048931.0
2012-09-24 10:00:00	QQQ	ETF	69.73	69.79	69.49	69.74	4009020.0
2012-09-24 11:00:00	QQQ	ETF	69.74	69.78	69.53	69.62	2159720.0
2012-09-24 12:00:00	QQQ	ETF	69.62	69.64	69.5	69.6	1935666.0
2012-09-24 13:00:00	QQQ	ETF	69.61	69.62	69.45	69.49	1548809.0
2012-09-24 14:00:00	QQQ	ETF	69.4899	69.8499	69.48	69.8	3169073.0
2012-09-24 15:00:00	QQQ	ETF	69.8	69.86	69.67	69.7	6089950.0
2012-09-24 16:00:00	QQQ	ETF	69.68	69.8	69.66	69.75	6004796.0
2012-09-24 17:00:00	QQQ	ETF	69.75	69.8	69.75	69.76	42500.0
2012-09-24 18:00:00	QQQ	ETF	69.79	69.79	69.74	69.77	9968.0
2012-09-24 19:00:00	QQQ	ETF	69.77	69.77	69.74	69.76	70018.0
2012-09-24 04:00:00	IWM	ETF	85.29	85.29	84.95	84.95	3800.0
2012-09-24 05:00:00	IWM	ETF	84.94	84.94	84.94	84.94	500.0
2012-09-24 07:00:00	IWM	ETF	84.96	84.99	84.9	84.98	26450.0
2012-09-24 08:00:00	IWM	ETF	84.98	85.23	84.78	84.84	138952.0
2012-09-24 09:00:00	IWM	ETF	84.86	84.99	84.74	84.9	3958704.0
2012-09-24 10:00:00	IWM	ETF	84.91	85.4	84.865	85.33	5607736.0
2012-09-24 11:00:00	IWM	ETF	85.33	85.43	84.975	85.055	3734824.0
2012-09-24 12:00:00	IWM	ETF	85.05	85.05	84.835	84.88	3313056.0
2012-09-24 13:00:00	IWM	ETF	84.89	84.89	84.6	84.681	2647235.0
2012-09-24 14:00:00	IWM	ETF	84.68	85.27	84.675	85.08	5348987.0
2012-09-24 15:00:00	IWM	ETF	85.08	85.1	84.72	84.92	6989737.0
2012-09-24 16:00:00	IWM	ETF	84.91	85.36	84.8486	84.99	3182805.0
2012-09-24 17:00:00	IWM	ETF	85.0	85.05	84.92	84.97	7750.0
2012-09-24 18:00:00	IWM	ETF	84.99	85.01	84.99	85.01	700.0
2012-09-24 19:00:00	IWM	ETF	84.99	84.99	84.98	84.98	5064.0
2012-09-24 05:00:00	DIA	ETF	135.06	135.06	135.06	135.06	124.0
2012-09-24 07:00:00	DIA	ETF	134.94	135.01	134.94	134.96	3900.0
2012-09-24 08:00:00	DIA	ETF	134.96	135.0	134.87	134.98	9817.0
2012-09-24 09:00:00	DIA	ETF	134.93	135.17	134.88	135.089	522814.0
2012-09-24 10:00:00	DIA	ETF	135.115	135.37	134.91	135.27	437286.0

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

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