PREVIEW / etf_1hour / 2011-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-28.parquet
  size:    181 KB
  rows:    5,598

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-28 04:00:00	SPY	ETF	135.75	135.75	135.64	135.64	575.0
2011-04-28 05:00:00	SPY	ETF	135.65	135.65	135.59	135.59	300.0
2011-04-28 06:00:00	SPY	ETF	135.58	135.59	135.46	135.47	18800.0
2011-04-28 07:00:00	SPY	ETF	135.53	135.54	135.39	135.39	194830.0
2011-04-28 08:00:00	SPY	ETF	135.43	135.67	135.13	135.34	2627838.0
2011-04-28 09:00:00	SPY	ETF	135.33	135.78	135.25	135.77	11669458.0
2011-04-28 10:00:00	SPY	ETF	135.77	135.85	135.6	135.79	13927133.0
2011-04-28 11:00:00	SPY	ETF	135.79	135.97	135.57	135.675	15671046.0
2011-04-28 12:00:00	SPY	ETF	135.675	135.92	135.6	135.79	15056682.0
2011-04-28 13:00:00	SPY	ETF	135.795	135.89	135.55	135.79	15839651.0
2011-04-28 14:00:00	SPY	ETF	135.79	135.97	135.73	135.91	8688207.0
2011-04-28 15:00:00	SPY	ETF	135.91	136.29	135.84	136.11	27911456.0
2011-04-28 16:00:00	SPY	ETF	136.12	136.1587	135.6676	135.97	8488603.0
2011-04-28 17:00:00	SPY	ETF	135.97	135.99	135.9	135.94	2927587.0
2011-04-28 18:00:00	SPY	ETF	135.91	136.04	135.91	136.04	77159.0
2011-04-28 19:00:00	SPY	ETF	136.03	136.05	135.98	136.03	51849.0
2011-04-28 06:00:00	QQQ	ETF	59.12	59.12	59.12	59.12	100.0
2011-04-28 07:00:00	QQQ	ETF	59.13	59.13	59.08	59.09	41171.0
2011-04-28 08:00:00	QQQ	ETF	59.09	59.13	58.98	59.07	763448.0
2011-04-28 09:00:00	QQQ	ETF	59.07	59.17	58.99	59.15	6780524.0
2011-04-28 10:00:00	QQQ	ETF	59.15	59.17	58.95	59.11	3432177.0
2011-04-28 11:00:00	QQQ	ETF	59.1064	59.19	58.92	58.959	3946716.0
2011-04-28 12:00:00	QQQ	ETF	58.96	59.09	58.92	58.99	3974867.0
2011-04-28 13:00:00	QQQ	ETF	58.99	59.05	58.88	59.03	4348165.0
2011-04-28 14:00:00	QQQ	ETF	59.02	59.1265	58.97	59.08	3617595.0
2011-04-28 15:00:00	QQQ	ETF	59.08	59.23	59.04	59.12	8209273.0
2011-04-28 16:00:00	QQQ	ETF	59.12	59.2304	58.94	59.01	5947217.0
2011-04-28 17:00:00	QQQ	ETF	58.98	58.98	58.92	58.93	96711.0
2011-04-28 18:00:00	QQQ	ETF	58.92	59.14	58.92	58.99	60795.0
2011-04-28 19:00:00	QQQ	ETF	58.99	59.03	58.99	59.02	29681.0
2011-04-28 04:00:00	IWM	ETF	85.81	85.81	85.81	85.81	220.0
2011-04-28 07:00:00	IWM	ETF	85.66	85.71	85.64	85.64	45200.0
2011-04-28 08:00:00	IWM	ETF	85.6	85.75	85.01	85.54	806928.0
2011-04-28 09:00:00	IWM	ETF	85.53	85.86	85.48	85.83	4042222.0
2011-04-28 10:00:00	IWM	ETF	85.84	85.92	85.63	85.8	4262524.0
2011-04-28 11:00:00	IWM	ETF	85.79	85.99	85.65	85.75	5491668.0
2011-04-28 12:00:00	IWM	ETF	85.74	85.94	85.65	85.82	2964343.0
2011-04-28 13:00:00	IWM	ETF	85.81	85.88	85.56	85.73	4058017.0
2011-04-28 14:00:00	IWM	ETF	85.73	85.92	85.69	85.85	3464408.0
2011-04-28 15:00:00	IWM	ETF	85.85	86.5	85.78	86.12	9922653.0
2011-04-28 16:00:00	IWM	ETF	86.3	86.3	85.81	86.06	1381244.0
2011-04-28 17:00:00	IWM	ETF	86.04	86.08	85.88	85.9	276831.0
2011-04-28 18:00:00	IWM	ETF	85.95	86.05	85.89	85.98	31550.0
2011-04-28 19:00:00	IWM	ETF	85.98	86.0	85.93	85.96	4240.0
2011-04-28 05:00:00	DIA	ETF	126.8	126.8	126.8	126.8	100.0
2011-04-28 06:00:00	DIA	ETF	126.73	126.75	126.7	126.7	9500.0
2011-04-28 07:00:00	DIA	ETF	126.72	126.72	126.6	126.61	30500.0
2011-04-28 08:00:00	DIA	ETF	126.62	126.62	126.4	126.54	154030.0
2011-04-28 09:00:00	DIA	ETF	126.56	126.9	126.49	126.9	1956892.0
2011-04-28 10:00:00	DIA	ETF	126.89	126.96	126.75	126.89	701816.0

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

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