PREVIEW / etf_1hour / 2011-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-29.parquet
  size:    179 KB
  rows:    5,510

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-29 04:00:00	SPY	ETF	135.87	135.87	135.77	135.77	3442.0
2011-04-29 05:00:00	SPY	ETF	135.84	135.97	135.84	135.89	10300.0
2011-04-29 06:00:00	SPY	ETF	135.95	136.05	135.95	136.05	11300.0
2011-04-29 07:00:00	SPY	ETF	136.05	136.29	135.98	136.22	341861.0
2011-04-29 08:00:00	SPY	ETF	136.22	136.2646	136.1	136.11	976448.0
2011-04-29 09:00:00	SPY	ETF	136.11	136.33	136.02	136.02	15236089.0
2011-04-29 10:00:00	SPY	ETF	136.03	136.28	135.98	136.26	14191068.0
2011-04-29 11:00:00	SPY	ETF	136.26	136.43	136.18	136.33	14066677.0
2011-04-29 12:00:00	SPY	ETF	136.34	136.5	136.33	136.46	7950160.0
2011-04-29 13:00:00	SPY	ETF	136.46	136.54	136.37	136.39	7292239.0
2011-04-29 14:00:00	SPY	ETF	136.39	136.57	136.355	136.39	7370596.0
2011-04-29 15:00:00	SPY	ETF	136.39	136.49	136.23	136.46	24514554.0
2011-04-29 16:00:00	SPY	ETF	136.46	136.84	136.2	136.76	18160417.0
2011-04-29 17:00:00	SPY	ETF	136.75	136.78	136.56	136.78	215889.0
2011-04-29 18:00:00	SPY	ETF	136.77	136.78	136.3854	136.74	91236.0
2011-04-29 19:00:00	SPY	ETF	136.75	136.78	136.7	136.78	26324.0
2011-04-29 04:00:00	QQQ	ETF	59.01	59.01	59.01	59.01	100.0
2011-04-29 06:00:00	QQQ	ETF	59.07	59.07	59.07	59.07	198800.0
2011-04-29 07:00:00	QQQ	ETF	59.07	59.09	59.01	59.06	570780.0
2011-04-29 08:00:00	QQQ	ETF	59.05	59.09	59.01	59.01	1220487.0
2011-04-29 09:00:00	QQQ	ETF	59.02	59.22	59.0	59.0	7328633.0
2011-04-29 10:00:00	QQQ	ETF	59.0	59.14	58.98	59.115	3931467.0
2011-04-29 11:00:00	QQQ	ETF	59.113	59.18	59.05	59.12	5330492.0
2011-04-29 12:00:00	QQQ	ETF	59.127	59.21	59.11	59.19	2149337.0
2011-04-29 13:00:00	QQQ	ETF	59.19	59.26	59.15	59.16	2231722.0
2011-04-29 14:00:00	QQQ	ETF	59.16	59.29	59.13	59.16	2803549.0
2011-04-29 15:00:00	QQQ	ETF	59.16	59.22	59.02	59.11	12241080.0
2011-04-29 16:00:00	QQQ	ETF	59.11	59.2	59.045	59.15	3513688.0
2011-04-29 17:00:00	QQQ	ETF	59.14	59.15	59.09	59.15	82850.0
2011-04-29 18:00:00	QQQ	ETF	59.0	59.14	59.0	59.14	8957.0
2011-04-29 19:00:00	QQQ	ETF	59.13	59.18	59.13	59.18	5300.0
2011-04-29 04:00:00	IWM	ETF	85.87	85.87	85.87	85.87	500.0
2011-04-29 07:00:00	IWM	ETF	86.12	86.28	86.1	86.28	65380.0
2011-04-29 08:00:00	IWM	ETF	86.25	86.32	86.16	86.16	192125.0
2011-04-29 09:00:00	IWM	ETF	86.15	86.41	85.98	85.99	5547059.0
2011-04-29 10:00:00	IWM	ETF	85.99	86.24	85.93	86.2	3613920.0
2011-04-29 11:00:00	IWM	ETF	86.2	86.5	86.15	86.45	5896741.0
2011-04-29 12:00:00	IWM	ETF	86.4599	86.61	86.44	86.5	5202671.0
2011-04-29 13:00:00	IWM	ETF	86.49	86.59	86.49	86.495	1874807.0
2011-04-29 14:00:00	IWM	ETF	86.495	86.68	86.47	86.49	2625046.0
2011-04-29 15:00:00	IWM	ETF	86.49	86.63	86.37	86.38	7352479.0
2011-04-29 16:00:00	IWM	ETF	86.38	86.57	86.1984	86.51	3062222.0
2011-04-29 17:00:00	IWM	ETF	86.47	86.51	86.47	86.51	15300.0
2011-04-29 18:00:00	IWM	ETF	86.52	86.57	86.51	86.57	3530.0
2011-04-29 19:00:00	IWM	ETF	86.57	86.6	86.56	86.6	1900.0
2011-04-29 04:00:00	DIA	ETF	127.19	127.19	127.18	127.18	1000.0
2011-04-29 07:00:00	DIA	ETF	127.51	127.65	127.51	127.65	500.0
2011-04-29 08:00:00	DIA	ETF	127.68	127.72	127.57	127.58	111900.0
2011-04-29 09:00:00	DIA	ETF	127.58	127.84	127.54	127.6	429968.0
2011-04-29 10:00:00	DIA	ETF	127.59	127.86	127.55	127.85	652716.0

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

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