PREVIEW / etf_1hour / 2013-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-07.parquet
  size:    206 KB
  rows:    6,467

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-10-07 04:00:00	SPY	ETF	167.41	167.41	167.16	167.3	166048.0
2013-10-07 05:00:00	SPY	ETF	167.32	167.45	167.2	167.45	25398.0
2013-10-07 06:00:00	SPY	ETF	167.45	167.45	167.32	167.39	125221.0
2013-10-07 07:00:00	SPY	ETF	167.42	167.62	167.34	167.57	470876.0
2013-10-07 08:00:00	SPY	ETF	167.56	168.08	167.35	167.57	1079783.0
2013-10-07 09:00:00	SPY	ETF	167.57	167.88	167.25	167.71	14414205.0
2013-10-07 10:00:00	SPY	ETF	167.72	168.38	167.61	168.19	15120062.0
2013-10-07 11:00:00	SPY	ETF	168.19	168.38	167.93	168.22	8867641.0
2013-10-07 12:00:00	SPY	ETF	168.21	168.24	167.8	167.84	5738214.0
2013-10-07 13:00:00	SPY	ETF	167.83	168.31	167.825	168.3	7787260.0
2013-10-07 14:00:00	SPY	ETF	168.3	168.45	168.05	168.24	8179076.0
2013-10-07 15:00:00	SPY	ETF	168.24	168.29	167.41	167.45	22718557.0
2013-10-07 16:00:00	SPY	ETF	167.44	168.8986	167.22	167.29	6955360.0
2013-10-07 17:00:00	SPY	ETF	167.31	167.8027	167.18	167.22	1444398.0
2013-10-07 18:00:00	SPY	ETF	167.24	167.35	167.01	167.27	192826.0
2013-10-07 19:00:00	SPY	ETF	167.28	167.3	167.24	167.3	31973.0
2013-10-07 04:00:00	QQQ	ETF	78.92	78.92	78.61	78.67	69387.0
2013-10-07 05:00:00	QQQ	ETF	78.68	78.77	78.64	78.77	13900.0
2013-10-07 06:00:00	QQQ	ETF	78.78	78.78	78.68	78.75	45000.0
2013-10-07 07:00:00	QQQ	ETF	78.76	78.85	78.72	78.82	46650.0
2013-10-07 08:00:00	QQQ	ETF	78.82	78.9	78.76	78.85	157387.0
2013-10-07 09:00:00	QQQ	ETF	78.84	79.17	78.67	79.02	3810041.0
2013-10-07 10:00:00	QQQ	ETF	79.03	79.35	78.96	79.17	3116299.0
2013-10-07 11:00:00	QQQ	ETF	79.17	79.2	78.96	79.1	1888411.0
2013-10-07 12:00:00	QQQ	ETF	79.09	79.14	78.83	78.85	1435412.0
2013-10-07 13:00:00	QQQ	ETF	78.85	79.189	78.845	79.179	2068139.0
2013-10-07 14:00:00	QQQ	ETF	79.18	79.23	79.0	79.12	2315629.0
2013-10-07 15:00:00	QQQ	ETF	79.1245	79.15	78.72	78.74	3758493.0
2013-10-07 16:00:00	QQQ	ETF	78.75	79.2874	78.66	78.71	1302057.0
2013-10-07 17:00:00	QQQ	ETF	78.72	78.9272	78.67	78.7	133298.0
2013-10-07 18:00:00	QQQ	ETF	78.72	78.75	78.63	78.75	6948.0
2013-10-07 19:00:00	QQQ	ETF	78.75	78.75	78.71	78.71	640.0
2013-10-07 04:00:00	IWM	ETF	106.22	106.27	105.75	105.75	10094.0
2013-10-07 06:00:00	IWM	ETF	105.99	105.99	105.88	105.9	3400.0
2013-10-07 07:00:00	IWM	ETF	105.97	106.06	105.84	106.03	115806.0
2013-10-07 08:00:00	IWM	ETF	105.99	106.17	105.94	106.08	209761.0
2013-10-07 09:00:00	IWM	ETF	106.06	106.43	105.75	106.11	5091605.0
2013-10-07 10:00:00	IWM	ETF	106.115	106.66	105.93	106.39	5220613.0
2013-10-07 11:00:00	IWM	ETF	106.4	106.41	106.125	106.29	2730918.0
2013-10-07 12:00:00	IWM	ETF	106.285	106.31	105.8899	105.92	2306443.0
2013-10-07 13:00:00	IWM	ETF	105.92	106.21	105.92	106.21	1947767.0
2013-10-07 14:00:00	IWM	ETF	106.2075	106.33	106.11	106.22	2870145.0
2013-10-07 15:00:00	IWM	ETF	106.22	106.25	105.72	105.76	8412125.0
2013-10-07 16:00:00	IWM	ETF	105.76	106.4296	105.63	105.7	1736755.0
2013-10-07 17:00:00	IWM	ETF	105.7	106.0757	105.56	105.69	431491.0
2013-10-07 18:00:00	IWM	ETF	105.69	105.69	105.57	105.69	14150.0
2013-10-07 19:00:00	IWM	ETF	105.7	105.77	105.67	105.77	8495.0
2013-10-07 04:00:00	DIA	ETF	149.5	149.5	149.25	149.25	400.0
2013-10-07 07:00:00	DIA	ETF	149.25	149.3	149.24	149.29	1636.0
2013-10-07 08:00:00	DIA	ETF	149.35	149.38	149.01	149.33	8455.0

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

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