PREVIEW / etf_1hour / 2014-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-24.parquet
  size:    146 KB
  rows:    4,459

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-12-24 04:00:00	SPY	ETF	208.0	208.0	208.0	208.0	9101.0
2014-12-24 05:00:00	SPY	ETF	208.08	208.13	208.06	208.13	53399.0
2014-12-24 06:00:00	SPY	ETF	208.08	208.09	208.0	208.03	2625.0
2014-12-24 07:00:00	SPY	ETF	208.02	208.12	208.01	208.08	38385.0
2014-12-24 08:00:00	SPY	ETF	208.08	208.19	208.0	208.1	170995.0
2014-12-24 09:00:00	SPY	ETF	208.1	208.17	207.88	208.04	7384909.0
2014-12-24 10:00:00	SPY	ETF	208.04	208.23	207.98	208.155	7711601.0
2014-12-24 11:00:00	SPY	ETF	208.15	208.335	208.15	208.22	6348535.0
2014-12-24 12:00:00	SPY	ETF	208.22	208.34	207.72	207.8	13650510.0
2014-12-24 13:00:00	SPY	ETF	207.79	208.1	207.73	207.8	5624314.0
2014-12-24 14:00:00	SPY	ETF	207.83	207.83	207.78	207.81	11140.0
2014-12-24 15:00:00	SPY	ETF	207.7901	207.9	207.78	207.9	49542.0
2014-12-24 16:00:00	SPY	ETF	207.93	207.93	207.85	207.86	5900.0
2014-12-24 05:00:00	QQQ	ETF	104.32	104.32	104.32	104.32	171.0
2014-12-24 07:00:00	QQQ	ETF	104.29	104.32	104.29	104.3	3300.0
2014-12-24 08:00:00	QQQ	ETF	104.3	104.37	104.3	104.3	16596.0
2014-12-24 09:00:00	QQQ	ETF	104.29	104.62	104.2699	104.57	2639112.0
2014-12-24 10:00:00	QQQ	ETF	104.57	104.62	104.4	104.59	2307209.0
2014-12-24 11:00:00	QQQ	ETF	104.6	104.7	104.53	104.54	1912664.0
2014-12-24 12:00:00	QQQ	ETF	104.55	104.6428	104.3	104.32	2111328.0
2014-12-24 13:00:00	QQQ	ETF	104.31	104.521	104.3	104.3499	3453621.0
2014-12-24 14:00:00	QQQ	ETF	104.35	104.35	104.3	104.3	2072.0
2014-12-24 15:00:00	QQQ	ETF	104.3499	104.3499	104.3499	104.3499	1000.0
2014-12-24 06:00:00	IWM	ETF	119.65	119.68	119.65	119.68	1900.0
2014-12-24 07:00:00	IWM	ETF	119.7	119.73	119.7	119.73	3600.0
2014-12-24 08:00:00	IWM	ETF	119.74	119.77	119.66	119.66	26925.0
2014-12-24 09:00:00	IWM	ETF	119.67	119.79	119.2601	119.743	2551427.0
2014-12-24 10:00:00	IWM	ETF	119.75	120.07	119.67	119.88	3771110.0
2014-12-24 11:00:00	IWM	ETF	119.88	119.99	119.83	119.95	2842341.0
2014-12-24 12:00:00	IWM	ETF	119.95	120.03	119.71	119.72	3750143.0
2014-12-24 13:00:00	IWM	ETF	119.76	119.98	119.59	119.65	774668.0
2014-12-24 14:00:00	IWM	ETF	119.66	119.76	119.61	119.75	2300.0
2014-12-24 15:00:00	IWM	ETF	119.7499	119.7499	119.7499	119.7499	700.0
2014-12-24 16:00:00	IWM	ETF	119.78	119.78	119.74	119.74	400.0
2014-12-24 06:00:00	DIA	ETF	180.15	180.15	180.15	180.15	100.0
2014-12-24 07:00:00	DIA	ETF	180.12	180.12	180.12	180.12	308.0
2014-12-24 08:00:00	DIA	ETF	180.46	180.46	180.46	180.46	100.0
2014-12-24 09:00:00	DIA	ETF	180.23	180.41	178.74	180.4	554056.0
2014-12-24 10:00:00	DIA	ETF	180.39	180.5	180.26	180.43	256302.0
2014-12-24 11:00:00	DIA	ETF	180.42	180.531	180.33	180.461	352374.0
2014-12-24 12:00:00	DIA	ETF	180.46	180.53	179.94	180.01	367434.0
2014-12-24 13:00:00	DIA	ETF	180.01	180.17	180.01	180.03	44588.0
2014-12-24 14:00:00	DIA	ETF	180.15	180.15	180.15	180.15	216.0
2014-12-24 15:00:00	DIA	ETF	180.1	180.1	180.1	180.1	500.0
2014-12-24 16:00:00	DIA	ETF	180.06	180.06	180.06	180.06	200.0
2014-12-24 04:00:00	GLD	ETF	113.35	113.35	113.22	113.22	2600.0
2014-12-24 05:00:00	GLD	ETF	113.31	113.31	113.04	113.04	1900.0
2014-12-24 06:00:00	GLD	ETF	113.1	113.1	113.1	113.1	100.0
2014-12-24 07:00:00	GLD	ETF	113.11	113.11	113.06	113.06	1300.0
2014-12-24 08:00:00	GLD	ETF	113.25	113.25	112.8	113.0	24630.0

> showing 50 of 4,459 rows — these rows as CSV

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