PREVIEW / etf_1hour / 2012-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-24.parquet
  size:    185 KB
  rows:    5,742

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-10-24 04:00:00	SPY	ETF	141.27	141.6	141.22	141.6	12276.0
2012-10-24 05:00:00	SPY	ETF	141.58	141.69	141.58	141.65	61300.0
2012-10-24 06:00:00	SPY	ETF	141.61	141.82	141.54	141.74	18283.0
2012-10-24 07:00:00	SPY	ETF	141.69	141.8	141.5	141.78	1025099.0
2012-10-24 08:00:00	SPY	ETF	141.79	141.95	141.69	141.92	1894348.0
2012-10-24 09:00:00	SPY	ETF	141.91	142.12	141.58	141.74	13119251.0
2012-10-24 10:00:00	SPY	ETF	141.74	141.84	141.36	141.67	17902538.0
2012-10-24 11:00:00	SPY	ETF	141.67	141.81	141.27	141.31	12408984.0
2012-10-24 12:00:00	SPY	ETF	141.3	141.69	141.24	141.66	9110203.0
2012-10-24 13:00:00	SPY	ETF	141.655	141.72	141.49	141.55	6911903.0
2012-10-24 14:00:00	SPY	ETF	141.555	141.75	141.13	141.27	15561710.0
2012-10-24 15:00:00	SPY	ETF	141.27	141.38	140.8	141.01	27766361.0
2012-10-24 16:00:00	SPY	ETF	141.01	141.6157	140.95	141.29	11265935.0
2012-10-24 17:00:00	SPY	ETF	141.29	141.33	141.25	141.31	1026122.0
2012-10-24 18:00:00	SPY	ETF	141.31	141.34	141.15	141.2	117232.0
2012-10-24 19:00:00	SPY	ETF	141.19	141.21	141.12	141.14	134738.0
2012-10-24 04:00:00	QQQ	ETF	65.37	65.51	65.33	65.51	2187.0
2012-10-24 05:00:00	QQQ	ETF	65.49	65.49	65.49	65.49	5000.0
2012-10-24 06:00:00	QQQ	ETF	65.59	65.59	65.56	65.56	30100.0
2012-10-24 07:00:00	QQQ	ETF	65.54	65.6	65.48	65.6	55920.0
2012-10-24 08:00:00	QQQ	ETF	65.62	65.72	65.33	65.7	265756.0
2012-10-24 09:00:00	QQQ	ETF	65.69	65.89	65.53	65.67	4305453.0
2012-10-24 10:00:00	QQQ	ETF	65.66	65.72	65.36	65.385	5367427.0
2012-10-24 11:00:00	QQQ	ETF	65.3801	65.47	65.13	65.1601	3407710.0
2012-10-24 12:00:00	QQQ	ETF	65.16	65.43	65.1	65.39	3076332.0
2012-10-24 13:00:00	QQQ	ETF	65.395	65.43	65.29	65.37	2159262.0
2012-10-24 14:00:00	QQQ	ETF	65.37	65.48	65.17	65.28	4690902.0
2012-10-24 15:00:00	QQQ	ETF	65.28	65.33	65.06	65.12	8125230.0
2012-10-24 16:00:00	QQQ	ETF	65.12	65.3775	65.1	65.26	3640764.0
2012-10-24 17:00:00	QQQ	ETF	65.25	65.3775	65.25	65.26	509326.0
2012-10-24 18:00:00	QQQ	ETF	65.26	65.3	65.24	65.24	9200.0
2012-10-24 19:00:00	QQQ	ETF	65.24	65.24	65.2	65.2	22510.0
2012-10-24 07:00:00	IWM	ETF	81.47	81.57	81.44	81.57	39300.0
2012-10-24 08:00:00	IWM	ETF	81.58	81.8	81.55	81.74	243151.0
2012-10-24 09:00:00	IWM	ETF	81.7	81.88	81.1699	81.34	3878889.0
2012-10-24 10:00:00	IWM	ETF	81.335	81.43	80.96	81.27	5376429.0
2012-10-24 11:00:00	IWM	ETF	81.26	81.39	81.04	81.07	1946488.0
2012-10-24 12:00:00	IWM	ETF	81.07	81.35	81.04	81.32	1404177.0
2012-10-24 13:00:00	IWM	ETF	81.33	81.35	81.18	81.28	1067851.0
2012-10-24 14:00:00	IWM	ETF	81.27	81.39	81.1	81.21	3128326.0
2012-10-24 15:00:00	IWM	ETF	81.21	81.285	80.91	81.19	5233897.0
2012-10-24 16:00:00	IWM	ETF	81.2	81.4	81.19	81.37	1058767.0
2012-10-24 17:00:00	IWM	ETF	81.34	81.79	81.01	81.3	17973.0
2012-10-24 18:00:00	IWM	ETF	81.39	81.39	81.32	81.34	600.0
2012-10-24 19:00:00	IWM	ETF	81.34	81.34	81.34	81.34	1900.0
2012-10-24 07:00:00	DIA	ETF	131.01	131.08	131.0	131.08	1900.0
2012-10-24 08:00:00	DIA	ETF	131.17	131.28	131.06	131.06	7800.0
2012-10-24 09:00:00	DIA	ETF	131.13	131.27	130.85	131.04	705786.0
2012-10-24 10:00:00	DIA	ETF	131.0	131.23	130.77	131.15	1094012.0
2012-10-24 11:00:00	DIA	ETF	131.15	131.25	130.79	130.814	537448.0

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

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