PREVIEW / etf_1hour / 2015-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-16.parquet
  size:    240 KB
  rows:    7,645

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-16 04:00:00	SPY	ETF	206.22	206.45	205.93	206.45	1126.0
2015-03-16 05:00:00	SPY	ETF	206.32	206.6	206.29	206.43	31875.0
2015-03-16 06:00:00	SPY	ETF	206.44	206.61	206.34	206.57	23481.0
2015-03-16 07:00:00	SPY	ETF	206.38	206.45	206.21	206.35	209997.0
2015-03-16 08:00:00	SPY	ETF	206.35	206.8	206.19	206.71	536415.0
2015-03-16 09:00:00	SPY	ETF	206.69	207.72	206.67	207.6	16101264.0
2015-03-16 10:00:00	SPY	ETF	207.6	207.945	207.56	207.77	19945548.0
2015-03-16 11:00:00	SPY	ETF	207.775	208.219	207.735	208.08	15909513.0
2015-03-16 12:00:00	SPY	ETF	208.075	208.11	207.76	207.94	11277720.0
2015-03-16 13:00:00	SPY	ETF	207.94	208.16	207.67	208.055	10526442.0
2015-03-16 14:00:00	SPY	ETF	208.055	208.52	207.94	208.47	17587757.0
2015-03-16 15:00:00	SPY	ETF	208.48	208.69	208.34	208.65	27683100.0
2015-03-16 16:00:00	SPY	ETF	208.66	208.66	207.25	208.15	10878494.0
2015-03-16 17:00:00	SPY	ETF	208.15	208.15	207.93	208.0	329848.0
2015-03-16 18:00:00	SPY	ETF	207.98	207.99	207.81	207.92	235525.0
2015-03-16 19:00:00	SPY	ETF	207.91	208.05	207.89	208.05	186457.0
2015-03-16 06:00:00	QQQ	ETF	105.6	105.68	105.57	105.57	21250.0
2015-03-16 07:00:00	QQQ	ETF	105.57	105.58	105.52	105.55	43263.0
2015-03-16 08:00:00	QQQ	ETF	105.53	105.75	105.53	105.71	214114.0
2015-03-16 09:00:00	QQQ	ETF	105.72	106.18	105.62	106.0944	5212652.0
2015-03-16 10:00:00	QQQ	ETF	106.0901	106.37	106.0865	106.33	3630832.0
2015-03-16 11:00:00	QQQ	ETF	106.33	106.5	106.31	106.41	2886640.0
2015-03-16 12:00:00	QQQ	ETF	106.4	106.44	106.2	106.32	1521283.0
2015-03-16 13:00:00	QQQ	ETF	106.31	106.43	106.16	106.41	1542426.0
2015-03-16 14:00:00	QQQ	ETF	106.42	106.615	106.36	106.56	2167492.0
2015-03-16 15:00:00	QQQ	ETF	106.57	106.73	106.53	106.73	4699988.0
2015-03-16 16:00:00	QQQ	ETF	106.65	106.74	106.39	106.43	664949.0
2015-03-16 17:00:00	QQQ	ETF	106.42	106.44	106.37	106.43	14517.0
2015-03-16 18:00:00	QQQ	ETF	106.35	106.37	106.29	106.35	13100.0
2015-03-16 19:00:00	QQQ	ETF	106.35	106.4	106.35	106.39	4850.0
2015-03-16 06:00:00	IWM	ETF	123.51	123.51	123.27	123.47	540.0
2015-03-16 07:00:00	IWM	ETF	123.36	123.47	123.25	123.3	52900.0
2015-03-16 08:00:00	IWM	ETF	123.24	123.43	123.21	123.35	107578.0
2015-03-16 09:00:00	IWM	ETF	123.35	123.415	122.88	123.17	3291600.0
2015-03-16 10:00:00	IWM	ETF	123.18	123.47	123.07	123.32	3073935.0
2015-03-16 11:00:00	IWM	ETF	123.32	123.5499	123.3	123.3101	2110653.0
2015-03-16 12:00:00	IWM	ETF	123.32	123.36	123.025	123.145	1664148.0
2015-03-16 13:00:00	IWM	ETF	123.15	123.43	122.96	123.3599	1565795.0
2015-03-16 14:00:00	IWM	ETF	123.36	123.58	123.33	123.38	1346063.0
2015-03-16 15:00:00	IWM	ETF	123.39	123.51	123.2	123.34	3964381.0
2015-03-16 16:00:00	IWM	ETF	123.34	123.35	123.1	123.21	892116.0
2015-03-16 17:00:00	IWM	ETF	123.21	123.22	123.21	123.21	22380.0
2015-03-16 18:00:00	IWM	ETF	123.2	123.2	123.2	123.2	300.0
2015-03-16 19:00:00	IWM	ETF	123.18	123.2	123.1	123.1	1600.0
2015-03-16 07:00:00	DIA	ETF	177.95	177.96	177.92	177.92	300.0
2015-03-16 08:00:00	DIA	ETF	178.0	178.49	178.0	178.3	2300.0
2015-03-16 09:00:00	DIA	ETF	178.32	179.28	178.25	179.17	1045713.0
2015-03-16 10:00:00	DIA	ETF	179.17	179.4	179.06	179.21	934774.0
2015-03-16 11:00:00	DIA	ETF	179.23	179.7	179.17	179.54	700227.0
2015-03-16 12:00:00	DIA	ETF	179.54	179.57	179.23	179.37	426842.0

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

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