PREVIEW / etf_1hour / 2011-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-12.parquet
  size:    182 KB
  rows:    5,540

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
2011-04-12 04:00:00	SPY	ETF	131.98	132.35	131.62	131.62	5100.0
2011-04-12 05:00:00	SPY	ETF	131.73	131.86	131.63	131.86	23175.0
2011-04-12 06:00:00	SPY	ETF	131.81	131.81	131.7	131.72	19900.0
2011-04-12 07:00:00	SPY	ETF	131.72	131.73	131.61	131.73	632252.0
2011-04-12 08:00:00	SPY	ETF	131.71	131.83	131.47	131.74	1872425.0
2011-04-12 09:00:00	SPY	ETF	131.74	131.98	131.43	131.543	20932611.0
2011-04-12 10:00:00	SPY	ETF	131.55	131.63	130.99	131.01	36651387.0
2011-04-12 11:00:00	SPY	ETF	131.02	131.36	130.99	131.23	17376614.0
2011-04-12 12:00:00	SPY	ETF	131.23	131.45	131.105	131.3429	10481003.0
2011-04-12 13:00:00	SPY	ETF	131.34	131.65	131.19	131.53	14186422.0
2011-04-12 14:00:00	SPY	ETF	131.53	131.84	131.49	131.55	20518258.0
2011-04-12 15:00:00	SPY	ETF	131.55	131.61	131.17	131.47	30301044.0
2011-04-12 16:00:00	SPY	ETF	131.46	132.4928	131.21	131.32	6435360.0
2011-04-12 17:00:00	SPY	ETF	131.31	131.44	131.31	131.38	131915.0
2011-04-12 18:00:00	SPY	ETF	131.41	131.46	131.31	131.31	192835.0
2011-04-12 19:00:00	SPY	ETF	131.29	131.64	131.28	131.62	74565.0
2011-04-12 04:00:00	QQQ	ETF	56.48	56.53	56.38	56.4	6834.0
2011-04-12 05:00:00	QQQ	ETF	56.43	56.48	56.43	56.48	15200.0
2011-04-12 06:00:00	QQQ	ETF	56.48	56.5	56.44	56.5	14500.0
2011-04-12 07:00:00	QQQ	ETF	56.48	56.48	56.4	56.43	68058.0
2011-04-12 08:00:00	QQQ	ETF	56.44	56.52	56.36	56.49	1246112.0
2011-04-12 09:00:00	QQQ	ETF	56.49	56.64	56.36	56.4038	7849130.0
2011-04-12 10:00:00	QQQ	ETF	56.4	56.455	56.22	56.24	9550848.0
2011-04-12 11:00:00	QQQ	ETF	56.245	56.345	56.15	56.27	3901237.0
2011-04-12 12:00:00	QQQ	ETF	56.2701	56.42	56.21	56.35	4541397.0
2011-04-12 13:00:00	QQQ	ETF	56.35	56.44	56.27	56.38	4031081.0
2011-04-12 14:00:00	QQQ	ETF	56.38	56.5	56.31	56.34	4303924.0
2011-04-12 15:00:00	QQQ	ETF	56.34	56.4	56.2	56.39	7305717.0
2011-04-12 16:00:00	QQQ	ETF	56.39	56.39	56.29	56.38	1293308.0
2011-04-12 17:00:00	QQQ	ETF	56.38	56.44	56.38	56.42	101583.0
2011-04-12 18:00:00	QQQ	ETF	56.41	56.44	56.4	56.4	227329.0
2011-04-12 19:00:00	QQQ	ETF	56.39	56.5	56.39	56.5	16026.0
2011-04-12 04:00:00	IWM	ETF	83.26	83.26	82.8	82.8	2753.0
2011-04-12 05:00:00	IWM	ETF	82.77	82.88	82.77	82.88	2700.0
2011-04-12 06:00:00	IWM	ETF	82.86	82.86	82.75	82.76	800.0
2011-04-12 07:00:00	IWM	ETF	82.75	82.75	82.61	82.65	54081.0
2011-04-12 08:00:00	IWM	ETF	82.66	82.85	82.4	82.62	613057.0
2011-04-12 09:00:00	IWM	ETF	82.62	83.05	82.42	82.569	7376866.0
2011-04-12 10:00:00	IWM	ETF	82.56	82.62	82.09	82.1	9565550.0
2011-04-12 11:00:00	IWM	ETF	82.1	82.37	82.05	82.18	4091107.0
2011-04-12 12:00:00	IWM	ETF	82.17	82.41	82.15	82.33	2958178.0
2011-04-12 13:00:00	IWM	ETF	82.32	82.5	82.16	82.4	2480918.0
2011-04-12 14:00:00	IWM	ETF	82.4	82.63	82.28	82.33	8136520.0
2011-04-12 15:00:00	IWM	ETF	82.3325	82.39	82.07	82.16	8740716.0
2011-04-12 16:00:00	IWM	ETF	82.16	82.17	81.96	82.05	2394407.0
2011-04-12 17:00:00	IWM	ETF	82.05	82.18	82.04	82.17	100912.0
2011-04-12 18:00:00	IWM	ETF	82.12	82.17	82.12	82.13	9100.0
2011-04-12 19:00:00	IWM	ETF	82.14	82.19	82.12	82.19	12200.0
2011-04-12 04:00:00	DIA	ETF	123.02	123.02	122.95	122.95	200.0
2011-04-12 07:00:00	DIA	ETF	123.02	123.04	123.0	123.04	6347.0

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

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