PREVIEW / etf_1hour / 2011-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-20.parquet
  size:    176 KB
  rows:    5,424

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-20 04:00:00	SPY	ETF	126.56	126.56	126.21	126.36	5066.0
2011-06-20 05:00:00	SPY	ETF	126.36	126.45	126.29	126.45	3200.0
2011-06-20 06:00:00	SPY	ETF	126.43	127.3	126.35	126.43	206600.0
2011-06-20 07:00:00	SPY	ETF	126.43	126.47	126.18	126.32	802524.0
2011-06-20 08:00:00	SPY	ETF	126.35	127.05	126.25	126.46	2526949.0
2011-06-20 09:00:00	SPY	ETF	126.47	127.22	126.47	127.14	17383748.0
2011-06-20 10:00:00	SPY	ETF	127.14	127.61	126.859	127.43	30681701.0
2011-06-20 11:00:00	SPY	ETF	127.43	127.93	127.3	127.89	19048969.0
2011-06-20 12:00:00	SPY	ETF	127.89	127.97	127.7	127.73	12538955.0
2011-06-20 13:00:00	SPY	ETF	127.73	127.82	127.51	127.551	12183125.0
2011-06-20 14:00:00	SPY	ETF	127.55	127.94	127.51	127.83	13412832.0
2011-06-20 15:00:00	SPY	ETF	127.83	127.87	127.41	127.72	31512741.0
2011-06-20 16:00:00	SPY	ETF	127.72	127.9	127.5	127.76	15094995.0
2011-06-20 17:00:00	SPY	ETF	127.0555	127.82	127.0555	127.76	1355069.0
2011-06-20 18:00:00	SPY	ETF	127.75	127.82	127.7	127.79	55639.0
2011-06-20 19:00:00	SPY	ETF	127.76	128.04	127.76	127.96	117721.0
2011-06-20 04:00:00	QQQ	ETF	53.56	53.56	53.5	53.52	1600.0
2011-06-20 05:00:00	QQQ	ETF	53.59	53.59	53.52	53.53	4033.0
2011-06-20 06:00:00	QQQ	ETF	53.67	53.67	53.6	53.61	12900.0
2011-06-20 07:00:00	QQQ	ETF	53.58	53.6	53.5	53.53	47419.0
2011-06-20 08:00:00	QQQ	ETF	53.56	53.79	53.52	53.6	220488.0
2011-06-20 09:00:00	QQQ	ETF	53.61	53.97	53.61	53.91	5721154.0
2011-06-20 10:00:00	QQQ	ETF	53.91	53.97	53.711	53.87	8087967.0
2011-06-20 11:00:00	QQQ	ETF	53.86	54.15	53.7904	54.13	6484219.0
2011-06-20 12:00:00	QQQ	ETF	54.13	54.23	54.09	54.145	2971329.0
2011-06-20 13:00:00	QQQ	ETF	54.14	54.19	54.05	54.07	2096008.0
2011-06-20 14:00:00	QQQ	ETF	54.07	54.21	54.04	54.18	3269460.0
2011-06-20 15:00:00	QQQ	ETF	54.18	54.185	53.96	54.07	6127313.0
2011-06-20 16:00:00	QQQ	ETF	54.07	54.11	54.02	54.11	1626944.0
2011-06-20 17:00:00	QQQ	ETF	54.09	54.11	54.06	54.07	2524.0
2011-06-20 18:00:00	QQQ	ETF	54.08	54.11	54.07	54.11	75236.0
2011-06-20 19:00:00	QQQ	ETF	54.09	54.22	54.09	54.21	53443.0
2011-06-20 04:00:00	IWM	ETF	77.68	77.73	77.6	77.6	683.0
2011-06-20 05:00:00	IWM	ETF	77.89	77.89	77.73	77.73	500.0
2011-06-20 06:00:00	IWM	ETF	77.77	77.86	77.77	77.86	300.0
2011-06-20 07:00:00	IWM	ETF	77.72	77.75	77.5	77.64	21010.0
2011-06-20 08:00:00	IWM	ETF	77.65	77.98	77.6	77.86	178759.0
2011-06-20 09:00:00	IWM	ETF	77.87	78.76	77.87	78.6	7040864.0
2011-06-20 10:00:00	IWM	ETF	78.6	78.73	78.12	78.55	7645601.0
2011-06-20 11:00:00	IWM	ETF	78.55	79.01	78.42	78.98	6151835.0
2011-06-20 12:00:00	IWM	ETF	78.9899	79.23	78.92	79.06	4217175.0
2011-06-20 13:00:00	IWM	ETF	79.06	79.1209	78.73	78.77	3953064.0
2011-06-20 14:00:00	IWM	ETF	78.77	79.0001	78.69	78.9	4219182.0
2011-06-20 15:00:00	IWM	ETF	78.895	78.94	78.53	78.94	9735375.0
2011-06-20 16:00:00	IWM	ETF	78.93	79.1	78.2217	79.01	4462181.0
2011-06-20 17:00:00	IWM	ETF	79.01	79.06	78.98	78.98	13247.0
2011-06-20 18:00:00	IWM	ETF	78.99	79.0	78.98	79.0	700.0
2011-06-20 19:00:00	IWM	ETF	79.04	79.2	79.04	79.2	6625.0
2011-06-20 04:00:00	DIA	ETF	119.35	119.35	119.17	119.17	500.0
2011-06-20 05:00:00	DIA	ETF	119.25	119.25	119.21	119.21	1600.0

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

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