PREVIEW / etf_1hour / 2014-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-16.parquet
  size:    246 KB
  rows:    7,773

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-16 04:00:00	SPY	ETF	200.08	200.36	199.7	200.34	95967.0
2014-12-16 05:00:00	SPY	ETF	200.4	200.69	200.2	200.43	151852.0
2014-12-16 06:00:00	SPY	ETF	200.44	200.44	198.84	198.89	338708.0
2014-12-16 07:00:00	SPY	ETF	198.82	198.88	197.49	198.12	2509713.0
2014-12-16 08:00:00	SPY	ETF	198.12	200.71	197.78	198.62	4631348.0
2014-12-16 09:00:00	SPY	ETF	198.61	199.44	198.18	198.95	23449397.0
2014-12-16 10:00:00	SPY	ETF	198.95	200.57	198.64	200.49	31402567.0
2014-12-16 11:00:00	SPY	ETF	200.48	202.395	200.17	201.35	46934729.0
2014-12-16 12:00:00	SPY	ETF	201.36	201.52	200.54	200.54	23762171.0
2014-12-16 13:00:00	SPY	ETF	200.54	200.83	199.26	200.0835	27090171.0
2014-12-16 14:00:00	SPY	ETF	200.07	200.5599	199.42	199.76	16548323.0
2014-12-16 15:00:00	SPY	ETF	199.76	200.0	197.86	197.93	45451150.0
2014-12-16 16:00:00	SPY	ETF	197.93	199.5802	197.6	197.97	25956494.0
2014-12-16 17:00:00	SPY	ETF	197.98	198.05	197.92	197.97	438330.0
2014-12-16 18:00:00	SPY	ETF	197.99	198.28	197.99	198.21	200032.0
2014-12-16 19:00:00	SPY	ETF	198.16	198.49	198.16	198.44	386679.0
2014-12-16 05:00:00	QQQ	ETF	102.08	102.12	102.08	102.09	23800.0
2014-12-16 06:00:00	QQQ	ETF	101.89	101.94	101.28	101.28	76235.0
2014-12-16 07:00:00	QQQ	ETF	101.26	101.26	100.56	100.84	343097.0
2014-12-16 08:00:00	QQQ	ETF	100.84	101.3	100.67	101.09	583321.0
2014-12-16 09:00:00	QQQ	ETF	101.09	101.44	100.6	100.991	9069836.0
2014-12-16 10:00:00	QQQ	ETF	100.991	101.48	100.44	101.43	11025719.0
2014-12-16 11:00:00	QQQ	ETF	101.43	102.47	101.24	101.94	9889013.0
2014-12-16 12:00:00	QQQ	ETF	101.94	102.06	101.57	101.57	4720719.0
2014-12-16 13:00:00	QQQ	ETF	101.57	101.72	100.85	101.31	8208184.0
2014-12-16 14:00:00	QQQ	ETF	101.31	101.4899	100.85	101.0	4244509.0
2014-12-16 15:00:00	QQQ	ETF	101.0	101.14	99.96	99.99	11105951.0
2014-12-16 16:00:00	QQQ	ETF	99.99	101.6296	99.82	100.02	2141287.0
2014-12-16 17:00:00	QQQ	ETF	100.01	100.04	99.92	99.98	91243.0
2014-12-16 18:00:00	QQQ	ETF	100.0	100.1	100.0	100.09	41223.0
2014-12-16 19:00:00	QQQ	ETF	100.1	100.22	100.1	100.2	17700.0
2014-12-16 05:00:00	IWM	ETF	114.22	114.22	114.22	114.22	350.0
2014-12-16 06:00:00	IWM	ETF	113.81	113.95	113.66	113.66	1200.0
2014-12-16 07:00:00	IWM	ETF	113.86	113.86	112.75	113.13	401170.0
2014-12-16 08:00:00	IWM	ETF	113.18	113.94	113.11	113.46	530310.0
2014-12-16 09:00:00	IWM	ETF	113.49	114.1	113.03	113.82	7316270.0
2014-12-16 10:00:00	IWM	ETF	113.81	114.48	113.29	114.37	8044654.0
2014-12-16 11:00:00	IWM	ETF	114.37	115.34	114.121	114.84	7983889.0
2014-12-16 12:00:00	IWM	ETF	114.86	115.0	114.35	114.51	5232100.0
2014-12-16 13:00:00	IWM	ETF	114.52	114.63	113.84	114.32	7435178.0
2014-12-16 14:00:00	IWM	ETF	114.325	114.59	114.08	114.238	3922445.0
2014-12-16 15:00:00	IWM	ETF	114.235	114.455	113.34	113.38	9833876.0
2014-12-16 16:00:00	IWM	ETF	113.37	114.1646	112.85	113.2	3862772.0
2014-12-16 17:00:00	IWM	ETF	113.22	113.33	113.13	113.24	32937.0
2014-12-16 18:00:00	IWM	ETF	113.37	113.52	113.37	113.52	1480.0
2014-12-16 19:00:00	IWM	ETF	113.51	113.79	113.5	113.79	3272.0
2014-12-16 04:00:00	DIA	ETF	172.46	172.46	172.46	172.46	840.0
2014-12-16 07:00:00	DIA	ETF	172.0	172.0	170.51	170.85	27400.0
2014-12-16 08:00:00	DIA	ETF	171.0	171.67	171.0	171.32	19522.0
2014-12-16 09:00:00	DIA	ETF	171.37	171.79	170.92	171.5	1297018.0

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

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