PREVIEW / etf_1hour / 2014-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-18.parquet
  size:    245 KB
  rows:    7,808

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-18 04:00:00	SPY	ETF	202.59	204.17	202.59	203.6	149815.0
2014-12-18 05:00:00	SPY	ETF	203.8	204.81	203.8	204.55	445323.0
2014-12-18 06:00:00	SPY	ETF	204.54	204.57	204.07	204.07	267817.0
2014-12-18 07:00:00	SPY	ETF	204.1	204.52	204.1	204.44	749385.0
2014-12-18 08:00:00	SPY	ETF	204.41	204.74	201.79	204.71	2020224.0
2014-12-18 09:00:00	SPY	ETF	204.71	205.12	204.2	205.01	26988105.0
2014-12-18 10:00:00	SPY	ETF	205.02	205.35	204.52	204.543	33707869.0
2014-12-18 11:00:00	SPY	ETF	204.54	204.99	203.92	204.94	25913535.0
2014-12-18 12:00:00	SPY	ETF	204.94	205.47	204.79	205.46	21237592.0
2014-12-18 13:00:00	SPY	ETF	205.46	205.59	205.13	205.44	24816835.0
2014-12-18 14:00:00	SPY	ETF	205.44	205.48	204.91	205.39	31060034.0
2014-12-18 15:00:00	SPY	ETF	205.39	212.97	205.29	206.8	60650401.0
2014-12-18 16:00:00	SPY	ETF	206.8	207.33	204.7369	207.29	17681710.0
2014-12-18 17:00:00	SPY	ETF	207.29	207.35	207.12	207.14	5287091.0
2014-12-18 18:00:00	SPY	ETF	207.13	207.23	207.08	207.13	294884.0
2014-12-18 19:00:00	SPY	ETF	207.13	207.29	207.13	207.21	323922.0
2014-12-18 04:00:00	QQQ	ETF	102.63	102.88	102.61	102.66	109920.0
2014-12-18 05:00:00	QQQ	ETF	102.74	103.32	102.74	103.22	35350.0
2014-12-18 06:00:00	QQQ	ETF	103.21	103.25	102.98	102.98	26990.0
2014-12-18 07:00:00	QQQ	ETF	102.98	103.22	102.98	103.14	113257.0
2014-12-18 08:00:00	QQQ	ETF	103.14	103.24	102.96	103.24	314009.0
2014-12-18 09:00:00	QQQ	ETF	103.22	103.48	102.98	103.475	7097068.0
2014-12-18 10:00:00	QQQ	ETF	103.475	103.77	103.33	103.44	7523598.0
2014-12-18 11:00:00	QQQ	ETF	103.44	103.63	103.11	103.615	4611039.0
2014-12-18 12:00:00	QQQ	ETF	103.61	103.76	103.39	103.76	2302642.0
2014-12-18 13:00:00	QQQ	ETF	103.75	103.96	103.621	103.92	3162456.0
2014-12-18 14:00:00	QQQ	ETF	103.93	103.9599	103.52	103.72	3765968.0
2014-12-18 15:00:00	QQQ	ETF	103.7248	104.26	103.6601	104.25	7774226.0
2014-12-18 16:00:00	QQQ	ETF	104.26	104.48	101.8174	104.46	3180930.0
2014-12-18 17:00:00	QQQ	ETF	104.44	104.53	104.4	104.46	115509.0
2014-12-18 18:00:00	QQQ	ETF	104.44	104.47	104.35	104.39	137322.0
2014-12-18 19:00:00	QQQ	ETF	104.38	104.41	104.36	104.39	11361.0
2014-12-18 04:00:00	IWM	ETF	117.18	118.0	117.18	117.89	700.0
2014-12-18 05:00:00	IWM	ETF	118.4	118.55	118.4	118.55	1500.0
2014-12-18 06:00:00	IWM	ETF	118.45	118.5	118.14	118.22	12600.0
2014-12-18 07:00:00	IWM	ETF	118.22	118.46	118.22	118.44	97404.0
2014-12-18 08:00:00	IWM	ETF	118.41	118.63	118.15	118.62	407561.0
2014-12-18 09:00:00	IWM	ETF	118.63	118.77	117.85	118.2	6678199.0
2014-12-18 10:00:00	IWM	ETF	118.2	118.4	117.655	117.81	7946197.0
2014-12-18 11:00:00	IWM	ETF	117.82	117.98	117.47	117.94	5403042.0
2014-12-18 12:00:00	IWM	ETF	117.93	118.38	117.91	118.37	3659105.0
2014-12-18 13:00:00	IWM	ETF	118.36	118.66	118.27	118.59	4272922.0
2014-12-18 14:00:00	IWM	ETF	118.6	118.62	118.135	118.55	3320663.0
2014-12-18 15:00:00	IWM	ETF	118.54	118.74	118.315	118.64	9382097.0
2014-12-18 16:00:00	IWM	ETF	118.64	118.95	116.9667	118.95	3737739.0
2014-12-18 17:00:00	IWM	ETF	118.86	118.99	118.31	118.75	5874.0
2014-12-18 18:00:00	IWM	ETF	118.87	118.91	118.84	118.88	8027.0
2014-12-18 19:00:00	IWM	ETF	118.84	118.97	118.84	118.91	9844.0
2014-12-18 05:00:00	DIA	ETF	175.55	175.6	175.25	175.6	300.0
2014-12-18 06:00:00	DIA	ETF	175.42	175.42	175.42	175.42	100.0

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

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