PREVIEW / etf_1hour / 2014-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-08.parquet
  size:    220 KB
  rows:    6,920

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-08-08 04:00:00	SPY	ETF	189.94	190.45	189.61	190.3	101885.0
2014-08-08 05:00:00	SPY	ETF	190.25	190.41	190.18	190.28	61169.0
2014-08-08 06:00:00	SPY	ETF	190.33	190.82	190.33	190.67	215610.0
2014-08-08 07:00:00	SPY	ETF	190.69	191.63	190.64	191.4	1370941.0
2014-08-08 08:00:00	SPY	ETF	191.55	191.94	190.59	191.63	2481115.0
2014-08-08 09:00:00	SPY	ETF	191.63	191.69	190.99	191.3	14797618.0
2014-08-08 10:00:00	SPY	ETF	191.3	191.88	190.95	191.67	17766636.0
2014-08-08 11:00:00	SPY	ETF	191.67	192.07	191.515	191.99	11355309.0
2014-08-08 12:00:00	SPY	ETF	191.98	192.03	191.62	191.8	6314279.0
2014-08-08 13:00:00	SPY	ETF	191.79	192.93	191.72	192.815	18360274.0
2014-08-08 14:00:00	SPY	ETF	192.815	193.02	192.69	192.79	10981756.0
2014-08-08 15:00:00	SPY	ETF	192.79	193.37	192.65	193.24	21065237.0
2014-08-08 16:00:00	SPY	ETF	193.23	193.2699	191.45	192.95	8534204.0
2014-08-08 17:00:00	SPY	ETF	192.95	193.07	192.91	193.0	2629212.0
2014-08-08 18:00:00	SPY	ETF	193.01	193.05	192.98	193.04	26276.0
2014-08-08 19:00:00	SPY	ETF	193.02	193.06	192.95	193.01	24271.0
2014-08-08 04:00:00	QQQ	ETF	93.75	93.9	93.62	93.85	22178.0
2014-08-08 05:00:00	QQQ	ETF	93.83	93.91	93.83	93.91	750.0
2014-08-08 06:00:00	QQQ	ETF	93.92	94.1	93.92	94.03	14760.0
2014-08-08 07:00:00	QQQ	ETF	94.03	94.46	94.03	94.38	389740.0
2014-08-08 08:00:00	QQQ	ETF	94.37	94.61	93.58	94.46	480568.0
2014-08-08 09:00:00	QQQ	ETF	94.45	94.49	94.12	94.31	5065458.0
2014-08-08 10:00:00	QQQ	ETF	94.3	94.47	93.97	94.36	6632283.0
2014-08-08 11:00:00	QQQ	ETF	94.35	94.53	94.2901	94.445	5395503.0
2014-08-08 12:00:00	QQQ	ETF	94.45	94.4801	94.25	94.34	2585116.0
2014-08-08 13:00:00	QQQ	ETF	94.34	94.94	94.31	94.875	3945828.0
2014-08-08 14:00:00	QQQ	ETF	94.88	94.985	94.82	94.9	2938671.0
2014-08-08 15:00:00	QQQ	ETF	94.89	95.01	94.78	94.9	6318316.0
2014-08-08 16:00:00	QQQ	ETF	94.9	94.9416	94.2137	94.72	2327890.0
2014-08-08 17:00:00	QQQ	ETF	94.71	94.79	94.71	94.79	7494.0
2014-08-08 18:00:00	QQQ	ETF	94.79	94.87	94.79	94.87	718.0
2014-08-08 19:00:00	QQQ	ETF	94.85	94.85	94.84	94.84	460.0
2014-08-08 04:00:00	IWM	ETF	110.15	110.37	110.15	110.27	1107.0
2014-08-08 06:00:00	IWM	ETF	110.7	110.9	110.7	110.9	1300.0
2014-08-08 07:00:00	IWM	ETF	110.9	111.54	110.9	111.42	232300.0
2014-08-08 08:00:00	IWM	ETF	111.42	111.67	111.34	111.42	192034.0
2014-08-08 09:00:00	IWM	ETF	111.44	111.58	111.03	111.43	3160744.0
2014-08-08 10:00:00	IWM	ETF	111.42	111.8	111.26	111.66	3822053.0
2014-08-08 11:00:00	IWM	ETF	111.65	112.05	111.58	111.94	3979895.0
2014-08-08 12:00:00	IWM	ETF	111.94	111.9533	111.64	111.76	1153842.0
2014-08-08 13:00:00	IWM	ETF	111.76	112.39	111.73	112.32	3270666.0
2014-08-08 14:00:00	IWM	ETF	112.325	112.4	112.14	112.26	2441482.0
2014-08-08 15:00:00	IWM	ETF	112.26	112.4	112.23	112.27	5687867.0
2014-08-08 16:00:00	IWM	ETF	112.27	112.27	112.0	112.13	1311029.0
2014-08-08 17:00:00	IWM	ETF	112.15	112.28	112.15	112.28	50942.0
2014-08-08 19:00:00	IWM	ETF	112.17	112.26	112.12	112.26	5816.0
2014-08-08 04:00:00	DIA	ETF	162.89	162.91	162.77	162.91	2300.0
2014-08-08 05:00:00	DIA	ETF	162.95	162.95	162.95	162.95	400.0
2014-08-08 07:00:00	DIA	ETF	163.21	163.77	163.21	163.77	1100.0
2014-08-08 08:00:00	DIA	ETF	163.77	163.94	163.6	163.73	5700.0

> showing 50 of 6,920 rows — these rows as CSV

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