PREVIEW / etf_1hour / 2011-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-14.parquet
  size:    177 KB
  rows:    5,417

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-14 05:00:00	SPY	ETF	131.01	131.01	130.62	130.67	14300.0
2011-04-14 06:00:00	SPY	ETF	130.63	130.79	130.61	130.61	53950.0
2011-04-14 07:00:00	SPY	ETF	130.65	130.85	130.54	130.8	356779.0
2011-04-14 08:00:00	SPY	ETF	130.8	131.293	130.43	130.63	2722490.0
2011-04-14 09:00:00	SPY	ETF	130.62	130.88	130.27	130.65	23374677.0
2011-04-14 10:00:00	SPY	ETF	130.66	131.27	130.6	131.03	25337247.0
2011-04-14 11:00:00	SPY	ETF	131.03	131.18	130.78	131.04	22367047.0
2011-04-14 12:00:00	SPY	ETF	131.04	131.39	130.98	131.33	12382932.0
2011-04-14 13:00:00	SPY	ETF	131.3399	131.43	131.05	131.06	11138043.0
2011-04-14 14:00:00	SPY	ETF	131.06	131.47	131.06	131.38	12017393.0
2011-04-14 15:00:00	SPY	ETF	131.38	131.76	131.33	131.56	30763003.0
2011-04-14 16:00:00	SPY	ETF	131.56	131.62	131.1374	131.49	11000669.0
2011-04-14 17:00:00	SPY	ETF	131.49	131.59	131.48	131.57	2127555.0
2011-04-14 18:00:00	SPY	ETF	131.57	131.68	131.43	131.64	98806.0
2011-04-14 19:00:00	SPY	ETF	131.61	131.76	131.56	131.65	65025.0
2011-04-14 05:00:00	QQQ	ETF	56.62	56.62	56.45	56.45	3400.0
2011-04-14 06:00:00	QQQ	ETF	56.39	56.42	56.34	56.34	46986.0
2011-04-14 07:00:00	QQQ	ETF	56.34	56.44	56.31	56.43	258493.0
2011-04-14 08:00:00	QQQ	ETF	56.43	56.48	56.31	56.41	682419.0
2011-04-14 09:00:00	QQQ	ETF	56.42	56.525	56.23	56.411	6807466.0
2011-04-14 10:00:00	QQQ	ETF	56.41	56.67	56.38	56.55	8576828.0
2011-04-14 11:00:00	QQQ	ETF	56.545	56.585	56.37	56.52	6705410.0
2011-04-14 12:00:00	QQQ	ETF	56.53	56.63	56.49	56.6	3894738.0
2011-04-14 13:00:00	QQQ	ETF	56.61	56.65	56.41	56.42	4818028.0
2011-04-14 14:00:00	QQQ	ETF	56.42	56.68	56.42	56.632	3931581.0
2011-04-14 15:00:00	QQQ	ETF	56.64	56.83	56.61	56.745	8867059.0
2011-04-14 16:00:00	QQQ	ETF	56.74	56.77	56.48	56.57	5874535.0
2011-04-14 17:00:00	QQQ	ETF	56.57	56.57	56.51	56.54	69634.0
2011-04-14 18:00:00	QQQ	ETF	56.54	56.72	56.54	56.57	45410.0
2011-04-14 19:00:00	QQQ	ETF	56.61	56.66	56.59	56.6	13442.0
2011-04-14 06:00:00	IWM	ETF	81.44	81.58	81.44	81.5	5900.0
2011-04-14 07:00:00	IWM	ETF	81.5	81.71	81.49	81.69	33810.0
2011-04-14 08:00:00	IWM	ETF	81.71	81.74	81.48	81.68	338092.0
2011-04-14 09:00:00	IWM	ETF	81.68	82.03	81.45	81.97	8972927.0
2011-04-14 10:00:00	IWM	ETF	81.96	82.21	81.83	82.0	12491289.0
2011-04-14 11:00:00	IWM	ETF	82.0	82.1	81.72	81.97	5686796.0
2011-04-14 12:00:00	IWM	ETF	81.9601	82.45	81.9601	82.39	4307611.0
2011-04-14 13:00:00	IWM	ETF	82.39	82.43	81.96	81.98	4979441.0
2011-04-14 14:00:00	IWM	ETF	81.98	82.485	81.98	82.4226	4744652.0
2011-04-14 15:00:00	IWM	ETF	82.4201	82.71	82.37	82.65	8726030.0
2011-04-14 16:00:00	IWM	ETF	82.66	82.78	82.2923	82.68	2632107.0
2011-04-14 17:00:00	IWM	ETF	82.66	82.75	82.66	82.71	5380.0
2011-04-14 18:00:00	IWM	ETF	82.75	82.78	82.63	82.75	7937.0
2011-04-14 19:00:00	IWM	ETF	82.7	82.79	82.7	82.77	2300.0
2011-04-14 05:00:00	DIA	ETF	121.88	121.88	121.88	121.88	100.0
2011-04-14 06:00:00	DIA	ETF	121.83	121.83	121.82	121.82	2300.0
2011-04-14 07:00:00	DIA	ETF	121.84	122.02	121.84	122.02	1400.0
2011-04-14 08:00:00	DIA	ETF	122.06	122.08	121.74	121.85	57392.0
2011-04-14 09:00:00	DIA	ETF	121.85	122.06	121.46	121.76	789594.0
2011-04-14 10:00:00	DIA	ETF	121.7601	122.27	121.74	122.13	601953.0

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

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