PREVIEW / etf_1hour / 2011-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-20.parquet
  size:    186 KB
  rows:    5,740

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-12-20 04:00:00	SPY	ETF	121.26	121.74	121.25	121.55	6790.0
2011-12-20 05:00:00	SPY	ETF	121.56	121.7	121.45	121.53	86469.0
2011-12-20 06:00:00	SPY	ETF	121.57	121.68	121.4	121.43	148980.0
2011-12-20 07:00:00	SPY	ETF	121.42	121.75	121.31	121.73	686483.0
2011-12-20 08:00:00	SPY	ETF	121.75	122.05	120.95	121.92	4374844.0
2011-12-20 09:00:00	SPY	ETF	121.92	123.17	121.92	122.98	33061016.0
2011-12-20 10:00:00	SPY	ETF	122.99	123.47	122.85	123.36	27513991.0
2011-12-20 11:00:00	SPY	ETF	123.35	123.65	123.26	123.43	19947029.0
2011-12-20 12:00:00	SPY	ETF	123.4254	123.58	123.26	123.55	12957978.0
2011-12-20 13:00:00	SPY	ETF	123.55	123.93	120.3702	123.69	22893328.0
2011-12-20 14:00:00	SPY	ETF	123.695	124.06	123.56	123.895	15751551.0
2011-12-20 15:00:00	SPY	ETF	123.9	124.14	123.75	123.93	40114446.0
2011-12-20 16:00:00	SPY	ETF	123.92	124.19	120.3702	124.11	39205717.0
2011-12-20 17:00:00	SPY	ETF	124.12	124.13	120.3702	123.98	3378158.0
2011-12-20 18:00:00	SPY	ETF	123.97	124.07	123.88	124.04	662337.0
2011-12-20 19:00:00	SPY	ETF	124.04	124.1	123.97	124.05	187304.0
2011-12-20 04:00:00	QQQ	ETF	54.76	54.76	54.76	54.76	300.0
2011-12-20 05:00:00	QQQ	ETF	54.83	54.92	54.83	54.85	2400.0
2011-12-20 06:00:00	QQQ	ETF	54.88	54.88	54.83	54.83	300.0
2011-12-20 07:00:00	QQQ	ETF	54.77	54.98	54.72	54.98	244025.0
2011-12-20 08:00:00	QQQ	ETF	54.97	55.02	54.68	54.99	1274123.0
2011-12-20 09:00:00	QQQ	ETF	54.99	55.59	54.99	55.5	16985135.0
2011-12-20 10:00:00	QQQ	ETF	55.5	55.72	55.44	55.65	11583637.0
2011-12-20 11:00:00	QQQ	ETF	55.65	55.89	55.61	55.82	7669408.0
2011-12-20 12:00:00	QQQ	ETF	55.81	55.82	55.75	55.81	3915706.0
2011-12-20 13:00:00	QQQ	ETF	55.8014	56.0	55.8014	55.87	5915231.0
2011-12-20 14:00:00	QQQ	ETF	55.87	55.96	55.81	55.9	2961919.0
2011-12-20 15:00:00	QQQ	ETF	55.9	55.98	55.8199	55.94	8232798.0
2011-12-20 16:00:00	QQQ	ETF	55.94	56.09	55.66	55.79	4735348.0
2011-12-20 17:00:00	QQQ	ETF	55.8	55.81	55.67	55.72	168488.0
2011-12-20 18:00:00	QQQ	ETF	55.72	55.72	55.69	55.69	57800.0
2011-12-20 19:00:00	QQQ	ETF	55.7	55.72	55.68	55.72	18632.0
2011-12-20 04:00:00	IWM	ETF	71.6	71.6	71.6	71.6	200.0
2011-12-20 06:00:00	IWM	ETF	71.74	71.76	71.7	71.72	1800.0
2011-12-20 07:00:00	IWM	ETF	71.68	72.06	71.64	72.02	575732.0
2011-12-20 08:00:00	IWM	ETF	72.06	72.28	71.86	72.27	1493138.0
2011-12-20 09:00:00	IWM	ETF	72.26	73.09	72.26	72.95	11093272.0
2011-12-20 10:00:00	IWM	ETF	72.95	73.47	72.88	73.43	8909709.0
2011-12-20 11:00:00	IWM	ETF	73.4299	73.78	73.33	73.585	7494315.0
2011-12-20 12:00:00	IWM	ETF	73.58	73.59	73.41	73.56	3648638.0
2011-12-20 13:00:00	IWM	ETF	73.57	73.69	73.46	73.51	3513351.0
2011-12-20 14:00:00	IWM	ETF	73.501	73.75	73.4	73.69	4656614.0
2011-12-20 15:00:00	IWM	ETF	73.69	73.97	73.62	73.85	13105496.0
2011-12-20 16:00:00	IWM	ETF	73.87	73.98	70.9595	73.94	7556584.0
2011-12-20 17:00:00	IWM	ETF	73.91	73.91	73.8	73.83	42867.0
2011-12-20 18:00:00	IWM	ETF	73.85	73.9	73.83	73.88	7700.0
2011-12-20 19:00:00	IWM	ETF	73.91	73.95	73.85	73.95	27568.0
2011-12-20 07:00:00	DIA	ETF	118.54	118.54	118.5	118.5	700.0
2011-12-20 08:00:00	DIA	ETF	118.5	118.81	118.37	118.76	21050.0
2011-12-20 09:00:00	DIA	ETF	118.75	119.93	118.75	119.77	1482495.0

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

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