PREVIEW / etf_1hour / 2011-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-18.parquet
  size:    176 KB
  rows:    5,467

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-11-18 04:00:00	SPY	ETF	122.12	122.74	122.12	122.72	25085.0
2011-11-18 05:00:00	SPY	ETF	122.76	122.85	122.4	122.52	43354.0
2011-11-18 06:00:00	SPY	ETF	122.54	122.9	122.28	122.89	115725.0
2011-11-18 07:00:00	SPY	ETF	122.89	123.54	122.77	123.07	1831837.0
2011-11-18 08:00:00	SPY	ETF	123.07	123.5	122.72	122.99	2059220.0
2011-11-18 09:00:00	SPY	ETF	122.97	123.09	121.86	122.34	33995578.0
2011-11-18 10:00:00	SPY	ETF	122.337	122.75	121.73	122.49	45982274.0
2011-11-18 11:00:00	SPY	ETF	122.49	122.56	121.9	121.99	18640614.0
2011-11-18 12:00:00	SPY	ETF	121.99	122.07	121.47	121.85	20788823.0
2011-11-18 13:00:00	SPY	ETF	121.85	122.48	121.8	122.26	19979768.0
2011-11-18 14:00:00	SPY	ETF	122.27	122.59	122.0	122.07	19663004.0
2011-11-18 15:00:00	SPY	ETF	122.08	122.26	121.88	121.98	36993088.0
2011-11-18 16:00:00	SPY	ETF	121.98	122.4231	121.85	121.97	10674508.0
2011-11-18 17:00:00	SPY	ETF	121.97	122.07	121.92	122.03	602453.0
2011-11-18 18:00:00	SPY	ETF	122.04	122.12	121.97	122.11	282173.0
2011-11-18 19:00:00	SPY	ETF	122.11	122.14	121.93	122.12	252365.0
2011-11-18 04:00:00	QQQ	ETF	55.83	55.99	55.83	55.97	4018.0
2011-11-18 05:00:00	QQQ	ETF	55.98	55.98	55.83	55.83	3300.0
2011-11-18 06:00:00	QQQ	ETF	55.77	56.05	55.76	56.05	29951.0
2011-11-18 07:00:00	QQQ	ETF	56.05	56.32	55.99	56.1	202976.0
2011-11-18 08:00:00	QQQ	ETF	56.1	56.15	56.02	56.12	513378.0
2011-11-18 09:00:00	QQQ	ETF	56.12	56.15	55.54	55.68	8518645.0
2011-11-18 10:00:00	QQQ	ETF	55.68	55.9	55.44	55.8	10955837.0
2011-11-18 11:00:00	QQQ	ETF	55.8	55.87	55.51	55.55	6254192.0
2011-11-18 12:00:00	QQQ	ETF	55.552	55.65	55.3	55.55	6868556.0
2011-11-18 13:00:00	QQQ	ETF	55.55	55.78	55.51	55.61	5458769.0
2011-11-18 14:00:00	QQQ	ETF	55.62	55.74	55.45	55.48	5657804.0
2011-11-18 15:00:00	QQQ	ETF	55.48	55.58	55.38	55.4	7528267.0
2011-11-18 16:00:00	QQQ	ETF	55.39	55.42	55.33	55.35	869661.0
2011-11-18 17:00:00	QQQ	ETF	55.36	55.39	55.36	55.38	8502.0
2011-11-18 18:00:00	QQQ	ETF	55.37	55.39	55.36	55.38	26566.0
2011-11-18 19:00:00	QQQ	ETF	55.4	55.42	55.35	55.42	10566.0
2011-11-18 04:00:00	IWM	ETF	72.16	72.31	72.16	72.31	1073.0
2011-11-18 06:00:00	IWM	ETF	72.07	72.52	72.07	72.5	12420.0
2011-11-18 07:00:00	IWM	ETF	72.55	73.12	72.49	72.75	293258.0
2011-11-18 08:00:00	IWM	ETF	72.75	72.81	72.55	72.75	596813.0
2011-11-18 09:00:00	IWM	ETF	72.7	72.77	71.53	71.99	9095479.0
2011-11-18 10:00:00	IWM	ETF	71.99	72.47	71.68	72.27	10119550.0
2011-11-18 11:00:00	IWM	ETF	72.27	72.35	71.7	71.71	6672116.0
2011-11-18 12:00:00	IWM	ETF	71.71	71.94	71.45	71.72	4010195.0
2011-11-18 13:00:00	IWM	ETF	71.73	72.11	71.7001	71.92	3103231.0
2011-11-18 14:00:00	IWM	ETF	71.93	72.28	71.78	71.93	4343721.0
2011-11-18 15:00:00	IWM	ETF	71.94	72.055	71.82	72.0	7699942.0
2011-11-18 16:00:00	IWM	ETF	71.99	72.01	71.5667	71.96	3721530.0
2011-11-18 17:00:00	IWM	ETF	71.96	71.96	71.91	71.93	2497.0
2011-11-18 18:00:00	IWM	ETF	71.9	71.96	71.9	71.96	53300.0
2011-11-18 19:00:00	IWM	ETF	71.98	72.0	71.98	72.0	5600.0
2011-11-18 07:00:00	DIA	ETF	118.55	118.6	118.21	118.21	7125.0
2011-11-18 08:00:00	DIA	ETF	118.21	118.34	118.14	118.3	5420.0
2011-11-18 09:00:00	DIA	ETF	118.25	118.3	117.53	117.97	943115.0

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

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