PREVIEW / etf_1hour / 2014-08-13

all etf 1-hour files

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

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-13 04:00:00	SPY	ETF	194.23	194.45	194.23	194.37	10438.0
2014-08-13 05:00:00	SPY	ETF	194.39	194.4	194.18	194.38	51447.0
2014-08-13 06:00:00	SPY	ETF	194.33	194.63	194.32	194.58	150940.0
2014-08-13 07:00:00	SPY	ETF	194.63	194.63	194.37	194.57	422777.0
2014-08-13 08:00:00	SPY	ETF	194.54	194.65	193.67	194.24	878931.0
2014-08-13 09:00:00	SPY	ETF	194.25	194.54	193.99	194.089	9778192.0
2014-08-13 10:00:00	SPY	ETF	194.08	194.49	193.96	194.47	9909704.0
2014-08-13 11:00:00	SPY	ETF	194.465	195.06	194.455	194.81	13768693.0
2014-08-13 12:00:00	SPY	ETF	194.8	194.92	194.6	194.83	5866015.0
2014-08-13 13:00:00	SPY	ETF	194.84	194.97	194.74	194.881	4711927.0
2014-08-13 14:00:00	SPY	ETF	194.89	194.89	194.6	194.73	4893685.0
2014-08-13 15:00:00	SPY	ETF	194.72	194.92	194.62	194.91	10549061.0
2014-08-13 16:00:00	SPY	ETF	194.91	195.18	193.5724	195.16	6947993.0
2014-08-13 17:00:00	SPY	ETF	195.16	195.2	195.11	195.15	59173.0
2014-08-13 18:00:00	SPY	ETF	195.15	195.16	195.0	195.05	59837.0
2014-08-13 19:00:00	SPY	ETF	195.06	195.08	194.99	195.01	60466.0
2014-08-13 04:00:00	QQQ	ETF	95.71	95.78	95.71	95.78	1300.0
2014-08-13 05:00:00	QQQ	ETF	95.7	95.78	95.7	95.76	9100.0
2014-08-13 06:00:00	QQQ	ETF	95.8	95.92	95.8	95.87	105150.0
2014-08-13 07:00:00	QQQ	ETF	95.85	95.87	95.79	95.87	25500.0
2014-08-13 08:00:00	QQQ	ETF	95.86	95.92	95.75	95.76	185002.0
2014-08-13 09:00:00	QQQ	ETF	95.76	95.979	95.68	95.811	3345199.0
2014-08-13 10:00:00	QQQ	ETF	95.805	96.17	95.8	96.155	5273856.0
2014-08-13 11:00:00	QQQ	ETF	96.15	96.41	96.15	96.28	4306735.0
2014-08-13 12:00:00	QQQ	ETF	96.28	96.36	96.17	96.2749	2731322.0
2014-08-13 13:00:00	QQQ	ETF	96.2701	96.45	96.26	96.405	1314461.0
2014-08-13 14:00:00	QQQ	ETF	96.41	96.43	96.3	96.39	1620098.0
2014-08-13 15:00:00	QQQ	ETF	96.39	96.47	96.33	96.44	4476788.0
2014-08-13 16:00:00	QQQ	ETF	96.43	96.53	96.1054	96.49	1706506.0
2014-08-13 17:00:00	QQQ	ETF	96.49	96.49	96.45	96.49	2850.0
2014-08-13 18:00:00	QQQ	ETF	96.45	96.46	96.41	96.43	62100.0
2014-08-13 19:00:00	QQQ	ETF	96.43	96.44	96.38	96.42	24245.0
2014-08-13 06:00:00	IWM	ETF	113.06	113.09	113.06	113.09	5000.0
2014-08-13 07:00:00	IWM	ETF	113.14	113.14	112.94	113.02	40600.0
2014-08-13 08:00:00	IWM	ETF	113.05	113.14	112.78	112.85	154805.0
2014-08-13 09:00:00	IWM	ETF	112.85	113.1	112.7	112.74	2621909.0
2014-08-13 10:00:00	IWM	ETF	112.74	113.31	112.71	113.26	2999788.0
2014-08-13 11:00:00	IWM	ETF	113.27	113.65	113.24	113.44	3590842.0
2014-08-13 12:00:00	IWM	ETF	113.44	113.47	113.19	113.22	2111075.0
2014-08-13 13:00:00	IWM	ETF	113.225	113.46	113.2	113.4	1092498.0
2014-08-13 14:00:00	IWM	ETF	113.4	113.45	113.2	113.35	1856748.0
2014-08-13 15:00:00	IWM	ETF	113.35	113.41	113.27	113.41	4126625.0
2014-08-13 16:00:00	IWM	ETF	113.42	113.57	113.31	113.54	1938443.0
2014-08-13 17:00:00	IWM	ETF	113.49	113.52	113.48	113.48	12249.0
2014-08-13 18:00:00	IWM	ETF	113.5	113.5	113.5	113.5	200.0
2014-08-13 19:00:00	IWM	ETF	113.47	113.49	113.35	113.35	2852.0
2014-08-13 04:00:00	DIA	ETF	166.0	166.05	166.0	166.05	699.0
2014-08-13 06:00:00	DIA	ETF	166.24	166.24	166.24	166.24	100.0
2014-08-13 07:00:00	DIA	ETF	166.2	166.2	166.2	166.2	600.0
2014-08-13 08:00:00	DIA	ETF	165.96	166.3	165.96	166.17	12850.0

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

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