PREVIEW / etf_1hour / 2012-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-27.parquet
  size:    190 KB
  rows:    5,788

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-07-27 04:00:00	SPY	ETF	136.12	136.2	136.0	136.1	14994.0
2012-07-27 05:00:00	SPY	ETF	136.0	136.52	135.96	136.15	15565.0
2012-07-27 06:00:00	SPY	ETF	136.23	136.59	136.22	136.56	22138.0
2012-07-27 07:00:00	SPY	ETF	136.57	136.78	136.44	136.45	514406.0
2012-07-27 08:00:00	SPY	ETF	136.48	137.02	136.42	136.74	2458070.0
2012-07-27 09:00:00	SPY	ETF	136.74	137.17	136.65	137.14	16469864.0
2012-07-27 10:00:00	SPY	ETF	137.14	137.59	137.02	137.54	29030818.0
2012-07-27 11:00:00	SPY	ETF	137.55	137.72	137.51	137.65	19129990.0
2012-07-27 12:00:00	SPY	ETF	137.66	137.9	137.58	137.8	11188870.0
2012-07-27 13:00:00	SPY	ETF	137.8	139.01	137.78	138.668	42069267.0
2012-07-27 14:00:00	SPY	ETF	138.67	138.78	138.39	138.7	29568112.0
2012-07-27 15:00:00	SPY	ETF	138.7	139.07	138.57	138.7	41426495.0
2012-07-27 16:00:00	SPY	ETF	138.69	138.93	136.1364	138.88	38686967.0
2012-07-27 17:00:00	SPY	ETF	138.87	138.89	138.74	138.8	2097573.0
2012-07-27 18:00:00	SPY	ETF	138.81	138.81	138.68	138.72	45054.0
2012-07-27 19:00:00	SPY	ETF	138.72	138.74	138.68	138.72	34149.0
2012-07-27 04:00:00	QQQ	ETF	63.38	63.38	63.36	63.36	651.0
2012-07-27 05:00:00	QQQ	ETF	63.29	63.29	63.29	63.29	300.0
2012-07-27 06:00:00	QQQ	ETF	63.45	63.48	63.4	63.41	1200.0
2012-07-27 07:00:00	QQQ	ETF	63.5	63.58	63.48	63.49	76950.0
2012-07-27 08:00:00	QQQ	ETF	63.5	63.73	63.46	63.63	189391.0
2012-07-27 09:00:00	QQQ	ETF	63.63	63.92	63.62	63.9	7113639.0
2012-07-27 10:00:00	QQQ	ETF	63.9	64.18	63.8	64.131	4601462.0
2012-07-27 11:00:00	QQQ	ETF	64.1399	64.3	64.12	64.28	5090951.0
2012-07-27 12:00:00	QQQ	ETF	64.28	64.43	64.22	64.3899	3070636.0
2012-07-27 13:00:00	QQQ	ETF	64.39	64.92	64.36	64.74	8159306.0
2012-07-27 14:00:00	QQQ	ETF	64.7348	64.83	64.62	64.795	2854394.0
2012-07-27 15:00:00	QQQ	ETF	64.8	64.99	64.77	64.91	7660939.0
2012-07-27 16:00:00	QQQ	ETF	64.91	65.02	63.3914	64.97	3459568.0
2012-07-27 17:00:00	QQQ	ETF	64.97	64.98	64.91	64.93	9379.0
2012-07-27 18:00:00	QQQ	ETF	64.89	64.96	64.89	64.96	2765.0
2012-07-27 19:00:00	QQQ	ETF	64.9	64.9	64.9	64.9	200.0
2012-07-27 07:00:00	IWM	ETF	77.66	77.71	77.49	77.5	119896.0
2012-07-27 08:00:00	IWM	ETF	77.54	77.87	77.53	77.68	457629.0
2012-07-27 09:00:00	IWM	ETF	77.69	77.97	77.39	77.89	6108903.0
2012-07-27 10:00:00	IWM	ETF	77.89	78.54	77.85	78.48	9013438.0
2012-07-27 11:00:00	IWM	ETF	78.48	78.82	78.48	78.8	6622573.0
2012-07-27 12:00:00	IWM	ETF	78.8	78.91	78.62	78.84	2382990.0
2012-07-27 13:00:00	IWM	ETF	78.85	79.72	78.78	79.4	11948358.0
2012-07-27 14:00:00	IWM	ETF	79.4	79.42	79.1	79.35	6886303.0
2012-07-27 15:00:00	IWM	ETF	79.35	79.63	79.26	79.39	11217099.0
2012-07-27 16:00:00	IWM	ETF	79.4	79.75	77.5	79.62	4169329.0
2012-07-27 17:00:00	IWM	ETF	79.64	79.64	79.57	79.57	1100.0
2012-07-27 18:00:00	IWM	ETF	79.57	79.6	79.57	79.57	7790.0
2012-07-27 19:00:00	IWM	ETF	79.5	79.55	79.5	79.55	350.0
2012-07-27 07:00:00	DIA	ETF	128.9	129.0	128.9	128.93	7100.0
2012-07-27 08:00:00	DIA	ETF	128.85	129.05	128.8	128.85	5920.0
2012-07-27 09:00:00	DIA	ETF	128.9	129.41	128.9	129.3599	950773.0
2012-07-27 10:00:00	DIA	ETF	129.35	129.63	129.14	129.6	688843.0
2012-07-27 11:00:00	DIA	ETF	129.61	129.7	129.48	129.632	794248.0

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

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