PREVIEW / etf_1hour / 2013-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-30.parquet
  size:    212 KB
  rows:    6,660

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-09-30 04:00:00	SPY	ETF	167.98	168.0	167.74	167.91	123395.0
2013-09-30 05:00:00	SPY	ETF	167.93	168.01	167.8	167.81	26646.0
2013-09-30 06:00:00	SPY	ETF	167.84	167.87	167.55	167.65	78826.0
2013-09-30 07:00:00	SPY	ETF	167.64	167.82	167.51	167.53	582695.0
2013-09-30 08:00:00	SPY	ETF	167.55	167.74	167.43	167.57	1100907.0
2013-09-30 09:00:00	SPY	ETF	167.57	167.84	167.15	167.6	20928430.0
2013-09-30 10:00:00	SPY	ETF	167.61	168.29	167.601	168.16	16927027.0
2013-09-30 11:00:00	SPY	ETF	168.17	168.29	167.89	168.27	11739405.0
2013-09-30 12:00:00	SPY	ETF	168.27	168.29	167.92	168.07	7890074.0
2013-09-30 13:00:00	SPY	ETF	168.07	168.54	167.92	168.1	14466454.0
2013-09-30 14:00:00	SPY	ETF	168.09	168.38	168.01	168.14	11866413.0
2013-09-30 15:00:00	SPY	ETF	168.14	168.14	167.59	168.01	40949376.0
2013-09-30 16:00:00	SPY	ETF	168.01	168.9739	167.5	168.25	10548269.0
2013-09-30 17:00:00	SPY	ETF	168.24	168.35	167.8963	168.34	476244.0
2013-09-30 18:00:00	SPY	ETF	168.3	168.41	168.23	168.23	275564.0
2013-09-30 19:00:00	SPY	ETF	168.23	168.31	168.21	168.22	41696.0
2013-09-30 04:00:00	QQQ	ETF	78.94	78.94	78.57	78.64	44600.0
2013-09-30 05:00:00	QQQ	ETF	78.65	78.66	78.57	78.57	10200.0
2013-09-30 06:00:00	QQQ	ETF	78.56	78.58	78.45	78.5	20700.0
2013-09-30 07:00:00	QQQ	ETF	78.49	78.55	78.44	78.45	71865.0
2013-09-30 08:00:00	QQQ	ETF	78.45	78.47	78.3	78.36	402031.0
2013-09-30 09:00:00	QQQ	ETF	78.36	78.51	78.0	78.44	4477322.0
2013-09-30 10:00:00	QQQ	ETF	78.44	78.9201	78.44	78.875	4779586.0
2013-09-30 11:00:00	QQQ	ETF	78.88	79.05	78.73	79.032	2181948.0
2013-09-30 12:00:00	QQQ	ETF	79.03	79.03	78.8	78.889	1306111.0
2013-09-30 13:00:00	QQQ	ETF	78.89	79.09	78.76	78.82	3120132.0
2013-09-30 14:00:00	QQQ	ETF	78.82	78.99	78.78	78.86	1768863.0
2013-09-30 15:00:00	QQQ	ETF	78.86	78.86	78.63	78.83	6135518.0
2013-09-30 16:00:00	QQQ	ETF	78.821	79.04	78.344	79.0	2864727.0
2013-09-30 17:00:00	QQQ	ETF	79.08	79.08	78.5467	79.0	245254.0
2013-09-30 18:00:00	QQQ	ETF	79.0	79.09	78.96	78.96	15389.0
2013-09-30 19:00:00	QQQ	ETF	78.96	78.99	78.92	78.92	5410.0
2013-09-30 04:00:00	IWM	ETF	106.03	106.03	105.81	105.84	680.0
2013-09-30 06:00:00	IWM	ETF	105.7	105.7	105.5	105.5	8200.0
2013-09-30 07:00:00	IWM	ETF	105.69	105.7	105.55	105.57	56871.0
2013-09-30 08:00:00	IWM	ETF	105.58	105.66	105.49	105.55	161301.0
2013-09-30 09:00:00	IWM	ETF	105.56	105.86	105.24	105.625	4783339.0
2013-09-30 10:00:00	IWM	ETF	105.63	106.4	105.53	106.19	7968825.0
2013-09-30 11:00:00	IWM	ETF	106.19	106.54	105.99	106.51	3356359.0
2013-09-30 12:00:00	IWM	ETF	106.51	106.52	106.21	106.37	3058156.0
2013-09-30 13:00:00	IWM	ETF	106.38	106.73	106.33	106.46	5082609.0
2013-09-30 14:00:00	IWM	ETF	106.46	106.84	106.41	106.7601	3420572.0
2013-09-30 15:00:00	IWM	ETF	106.76	106.76	106.31	106.65	11152237.0
2013-09-30 16:00:00	IWM	ETF	106.65	106.82	106.145	106.72	3319810.0
2013-09-30 17:00:00	IWM	ETF	106.71	106.76	106.1008	106.76	200466.0
2013-09-30 18:00:00	IWM	ETF	106.8	106.8	106.7	106.7	1050.0
2013-09-30 19:00:00	IWM	ETF	106.78	106.79	106.73	106.74	12120.0
2013-09-30 04:00:00	DIA	ETF	151.4	151.4	151.4	151.4	200.0
2013-09-30 06:00:00	DIA	ETF	151.15	151.15	151.15	151.15	500.0
2013-09-30 07:00:00	DIA	ETF	151.09	151.09	151.09	151.09	1500.0

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

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