PREVIEW / etf_1hour / 2014-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-21.parquet
  size:    217 KB
  rows:    6,906

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-21 04:00:00	SPY	ETF	199.17	199.35	199.11	199.26	34048.0
2014-08-21 05:00:00	SPY	ETF	199.22	199.28	199.05	199.28	9365.0
2014-08-21 06:00:00	SPY	ETF	199.29	199.33	199.21	199.23	11649.0
2014-08-21 07:00:00	SPY	ETF	199.26	199.32	199.19	199.28	101371.0
2014-08-21 08:00:00	SPY	ETF	199.28	199.34	199.15	199.22	618483.0
2014-08-21 09:00:00	SPY	ETF	199.24	199.43	198.95	199.34	8166956.0
2014-08-21 10:00:00	SPY	ETF	199.36	199.53	198.93	199.41	16767328.0
2014-08-21 11:00:00	SPY	ETF	199.42	199.57	199.3	199.33	6613656.0
2014-08-21 12:00:00	SPY	ETF	199.325	199.48	199.32	199.41	4012617.0
2014-08-21 13:00:00	SPY	ETF	199.4	199.64	199.4	199.555	4987030.0
2014-08-21 14:00:00	SPY	ETF	199.555	199.7	199.49	199.66	4889815.0
2014-08-21 15:00:00	SPY	ETF	199.66	199.76	199.45	199.49	10285136.0
2014-08-21 16:00:00	SPY	ETF	199.48	199.6919	198.9285	199.55	7079654.0
2014-08-21 17:00:00	SPY	ETF	199.54	199.58	199.52	199.56	263448.0
2014-08-21 18:00:00	SPY	ETF	199.56	199.58	199.52	199.54	17584.0
2014-08-21 19:00:00	SPY	ETF	199.54	199.6	199.54	199.6	27382.0
2014-08-21 05:00:00	QQQ	ETF	98.84	98.84	98.84	98.84	300.0
2014-08-21 06:00:00	QQQ	ETF	98.85	98.85	98.84	98.84	3200.0
2014-08-21 07:00:00	QQQ	ETF	98.86	98.87	98.81	98.85	15470.0
2014-08-21 08:00:00	QQQ	ETF	98.85	98.88	98.81	98.86	153649.0
2014-08-21 09:00:00	QQQ	ETF	98.85	98.92	98.711	98.8699	2324712.0
2014-08-21 10:00:00	QQQ	ETF	98.852	98.95	98.6	98.8499	4078227.0
2014-08-21 11:00:00	QQQ	ETF	98.845	98.9	98.74	98.75	1506694.0
2014-08-21 12:00:00	QQQ	ETF	98.75	98.83	98.72	98.7832	1188915.0
2014-08-21 13:00:00	QQQ	ETF	98.79	98.91	98.78	98.8122	1522322.0
2014-08-21 14:00:00	QQQ	ETF	98.81	98.93	98.78	98.91	1715386.0
2014-08-21 15:00:00	QQQ	ETF	98.9101	98.94	98.84	98.9	3089416.0
2014-08-21 16:00:00	QQQ	ETF	98.89	98.95	98.7994	98.95	2550751.0
2014-08-21 17:00:00	QQQ	ETF	98.95	98.99	98.9	98.99	481316.0
2014-08-21 18:00:00	QQQ	ETF	98.94	98.94	98.93	98.93	3600.0
2014-08-21 19:00:00	QQQ	ETF	98.95	98.95	98.92	98.94	13970.0
2014-08-21 04:00:00	IWM	ETF	114.93	114.93	114.93	114.93	200.0
2014-08-21 05:00:00	IWM	ETF	114.91	114.91	114.91	114.91	200.0
2014-08-21 06:00:00	IWM	ETF	114.62	114.62	114.62	114.62	100.0
2014-08-21 07:00:00	IWM	ETF	114.95	114.95	114.93	114.93	9985.0
2014-08-21 08:00:00	IWM	ETF	114.92	114.93	114.8	114.81	72168.0
2014-08-21 09:00:00	IWM	ETF	114.85	115.1	114.53	114.56	3295790.0
2014-08-21 10:00:00	IWM	ETF	114.59	114.73	113.84	114.55	9105579.0
2014-08-21 11:00:00	IWM	ETF	114.55	114.94	114.545	114.8101	3380196.0
2014-08-21 12:00:00	IWM	ETF	114.8	115.07	114.75	114.99	1900484.0
2014-08-21 13:00:00	IWM	ETF	115.0	115.31	114.97	115.195	2709339.0
2014-08-21 14:00:00	IWM	ETF	115.19	115.36	115.15	115.345	2067303.0
2014-08-21 15:00:00	IWM	ETF	115.345	115.4	115.15	115.2	4477667.0
2014-08-21 16:00:00	IWM	ETF	115.19	115.26	115.09	115.14	2300440.0
2014-08-21 17:00:00	IWM	ETF	115.06	115.16	115.06	115.16	16871.0
2014-08-21 18:00:00	IWM	ETF	115.06	115.15	115.06	115.1	5000.0
2014-08-21 07:00:00	DIA	ETF	169.81	169.95	169.81	169.95	250.0
2014-08-21 08:00:00	DIA	ETF	169.95	169.97	169.9	169.92	1050.0
2014-08-21 09:00:00	DIA	ETF	169.81	170.08	169.69	170.03	339823.0
2014-08-21 10:00:00	DIA	ETF	170.04	170.37	169.83	170.32	658691.0

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

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