PREVIEW / etf_1hour / 2012-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-21.parquet
  size:    190 KB
  rows:    5,819

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-06-21 04:00:00	SPY	ETF	135.0	135.13	134.97	135.12	4300.0
2012-06-21 05:00:00	SPY	ETF	135.12	135.36	135.12	135.32	43654.0
2012-06-21 06:00:00	SPY	ETF	135.29	135.34	135.22	135.26	58310.0
2012-06-21 07:00:00	SPY	ETF	135.26	135.88	135.22	135.62	215417.0
2012-06-21 08:00:00	SPY	ETF	135.62	135.78	135.44	135.55	1045191.0
2012-06-21 09:00:00	SPY	ETF	135.55	135.85	135.26	135.31	15522818.0
2012-06-21 10:00:00	SPY	ETF	135.31	135.34	134.74	134.955	26491058.0
2012-06-21 11:00:00	SPY	ETF	134.95	134.965	134.02	134.32	27405994.0
2012-06-21 12:00:00	SPY	ETF	134.32	134.37	133.43	133.66	25520935.0
2012-06-21 13:00:00	SPY	ETF	133.65	133.77	133.14	133.26	22172512.0
2012-06-21 14:00:00	SPY	ETF	133.26	133.33	132.79	133.049	20789777.0
2012-06-21 15:00:00	SPY	ETF	133.04	133.09	132.33	132.46	46481868.0
2012-06-21 16:00:00	SPY	ETF	132.46	135.4876	132.22	132.45	13790230.0
2012-06-21 17:00:00	SPY	ETF	132.44	132.8	132.39	132.76	802279.0
2012-06-21 18:00:00	SPY	ETF	132.76	132.8	132.68	132.7	112683.0
2012-06-21 19:00:00	SPY	ETF	132.7	132.78	132.63	132.65	67462.0
2012-06-21 04:00:00	QQQ	ETF	64.19	64.19	64.19	64.19	100.0
2012-06-21 07:00:00	QQQ	ETF	64.12	64.37	64.12	64.37	16840.0
2012-06-21 08:00:00	QQQ	ETF	64.27	64.34	64.16	64.2	100695.0
2012-06-21 09:00:00	QQQ	ETF	64.21	64.31	64.025	64.05	3216220.0
2012-06-21 10:00:00	QQQ	ETF	64.05	64.0682	63.79	63.99	5960860.0
2012-06-21 11:00:00	QQQ	ETF	64.0	64.0	63.46	63.6	5481871.0
2012-06-21 12:00:00	QQQ	ETF	63.6005	63.63	63.2	63.26	3919319.0
2012-06-21 13:00:00	QQQ	ETF	63.26	63.34	63.06	63.16	3356934.0
2012-06-21 14:00:00	QQQ	ETF	63.1599	63.16	62.92	63.04	4540367.0
2012-06-21 15:00:00	QQQ	ETF	63.04	63.06	62.62	62.69	13821658.0
2012-06-21 16:00:00	QQQ	ETF	62.69	63.6793	62.6211	62.71	883306.0
2012-06-21 17:00:00	QQQ	ETF	62.71	62.83	62.69	62.83	13720.0
2012-06-21 18:00:00	QQQ	ETF	62.83	62.87	62.8	62.8	17430.0
2012-06-21 19:00:00	QQQ	ETF	62.8	62.84	62.78	62.78	9769.0
2012-06-21 07:00:00	IWM	ETF	78.38	78.63	78.38	78.43	8081.0
2012-06-21 08:00:00	IWM	ETF	78.44	78.55	78.25	78.29	813461.0
2012-06-21 09:00:00	IWM	ETF	78.31	78.53	78.05	78.19	5382453.0
2012-06-21 10:00:00	IWM	ETF	78.19	78.21	77.66	78.04	8200888.0
2012-06-21 11:00:00	IWM	ETF	78.04	78.05	77.22	77.48	8932322.0
2012-06-21 12:00:00	IWM	ETF	77.47	77.5301	76.87	77.03	7186531.0
2012-06-21 13:00:00	IWM	ETF	77.03	77.07	76.64	76.77	6336513.0
2012-06-21 14:00:00	IWM	ETF	76.77	76.85	76.53	76.8	6365610.0
2012-06-21 15:00:00	IWM	ETF	76.8	76.83	76.49	76.64	11819866.0
2012-06-21 16:00:00	IWM	ETF	76.65	76.87	76.5133	76.69	2013846.0
2012-06-21 17:00:00	IWM	ETF	76.69	76.87	76.68	76.86	83605.0
2012-06-21 18:00:00	IWM	ETF	76.87	76.87	76.81	76.81	1939.0
2012-06-21 07:00:00	DIA	ETF	128.0	128.1	128.0	128.1	3850.0
2012-06-21 08:00:00	DIA	ETF	128.0	128.2	128.0	128.06	2200.0
2012-06-21 09:00:00	DIA	ETF	128.13	128.3443	127.98	128.02	479788.0
2012-06-21 10:00:00	DIA	ETF	128.07	128.07	127.55	127.74	697330.0
2012-06-21 11:00:00	DIA	ETF	127.75	127.76	126.93	127.1	1778707.0
2012-06-21 12:00:00	DIA	ETF	127.11	127.14	126.22	126.5182	1457201.0
2012-06-21 13:00:00	DIA	ETF	126.5	126.61	126.04	126.2	839125.0
2012-06-21 14:00:00	DIA	ETF	126.18	126.23	125.74	125.95	838000.0

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

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