PREVIEW / etf_1hour / 2014-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-11-25.parquet
  size:    229 KB
  rows:    7,275

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-11-25 04:00:00	SPY	ETF	207.31	207.54	207.31	207.49	22352.0
2014-11-25 05:00:00	SPY	ETF	207.46	207.58	207.45	207.47	29882.0
2014-11-25 06:00:00	SPY	ETF	207.46	207.52	207.41	207.41	12498.0
2014-11-25 07:00:00	SPY	ETF	207.41	207.54	207.41	207.48	210543.0
2014-11-25 08:00:00	SPY	ETF	207.48	207.79	207.15	207.63	2343978.0
2014-11-25 09:00:00	SPY	ETF	207.65	207.79	207.33	207.49	10305345.0
2014-11-25 10:00:00	SPY	ETF	207.49	207.5	206.96	207.02	10978836.0
2014-11-25 11:00:00	SPY	ETF	207.02	207.21	206.8	207.16	9061922.0
2014-11-25 12:00:00	SPY	ETF	207.17	207.56	207.09	207.37	9192134.0
2014-11-25 13:00:00	SPY	ETF	207.37	207.51	207.305	207.48	5573450.0
2014-11-25 14:00:00	SPY	ETF	207.47	207.5	207.11	207.22	5163126.0
2014-11-25 15:00:00	SPY	ETF	207.21	207.47	207.08	207.18	15796676.0
2014-11-25 16:00:00	SPY	ETF	207.19	207.4242	207.05	207.33	9420330.0
2014-11-25 17:00:00	SPY	ETF	207.34	207.37	207.31	207.33	92536.0
2014-11-25 18:00:00	SPY	ETF	207.33	207.36	207.3	207.35	37002.0
2014-11-25 19:00:00	SPY	ETF	207.35	207.4	207.33	207.37	35466.0
2014-11-25 04:00:00	QQQ	ETF	104.65	104.78	104.57	104.78	7000.0
2014-11-25 05:00:00	QQQ	ETF	104.82	104.82	104.79	104.81	750.0
2014-11-25 06:00:00	QQQ	ETF	104.83	104.85	104.79	104.79	44550.0
2014-11-25 07:00:00	QQQ	ETF	104.83	104.86	104.8	104.85	33963.0
2014-11-25 08:00:00	QQQ	ETF	104.83	104.93	104.68	104.86	98131.0
2014-11-25 09:00:00	QQQ	ETF	104.86	105.15	104.79	104.9601	3409159.0
2014-11-25 10:00:00	QQQ	ETF	104.96	105.031	104.57	104.84	3589857.0
2014-11-25 11:00:00	QQQ	ETF	104.84	104.94	104.72	104.89	2045859.0
2014-11-25 12:00:00	QQQ	ETF	104.89	104.925	104.75	104.789	1544919.0
2014-11-25 13:00:00	QQQ	ETF	104.78	104.99	104.77	104.9299	892736.0
2014-11-25 14:00:00	QQQ	ETF	104.92	104.97	104.74	104.8036	1109483.0
2014-11-25 15:00:00	QQQ	ETF	104.8	104.959	104.7899	104.84	2967459.0
2014-11-25 16:00:00	QQQ	ETF	104.83	104.96	104.82	104.93	847300.0
2014-11-25 17:00:00	QQQ	ETF	104.93	104.96	104.91	104.96	13478.0
2014-11-25 18:00:00	QQQ	ETF	104.93	104.93	104.91	104.91	8005.0
2014-11-25 19:00:00	QQQ	ETF	104.93	104.95	104.93	104.94	2200.0
2014-11-25 04:00:00	IWM	ETF	118.2	118.36	118.2	118.36	300.0
2014-11-25 06:00:00	IWM	ETF	118.25	118.25	118.25	118.25	100.0
2014-11-25 07:00:00	IWM	ETF	118.25	118.35	118.25	118.35	10100.0
2014-11-25 08:00:00	IWM	ETF	118.35	118.49	118.29	118.3	127127.0
2014-11-25 09:00:00	IWM	ETF	118.28	118.78	118.055	118.31	5039080.0
2014-11-25 10:00:00	IWM	ETF	118.29	118.3	117.66	117.6768	4550402.0
2014-11-25 11:00:00	IWM	ETF	117.67	117.92	117.53	117.83	2994707.0
2014-11-25 12:00:00	IWM	ETF	117.82	118.17	117.72	118.0	2420064.0
2014-11-25 13:00:00	IWM	ETF	118.0	118.055	117.895	117.92	1148311.0
2014-11-25 14:00:00	IWM	ETF	117.92	118.11	117.84	117.91	2688392.0
2014-11-25 15:00:00	IWM	ETF	117.9	118.07	117.87	118.04	3975386.0
2014-11-25 16:00:00	IWM	ETF	118.05	118.5964	118.02	118.08	681010.0
2014-11-25 17:00:00	IWM	ETF	118.12	118.12	118.07	118.07	5382.0
2014-11-25 18:00:00	IWM	ETF	118.07	118.07	118.07	118.07	100.0
2014-11-25 07:00:00	DIA	ETF	178.05	178.05	178.05	178.05	100.0
2014-11-25 08:00:00	DIA	ETF	178.15	178.23	178.12	178.19	13072.0
2014-11-25 09:00:00	DIA	ETF	178.19	178.24	177.77	177.89	513273.0
2014-11-25 10:00:00	DIA	ETF	177.91	177.91	177.56	177.69	514831.0

> showing 50 of 7,275 rows — these rows as CSV

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