PREVIEW / etf_1hour / 2015-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-17.parquet
  size:    247 KB
  rows:    7,781

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-04-17 04:00:00	SPY	ETF	210.25	210.28	210.17	210.28	6671.0
2015-04-17 05:00:00	SPY	ETF	210.28	210.28	210.04	210.04	26876.0
2015-04-17 06:00:00	SPY	ETF	209.99	209.99	208.75	209.21	504233.0
2015-04-17 07:00:00	SPY	ETF	209.2	209.38	209.12	209.24	466020.0
2015-04-17 08:00:00	SPY	ETF	209.29	209.72	209.0	209.27	1783228.0
2015-04-17 09:00:00	SPY	ETF	209.26	209.26	208.17	208.395	24906011.0
2015-04-17 10:00:00	SPY	ETF	208.4	208.51	207.8	207.97	26688320.0
2015-04-17 11:00:00	SPY	ETF	207.98	208.35	207.69	208.19	15637128.0
2015-04-17 12:00:00	SPY	ETF	208.19	208.33	207.98	208.16	10251404.0
2015-04-17 13:00:00	SPY	ETF	208.15	208.3	207.34	207.45	17041076.0
2015-04-17 14:00:00	SPY	ETF	207.46	207.56	207.01	207.38	30215316.0
2015-04-17 15:00:00	SPY	ETF	207.38	208.2	207.33	207.93	34683968.0
2015-04-17 16:00:00	SPY	ETF	207.93	210.3261	207.45	208.13	14222782.0
2015-04-17 17:00:00	SPY	ETF	208.14	208.17	207.7476	208.13	7818783.0
2015-04-17 18:00:00	SPY	ETF	208.14	208.15	208.1	208.11	49692.0
2015-04-17 19:00:00	SPY	ETF	208.1	208.1	208.06	208.08	40843.0
2015-04-17 05:00:00	QQQ	ETF	107.43	107.43	107.43	107.43	100.0
2015-04-17 06:00:00	QQQ	ETF	107.3	107.3	106.5	106.77	123041.0
2015-04-17 07:00:00	QQQ	ETF	106.77	106.87	106.75	106.82	81047.0
2015-04-17 08:00:00	QQQ	ETF	106.88	107.1	106.75	106.85	204626.0
2015-04-17 09:00:00	QQQ	ETF	106.84	106.95	106.19	106.32	7714846.0
2015-04-17 10:00:00	QQQ	ETF	106.34	106.4	105.97	106.07	7300773.0
2015-04-17 11:00:00	QQQ	ETF	106.06	106.23	105.94	106.13	3448351.0
2015-04-17 12:00:00	QQQ	ETF	106.125	106.21	105.99	106.11	1972899.0
2015-04-17 13:00:00	QQQ	ETF	106.1	106.19	105.74	105.78	3007536.0
2015-04-17 14:00:00	QQQ	ETF	105.78	105.85	105.55	105.75	4385579.0
2015-04-17 15:00:00	QQQ	ETF	105.75	106.17	105.73	106.03	7098124.0
2015-04-17 16:00:00	QQQ	ETF	106.03	106.17	106.01	106.11	904839.0
2015-04-17 17:00:00	QQQ	ETF	106.11	106.11	106.0	106.02	1394108.0
2015-04-17 18:00:00	QQQ	ETF	106.01	106.03	106.01	106.03	4900.0
2015-04-17 19:00:00	QQQ	ETF	106.01	106.01	105.95	105.98	7117.0
2015-04-17 04:00:00	IWM	ETF	126.05	126.05	126.05	126.05	100.0
2015-04-17 05:00:00	IWM	ETF	126.0	126.0	126.0	126.0	100.0
2015-04-17 06:00:00	IWM	ETF	125.97	125.97	124.93	125.04	15500.0
2015-04-17 07:00:00	IWM	ETF	125.38	125.45	125.13	125.25	98347.0
2015-04-17 08:00:00	IWM	ETF	125.21	125.5	125.19	125.25	245609.0
2015-04-17 09:00:00	IWM	ETF	125.27	125.545	124.92	125.0	5451637.0
2015-04-17 10:00:00	IWM	ETF	124.99	125.02	124.2	124.305	6827273.0
2015-04-17 11:00:00	IWM	ETF	124.29	124.72	124.1	124.42	3907186.0
2015-04-17 12:00:00	IWM	ETF	124.42	124.58	124.255	124.45	3434256.0
2015-04-17 13:00:00	IWM	ETF	124.44	124.57	124.15	124.17	3509189.0
2015-04-17 14:00:00	IWM	ETF	124.17	124.2601	123.82	123.96	4231937.0
2015-04-17 15:00:00	IWM	ETF	123.96	124.58	123.95	124.45	6690774.0
2015-04-17 16:00:00	IWM	ETF	124.45	124.55	124.34	124.4	1516802.0
2015-04-17 17:00:00	IWM	ETF	124.38	124.42	124.36	124.36	29200.0
2015-04-17 06:00:00	DIA	ETF	180.38	180.38	180.0	180.0	12650.0
2015-04-17 07:00:00	DIA	ETF	179.55	179.55	179.55	179.55	1125.0
2015-04-17 08:00:00	DIA	ETF	179.83	179.89	179.37	179.45	14727.0
2015-04-17 09:00:00	DIA	ETF	179.48	179.57	178.065	178.4	1558109.0
2015-04-17 10:00:00	DIA	ETF	178.4	178.54	177.95	178.06	1637805.0

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

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