PREVIEW / etf_1hour / 2012-03-30

all etf 1-hour files

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

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-30 04:00:00	SPY	ETF	140.66	140.78	140.51	140.78	10840.0
2012-03-30 05:00:00	SPY	ETF	140.72	141.01	140.72	141.01	8700.0
2012-03-30 06:00:00	SPY	ETF	140.98	140.98	140.83	140.9	165300.0
2012-03-30 07:00:00	SPY	ETF	140.87	141.03	140.87	141.0	299306.0
2012-03-30 08:00:00	SPY	ETF	140.98	141.05	140.74	140.84	1459552.0
2012-03-30 09:00:00	SPY	ETF	140.86	140.97	140.58	140.5999	18313861.0
2012-03-30 10:00:00	SPY	ETF	140.6	140.72	140.05	140.31	23900536.0
2012-03-30 11:00:00	SPY	ETF	140.31	140.84	140.2661	140.765	18817913.0
2012-03-30 12:00:00	SPY	ETF	140.76	140.92	140.67	140.76	10226207.0
2012-03-30 13:00:00	SPY	ETF	140.77	140.93	140.74	140.89	6488661.0
2012-03-30 14:00:00	SPY	ETF	140.895	141.05	140.82	140.84	10156357.0
2012-03-30 15:00:00	SPY	ETF	140.835	140.95	140.63	140.72	29769336.0
2012-03-30 16:00:00	SPY	ETF	140.72	141.0	140.266	140.87	11590971.0
2012-03-30 17:00:00	SPY	ETF	140.87	141.04	140.2661	140.95	1552380.0
2012-03-30 18:00:00	SPY	ETF	140.99	140.99	140.84	140.88	99713.0
2012-03-30 19:00:00	SPY	ETF	140.86	140.95	140.85	140.95	33359.0
2012-03-30 04:00:00	QQQ	ETF	67.81	67.94	67.81	67.9	1400.0
2012-03-30 05:00:00	QQQ	ETF	67.97	68.06	67.97	68.06	5080.0
2012-03-30 06:00:00	QQQ	ETF	68.0	68.03	68.0	68.0	19400.0
2012-03-30 07:00:00	QQQ	ETF	68.02	68.07	68.02	68.06	36185.0
2012-03-30 08:00:00	QQQ	ETF	68.05	68.08	67.93	67.96	586929.0
2012-03-30 09:00:00	QQQ	ETF	67.94	68.02	67.65	67.66	5522257.0
2012-03-30 10:00:00	QQQ	ETF	67.65	67.749	67.28	67.5	7911988.0
2012-03-30 11:00:00	QQQ	ETF	67.5	67.75	67.49	67.71	8044229.0
2012-03-30 12:00:00	QQQ	ETF	67.705	67.74	67.58	67.655	3866115.0
2012-03-30 13:00:00	QQQ	ETF	67.66	67.77	67.65	67.7215	1635451.0
2012-03-30 14:00:00	QQQ	ETF	67.73	67.77	67.58	67.59	3044343.0
2012-03-30 15:00:00	QQQ	ETF	67.595	67.69	67.52	67.55	5738902.0
2012-03-30 16:00:00	QQQ	ETF	67.54	67.66	67.5	67.59	772414.0
2012-03-30 17:00:00	QQQ	ETF	67.57	67.62	67.57	67.62	7589.0
2012-03-30 18:00:00	QQQ	ETF	67.59	67.62	67.58	67.59	4086.0
2012-03-30 19:00:00	QQQ	ETF	67.62	67.62	67.62	67.62	100.0
2012-03-30 06:00:00	IWM	ETF	83.61	83.61	83.61	83.61	500.0
2012-03-30 07:00:00	IWM	ETF	83.6	83.62	83.53	83.6	17245.0
2012-03-30 08:00:00	IWM	ETF	83.58	83.66	83.39	83.46	243385.0
2012-03-30 09:00:00	IWM	ETF	83.46	83.64	83.08	83.1	5260549.0
2012-03-30 10:00:00	IWM	ETF	83.1	83.18	82.53	82.84	6703629.0
2012-03-30 11:00:00	IWM	ETF	82.83	83.38	82.81	83.26	7396618.0
2012-03-30 12:00:00	IWM	ETF	83.27	83.28	82.98	83.04	2196352.0
2012-03-30 13:00:00	IWM	ETF	83.03	83.21	83.03	83.16	2141504.0
2012-03-30 14:00:00	IWM	ETF	83.17	83.3	83.09	83.1	2936615.0
2012-03-30 15:00:00	IWM	ETF	83.1	83.18	82.8	82.84	9333430.0
2012-03-30 16:00:00	IWM	ETF	82.84	83.0721	82.77	82.83	6347117.0
2012-03-30 17:00:00	IWM	ETF	82.83	82.87	82.83	82.87	26170.0
2012-03-30 18:00:00	IWM	ETF	82.87	82.87	82.84	82.84	3660.0
2012-03-30 04:00:00	DIA	ETF	131.51	131.6	131.51	131.6	10000.0
2012-03-30 05:00:00	DIA	ETF	131.61	131.73	131.61	131.73	21000.0
2012-03-30 07:00:00	DIA	ETF	131.75	131.77	131.75	131.77	5900.0
2012-03-30 08:00:00	DIA	ETF	131.72	131.79	131.59	131.66	17977.0
2012-03-30 09:00:00	DIA	ETF	131.66	131.7499	131.41	131.48	491233.0

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

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