PREVIEW / etf_1hour / 2014-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-30.parquet
  size:    212 KB
  rows:    6,760

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
2014-05-30 04:00:00	SPY	ETF	192.17	192.22	192.03	192.2	2310.0
2014-05-30 05:00:00	SPY	ETF	192.2	192.25	192.14	192.16	8947.0
2014-05-30 06:00:00	SPY	ETF	192.17	192.22	192.08	192.22	28742.0
2014-05-30 07:00:00	SPY	ETF	192.22	192.31	192.21	192.22	57205.0
2014-05-30 08:00:00	SPY	ETF	192.22	192.28	192.12	192.22	318784.0
2014-05-30 09:00:00	SPY	ETF	192.21	192.3	192.03	192.21	7152212.0
2014-05-30 10:00:00	SPY	ETF	192.22	192.52	192.15	192.45	9591928.0
2014-05-30 11:00:00	SPY	ETF	192.45	192.54	192.35	192.47	5035357.0
2014-05-30 12:00:00	SPY	ETF	192.47	192.51	192.07	192.18	9182296.0
2014-05-30 13:00:00	SPY	ETF	192.18	192.3	192.1	192.295	6775772.0
2014-05-30 14:00:00	SPY	ETF	192.3	192.62	192.25	192.42	7408448.0
2014-05-30 15:00:00	SPY	ETF	192.42	192.8	192.31	192.65	18986002.0
2014-05-30 16:00:00	SPY	ETF	192.66	192.7376	192.365	192.5	8152109.0
2014-05-30 17:00:00	SPY	ETF	192.49	192.82	192.49	192.72	2490853.0
2014-05-30 18:00:00	SPY	ETF	192.71	192.74	192.7	192.74	29096.0
2014-05-30 19:00:00	SPY	ETF	192.72	192.78	192.72	192.78	31293.0
2014-05-30 04:00:00	QQQ	ETF	91.26	91.26	91.26	91.26	100.0
2014-05-30 06:00:00	QQQ	ETF	91.26	91.26	91.26	91.26	400.0
2014-05-30 07:00:00	QQQ	ETF	91.31	91.34	91.29	91.29	8250.0
2014-05-30 08:00:00	QQQ	ETF	91.29	91.31	91.23	91.26	186799.0
2014-05-30 09:00:00	QQQ	ETF	91.27	91.38	91.14	91.17	4699516.0
2014-05-30 10:00:00	QQQ	ETF	91.17	91.41	91.12	91.34	3695717.0
2014-05-30 11:00:00	QQQ	ETF	91.34	91.45	91.29	91.35	1755755.0
2014-05-30 12:00:00	QQQ	ETF	91.36	91.42	90.92	91.01	2970929.0
2014-05-30 13:00:00	QQQ	ETF	91.01	91.08	90.83	91.0075	2079044.0
2014-05-30 14:00:00	QQQ	ETF	91.005	91.23	90.94	91.1	2595117.0
2014-05-30 15:00:00	QQQ	ETF	91.09	91.34	91.06	91.3	4243097.0
2014-05-30 16:00:00	QQQ	ETF	91.3	91.33	91.15	91.15	3183831.0
2014-05-30 17:00:00	QQQ	ETF	91.31	91.31	91.17	91.23	727986.0
2014-05-30 18:00:00	QQQ	ETF	91.23	91.23	91.2	91.23	8668.0
2014-05-30 19:00:00	QQQ	ETF	91.23	91.24	91.21	91.22	6400.0
2014-05-30 07:00:00	IWM	ETF	113.37	113.41	113.37	113.41	440.0
2014-05-30 08:00:00	IWM	ETF	113.4	113.52	113.26	113.32	32659.0
2014-05-30 09:00:00	IWM	ETF	113.32	113.43	113.07	113.2	3850350.0
2014-05-30 10:00:00	IWM	ETF	113.2	113.39	112.9	113.05	6219287.0
2014-05-30 11:00:00	IWM	ETF	113.05	113.28	112.95	112.97	2056444.0
2014-05-30 12:00:00	IWM	ETF	112.96	113.02	112.4	112.59	4735209.0
2014-05-30 13:00:00	IWM	ETF	112.59	112.71	112.34	112.51	6058443.0
2014-05-30 14:00:00	IWM	ETF	112.51	112.78	112.47	112.52	4798994.0
2014-05-30 15:00:00	IWM	ETF	112.51	112.94	112.49	112.81	6015547.0
2014-05-30 16:00:00	IWM	ETF	112.81	113.1388	112.69	112.7	1430679.0
2014-05-30 17:00:00	IWM	ETF	112.86	112.86	112.73	112.73	170385.0
2014-05-30 19:00:00	IWM	ETF	112.78	112.84	112.78	112.8	600.0
2014-05-30 06:00:00	DIA	ETF	166.61	166.61	166.6	166.6	2000.0
2014-05-30 07:00:00	DIA	ETF	166.7	166.7	166.7	166.7	300.0
2014-05-30 08:00:00	DIA	ETF	166.61	166.64	166.54	166.64	8000.0
2014-05-30 09:00:00	DIA	ETF	166.58	166.63	166.3	166.45	514879.0
2014-05-30 10:00:00	DIA	ETF	166.47	166.68	166.42	166.58	254725.0
2014-05-30 11:00:00	DIA	ETF	166.58	166.64	166.49	166.63	203323.0
2014-05-30 12:00:00	DIA	ETF	166.61	166.68	166.41	166.5	238621.0

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

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