PREVIEW / etf_1hour / 2011-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-08.parquet
  size:    183 KB
  rows:    5,609

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-06-08 04:00:00	SPY	ETF	128.61	128.76	128.4	128.59	8150.0
2011-06-08 05:00:00	SPY	ETF	128.59	128.7	128.51	128.7	17650.0
2011-06-08 06:00:00	SPY	ETF	128.61	128.66	128.2	128.34	93950.0
2011-06-08 07:00:00	SPY	ETF	128.35	128.49	128.3	128.43	417103.0
2011-06-08 08:00:00	SPY	ETF	128.45	128.71	128.35	128.67	1715542.0
2011-06-08 09:00:00	SPY	ETF	128.65	129.07	128.43	128.5	23440213.0
2011-06-08 10:00:00	SPY	ETF	128.5	129.05	128.47	128.91	30744816.0
2011-06-08 11:00:00	SPY	ETF	128.92	129.19	128.62	129.04	22349193.0
2011-06-08 12:00:00	SPY	ETF	129.05	129.14	128.69	129.04	15255896.0
2011-06-08 13:00:00	SPY	ETF	129.04	129.12	128.26	128.42	19130455.0
2011-06-08 14:00:00	SPY	ETF	128.41	128.89	128.24	128.69	28076668.0
2011-06-08 15:00:00	SPY	ETF	128.69	128.72	128.18	128.42	41246450.0
2011-06-08 16:00:00	SPY	ETF	128.4	128.9516	128.08	128.1	13225563.0
2011-06-08 17:00:00	SPY	ETF	128.1	128.38	128.1	128.38	483881.0
2011-06-08 18:00:00	SPY	ETF	128.38	128.45	128.3	128.44	543171.0
2011-06-08 19:00:00	SPY	ETF	128.43	128.55	128.41	128.5	191963.0
2011-06-08 04:00:00	QQQ	ETF	55.77	55.77	55.53	55.53	800.0
2011-06-08 05:00:00	QQQ	ETF	55.66	55.68	55.66	55.68	15000.0
2011-06-08 06:00:00	QQQ	ETF	55.52	55.57	55.5	55.51	21400.0
2011-06-08 07:00:00	QQQ	ETF	55.51	55.55	55.47	55.52	161200.0
2011-06-08 08:00:00	QQQ	ETF	55.54	55.67	55.48	55.64	350300.0
2011-06-08 09:00:00	QQQ	ETF	55.63	55.77	55.45	55.4967	5786115.0
2011-06-08 10:00:00	QQQ	ETF	55.4901	55.7394	55.47	55.63	6434716.0
2011-06-08 11:00:00	QQQ	ETF	55.64	55.74	55.47	55.66	4415944.0
2011-06-08 12:00:00	QQQ	ETF	55.66	55.68	55.49	55.655	4106301.0
2011-06-08 13:00:00	QQQ	ETF	55.655	55.68	55.23	55.3	5171203.0
2011-06-08 14:00:00	QQQ	ETF	55.291	55.55	55.28	55.44	6450273.0
2011-06-08 15:00:00	QQQ	ETF	55.45	55.5	55.26	55.39	9137870.0
2011-06-08 16:00:00	QQQ	ETF	55.39	55.399	55.21	55.23	2646680.0
2011-06-08 17:00:00	QQQ	ETF	55.24	55.33	55.24	55.3	92918.0
2011-06-08 18:00:00	QQQ	ETF	55.33	55.39	55.32	55.34	60386.0
2011-06-08 19:00:00	QQQ	ETF	55.35	55.39	55.34	55.39	20236.0
2011-06-08 04:00:00	IWM	ETF	79.35	79.35	79.35	79.35	200.0
2011-06-08 05:00:00	IWM	ETF	79.4	79.4	79.25	79.25	1800.0
2011-06-08 06:00:00	IWM	ETF	79.34	79.34	79.15	79.18	6400.0
2011-06-08 07:00:00	IWM	ETF	79.21	79.29	79.08	79.2	58650.0
2011-06-08 08:00:00	IWM	ETF	79.22	79.4	79.17	79.37	485044.0
2011-06-08 09:00:00	IWM	ETF	79.355	79.72	79.07	79.1501	10402862.0
2011-06-08 10:00:00	IWM	ETF	79.16	79.61	79.14	79.45	9300320.0
2011-06-08 11:00:00	IWM	ETF	79.45	79.7	79.13	79.54	6217886.0
2011-06-08 12:00:00	IWM	ETF	79.545	79.56	79.16	79.39	4422958.0
2011-06-08 13:00:00	IWM	ETF	79.39	79.47	78.85	78.97	4152388.0
2011-06-08 14:00:00	IWM	ETF	78.97	79.27	78.75	79.14	9696312.0
2011-06-08 15:00:00	IWM	ETF	79.135	79.168	78.71	78.86	13060793.0
2011-06-08 16:00:00	IWM	ETF	78.85	79.7577	78.53	78.6	2769594.0
2011-06-08 17:00:00	IWM	ETF	78.57	78.7	78.57	78.7	16115.0
2011-06-08 18:00:00	IWM	ETF	78.77	78.77	78.69	78.77	10299.0
2011-06-08 19:00:00	IWM	ETF	78.8	78.88	78.8	78.86	12900.0
2011-06-08 05:00:00	DIA	ETF	120.49	120.49	120.49	120.49	100.0
2011-06-08 06:00:00	DIA	ETF	120.0	120.0	119.5	119.9	600.0

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

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