PREVIEW / etf_1hour / 2011-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-08-01.parquet
  size:    191 KB
  rows:    5,882

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-08-01 04:00:00	SPY	ETF	130.5	130.86	130.47	130.65	6045.0
2011-08-01 05:00:00	SPY	ETF	130.75	130.89	130.68	130.85	40840.0
2011-08-01 06:00:00	SPY	ETF	130.93	131.3	130.88	131.23	146352.0
2011-08-01 07:00:00	SPY	ETF	131.25	131.35	130.82	130.88	1004183.0
2011-08-01 08:00:00	SPY	ETF	130.92	131.4	129.33	130.62	5081563.0
2011-08-01 09:00:00	SPY	ETF	130.62	130.96	129.05	129.68	41957380.0
2011-08-01 10:00:00	SPY	ETF	129.65	129.679	128.07	128.54	72704418.0
2011-08-01 11:00:00	SPY	ETF	128.55	128.59	127.61	127.69	47412186.0
2011-08-01 12:00:00	SPY	ETF	127.69	128.11	127.53	128.0	29888079.0
2011-08-01 13:00:00	SPY	ETF	127.99	128.19	127.8	128.185	18923728.0
2011-08-01 14:00:00	SPY	ETF	128.19	128.51	127.73	128.45	23877933.0
2011-08-01 15:00:00	SPY	ETF	128.46	129.0	128.39	128.79	55812033.0
2011-08-01 16:00:00	SPY	ETF	128.79	130.97	128.06	128.43	20342268.0
2011-08-01 17:00:00	SPY	ETF	128.43	128.43	128.2	128.28	5527477.0
2011-08-01 18:00:00	SPY	ETF	128.29	128.76	128.29	128.73	617330.0
2011-08-01 19:00:00	SPY	ETF	128.72	128.98	128.51	128.69	496743.0
2011-08-01 04:00:00	QQQ	ETF	58.58	58.58	58.5	58.58	15547.0
2011-08-01 05:00:00	QQQ	ETF	58.57	58.62	58.53	58.62	7500.0
2011-08-01 06:00:00	QQQ	ETF	58.63	58.8	58.6	58.8	5900.0
2011-08-01 07:00:00	QQQ	ETF	58.72	58.8	58.59	58.61	114602.0
2011-08-01 08:00:00	QQQ	ETF	58.62	58.7	58.5	58.53	1086247.0
2011-08-01 09:00:00	QQQ	ETF	58.53	58.82	58.14	58.17	11973626.0
2011-08-01 10:00:00	QQQ	ETF	58.17	58.175	57.48	57.68	23894810.0
2011-08-01 11:00:00	QQQ	ETF	57.68	57.69	57.16	57.19	11166410.0
2011-08-01 12:00:00	QQQ	ETF	57.19	57.325	57.03	57.27	8105970.0
2011-08-01 13:00:00	QQQ	ETF	57.27	57.37	57.16	57.37	5562683.0
2011-08-01 14:00:00	QQQ	ETF	57.375	57.48	57.12	57.46	4503620.0
2011-08-01 15:00:00	QQQ	ETF	57.47	57.825	57.45	57.76	12329988.0
2011-08-01 16:00:00	QQQ	ETF	57.76	57.79	57.62	57.67	2246433.0
2011-08-01 17:00:00	QQQ	ETF	57.66	57.67	57.55	57.62	619850.0
2011-08-01 18:00:00	QQQ	ETF	57.62	57.82	57.61	57.81	98239.0
2011-08-01 19:00:00	QQQ	ETF	57.81	57.86	57.68	57.75	90475.0
2011-08-01 04:00:00	IWM	ETF	80.3	80.3	80.07	80.13	4921.0
2011-08-01 05:00:00	IWM	ETF	80.32	80.32	80.26	80.26	738.0
2011-08-01 06:00:00	IWM	ETF	80.35	80.7	80.35	80.7	29700.0
2011-08-01 07:00:00	IWM	ETF	80.7	80.74	80.48	80.56	127803.0
2011-08-01 08:00:00	IWM	ETF	80.56	80.76	80.5	80.62	1495392.0
2011-08-01 09:00:00	IWM	ETF	80.63	80.99	79.65	79.92	18194664.0
2011-08-01 10:00:00	IWM	ETF	79.92	79.93	79.02	79.3	16428646.0
2011-08-01 11:00:00	IWM	ETF	79.3	79.34	78.66	78.7008	9067427.0
2011-08-01 12:00:00	IWM	ETF	78.71	78.86	78.53	78.7	10020819.0
2011-08-01 13:00:00	IWM	ETF	78.71	78.76	78.47	78.745	6215999.0
2011-08-01 14:00:00	IWM	ETF	78.74	79.0	78.48	79.0	3776475.0
2011-08-01 15:00:00	IWM	ETF	78.9967	79.32	78.82	79.32	14055077.0
2011-08-01 16:00:00	IWM	ETF	79.31	79.35	79.0	79.05	1973259.0
2011-08-01 17:00:00	IWM	ETF	79.04	79.04	78.96	78.96	38300.0
2011-08-01 18:00:00	IWM	ETF	79.2	79.34	79.2	79.21	3900.0
2011-08-01 19:00:00	IWM	ETF	79.34	79.38	79.08	79.2	22471.0
2011-08-01 04:00:00	DIA	ETF	122.61	122.67	122.61	122.67	500.0
2011-08-01 05:00:00	DIA	ETF	122.66	122.66	122.65	122.65	400.0

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

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