PREVIEW / etf_1hour / 2012-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-11.parquet
  size:    184 KB
  rows:    5,780

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-04-11 04:00:00	SPY	ETF	136.48	136.97	136.47	136.78	38075.0
2012-04-11 05:00:00	SPY	ETF	136.87	137.32	136.84	137.32	39570.0
2012-04-11 06:00:00	SPY	ETF	137.29	137.35	137.19	137.32	123383.0
2012-04-11 07:00:00	SPY	ETF	137.3	137.43	137.11	137.15	1387676.0
2012-04-11 08:00:00	SPY	ETF	137.14	137.36	137.06	137.21	2459330.0
2012-04-11 09:00:00	SPY	ETF	137.22	137.43	137.03	137.12	22510170.0
2012-04-11 10:00:00	SPY	ETF	137.13	137.54	137.11	137.305	24232866.0
2012-04-11 11:00:00	SPY	ETF	137.32	137.34	136.92	136.9395	15913596.0
2012-04-11 12:00:00	SPY	ETF	136.93	137.31	136.89	137.31	12226162.0
2012-04-11 13:00:00	SPY	ETF	137.31	137.405	137.06	137.32	11772751.0
2012-04-11 14:00:00	SPY	ETF	137.32	137.35	136.93	137.09	15627632.0
2012-04-11 15:00:00	SPY	ETF	137.09	137.15	136.75	136.94	31694869.0
2012-04-11 16:00:00	SPY	ETF	136.92	137.1523	136.85	137.03	13052535.0
2012-04-11 17:00:00	SPY	ETF	137.02	137.04	136.99	137.0	655509.0
2012-04-11 18:00:00	SPY	ETF	137.01	137.22	137.0	137.18	158731.0
2012-04-11 19:00:00	SPY	ETF	137.19	137.26	137.01	137.03	676737.0
2012-04-11 05:00:00	QQQ	ETF	66.46	66.66	66.46	66.66	2400.0
2012-04-11 06:00:00	QQQ	ETF	66.67	66.69	66.65	66.68	14425.0
2012-04-11 07:00:00	QQQ	ETF	66.7	66.77	66.64	66.64	273131.0
2012-04-11 08:00:00	QQQ	ETF	66.65	66.71	66.61	66.65	593074.0
2012-04-11 09:00:00	QQQ	ETF	66.67	66.74	66.46	66.63	8751311.0
2012-04-11 10:00:00	QQQ	ETF	66.63	66.89	66.62	66.8	12876353.0
2012-04-11 11:00:00	QQQ	ETF	66.81	66.83	66.55	66.57	6040976.0
2012-04-11 12:00:00	QQQ	ETF	66.57	66.65	66.45	66.61	5913030.0
2012-04-11 13:00:00	QQQ	ETF	66.61	66.68	66.5	66.6	7301398.0
2012-04-11 14:00:00	QQQ	ETF	66.6	66.61	66.32	66.46	7194683.0
2012-04-11 15:00:00	QQQ	ETF	66.47	66.49	66.28	66.44	5154887.0
2012-04-11 16:00:00	QQQ	ETF	66.44	66.51	66.43	66.5	503726.0
2012-04-11 17:00:00	QQQ	ETF	66.51	66.53	66.5	66.5	34835.0
2012-04-11 18:00:00	QQQ	ETF	66.5	66.56	66.5	66.55	115515.0
2012-04-11 19:00:00	QQQ	ETF	66.55	66.58	66.49	66.51	59700.0
2012-04-11 05:00:00	IWM	ETF	78.99	78.99	78.99	78.99	2000.0
2012-04-11 07:00:00	IWM	ETF	78.99	79.13	78.87	78.92	141569.0
2012-04-11 08:00:00	IWM	ETF	78.95	79.04	78.86	78.98	731171.0
2012-04-11 09:00:00	IWM	ETF	78.99	79.18	78.8499	78.92	7686802.0
2012-04-11 10:00:00	IWM	ETF	78.92	79.57	78.91	79.495	11084073.0
2012-04-11 11:00:00	IWM	ETF	79.505	79.51	79.16	79.23	4537158.0
2012-04-11 12:00:00	IWM	ETF	79.22	79.35	79.155	79.35	2986780.0
2012-04-11 13:00:00	IWM	ETF	79.345	79.42	79.23	79.335	3750591.0
2012-04-11 14:00:00	IWM	ETF	79.33	79.34	78.97	79.14	4156085.0
2012-04-11 15:00:00	IWM	ETF	79.14	79.48	79.02	79.42	9618453.0
2012-04-11 16:00:00	IWM	ETF	79.44	79.52	78.2737	79.51	2557429.0
2012-04-11 17:00:00	IWM	ETF	79.5	79.52	79.48	79.52	6766.0
2012-04-11 18:00:00	IWM	ETF	79.5	79.59	79.5	79.59	632.0
2012-04-11 19:00:00	IWM	ETF	79.6	79.6	79.5	79.5	1471.0
2012-04-11 04:00:00	DIA	ETF	127.22	127.6	127.22	127.6	250.0
2012-04-11 05:00:00	DIA	ETF	128.0	128.09	128.0	128.09	10150.0
2012-04-11 06:00:00	DIA	ETF	128.11	128.11	128.11	128.11	2000.0
2012-04-11 07:00:00	DIA	ETF	128.06	128.19	128.01	128.01	11000.0
2012-04-11 08:00:00	DIA	ETF	127.97	128.11	127.93	128.04	9347.0

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

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