PREVIEW / etf_1hour / 2015-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-31.parquet
  size:    239 KB
  rows:    7,644

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
2015-03-31 04:00:00	SPY	ETF	207.79	207.8	207.64	207.64	27393.0
2015-03-31 05:00:00	SPY	ETF	207.64	207.64	206.97	207.06	51000.0
2015-03-31 06:00:00	SPY	ETF	207.03	207.03	206.83	206.86	266733.0
2015-03-31 07:00:00	SPY	ETF	206.83	207.08	206.71	206.99	427979.0
2015-03-31 08:00:00	SPY	ETF	206.99	208.02	206.74	207.12	947943.0
2015-03-31 09:00:00	SPY	ETF	207.1	207.56	206.95	207.355	13824390.0
2015-03-31 10:00:00	SPY	ETF	207.35	207.86	207.3	207.55	9720653.0
2015-03-31 11:00:00	SPY	ETF	207.55	208.1	207.37	207.38	9405136.0
2015-03-31 12:00:00	SPY	ETF	207.38	207.58	207.14	207.47	6664316.0
2015-03-31 13:00:00	SPY	ETF	207.46	207.88	207.39	207.47	6621890.0
2015-03-31 14:00:00	SPY	ETF	207.47	207.64	207.29	207.57	7185992.0
2015-03-31 15:00:00	SPY	ETF	207.57	207.59	206.36	206.44	44915248.0
2015-03-31 16:00:00	SPY	ETF	206.44	207.24	206.14	206.35	21241851.0
2015-03-31 17:00:00	SPY	ETF	206.35	206.43	206.28	206.33	1378018.0
2015-03-31 18:00:00	SPY	ETF	206.35	206.38	206.18	206.34	141527.0
2015-03-31 19:00:00	SPY	ETF	206.37	206.47	206.35	206.4	31689.0
2015-03-31 05:00:00	QQQ	ETF	106.35	106.35	106.21	106.23	5300.0
2015-03-31 06:00:00	QQQ	ETF	106.2	106.25	106.1	106.23	31800.0
2015-03-31 07:00:00	QQQ	ETF	106.08	106.26	106.08	106.23	50695.0
2015-03-31 08:00:00	QQQ	ETF	106.21	106.65	106.12	106.34	116533.0
2015-03-31 09:00:00	QQQ	ETF	106.33	106.49	106.02	106.26	3957354.0
2015-03-31 10:00:00	QQQ	ETF	106.26	106.51	106.2	106.35	2626102.0
2015-03-31 11:00:00	QQQ	ETF	106.34	106.65	106.25	106.25	2466233.0
2015-03-31 12:00:00	QQQ	ETF	106.25	106.35	106.1041	106.33	1469378.0
2015-03-31 13:00:00	QQQ	ETF	106.34	106.5	106.2	106.245	1395011.0
2015-03-31 14:00:00	QQQ	ETF	106.2389	106.3841	106.17	106.34	1592854.0
2015-03-31 15:00:00	QQQ	ETF	106.34	106.34	105.57	105.6	10588932.0
2015-03-31 16:00:00	QQQ	ETF	105.61	106.7765	105.45	105.52	1379393.0
2015-03-31 17:00:00	QQQ	ETF	105.509	105.6	105.48	105.48	25030.0
2015-03-31 18:00:00	QQQ	ETF	105.49	105.58	105.49	105.51	10951.0
2015-03-31 19:00:00	QQQ	ETF	105.54	105.6	105.54	105.55	20375.0
2015-03-31 05:00:00	IWM	ETF	124.24	124.24	123.97	123.97	1500.0
2015-03-31 06:00:00	IWM	ETF	123.97	123.97	123.97	123.97	100.0
2015-03-31 07:00:00	IWM	ETF	123.97	124.14	123.85	124.1	27954.0
2015-03-31 08:00:00	IWM	ETF	124.12	124.19	123.969	124.16	179290.0
2015-03-31 09:00:00	IWM	ETF	124.17	124.45	124.01	124.44	2741122.0
2015-03-31 10:00:00	IWM	ETF	124.44	124.64	124.33	124.43	2476968.0
2015-03-31 11:00:00	IWM	ETF	124.42	124.71	124.03	124.12	2360367.0
2015-03-31 12:00:00	IWM	ETF	124.11	124.38	123.9	124.34	1547391.0
2015-03-31 13:00:00	IWM	ETF	124.345	124.59	124.3	124.32	1853607.0
2015-03-31 14:00:00	IWM	ETF	124.32	124.6	124.26	124.5	1879203.0
2015-03-31 15:00:00	IWM	ETF	124.51	124.63	123.98	124.37	7076197.0
2015-03-31 16:00:00	IWM	ETF	124.37	124.44	124.14	124.24	1463436.0
2015-03-31 17:00:00	IWM	ETF	124.27	124.37	124.18	124.21	88319.0
2015-03-31 18:00:00	IWM	ETF	124.22	124.25	124.21	124.25	600.0
2015-03-31 19:00:00	IWM	ETF	124.25	124.25	124.25	124.25	200.0
2015-03-31 04:00:00	DIA	ETF	179.02	179.02	179.02	179.02	400.0
2015-03-31 05:00:00	DIA	ETF	178.88	178.88	178.88	178.88	200.0
2015-03-31 06:00:00	DIA	ETF	178.22	178.22	178.22	178.22	200.0
2015-03-31 07:00:00	DIA	ETF	178.27	178.27	178.21	178.24	1928.0

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

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