PREVIEW / etf_1hour / 2011-04-04

all etf 1-hour files

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

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-04 05:00:00	SPY	ETF	133.35	133.41	133.27	133.3	3900.0
2011-04-04 06:00:00	SPY	ETF	133.32	133.49	133.32	133.47	27880.0
2011-04-04 07:00:00	SPY	ETF	133.46	133.55	133.37	133.41	196081.0
2011-04-04 08:00:00	SPY	ETF	133.41	133.53	133.4	133.44	380312.0
2011-04-04 09:00:00	SPY	ETF	133.45	133.67	133.15	133.34	15427315.0
2011-04-04 10:00:00	SPY	ETF	133.34	133.44	133.16	133.23	17104334.0
2011-04-04 11:00:00	SPY	ETF	133.22	133.38	133.11	133.31	9715807.0
2011-04-04 12:00:00	SPY	ETF	133.315	133.37	133.1	133.19	8375645.0
2011-04-04 13:00:00	SPY	ETF	133.18	133.27	132.88	132.99	10434652.0
2011-04-04 14:00:00	SPY	ETF	132.99	133.14	132.88	133.08	9112100.0
2011-04-04 15:00:00	SPY	ETF	133.08	133.26	132.95	133.24	18824901.0
2011-04-04 16:00:00	SPY	ETF	133.25	133.48	133.2245	133.4	7776119.0
2011-04-04 17:00:00	SPY	ETF	133.4	133.45	133.38	133.44	87348.0
2011-04-04 18:00:00	SPY	ETF	133.44	133.44	133.24	133.4	56333.0
2011-04-04 19:00:00	SPY	ETF	133.43	133.5	133.37	133.37	68160.0
2011-04-04 05:00:00	QQQ	ETF	57.59	57.59	57.59	57.59	800.0
2011-04-04 06:00:00	QQQ	ETF	57.66	57.66	57.66	57.66	200.0
2011-04-04 07:00:00	QQQ	ETF	57.66	57.68	57.63	57.65	25613.0
2011-04-04 08:00:00	QQQ	ETF	57.63	57.68	57.63	57.64	92787.0
2011-04-04 09:00:00	QQQ	ETF	57.65	57.68	57.34	57.39	7927343.0
2011-04-04 10:00:00	QQQ	ETF	57.39	57.41	57.22	57.2494	7588617.0
2011-04-04 11:00:00	QQQ	ETF	57.24	57.38	57.21	57.3575	3417045.0
2011-04-04 12:00:00	QQQ	ETF	57.36	57.4	57.19	57.2325	2522914.0
2011-04-04 13:00:00	QQQ	ETF	57.239	57.26	57.02	57.06	4976756.0
2011-04-04 14:00:00	QQQ	ETF	57.06	57.15	57.03	57.12	4155082.0
2011-04-04 15:00:00	QQQ	ETF	57.1162	57.28	57.02	57.28	7569919.0
2011-04-04 16:00:00	QQQ	ETF	57.28	57.51	57.1761	57.5	6077066.0
2011-04-04 17:00:00	QQQ	ETF	57.5	57.53	57.48	57.51	151573.0
2011-04-04 18:00:00	QQQ	ETF	57.51	57.51	57.29	57.49	52306.0
2011-04-04 19:00:00	QQQ	ETF	57.49	57.54	57.48	57.49	30986.0
2011-04-04 06:00:00	IWM	ETF	84.79	84.79	84.79	84.79	210.0
2011-04-04 07:00:00	IWM	ETF	84.83	84.87	84.76	84.76	24419.0
2011-04-04 08:00:00	IWM	ETF	84.78	84.9	84.76	84.79	94299.0
2011-04-04 09:00:00	IWM	ETF	84.77	84.93	84.54	84.74	4804092.0
2011-04-04 10:00:00	IWM	ETF	84.75	84.96	84.5899	84.83	6388093.0
2011-04-04 11:00:00	IWM	ETF	84.83	84.95	84.75	84.92	4248936.0
2011-04-04 12:00:00	IWM	ETF	84.92	84.97	84.75	84.8119	5044576.0
2011-04-04 13:00:00	IWM	ETF	84.82	84.8502	84.54	84.64	2869173.0
2011-04-04 14:00:00	IWM	ETF	84.64	84.8	84.56	84.655	4485878.0
2011-04-04 15:00:00	IWM	ETF	84.65	84.9	84.545	84.74	6938854.0
2011-04-04 16:00:00	IWM	ETF	84.74	87.9157	84.72	84.93	1417969.0
2011-04-04 17:00:00	IWM	ETF	84.93	84.97	84.93	84.97	31800.0
2011-04-04 18:00:00	IWM	ETF	84.93	84.93	84.93	84.93	200.0
2011-04-04 19:00:00	IWM	ETF	84.95	84.98	84.93	84.98	2700.0
2011-04-04 06:00:00	DIA	ETF	123.67	123.67	123.67	123.67	100.0
2011-04-04 08:00:00	DIA	ETF	123.7	123.71	123.67	123.68	6200.0
2011-04-04 09:00:00	DIA	ETF	123.65	123.8368	123.57	123.6299	441432.0
2011-04-04 10:00:00	DIA	ETF	123.64	123.76	123.49	123.6	1519389.0
2011-04-04 11:00:00	DIA	ETF	123.62	123.76	123.53	123.72	348585.0
2011-04-04 12:00:00	DIA	ETF	123.73	123.77	123.59	123.66	270540.0

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

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