PREVIEW / etf_1hour / 2012-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-23.parquet
  size:    192 KB
  rows:    5,935

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-23 04:00:00	SPY	ETF	131.67	131.67	131.2	131.27	1250.0
2012-05-23 05:00:00	SPY	ETF	131.24	131.26	131.1	131.13	34300.0
2012-05-23 06:00:00	SPY	ETF	131.07	131.18	130.97	131.15	213065.0
2012-05-23 07:00:00	SPY	ETF	131.16	131.36	131.07	131.3	562681.0
2012-05-23 08:00:00	SPY	ETF	131.27	131.46	130.84	131.38	1711442.0
2012-05-23 09:00:00	SPY	ETF	131.39	131.52	130.92	131.36	18935363.0
2012-05-23 10:00:00	SPY	ETF	131.35	131.61	130.18	130.389	39894435.0
2012-05-23 11:00:00	SPY	ETF	130.38	130.72	130.24	130.32	22207178.0
2012-05-23 12:00:00	SPY	ETF	130.32	130.48	129.99	130.31	18069881.0
2012-05-23 13:00:00	SPY	ETF	130.31	130.99	130.29	130.941	18629581.0
2012-05-23 14:00:00	SPY	ETF	130.95	131.31	130.38	131.269	22168477.0
2012-05-23 15:00:00	SPY	ETF	131.27	132.46	131.05	132.26	52153945.0
2012-05-23 16:00:00	SPY	ETF	132.25	132.3	130.38	132.03	9188249.0
2012-05-23 17:00:00	SPY	ETF	132.03	132.27	132.03	132.1	256213.0
2012-05-23 18:00:00	SPY	ETF	132.1	132.17	132.02	132.13	72126.0
2012-05-23 19:00:00	SPY	ETF	132.13	132.16	131.48	131.51	226811.0
2012-05-23 05:00:00	QQQ	ETF	61.97	61.99	61.89	61.89	1100.0
2012-05-23 06:00:00	QQQ	ETF	61.85	61.85	61.82	61.83	3900.0
2012-05-23 07:00:00	QQQ	ETF	61.85	61.96	61.84	61.96	33540.0
2012-05-23 08:00:00	QQQ	ETF	61.96	62.08	61.75	61.99	241384.0
2012-05-23 09:00:00	QQQ	ETF	61.99	62.12	61.67	62.05	6271586.0
2012-05-23 10:00:00	QQQ	ETF	62.05	62.19	61.52	61.61	11760147.0
2012-05-23 11:00:00	QQQ	ETF	61.61	61.79	61.47	61.51	6218406.0
2012-05-23 12:00:00	QQQ	ETF	61.51	61.66	61.37	61.56	5093589.0
2012-05-23 13:00:00	QQQ	ETF	61.56	61.97	61.55	61.96	5231126.0
2012-05-23 14:00:00	QQQ	ETF	61.96	62.09	61.61	62.056	7428782.0
2012-05-23 15:00:00	QQQ	ETF	62.06	62.71	61.94	62.56	12185841.0
2012-05-23 16:00:00	QQQ	ETF	62.55	62.5998	62.37	62.38	1446313.0
2012-05-23 17:00:00	QQQ	ETF	62.39	62.49	62.39	62.47	27385.0
2012-05-23 18:00:00	QQQ	ETF	62.46	62.46	62.43	62.46	164958.0
2012-05-23 19:00:00	QQQ	ETF	62.45	62.47	62.18	62.21	32550.0
2012-05-23 04:00:00	IWM	ETF	75.25	75.25	75.05	75.05	250.0
2012-05-23 06:00:00	IWM	ETF	75.19	75.29	75.13	75.29	600.0
2012-05-23 07:00:00	IWM	ETF	75.21	75.41	75.21	75.34	24100.0
2012-05-23 08:00:00	IWM	ETF	75.36	75.38	75.03	75.33	345302.0
2012-05-23 09:00:00	IWM	ETF	75.33	75.6	75.04	75.4999	5977510.0
2012-05-23 10:00:00	IWM	ETF	75.5	75.69	74.8399	74.96	12668253.0
2012-05-23 11:00:00	IWM	ETF	74.95	75.18	74.8099	74.84	6100927.0
2012-05-23 12:00:00	IWM	ETF	74.84	75.09	74.69	74.9475	4789252.0
2012-05-23 13:00:00	IWM	ETF	74.945	75.63	74.93	75.39	6802618.0
2012-05-23 14:00:00	IWM	ETF	75.4	75.7	75.03	75.67	5949679.0
2012-05-23 15:00:00	IWM	ETF	75.67	76.64	75.49	76.48	16408841.0
2012-05-23 16:00:00	IWM	ETF	76.47	76.55	75.9251	76.34	1616625.0
2012-05-23 17:00:00	IWM	ETF	76.36	76.42	76.36	76.4	9804.0
2012-05-23 18:00:00	IWM	ETF	76.37	76.4	76.35	76.4	1000.0
2012-05-23 19:00:00	IWM	ETF	76.4	76.4	75.93	75.93	20950.0
2012-05-23 04:00:00	DIA	ETF	124.05	124.05	123.95	123.95	6000.0
2012-05-23 05:00:00	DIA	ETF	123.93	123.93	123.87	123.87	6140.0
2012-05-23 06:00:00	DIA	ETF	123.85	123.85	123.81	123.81	4800.0
2012-05-23 07:00:00	DIA	ETF	123.92	124.02	123.88	124.02	1000.0

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

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