PREVIEW / etf_1hour / 2012-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-11-26.parquet
  size:    187 KB
  rows:    5,870

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
2012-11-26 04:00:00	SPY	ETF	140.74	140.74	140.43	140.43	31778.0
2012-11-26 05:00:00	SPY	ETF	140.51	140.71	140.43	140.71	58850.0
2012-11-26 06:00:00	SPY	ETF	140.74	140.86	140.62	140.64	42354.0
2012-11-26 07:00:00	SPY	ETF	140.66	140.68	140.49	140.53	337159.0
2012-11-26 08:00:00	SPY	ETF	140.55	140.74	140.5	140.69	1533525.0
2012-11-26 09:00:00	SPY	ETF	140.69	140.84	140.44	140.77	14053504.0
2012-11-26 10:00:00	SPY	ETF	140.77	140.88	140.49	140.51	14174890.0
2012-11-26 11:00:00	SPY	ETF	140.51	141.3563	140.19	140.54	13726581.0
2012-11-26 12:00:00	SPY	ETF	140.55	141.3563	140.35	140.7	8811252.0
2012-11-26 13:00:00	SPY	ETF	140.7	140.85	140.59	140.66	7395160.0
2012-11-26 14:00:00	SPY	ETF	140.67	141.3563	140.58	140.85	11599906.0
2012-11-26 15:00:00	SPY	ETF	140.845	141.11	140.7	141.09	17071963.0
2012-11-26 16:00:00	SPY	ETF	141.09	141.3563	140.25	141.05	8301234.0
2012-11-26 17:00:00	SPY	ETF	141.06	141.16	141.06	141.07	195764.0
2012-11-26 18:00:00	SPY	ETF	141.06	141.14	141.05	141.14	43859.0
2012-11-26 19:00:00	SPY	ETF	141.15	141.42	141.12	141.26	434787.0
2012-11-26 04:00:00	QQQ	ETF	64.67	64.67	64.54	64.54	1200.0
2012-11-26 05:00:00	QQQ	ETF	64.62	64.62	64.62	64.62	200.0
2012-11-26 06:00:00	QQQ	ETF	64.69	64.72	64.64	64.64	20500.0
2012-11-26 07:00:00	QQQ	ETF	64.66	64.66	64.6	64.6	25701.0
2012-11-26 08:00:00	QQQ	ETF	64.64	64.72	64.6	64.72	119892.0
2012-11-26 09:00:00	QQQ	ETF	64.7	64.93	64.6104	64.89	4382367.0
2012-11-26 10:00:00	QQQ	ETF	64.9	64.9	64.71	64.73	3145340.0
2012-11-26 11:00:00	QQQ	ETF	64.73	64.82	64.54	64.79	3520457.0
2012-11-26 12:00:00	QQQ	ETF	64.79	65.01	64.75	64.94	3452822.0
2012-11-26 13:00:00	QQQ	ETF	64.945	65.05	64.91	64.97	2367673.0
2012-11-26 14:00:00	QQQ	ETF	64.972	65.15	64.9	65.11	1877277.0
2012-11-26 15:00:00	QQQ	ETF	65.12	65.21	65.015	65.18	4400568.0
2012-11-26 16:00:00	QQQ	ETF	65.18	65.22	65.06	65.16	661561.0
2012-11-26 17:00:00	QQQ	ETF	65.17	65.19	65.0219	65.16	164685.0
2012-11-26 18:00:00	QQQ	ETF	65.18	65.18	65.15	65.18	8518.0
2012-11-26 19:00:00	QQQ	ETF	65.18	65.3	65.17	65.24	31198.0
2012-11-26 05:00:00	IWM	ETF	80.39	80.39	80.39	80.39	100.0
2012-11-26 06:00:00	IWM	ETF	80.37	80.37	80.37	80.37	200.0
2012-11-26 07:00:00	IWM	ETF	80.31	80.32	80.25	80.25	20300.0
2012-11-26 08:00:00	IWM	ETF	80.28	80.44	80.25	80.42	562748.0
2012-11-26 09:00:00	IWM	ETF	80.42	80.65	80.28	80.54	3804177.0
2012-11-26 10:00:00	IWM	ETF	80.55	80.6	80.27	80.27	3735393.0
2012-11-26 11:00:00	IWM	ETF	80.28	80.37	80.07	80.35	3682215.0
2012-11-26 12:00:00	IWM	ETF	80.365	80.52	80.28	80.44	1179381.0
2012-11-26 13:00:00	IWM	ETF	80.44	80.65	80.3999	80.425	1784542.0
2012-11-26 14:00:00	IWM	ETF	80.42	80.58	80.3	80.53	2718820.0
2012-11-26 15:00:00	IWM	ETF	80.53	80.76	80.47	80.74	4581315.0
2012-11-26 16:00:00	IWM	ETF	80.76	80.93	80.45	80.84	2671445.0
2012-11-26 17:00:00	IWM	ETF	80.5378	80.93	80.5378	80.85	65999.0
2012-11-26 19:00:00	IWM	ETF	80.84	80.93	80.84	80.93	10872.0
2012-11-26 04:00:00	DIA	ETF	129.21	129.21	129.18	129.18	1100.0
2012-11-26 06:00:00	DIA	ETF	129.21	129.21	129.21	129.21	100.0
2012-11-26 07:00:00	DIA	ETF	129.12	129.12	129.1	129.1	300.0
2012-11-26 08:00:00	DIA	ETF	129.19	129.34	129.14	129.34	26955.0

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

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