PREVIEW / etf_1hour / 2012-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-29.parquet
  size:    184 KB
  rows:    5,695

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-29 04:00:00	SPY	ETF	140.52	140.7	140.48	140.48	8902.0
2012-03-29 05:00:00	SPY	ETF	140.36	140.36	140.08	140.09	108390.0
2012-03-29 06:00:00	SPY	ETF	140.0	140.05	139.95	140.0	115714.0
2012-03-29 07:00:00	SPY	ETF	140.0	140.18	139.93	140.14	221114.0
2012-03-29 08:00:00	SPY	ETF	140.15	140.35	139.82	140.03	1749355.0
2012-03-29 09:00:00	SPY	ETF	140.04	140.04	139.35	139.56	21029219.0
2012-03-29 10:00:00	SPY	ETF	139.55	139.75	139.1	139.475	29202192.0
2012-03-29 11:00:00	SPY	ETF	139.47	139.56	139.09	139.22	20027060.0
2012-03-29 12:00:00	SPY	ETF	139.23	139.56	139.13	139.525	16643394.0
2012-03-29 13:00:00	SPY	ETF	139.53	140.4934	139.28	139.405	15427609.0
2012-03-29 14:00:00	SPY	ETF	139.39	139.87	139.38	139.76	16097873.0
2012-03-29 15:00:00	SPY	ETF	139.75	140.4934	139.67	140.22	32023478.0
2012-03-29 16:00:00	SPY	ETF	140.21	140.4934	139.65	140.32	9391686.0
2012-03-29 17:00:00	SPY	ETF	140.33	140.37	140.19	140.26	160183.0
2012-03-29 18:00:00	SPY	ETF	140.26	140.27	140.19	140.21	25980.0
2012-03-29 19:00:00	SPY	ETF	140.23	140.24	140.15	140.2	52963.0
2012-03-29 04:00:00	QQQ	ETF	68.02	68.02	68.02	68.02	100.0
2012-03-29 05:00:00	QQQ	ETF	67.81	67.81	67.81	67.81	100.0
2012-03-29 06:00:00	QQQ	ETF	67.8	67.82	67.78	67.8	12143.0
2012-03-29 07:00:00	QQQ	ETF	67.75	67.86	67.74	67.79	161270.0
2012-03-29 08:00:00	QQQ	ETF	67.83	67.85	67.7	67.79	897554.0
2012-03-29 09:00:00	QQQ	ETF	67.79	67.93	67.54	67.64	8641875.0
2012-03-29 10:00:00	QQQ	ETF	67.64	67.81	67.46	67.62	7187830.0
2012-03-29 11:00:00	QQQ	ETF	67.61	67.65	67.21	67.29	6425765.0
2012-03-29 12:00:00	QQQ	ETF	67.2889	67.47	67.2	67.4495	5888487.0
2012-03-29 13:00:00	QQQ	ETF	67.45	67.458	67.26	67.33	4400678.0
2012-03-29 14:00:00	QQQ	ETF	67.32	67.62	67.32	67.58	5110136.0
2012-03-29 15:00:00	QQQ	ETF	67.58	67.83	67.51	67.7	7312299.0
2012-03-29 16:00:00	QQQ	ETF	67.7	67.79	67.68	67.76	1269780.0
2012-03-29 17:00:00	QQQ	ETF	67.77	67.78	67.63	67.69	159245.0
2012-03-29 18:00:00	QQQ	ETF	67.7	67.7	67.66	67.66	30863.0
2012-03-29 19:00:00	QQQ	ETF	67.66	67.68	67.64	67.66	13392.0
2012-03-29 06:00:00	IWM	ETF	82.9	82.9	82.9	82.9	25000.0
2012-03-29 07:00:00	IWM	ETF	82.88	83.05	82.86	83.02	86694.0
2012-03-29 08:00:00	IWM	ETF	83.06	83.06	82.75	82.92	412678.0
2012-03-29 09:00:00	IWM	ETF	82.95	82.96	82.35	82.56	5077730.0
2012-03-29 10:00:00	IWM	ETF	82.56	82.69	82.16	82.33	6916259.0
2012-03-29 11:00:00	IWM	ETF	82.335	82.43	82.015	82.17	4972171.0
2012-03-29 12:00:00	IWM	ETF	82.17	82.57	82.05	82.52	6708757.0
2012-03-29 13:00:00	IWM	ETF	82.53	82.55	82.34	82.47	2669488.0
2012-03-29 14:00:00	IWM	ETF	82.47	82.84	82.4629	82.745	4628825.0
2012-03-29 15:00:00	IWM	ETF	82.745	83.22	82.63	83.02	8848386.0
2012-03-29 16:00:00	IWM	ETF	83.01	83.17	82.96	83.17	1265938.0
2012-03-29 17:00:00	IWM	ETF	83.17	83.17	83.14	83.16	25600.0
2012-03-29 18:00:00	IWM	ETF	83.18	83.18	83.1	83.1	1100.0
2012-03-29 19:00:00	IWM	ETF	83.09	83.09	83.07	83.07	8500.0
2012-03-29 07:00:00	DIA	ETF	130.67	130.67	130.67	130.67	150.0
2012-03-29 08:00:00	DIA	ETF	130.61	130.63	130.45	130.48	6350.0
2012-03-29 09:00:00	DIA	ETF	130.54	130.588	130.18	130.33	528618.0
2012-03-29 10:00:00	DIA	ETF	130.31	130.55	130.04	130.36	723479.0

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

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