PREVIEW / etf_1hour / 2013-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-29.parquet
  size:    208 KB
  rows:    6,518

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
2013-05-29 04:00:00	SPY	ETF	165.4	165.58	165.27	165.27	40400.0
2013-05-29 05:00:00	SPY	ETF	165.32	165.45	165.28	165.45	4000.0
2013-05-29 06:00:00	SPY	ETF	165.31	165.32	164.85	164.92	186518.0
2013-05-29 07:00:00	SPY	ETF	164.93	165.13	164.73	164.86	727457.0
2013-05-29 08:00:00	SPY	ETF	164.86	165.33	164.76	165.2	1037711.0
2013-05-29 09:00:00	SPY	ETF	165.2	166.3	164.95	165.33	23755275.0
2013-05-29 10:00:00	SPY	ETF	165.335	165.72	164.51	164.54	27512317.0
2013-05-29 11:00:00	SPY	ETF	164.55	165.19	164.34	165.11	22580001.0
2013-05-29 12:00:00	SPY	ETF	165.109	165.24	164.58	164.65	14038044.0
2013-05-29 13:00:00	SPY	ETF	164.65	165.67	164.535	165.57	20366943.0
2013-05-29 14:00:00	SPY	ETF	165.575	165.8	165.31	165.32	16224892.0
2013-05-29 15:00:00	SPY	ETF	165.32	165.68	165.13	165.22	24429883.0
2013-05-29 16:00:00	SPY	ETF	165.26	165.6416	165.1	165.11	4730247.0
2013-05-29 17:00:00	SPY	ETF	165.13	165.2	165.12	165.17	125083.0
2013-05-29 18:00:00	SPY	ETF	165.17	165.23	165.02	165.1	113082.0
2013-05-29 19:00:00	SPY	ETF	165.1	165.18	165.05	165.14	36160.0
2013-05-29 04:00:00	QQQ	ETF	73.6	73.6	73.49	73.49	9775.0
2013-05-29 05:00:00	QQQ	ETF	73.45	73.55	73.45	73.54	1700.0
2013-05-29 06:00:00	QQQ	ETF	73.53	73.53	73.34	73.34	4399.0
2013-05-29 07:00:00	QQQ	ETF	73.34	73.39	73.24	73.3	45553.0
2013-05-29 08:00:00	QQQ	ETF	73.29	73.55	73.27	73.5	229148.0
2013-05-29 09:00:00	QQQ	ETF	73.5	73.67	73.38	73.49	5952065.0
2013-05-29 10:00:00	QQQ	ETF	73.49	73.67	73.19	73.22	5088324.0
2013-05-29 11:00:00	QQQ	ETF	73.22	73.535	73.12	73.49	4621320.0
2013-05-29 12:00:00	QQQ	ETF	73.5	73.565	73.27	73.31	3271995.0
2013-05-29 13:00:00	QQQ	ETF	73.31	73.72	73.225	73.67	2916057.0
2013-05-29 14:00:00	QQQ	ETF	73.67	73.8	73.61	73.61	4348651.0
2013-05-29 15:00:00	QQQ	ETF	73.61	73.76	73.51	73.53	4258485.0
2013-05-29 16:00:00	QQQ	ETF	73.53	73.69	73.48	73.51	660454.0
2013-05-29 17:00:00	QQQ	ETF	73.51	73.55	73.5	73.52	4800.0
2013-05-29 18:00:00	QQQ	ETF	73.52	73.54	73.46	73.46	8903.0
2013-05-29 19:00:00	QQQ	ETF	73.45	73.47	73.45	73.47	2500.0
2013-05-29 04:00:00	IWM	ETF	98.52	98.52	98.52	98.52	101.0
2013-05-29 06:00:00	IWM	ETF	98.5	98.5	98.15	98.15	28750.0
2013-05-29 07:00:00	IWM	ETF	98.16	98.29	98.02	98.07	133810.0
2013-05-29 08:00:00	IWM	ETF	98.06	98.54	98.06	98.41	366697.0
2013-05-29 09:00:00	IWM	ETF	98.4	98.85	98.2398	98.4	5786464.0
2013-05-29 10:00:00	IWM	ETF	98.4	98.7	97.57	97.6	7990401.0
2013-05-29 11:00:00	IWM	ETF	97.6	98.01	97.37	97.94	5915528.0
2013-05-29 12:00:00	IWM	ETF	97.95	98.03	97.62	97.7095	2591065.0
2013-05-29 13:00:00	IWM	ETF	97.71	98.5	97.65	98.41	3713200.0
2013-05-29 14:00:00	IWM	ETF	98.42	98.52	98.11	98.15	4077415.0
2013-05-29 15:00:00	IWM	ETF	98.15	98.44	98.08	98.22	6208178.0
2013-05-29 16:00:00	IWM	ETF	98.22	98.37	98.19	98.21	1246560.0
2013-05-29 17:00:00	IWM	ETF	98.23	98.23	98.23	98.23	100.0
2013-05-29 18:00:00	IWM	ETF	98.21	98.21	98.21	98.21	167.0
2013-05-29 19:00:00	IWM	ETF	98.23	98.23	98.23	98.23	200.0
2013-05-29 05:00:00	DIA	ETF	153.11	153.11	153.11	153.11	100.0
2013-05-29 06:00:00	DIA	ETF	153.03	153.03	153.03	153.03	459.0
2013-05-29 07:00:00	DIA	ETF	152.79	152.92	152.67	152.75	9312.0

> showing 50 of 6,518 rows — these rows as CSV

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