PREVIEW / etf_1hour / 2011-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-13.parquet
  size:    180 KB
  rows:    5,517

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
2011-06-13 04:00:00	SPY	ETF	127.6	127.83	127.6	127.64	925.0
2011-06-13 05:00:00	SPY	ETF	127.58	127.6	127.48	127.6	1100.0
2011-06-13 06:00:00	SPY	ETF	127.68	127.82	127.55	127.78	164658.0
2011-06-13 07:00:00	SPY	ETF	127.78	127.96	127.73	127.78	825332.0
2011-06-13 08:00:00	SPY	ETF	127.76	128.08	127.38	128.04	2827135.0
2011-06-13 09:00:00	SPY	ETF	128.05	128.22	127.81	128.13	15980905.0
2011-06-13 10:00:00	SPY	ETF	128.12	128.21	127.77	127.87	23976260.0
2011-06-13 11:00:00	SPY	ETF	127.86	127.99	127.59	127.64	23898260.0
2011-06-13 12:00:00	SPY	ETF	127.645	127.76	127.37	127.42	17073134.0
2011-06-13 13:00:00	SPY	ETF	127.42	128.03	127.05	128.02	26138597.0
2011-06-13 14:00:00	SPY	ETF	128.01	128.24	127.79	127.9	28135835.0
2011-06-13 15:00:00	SPY	ETF	127.905	128.11	127.56	127.69	31337964.0
2011-06-13 16:00:00	SPY	ETF	127.7	128.137	127.59	127.8	6345260.0
2011-06-13 17:00:00	SPY	ETF	127.8	127.89	127.8	127.87	685538.0
2011-06-13 18:00:00	SPY	ETF	127.86	127.87	127.67	127.84	23089380.0
2011-06-13 19:00:00	SPY	ETF	127.85	127.9	127.82	127.88	30768.0
2011-06-13 04:00:00	QQQ	ETF	55.29	55.29	55.29	55.29	100.0
2011-06-13 06:00:00	QQQ	ETF	54.71	54.71	54.71	54.71	200.0
2011-06-13 07:00:00	QQQ	ETF	54.68	54.77	54.67	54.7	42400.0
2011-06-13 08:00:00	QQQ	ETF	54.7	54.82	54.63	54.81	277357.0
2011-06-13 09:00:00	QQQ	ETF	54.81	54.89	54.63	54.85	4982279.0
2011-06-13 10:00:00	QQQ	ETF	54.84	54.93	54.68	54.71	5136897.0
2011-06-13 11:00:00	QQQ	ETF	54.71	54.79	54.59	54.62	2994134.0
2011-06-13 12:00:00	QQQ	ETF	54.63	54.68	54.55	54.59	3545562.0
2011-06-13 13:00:00	QQQ	ETF	54.595	54.84	54.45	54.83	5121346.0
2011-06-13 14:00:00	QQQ	ETF	54.83	54.9	54.72	54.77	4035378.0
2011-06-13 15:00:00	QQQ	ETF	54.7689	54.84	54.58	54.62	6697944.0
2011-06-13 16:00:00	QQQ	ETF	54.63	54.75	54.585	54.67	1708882.0
2011-06-13 17:00:00	QQQ	ETF	54.67	54.7313	54.65	54.67	12736.0
2011-06-13 18:00:00	QQQ	ETF	54.67	54.71	54.67	54.69	12474.0
2011-06-13 19:00:00	QQQ	ETF	54.69	54.7	54.68	54.7	2569.0
2011-06-13 05:00:00	IWM	ETF	78.11	78.11	78.11	78.11	800.0
2011-06-13 06:00:00	IWM	ETF	78.18	78.19	78.18	78.19	600.0
2011-06-13 07:00:00	IWM	ETF	78.32	78.39	78.24	78.24	17775.0
2011-06-13 08:00:00	IWM	ETF	78.27	78.51	78.27	78.5	337114.0
2011-06-13 09:00:00	IWM	ETF	78.5	78.64	78.13	78.49	8370216.0
2011-06-13 10:00:00	IWM	ETF	78.49	78.59	78.0	78.06	7967954.0
2011-06-13 11:00:00	IWM	ETF	78.05	78.2	77.76	77.8	5110156.0
2011-06-13 12:00:00	IWM	ETF	77.805	77.87	77.55	77.63	5294604.0
2011-06-13 13:00:00	IWM	ETF	77.62	78.24	77.35	78.22	6845001.0
2011-06-13 14:00:00	IWM	ETF	78.22	78.35	77.86	77.98	8073933.0
2011-06-13 15:00:00	IWM	ETF	77.97	78.09	77.73	77.78	9850127.0
2011-06-13 16:00:00	IWM	ETF	77.78	77.87	77.61	77.85	1979921.0
2011-06-13 17:00:00	IWM	ETF	77.86	77.86	77.81	77.81	1463.0
2011-06-13 18:00:00	IWM	ETF	77.81	77.87	77.81	77.87	300.0
2011-06-13 19:00:00	IWM	ETF	77.81	77.86	77.81	77.83	3125.0
2011-06-13 05:00:00	DIA	ETF	119.43	119.43	119.43	119.43	100.0
2011-06-13 07:00:00	DIA	ETF	119.73	119.83	119.73	119.83	1250.0
2011-06-13 08:00:00	DIA	ETF	119.61	119.87	119.61	119.87	57462.0
2011-06-13 09:00:00	DIA	ETF	119.89	120.01	119.66	119.97	416994.0

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

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