PREVIEW / etf_1hour / 2014-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-04.parquet
  size:    231 KB
  rows:    7,320

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-04 04:00:00	SPY	ETF	207.86	207.94	207.84	207.88	3202.0
2014-12-04 05:00:00	SPY	ETF	207.85	208.08	207.85	208.03	15016.0
2014-12-04 06:00:00	SPY	ETF	208.01	208.03	207.95	207.98	103945.0
2014-12-04 07:00:00	SPY	ETF	207.98	208.05	207.95	208.0	162662.0
2014-12-04 08:00:00	SPY	ETF	207.89	208.15	207.03	207.24	2274614.0
2014-12-04 09:00:00	SPY	ETF	207.22	207.77	207.2	207.47	9730857.0
2014-12-04 10:00:00	SPY	ETF	207.47	207.6465	206.7	206.97	13098730.0
2014-12-04 11:00:00	SPY	ETF	206.96	207.41	206.74	207.401	9883666.0
2014-12-04 12:00:00	SPY	ETF	207.4	208.265	207.36	207.84	20289807.0
2014-12-04 13:00:00	SPY	ETF	207.84	208.0	207.78	207.903	6489848.0
2014-12-04 14:00:00	SPY	ETF	207.89	207.97	207.56	207.62	6181296.0
2014-12-04 15:00:00	SPY	ETF	207.6299	207.75	207.12	207.66	14969636.0
2014-12-04 16:00:00	SPY	ETF	207.67	207.85	207.52	207.73	6633143.0
2014-12-04 17:00:00	SPY	ETF	207.74	207.77	207.72	207.73	62040.0
2014-12-04 18:00:00	SPY	ETF	207.73	207.79	207.72	207.73	24046.0
2014-12-04 19:00:00	SPY	ETF	207.75	207.78	207.71	207.77	66837.0
2014-12-04 05:00:00	QQQ	ETF	105.5	105.53	105.5	105.53	1600.0
2014-12-04 06:00:00	QQQ	ETF	105.51	105.51	105.51	105.51	5000.0
2014-12-04 07:00:00	QQQ	ETF	105.5	105.52	105.49	105.49	27674.0
2014-12-04 08:00:00	QQQ	ETF	105.5	105.59	104.97	105.14	476834.0
2014-12-04 09:00:00	QQQ	ETF	105.13	105.63	105.12	105.52	4124469.0
2014-12-04 10:00:00	QQQ	ETF	105.52	105.64	105.1	105.29	5127568.0
2014-12-04 11:00:00	QQQ	ETF	105.28	105.41	104.93	105.4	3003328.0
2014-12-04 12:00:00	QQQ	ETF	105.4	105.78	105.35	105.59	4016139.0
2014-12-04 13:00:00	QQQ	ETF	105.59	105.65	105.5	105.56	1769422.0
2014-12-04 14:00:00	QQQ	ETF	105.57	105.64	105.4	105.46	2204333.0
2014-12-04 15:00:00	QQQ	ETF	105.46	105.53	105.16	105.36	3923948.0
2014-12-04 16:00:00	QQQ	ETF	105.37	105.49	105.2875	105.43	822017.0
2014-12-04 17:00:00	QQQ	ETF	105.42	105.44	105.41	105.44	7750.0
2014-12-04 18:00:00	QQQ	ETF	105.4	105.41	105.38	105.41	5150.0
2014-12-04 19:00:00	QQQ	ETF	105.38	105.41	105.37	105.41	11822.0
2014-12-04 07:00:00	IWM	ETF	117.4	117.42	117.38	117.38	13000.0
2014-12-04 08:00:00	IWM	ETF	117.41	117.57	116.82	116.94	449023.0
2014-12-04 09:00:00	IWM	ETF	116.92	117.301	116.86	117.01	3076531.0
2014-12-04 10:00:00	IWM	ETF	117.03	117.135	116.219	116.565	5295502.0
2014-12-04 11:00:00	IWM	ETF	116.56	116.9399	116.4101	116.935	2331515.0
2014-12-04 12:00:00	IWM	ETF	116.92	117.24	116.835	117.175	2707084.0
2014-12-04 13:00:00	IWM	ETF	117.17	117.3	116.92	117.08	2218151.0
2014-12-04 14:00:00	IWM	ETF	117.0749	117.12	116.835	116.88	1854659.0
2014-12-04 15:00:00	IWM	ETF	116.89	117.0	116.4	116.81	5096406.0
2014-12-04 16:00:00	IWM	ETF	116.82	116.94	116.715	116.91	1175470.0
2014-12-04 17:00:00	IWM	ETF	116.92	116.99	116.92	116.99	5102.0
2014-12-04 19:00:00	IWM	ETF	116.92	116.92	116.89	116.89	1000.0
2014-12-04 08:00:00	DIA	ETF	179.05	179.05	178.4	178.4	6350.0
2014-12-04 09:00:00	DIA	ETF	178.49	178.89	178.48	178.515	786703.0
2014-12-04 10:00:00	DIA	ETF	178.52	178.6	178.03	178.24	594720.0
2014-12-04 11:00:00	DIA	ETF	178.235	178.53	178.07	178.5226	471284.0
2014-12-04 12:00:00	DIA	ETF	178.5	179.3	178.485	179.035	1026470.0
2014-12-04 13:00:00	DIA	ETF	179.04	179.14	178.96	178.98	527394.0
2014-12-04 14:00:00	DIA	ETF	178.97	179.06	178.79	178.85	338476.0

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

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