PREVIEW / etf_1hour / 2013-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-12-19.parquet
  size:    215 KB
  rows:    6,830

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
2013-12-19 04:00:00	SPY	ETF	181.54	181.54	181.42	181.47	137133.0
2013-12-19 05:00:00	SPY	ETF	181.48	181.49	181.33	181.46	91289.0
2013-12-19 06:00:00	SPY	ETF	181.44	181.65	181.4	181.5	142734.0
2013-12-19 07:00:00	SPY	ETF	181.52	181.68	181.42	181.43	377928.0
2013-12-19 08:00:00	SPY	ETF	181.45	181.5607	180.75	180.77	3214165.0
2013-12-19 09:00:00	SPY	ETF	180.77	181.42	180.72	181.16	20263878.0
2013-12-19 10:00:00	SPY	ETF	181.16	181.34	180.71	181.22	22956769.0
2013-12-19 11:00:00	SPY	ETF	181.22	181.44	181.065	181.37	16213156.0
2013-12-19 12:00:00	SPY	ETF	181.38	181.51	181.22	181.42	11230262.0
2013-12-19 13:00:00	SPY	ETF	181.42	181.63	181.31	181.54	8860003.0
2013-12-19 14:00:00	SPY	ETF	181.54	181.6	181.3	181.501	10767149.0
2013-12-19 15:00:00	SPY	ETF	181.5	181.7	181.36	181.525	24614583.0
2013-12-19 16:00:00	SPY	ETF	181.51	181.7571	181.36	181.37	14244067.0
2013-12-19 17:00:00	SPY	ETF	181.38	181.75	181.38	181.62	601351.0
2013-12-19 18:00:00	SPY	ETF	181.59	181.67	181.55	181.58	71335.0
2013-12-19 19:00:00	SPY	ETF	181.56	181.66	181.54	181.56	9730.0
2013-12-19 04:00:00	QQQ	ETF	86.13	86.15	86.13	86.13	2600.0
2013-12-19 05:00:00	QQQ	ETF	86.11	86.13	86.05	86.13	9200.0
2013-12-19 06:00:00	QQQ	ETF	86.11	86.13	86.04	86.04	14000.0
2013-12-19 07:00:00	QQQ	ETF	86.07	86.09	86.04	86.04	29800.0
2013-12-19 08:00:00	QQQ	ETF	86.05	86.09	85.79	85.8	502643.0
2013-12-19 09:00:00	QQQ	ETF	85.8	86.01	85.77	85.79	5563048.0
2013-12-19 10:00:00	QQQ	ETF	85.79	85.93	85.52	85.84	8953226.0
2013-12-19 11:00:00	QQQ	ETF	85.84	85.94	85.78	85.8699	4257033.0
2013-12-19 12:00:00	QQQ	ETF	85.87	85.89	85.79	85.85	4732450.0
2013-12-19 13:00:00	QQQ	ETF	85.86	85.96	85.8001	85.935	4491682.0
2013-12-19 14:00:00	QQQ	ETF	85.935	85.99	85.82	85.91	4328276.0
2013-12-19 15:00:00	QQQ	ETF	85.9	85.96	85.795	85.9	4961603.0
2013-12-19 16:00:00	QQQ	ETF	85.9	85.93	85.684	85.895	927729.0
2013-12-19 17:00:00	QQQ	ETF	85.9	86.1778	85.84	86.1778	1059659.0
2013-12-19 18:00:00	QQQ	ETF	85.9	85.98	85.9	85.94	16200.0
2013-12-19 19:00:00	QQQ	ETF	85.95	85.95	85.93	85.93	1300.0
2013-12-19 07:00:00	IWM	ETF	112.98	113.15	112.95	113.01	109475.0
2013-12-19 08:00:00	IWM	ETF	113.0	113.03	112.59	112.6	226090.0
2013-12-19 09:00:00	IWM	ETF	112.57	112.85	112.36	112.49	4775308.0
2013-12-19 10:00:00	IWM	ETF	112.4999	112.58	112.22	112.35	6006010.0
2013-12-19 11:00:00	IWM	ETF	112.36	112.51	112.27	112.33	2912275.0
2013-12-19 12:00:00	IWM	ETF	112.338	112.35	112.095	112.25	3426937.0
2013-12-19 13:00:00	IWM	ETF	112.255	112.45	112.21	112.33	2805353.0
2013-12-19 14:00:00	IWM	ETF	112.33	112.36	112.0101	112.11	2499515.0
2013-12-19 15:00:00	IWM	ETF	112.11	112.2	111.885	112.04	6364201.0
2013-12-19 16:00:00	IWM	ETF	112.04	112.25	111.91	112.0	845354.0
2013-12-19 17:00:00	IWM	ETF	111.94	112.1	111.92	112.0	12752.0
2013-12-19 18:00:00	IWM	ETF	112.0	112.0	112.0	112.0	200.0
2013-12-19 04:00:00	DIA	ETF	161.7	161.7	161.7	161.7	500.0
2013-12-19 08:00:00	DIA	ETF	161.6	161.63	161.2	161.22	11150.0
2013-12-19 09:00:00	DIA	ETF	161.06	161.72	161.0	161.58	1222801.0
2013-12-19 10:00:00	DIA	ETF	161.54	161.68	161.28	161.6	1728130.0
2013-12-19 11:00:00	DIA	ETF	161.61	161.73	161.46	161.6884	717410.0
2013-12-19 12:00:00	DIA	ETF	161.69	161.82	161.58	161.78	578433.0

> showing 50 of 6,830 rows — these rows as CSV

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