PREVIEW / etf_1hour / 2012-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-17.parquet
  size:    195 KB
  rows:    6,077

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-05-17 04:00:00	SPY	ETF	133.06	133.49	133.06	133.44	20750.0
2012-05-17 05:00:00	SPY	ETF	133.3	133.3	133.09	133.15	1000.0
2012-05-17 06:00:00	SPY	ETF	133.04	133.04	132.8	132.9	89272.0
2012-05-17 07:00:00	SPY	ETF	132.86	132.93	132.16	132.41	1848492.0
2012-05-17 08:00:00	SPY	ETF	132.43	133.1	132.21	133.0	2116138.0
2012-05-17 09:00:00	SPY	ETF	133.0	133.07	132.29	132.54	24145323.0
2012-05-17 10:00:00	SPY	ETF	132.54	132.75	131.83	132.488	45794270.0
2012-05-17 11:00:00	SPY	ETF	132.489	132.66	131.86	132.0614	28008636.0
2012-05-17 12:00:00	SPY	ETF	132.07	132.09	131.44	131.83	29834045.0
2012-05-17 13:00:00	SPY	ETF	131.84	132.29	131.73	131.93	20908535.0
2012-05-17 14:00:00	SPY	ETF	131.93	131.93	131.52	131.665	21064719.0
2012-05-17 15:00:00	SPY	ETF	131.66	131.8	130.81	130.83	43835014.0
2012-05-17 16:00:00	SPY	ETF	130.83	132.8417	130.58	130.85	27391496.0
2012-05-17 17:00:00	SPY	ETF	130.87	131.03	130.79	130.94	394840.0
2012-05-17 18:00:00	SPY	ETF	130.94	131.05	130.73	130.88	141644.0
2012-05-17 19:00:00	SPY	ETF	130.87	131.03	130.81	131.0	187226.0
2012-05-17 04:00:00	QQQ	ETF	63.0	63.0	62.93	63.0	908.0
2012-05-17 06:00:00	QQQ	ETF	62.85	62.85	62.77	62.79	2300.0
2012-05-17 07:00:00	QQQ	ETF	62.78	62.84	62.5	62.61	35400.0
2012-05-17 08:00:00	QQQ	ETF	62.63	62.93	62.62	62.91	492393.0
2012-05-17 09:00:00	QQQ	ETF	62.92	63.06	62.58	62.74	6958157.0
2012-05-17 10:00:00	QQQ	ETF	62.74	62.8601	62.44	62.6077	12789687.0
2012-05-17 11:00:00	QQQ	ETF	62.61	62.65	62.24	62.3	8364025.0
2012-05-17 12:00:00	QQQ	ETF	62.31	62.34	62.05	62.26	6827231.0
2012-05-17 13:00:00	QQQ	ETF	62.27	62.55	62.21	62.3	5376322.0
2012-05-17 14:00:00	QQQ	ETF	62.29	62.295	61.99	62.07	5136534.0
2012-05-17 15:00:00	QQQ	ETF	62.07	62.1801	61.61	61.61	12521246.0
2012-05-17 16:00:00	QQQ	ETF	61.61	63.6288	61.55	61.64	2495545.0
2012-05-17 17:00:00	QQQ	ETF	61.65	61.76	61.65	61.76	32730.0
2012-05-17 18:00:00	QQQ	ETF	61.72	61.74	61.64	61.66	15240.0
2012-05-17 19:00:00	QQQ	ETF	61.67	61.75	61.66	61.73	23004.0
2012-05-17 04:00:00	IWM	ETF	77.29	77.29	77.29	77.29	1500.0
2012-05-17 06:00:00	IWM	ETF	77.04	77.04	77.04	77.04	200.0
2012-05-17 07:00:00	IWM	ETF	77.06	77.09	76.63	76.83	186188.0
2012-05-17 08:00:00	IWM	ETF	76.8	77.28	76.79	77.26	1084264.0
2012-05-17 09:00:00	IWM	ETF	77.24	77.36	76.62	76.76	6587837.0
2012-05-17 10:00:00	IWM	ETF	76.77	77.07	76.37	76.67	14157667.0
2012-05-17 11:00:00	IWM	ETF	76.67	76.75	76.15	76.23	8744032.0
2012-05-17 12:00:00	IWM	ETF	76.23	76.35	75.84	76.15	7614915.0
2012-05-17 13:00:00	IWM	ETF	76.15	76.52	76.015	76.08	5615418.0
2012-05-17 14:00:00	IWM	ETF	76.08	76.18	75.88	75.99	5190321.0
2012-05-17 15:00:00	IWM	ETF	75.98	76.11	75.36	75.41	13212763.0
2012-05-17 16:00:00	IWM	ETF	75.39	76.67	75.2	75.42	1768629.0
2012-05-17 17:00:00	IWM	ETF	75.42	75.56	75.4	75.56	25482.0
2012-05-17 18:00:00	IWM	ETF	75.51	75.59	75.45	75.59	2900.0
2012-05-17 19:00:00	IWM	ETF	75.58	75.58	75.43	75.43	4025.0
2012-05-17 06:00:00	DIA	ETF	126.05	126.05	126.03	126.03	700.0
2012-05-17 07:00:00	DIA	ETF	126.1	126.1	125.7	125.82	8800.0
2012-05-17 08:00:00	DIA	ETF	125.97	126.33	125.92	126.33	2700.0
2012-05-17 09:00:00	DIA	ETF	126.23	126.3	125.7	125.93	690998.0

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

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