PREVIEW / etf_1hour / 2013-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-18.parquet
  size:    211 KB
  rows:    6,634

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-18 04:00:00	SPY	ETF	171.11	171.31	171.11	171.31	16900.0
2013-09-18 05:00:00	SPY	ETF	171.28	171.37	171.25	171.25	4477.0
2013-09-18 06:00:00	SPY	ETF	171.23	171.32	171.18	171.25	55857.0
2013-09-18 07:00:00	SPY	ETF	171.28	171.28	171.16	171.18	152083.0
2013-09-18 08:00:00	SPY	ETF	171.16	171.25	171.07	171.1	289749.0
2013-09-18 09:00:00	SPY	ETF	171.1	171.13	170.92	171.0	8297752.0
2013-09-18 10:00:00	SPY	ETF	171.0	171.16	170.71	170.83	12315689.0
2013-09-18 11:00:00	SPY	ETF	170.83	171.0128	170.66	170.67	9882678.0
2013-09-18 12:00:00	SPY	ETF	170.67	170.79	170.58	170.75	9010298.0
2013-09-18 13:00:00	SPY	ETF	170.75	170.98	170.73	170.819	10752163.0
2013-09-18 14:00:00	SPY	ETF	170.86	173.47	170.82	173.45	71900930.0
2013-09-18 15:00:00	SPY	ETF	173.45	173.52	172.85	173.1	44768155.0
2013-09-18 16:00:00	SPY	ETF	173.09	173.14	171.0128	173.05	22212854.0
2013-09-18 17:00:00	SPY	ETF	173.06	173.1	172.3508	173.07	6847979.0
2013-09-18 18:00:00	SPY	ETF	173.07	173.15	173.06	173.15	179831.0
2013-09-18 19:00:00	SPY	ETF	173.15	173.26	173.12	173.16	201057.0
2013-09-18 04:00:00	QQQ	ETF	78.54	78.54	78.54	78.54	2000.0
2013-09-18 05:00:00	QQQ	ETF	78.54	78.59	78.53	78.57	14300.0
2013-09-18 06:00:00	QQQ	ETF	78.55	78.57	78.53	78.57	8600.0
2013-09-18 07:00:00	QQQ	ETF	78.55	78.57	78.53	78.53	24798.0
2013-09-18 08:00:00	QQQ	ETF	78.53	78.57	78.47	78.49	90325.0
2013-09-18 09:00:00	QQQ	ETF	78.48	78.59	78.46	78.51	2076842.0
2013-09-18 10:00:00	QQQ	ETF	78.52	78.6001	78.45	78.519	3465306.0
2013-09-18 11:00:00	QQQ	ETF	78.51	78.5491	78.349	78.349	1185343.0
2013-09-18 12:00:00	QQQ	ETF	78.34	78.46	78.33	78.44	1021611.0
2013-09-18 13:00:00	QQQ	ETF	78.44	78.51	78.36	78.41	2059150.0
2013-09-18 14:00:00	QQQ	ETF	78.45	79.41	78.43	79.41	10735376.0
2013-09-18 15:00:00	QQQ	ETF	79.41	79.47	79.25	79.3199	8864893.0
2013-09-18 16:00:00	QQQ	ETF	79.34	79.36	78.496	79.36	1363653.0
2013-09-18 17:00:00	QQQ	ETF	79.36	79.4	78.857	79.35	577553.0
2013-09-18 18:00:00	QQQ	ETF	79.36	79.45	79.36	79.44	17624.0
2013-09-18 19:00:00	QQQ	ETF	79.44	79.49	79.41	79.47	50863.0
2013-09-18 07:00:00	IWM	ETF	106.22	106.34	106.21	106.23	87320.0
2013-09-18 08:00:00	IWM	ETF	106.22	106.3	106.13	106.15	82855.0
2013-09-18 09:00:00	IWM	ETF	106.15	106.17	105.935	105.94	2004556.0
2013-09-18 10:00:00	IWM	ETF	105.95	106.015	105.66	105.76	3458021.0
2013-09-18 11:00:00	IWM	ETF	105.76	105.79	105.33	105.34	3344896.0
2013-09-18 12:00:00	IWM	ETF	105.33	105.49	105.26	105.45	2222045.0
2013-09-18 13:00:00	IWM	ETF	105.45	105.595	105.321	105.49	2203449.0
2013-09-18 14:00:00	IWM	ETF	105.51	107.48	105.51	107.47	16506845.0
2013-09-18 15:00:00	IWM	ETF	107.47	107.61	106.93	107.1	11744890.0
2013-09-18 16:00:00	IWM	ETF	107.1	107.1668	106.0501	107.13	1938241.0
2013-09-18 17:00:00	IWM	ETF	107.17	107.19	106.4944	107.11	171335.0
2013-09-18 18:00:00	IWM	ETF	107.16	107.16	107.16	107.16	100.0
2013-09-18 19:00:00	IWM	ETF	107.25	107.25	107.24	107.25	7380.0
2013-09-18 07:00:00	DIA	ETF	155.36	155.36	155.36	155.36	1000.0
2013-09-18 08:00:00	DIA	ETF	155.5	155.5	155.21	155.22	32050.0
2013-09-18 09:00:00	DIA	ETF	155.2	155.25	154.98	155.05	475618.0
2013-09-18 10:00:00	DIA	ETF	155.05	155.17	154.81	154.85	757508.0
2013-09-18 11:00:00	DIA	ETF	154.86	154.96	154.81	154.81	317210.0

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

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