PREVIEW / etf_1hour / 2012-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-14.parquet
  size:    189 KB
  rows:    5,924

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-14 04:00:00	SPY	ETF	134.61	134.75	134.28	134.29	18385.0
2012-05-14 05:00:00	SPY	ETF	134.28	134.57	134.28	134.54	47595.0
2012-05-14 06:00:00	SPY	ETF	134.51	134.55	134.27	134.27	79300.0
2012-05-14 07:00:00	SPY	ETF	134.24	134.59	134.15	134.5	620336.0
2012-05-14 08:00:00	SPY	ETF	134.53	135.17	134.25	134.4	1163468.0
2012-05-14 09:00:00	SPY	ETF	134.41	134.61	134.03	134.27	21638857.0
2012-05-14 10:00:00	SPY	ETF	134.2725	134.53	133.91	134.34	29957561.0
2012-05-14 11:00:00	SPY	ETF	134.34	134.92	134.25	134.64	24939091.0
2012-05-14 12:00:00	SPY	ETF	134.65	134.85	134.57	134.71	9236060.0
2012-05-14 13:00:00	SPY	ETF	134.72	135.03	134.4607	134.9	12439489.0
2012-05-14 14:00:00	SPY	ETF	134.89	135.01	134.34	134.42	12598331.0
2012-05-14 15:00:00	SPY	ETF	134.415	135.6144	134.06	134.14	31066781.0
2012-05-14 16:00:00	SPY	ETF	134.13	134.4244	133.8	133.92	17053960.0
2012-05-14 17:00:00	SPY	ETF	133.93	134.13	133.93	134.06	195034.0
2012-05-14 18:00:00	SPY	ETF	134.04	134.24	134.0	134.22	451642.0
2012-05-14 19:00:00	SPY	ETF	134.22	134.34	134.2	134.27	281925.0
2012-05-14 04:00:00	QQQ	ETF	63.78	63.78	63.57	63.57	1700.0
2012-05-14 05:00:00	QQQ	ETF	63.72	63.72	63.72	63.72	1200.0
2012-05-14 06:00:00	QQQ	ETF	63.66	63.67	63.58	63.58	28200.0
2012-05-14 07:00:00	QQQ	ETF	63.58	63.73	63.52	63.69	137350.0
2012-05-14 08:00:00	QQQ	ETF	63.7	63.75	63.58	63.65	367761.0
2012-05-14 09:00:00	QQQ	ETF	63.65	63.83	63.58	63.71	6330058.0
2012-05-14 10:00:00	QQQ	ETF	63.712	63.83	63.48	63.74	10513936.0
2012-05-14 11:00:00	QQQ	ETF	63.74	64.06	63.65	63.94	6878240.0
2012-05-14 12:00:00	QQQ	ETF	63.95	64.03	63.88	63.92	2597121.0
2012-05-14 13:00:00	QQQ	ETF	63.9187	64.07	63.73	63.9816	3420561.0
2012-05-14 14:00:00	QQQ	ETF	63.99	64.08	63.69	63.73	3743897.0
2012-05-14 15:00:00	QQQ	ETF	63.72	63.77	63.52	63.56	7111637.0
2012-05-14 16:00:00	QQQ	ETF	63.57	63.8038	63.45	63.52	2050516.0
2012-05-14 17:00:00	QQQ	ETF	63.52	63.57	63.52	63.54	8077.0
2012-05-14 18:00:00	QQQ	ETF	63.54	63.65	63.54	63.65	10225.0
2012-05-14 19:00:00	QQQ	ETF	63.63	63.67	63.63	63.65	5880.0
2012-05-14 04:00:00	IWM	ETF	78.45	78.45	78.1	78.1	2052.0
2012-05-14 06:00:00	IWM	ETF	78.02	78.02	77.86	77.86	400.0
2012-05-14 07:00:00	IWM	ETF	77.84	78.24	77.82	78.19	384700.0
2012-05-14 08:00:00	IWM	ETF	78.19	78.25	77.9286	78.14	682661.0
2012-05-14 09:00:00	IWM	ETF	78.15	78.41	77.96	78.04	5827486.0
2012-05-14 10:00:00	IWM	ETF	78.03	78.14	77.61	78.0	9572396.0
2012-05-14 11:00:00	IWM	ETF	78.01	78.31	77.88	78.1	5153185.0
2012-05-14 12:00:00	IWM	ETF	78.1	78.23	78.05	78.12	1878684.0
2012-05-14 13:00:00	IWM	ETF	78.12	78.46	78.02	78.36	3622131.0
2012-05-14 14:00:00	IWM	ETF	78.36	78.46	78.04	78.1	3049960.0
2012-05-14 15:00:00	IWM	ETF	78.1	78.15	77.81	77.86	8318785.0
2012-05-14 16:00:00	IWM	ETF	77.86	78.1928	77.53	77.65	2363395.0
2012-05-14 17:00:00	IWM	ETF	77.64	77.72	77.6	77.72	57496.0
2012-05-14 18:00:00	IWM	ETF	77.85	77.85	77.81	77.81	500.0
2012-05-14 19:00:00	IWM	ETF	77.76	77.78	77.75	77.75	975.0
2012-05-14 05:00:00	DIA	ETF	127.31	127.31	127.31	127.31	100.0
2012-05-14 07:00:00	DIA	ETF	127.19	127.39	127.19	127.34	2233.0
2012-05-14 08:00:00	DIA	ETF	127.4	127.5	127.16	127.29	29581.0

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

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