PREVIEW / etf_1hour / 2011-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-21.parquet
  size:    181 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-03-21 04:00:00	SPY	ETF	128.26	129.51	128.26	129.45	24363.0
2011-03-21 05:00:00	SPY	ETF	129.36	129.36	129.25	129.32	10100.0
2011-03-21 06:00:00	SPY	ETF	129.23	129.45	129.19	129.39	71050.0
2011-03-21 07:00:00	SPY	ETF	129.37	129.42	129.15	129.31	1419605.0
2011-03-21 08:00:00	SPY	ETF	129.33	129.49	129.24	129.33	5214527.0
2011-03-21 09:00:00	SPY	ETF	129.33	129.88	129.2	129.74	29630918.0
2011-03-21 10:00:00	SPY	ETF	129.75	130.01	129.64	129.76	23986953.0
2011-03-21 11:00:00	SPY	ETF	129.76	130.0	129.5	129.75	16137900.0
2011-03-21 12:00:00	SPY	ETF	129.76	129.94	129.71	129.76	13181228.0
2011-03-21 13:00:00	SPY	ETF	129.755	129.82	129.53	129.8	11702547.0
2011-03-21 14:00:00	SPY	ETF	129.8	129.91	129.64	129.65	10395909.0
2011-03-21 15:00:00	SPY	ETF	129.65	129.79	129.43	129.725	27281893.0
2011-03-21 16:00:00	SPY	ETF	129.72	129.86	127.8328	129.62	11228294.0
2011-03-21 17:00:00	SPY	ETF	129.66	129.7	129.58	129.68	46921.0
2011-03-21 18:00:00	SPY	ETF	129.67	129.8	129.65	129.75	185286.0
2011-03-21 19:00:00	SPY	ETF	129.74	129.78	129.65	129.71	96203.0
2011-03-21 04:00:00	QQQ	ETF	55.09	55.27	55.06	55.27	18280.0
2011-03-21 05:00:00	QQQ	ETF	55.21	55.22	55.19	55.21	2700.0
2011-03-21 06:00:00	QQQ	ETF	55.18	55.27	55.17	55.22	28500.0
2011-03-21 07:00:00	QQQ	ETF	55.22	55.27	55.15	55.22	246382.0
2011-03-21 08:00:00	QQQ	ETF	55.24	55.28	54.75	55.2	1131303.0
2011-03-21 09:00:00	QQQ	ETF	55.21	55.63	55.18	55.56	12539191.0
2011-03-21 10:00:00	QQQ	ETF	55.55	55.69	55.51	55.63	9918785.0
2011-03-21 11:00:00	QQQ	ETF	55.6281	55.78	55.57	55.58	5686307.0
2011-03-21 12:00:00	QQQ	ETF	55.58	55.66	55.54	55.58	4597611.0
2011-03-21 13:00:00	QQQ	ETF	55.57	55.59	55.4	55.59	4541276.0
2011-03-21 14:00:00	QQQ	ETF	55.59	55.66	55.51	55.52	3220314.0
2011-03-21 15:00:00	QQQ	ETF	55.52	55.58	55.43	55.49	7657920.0
2011-03-21 16:00:00	QQQ	ETF	55.48	55.62	54.4956	55.4	4488371.0
2011-03-21 17:00:00	QQQ	ETF	55.4	55.48	55.39	55.48	82073.0
2011-03-21 18:00:00	QQQ	ETF	55.43	55.48	55.41	55.45	35603.0
2011-03-21 19:00:00	QQQ	ETF	55.44	55.46	55.4	55.4	4984.0
2011-03-21 04:00:00	IWM	ETF	80.27	80.51	80.19	80.45	54600.0
2011-03-21 05:00:00	IWM	ETF	80.46	80.51	80.46	80.51	5300.0
2011-03-21 06:00:00	IWM	ETF	80.54	80.54	80.5	80.53	10000.0
2011-03-21 07:00:00	IWM	ETF	80.6	80.63	80.51	80.58	331150.0
2011-03-21 08:00:00	IWM	ETF	80.56	80.59	80.37	80.48	1312494.0
2011-03-21 09:00:00	IWM	ETF	80.48	80.94	80.36	80.86	8158860.0
2011-03-21 10:00:00	IWM	ETF	80.86	81.1	80.8	81.05	7305569.0
2011-03-21 11:00:00	IWM	ETF	81.05	81.23	81.021	81.09	3869093.0
2011-03-21 12:00:00	IWM	ETF	81.09	81.19	81.01	81.04	2796513.0
2011-03-21 13:00:00	IWM	ETF	81.0425	81.055	80.76	80.98	3619091.0
2011-03-21 14:00:00	IWM	ETF	80.99	81.16	80.97	81.0	3028880.0
2011-03-21 15:00:00	IWM	ETF	81.0	81.32	80.92	81.31	10310061.0
2011-03-21 16:00:00	IWM	ETF	81.3	81.45	81.0988	81.33	2719708.0
2011-03-21 17:00:00	IWM	ETF	81.31	81.35	81.31	81.32	59141.0
2011-03-21 18:00:00	IWM	ETF	81.32	81.38	81.28	81.36	9400.0
2011-03-21 19:00:00	IWM	ETF	81.3	81.39	81.3	81.38	8106.0
2011-03-21 04:00:00	DIA	ETF	119.3	119.45	119.3	119.45	476.0
2011-03-21 05:00:00	DIA	ETF	119.52	119.52	119.44	119.44	4500.0

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

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