PREVIEW / etf_1hour / 2012-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-04.parquet
  size:    184 KB
  rows:    5,777

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-12-04 04:00:00	SPY	ETF	141.16	141.49	141.16	141.41	20000.0
2012-12-04 05:00:00	SPY	ETF	141.41	141.6	141.41	141.5	6272.0
2012-12-04 06:00:00	SPY	ETF	141.45	141.54	141.45	141.49	39815.0
2012-12-04 07:00:00	SPY	ETF	141.49	141.65	141.43	141.58	336549.0
2012-12-04 08:00:00	SPY	ETF	141.58	141.64	141.09	141.3	1285130.0
2012-12-04 09:00:00	SPY	ETF	141.3	141.76	141.26	141.48	12301760.0
2012-12-04 10:00:00	SPY	ETF	141.48	141.87	141.21	141.32	20019266.0
2012-12-04 11:00:00	SPY	ETF	141.32	141.45	141.01	141.33	15760678.0
2012-12-04 12:00:00	SPY	ETF	141.34	141.34	140.935	141.09	15580801.0
2012-12-04 13:00:00	SPY	ETF	141.08	141.49	140.87	141.401	17243952.0
2012-12-04 14:00:00	SPY	ETF	141.41	141.51	141.17	141.26	14471109.0
2012-12-04 15:00:00	SPY	ETF	141.26	141.57	141.19	141.21	16645449.0
2012-12-04 16:00:00	SPY	ETF	141.22	141.4759	141.07	141.075	8058444.0
2012-12-04 17:00:00	SPY	ETF	141.08	141.2309	140.97	140.98	3109624.0
2012-12-04 18:00:00	SPY	ETF	140.98	141.02	140.86	141.02	901547.0
2012-12-04 19:00:00	SPY	ETF	140.99	141.12	140.92	141.07	99402.0
2012-12-04 05:00:00	QQQ	ETF	65.74	65.74	65.74	65.74	100.0
2012-12-04 06:00:00	QQQ	ETF	65.74	65.76	65.74	65.76	7200.0
2012-12-04 07:00:00	QQQ	ETF	65.77	65.8	65.74	65.77	13180.0
2012-12-04 08:00:00	QQQ	ETF	65.76	65.78	65.6	65.6	206915.0
2012-12-04 09:00:00	QQQ	ETF	65.59	65.72	65.52	65.56	4736583.0
2012-12-04 10:00:00	QQQ	ETF	65.56	65.73	65.275	65.4	7625162.0
2012-12-04 11:00:00	QQQ	ETF	65.4	65.62	65.2	65.53	4517435.0
2012-12-04 12:00:00	QQQ	ETF	65.53	65.53	65.31	65.39	3789852.0
2012-12-04 13:00:00	QQQ	ETF	65.4	65.66	65.31	65.64	5057104.0
2012-12-04 14:00:00	QQQ	ETF	65.64	65.68	65.472	65.58	4693707.0
2012-12-04 15:00:00	QQQ	ETF	65.5701	65.77	65.56	65.58	6157443.0
2012-12-04 16:00:00	QQQ	ETF	65.58	65.7009	65.4857	65.55	4092866.0
2012-12-04 17:00:00	QQQ	ETF	65.53	65.53	65.46	65.47	14280.0
2012-12-04 18:00:00	QQQ	ETF	65.45	65.49	65.4	65.49	47365.0
2012-12-04 19:00:00	QQQ	ETF	65.47	65.5	65.43	65.5	69600.0
2012-12-04 04:00:00	IWM	ETF	82.06	82.06	82.02	82.02	1500.0
2012-12-04 05:00:00	IWM	ETF	82.03	82.04	82.01	82.01	21120.0
2012-12-04 06:00:00	IWM	ETF	82.05	82.11	82.05	82.09	15500.0
2012-12-04 07:00:00	IWM	ETF	82.06	82.2	82.06	82.2	28950.0
2012-12-04 08:00:00	IWM	ETF	82.23	82.23	81.97	81.99	318433.0
2012-12-04 09:00:00	IWM	ETF	81.96	82.27	81.9	82.08	2940741.0
2012-12-04 10:00:00	IWM	ETF	82.1	82.32	81.6	81.88	5487990.0
2012-12-04 11:00:00	IWM	ETF	81.88	81.9	81.61	81.74	2728134.0
2012-12-04 12:00:00	IWM	ETF	81.7499	81.75	81.46	81.56	3395153.0
2012-12-04 13:00:00	IWM	ETF	81.57	82.2	81.46	82.04	5920077.0
2012-12-04 14:00:00	IWM	ETF	82.04	82.14	81.84	82.01	3645794.0
2012-12-04 15:00:00	IWM	ETF	82.01	82.23	82.01	82.13	5413672.0
2012-12-04 16:00:00	IWM	ETF	82.15	82.19	82.07	82.08	1531003.0
2012-12-04 17:00:00	IWM	ETF	82.07	82.07	81.96	81.98	9479.0
2012-12-04 18:00:00	IWM	ETF	81.99	81.99	81.98	81.98	1299.0
2012-12-04 19:00:00	IWM	ETF	82.0	82.07	82.0	82.07	850.0
2012-12-04 07:00:00	DIA	ETF	129.69	129.78	129.69	129.77	3300.0
2012-12-04 08:00:00	DIA	ETF	129.74	129.74	129.54	129.54	5379.0
2012-12-04 09:00:00	DIA	ETF	129.54	129.971	129.51	129.81	716994.0

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

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