PREVIEW / etf_1hour / 2014-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-05.parquet
  size:    225 KB
  rows:    7,093

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-05 04:00:00	SPY	ETF	193.65	193.8	193.59	193.76	2357.0
2014-08-05 05:00:00	SPY	ETF	193.77	193.81	193.57	193.57	3693.0
2014-08-05 06:00:00	SPY	ETF	193.51	193.52	193.34	193.44	45630.0
2014-08-05 07:00:00	SPY	ETF	193.42	193.43	193.12	193.15	334787.0
2014-08-05 08:00:00	SPY	ETF	193.15	193.55	192.76	193.08	1372128.0
2014-08-05 09:00:00	SPY	ETF	193.06	193.88	192.62	192.88	13705001.0
2014-08-05 10:00:00	SPY	ETF	192.89	193.55	192.56	193.16	17519344.0
2014-08-05 11:00:00	SPY	ETF	193.17	193.6	192.9	192.98	9608153.0
2014-08-05 12:00:00	SPY	ETF	192.97	193.11	192.57	192.87	10623446.0
2014-08-05 13:00:00	SPY	ETF	192.87	193.1	191.59	191.85	28038498.0
2014-08-05 14:00:00	SPY	ETF	191.85	192.17	191.31	191.75	24713604.0
2014-08-05 15:00:00	SPY	ETF	191.75	192.3	191.4	191.98	30491025.0
2014-08-05 16:00:00	SPY	ETF	191.97	193.8959	191.719	191.97	13591221.0
2014-08-05 17:00:00	SPY	ETF	191.97	192.04	191.93	192.01	180681.0
2014-08-05 18:00:00	SPY	ETF	192.01	192.17	192.01	192.11	103031.0
2014-08-05 19:00:00	SPY	ETF	192.15	192.15	192.01	192.09	44643.0
2014-08-05 05:00:00	QQQ	ETF	95.26	95.26	95.14	95.21	7700.0
2014-08-05 06:00:00	QQQ	ETF	95.24	95.24	95.06	95.12	8700.0
2014-08-05 07:00:00	QQQ	ETF	95.1	95.1	94.98	95.0	35483.0
2014-08-05 08:00:00	QQQ	ETF	94.98	94.99	94.83	94.93	217976.0
2014-08-05 09:00:00	QQQ	ETF	94.93	95.16	94.56	94.68	4994162.0
2014-08-05 10:00:00	QQQ	ETF	94.69	95.16	94.55	94.97	6196981.0
2014-08-05 11:00:00	QQQ	ETF	94.97	95.21	94.79	94.86	3593664.0
2014-08-05 12:00:00	QQQ	ETF	94.86	94.92	94.64	94.83	2871883.0
2014-08-05 13:00:00	QQQ	ETF	94.84	94.999	94.3	94.42	7609331.0
2014-08-05 14:00:00	QQQ	ETF	94.41	94.57	94.15	94.35	5527669.0
2014-08-05 15:00:00	QQQ	ETF	94.35	94.6625	94.165	94.59	7836781.0
2014-08-05 16:00:00	QQQ	ETF	94.59	94.8001	94.3061	94.69	3671416.0
2014-08-05 17:00:00	QQQ	ETF	95.3863	95.3863	94.64	94.65	2521859.0
2014-08-05 18:00:00	QQQ	ETF	94.65	94.78	94.64	94.77	56727.0
2014-08-05 19:00:00	QQQ	ETF	94.77	94.77	94.7	94.74	8266.0
2014-08-05 06:00:00	IWM	ETF	111.39	111.63	111.39	111.63	1100.0
2014-08-05 07:00:00	IWM	ETF	111.31	111.31	111.31	111.31	100.0
2014-08-05 08:00:00	IWM	ETF	111.23	111.25	111.03	111.21	370537.0
2014-08-05 09:00:00	IWM	ETF	111.2	111.4	110.81	111.11	3752423.0
2014-08-05 10:00:00	IWM	ETF	111.11	112.12	110.96	111.94	7684764.0
2014-08-05 11:00:00	IWM	ETF	111.95	112.23	111.76	111.89	3744719.0
2014-08-05 12:00:00	IWM	ETF	111.9	111.97	111.34	111.62	2637549.0
2014-08-05 13:00:00	IWM	ETF	111.62	111.72	110.84	110.92	5190711.0
2014-08-05 14:00:00	IWM	ETF	110.91	111.25	110.56	110.95	5449936.0
2014-08-05 15:00:00	IWM	ETF	110.955	111.43	110.69	111.38	7108801.0
2014-08-05 16:00:00	IWM	ETF	111.37	111.68	111.0507	111.35	2314156.0
2014-08-05 17:00:00	IWM	ETF	111.31	111.38	110.9636	111.32	178074.0
2014-08-05 18:00:00	IWM	ETF	111.39	111.44	111.36	111.36	6709.0
2014-08-05 19:00:00	IWM	ETF	111.29	111.29	111.29	111.29	300.0
2014-08-05 07:00:00	DIA	ETF	164.86	164.86	164.86	164.86	300.0
2014-08-05 08:00:00	DIA	ETF	164.7	164.84	164.7	164.84	2800.0
2014-08-05 09:00:00	DIA	ETF	164.8	165.01	164.42	164.66	1047365.0
2014-08-05 10:00:00	DIA	ETF	164.67	165.14	164.4	164.73	968804.0
2014-08-05 11:00:00	DIA	ETF	164.74	165.03	164.56	164.64	670409.0

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

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