PREVIEW / etf_1hour / 2012-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-12-10.parquet
  size:    185 KB
  rows:    5,804

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-12-10 04:00:00	SPY	ETF	142.06	142.06	141.88	141.88	22698.0
2012-12-10 05:00:00	SPY	ETF	141.88	141.91	141.77	141.91	34844.0
2012-12-10 06:00:00	SPY	ETF	141.94	142.09	141.94	142.03	105639.0
2012-12-10 07:00:00	SPY	ETF	142.06	142.09	141.93	141.97	238587.0
2012-12-10 08:00:00	SPY	ETF	142.02	142.33	142.01	142.28	605277.0
2012-12-10 09:00:00	SPY	ETF	142.27	142.56	142.11	142.475	13235207.0
2012-12-10 10:00:00	SPY	ETF	142.47	142.8	142.35	142.795	13423578.0
2012-12-10 11:00:00	SPY	ETF	142.79	142.81	142.56	142.615	9713747.0
2012-12-10 12:00:00	SPY	ETF	142.61	142.78	142.56	142.65	5712456.0
2012-12-10 13:00:00	SPY	ETF	142.645	142.65	142.47	142.48	6649868.0
2012-12-10 14:00:00	SPY	ETF	142.49	142.58	142.28	142.55	9840490.0
2012-12-10 15:00:00	SPY	ETF	142.55	142.67	142.45	142.51	20124184.0
2012-12-10 16:00:00	SPY	ETF	142.5	142.75	142.3291	142.48	13483104.0
2012-12-10 17:00:00	SPY	ETF	142.49	142.52	142.38	142.4	595061.0
2012-12-10 18:00:00	SPY	ETF	142.4	142.46	142.32	142.32	125200.0
2012-12-10 19:00:00	SPY	ETF	142.35	142.38	142.32	142.34	62670.0
2012-12-10 05:00:00	QQQ	ETF	64.7	64.7	64.7	64.7	1800.0
2012-12-10 06:00:00	QQQ	ETF	64.67	64.73	64.67	64.73	1532.0
2012-12-10 07:00:00	QQQ	ETF	64.74	64.75	64.69	64.74	6200.0
2012-12-10 08:00:00	QQQ	ETF	64.68	64.842	64.68	64.8	1140288.0
2012-12-10 09:00:00	QQQ	ETF	64.82	65.23	64.7	65.16	5049193.0
2012-12-10 10:00:00	QQQ	ETF	65.16	65.45	65.03	65.44	4720251.0
2012-12-10 11:00:00	QQQ	ETF	65.45	65.455	65.21	65.23	2880165.0
2012-12-10 12:00:00	QQQ	ETF	65.23	65.31	65.08	65.115	1867340.0
2012-12-10 13:00:00	QQQ	ETF	65.11	65.13	64.99	65.08	1641284.0
2012-12-10 14:00:00	QQQ	ETF	65.09	65.17	64.93	65.15	2224839.0
2012-12-10 15:00:00	QQQ	ETF	65.15	65.2	65.06	65.12	3594814.0
2012-12-10 16:00:00	QQQ	ETF	65.11	65.27	64.9415	64.9415	5539367.0
2012-12-10 17:00:00	QQQ	ETF	65.17	65.2	65.13	65.18	9410.0
2012-12-10 18:00:00	QQQ	ETF	65.17	65.17	65.1	65.13	8700.0
2012-12-10 19:00:00	QQQ	ETF	65.12	65.14	65.1	65.13	16975.0
2012-12-10 04:00:00	IWM	ETF	82.15	82.15	82.15	82.15	100.0
2012-12-10 06:00:00	IWM	ETF	82.19	82.3	82.17	82.3	36200.0
2012-12-10 07:00:00	IWM	ETF	82.3	82.3	82.2	82.29	16200.0
2012-12-10 08:00:00	IWM	ETF	82.29	82.42	82.15	82.4	685173.0
2012-12-10 09:00:00	IWM	ETF	82.38	82.455	82.21	82.35	4919403.0
2012-12-10 10:00:00	IWM	ETF	82.36	82.6	82.25	82.5801	4513248.0
2012-12-10 11:00:00	IWM	ETF	82.59	82.66	82.48	82.53	3015175.0
2012-12-10 12:00:00	IWM	ETF	82.53	82.575	82.42	82.48	1736402.0
2012-12-10 13:00:00	IWM	ETF	82.48	82.48	82.35	82.38	1506122.0
2012-12-10 14:00:00	IWM	ETF	82.38	82.42	82.27	82.39	1646523.0
2012-12-10 15:00:00	IWM	ETF	82.39	82.59	82.34	82.56	5252607.0
2012-12-10 16:00:00	IWM	ETF	82.56	82.69	82.4487	82.56	1219057.0
2012-12-10 17:00:00	IWM	ETF	82.3597	82.56	82.3597	82.56	31000.0
2012-12-10 18:00:00	IWM	ETF	82.56	82.56	82.56	82.56	500.0
2012-12-10 19:00:00	IWM	ETF	82.53	82.57	82.51	82.53	4325.0
2012-12-10 04:00:00	DIA	ETF	131.56	131.56	131.56	131.56	100.0
2012-12-10 06:00:00	DIA	ETF	131.3	131.3	131.3	131.3	500.0
2012-12-10 08:00:00	DIA	ETF	131.33	131.61	131.33	131.59	18550.0
2012-12-10 09:00:00	DIA	ETF	131.57	131.86	131.48	131.81	549463.0

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

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