PREVIEW / etf_1hour / 2014-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-30.parquet
  size:    221 KB
  rows:    6,879

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-01-30 04:00:00	SPY	ETF	177.67	178.03	177.53	177.86	51561.0
2014-01-30 05:00:00	SPY	ETF	177.85	178.07	177.83	177.98	205549.0
2014-01-30 06:00:00	SPY	ETF	177.97	178.34	177.9	178.16	183992.0
2014-01-30 07:00:00	SPY	ETF	178.12	178.19	177.96	178.1	625360.0
2014-01-30 08:00:00	SPY	ETF	178.1	178.54	177.79	178.53	2751974.0
2014-01-30 09:00:00	SPY	ETF	178.53	178.99	178.46	178.53	17109569.0
2014-01-30 10:00:00	SPY	ETF	178.54	178.93	178.26	178.78	16843084.0
2014-01-30 11:00:00	SPY	ETF	178.78	179.66	178.64	179.535	15752642.0
2014-01-30 12:00:00	SPY	ETF	179.53	179.81	179.39	179.7	10627146.0
2014-01-30 13:00:00	SPY	ETF	179.7	179.7	179.34	179.39	8824136.0
2014-01-30 14:00:00	SPY	ETF	179.39	179.51	179.09	179.38	9482751.0
2014-01-30 15:00:00	SPY	ETF	179.38	179.69	179.21	179.32	21403358.0
2014-01-30 16:00:00	SPY	ETF	179.32	179.3551	177.3222	178.89	9724285.0
2014-01-30 17:00:00	SPY	ETF	178.89	179.3632	178.69	178.76	698365.0
2014-01-30 18:00:00	SPY	ETF	178.78	179.23	178.66	178.82	2589807.0
2014-01-30 19:00:00	SPY	ETF	178.82	178.88	178.68	178.87	183706.0
2014-01-30 04:00:00	QQQ	ETF	85.27	85.35	85.23	85.35	17600.0
2014-01-30 05:00:00	QQQ	ETF	85.45	85.45	85.45	85.45	2500.0
2014-01-30 06:00:00	QQQ	ETF	85.54	85.63	85.54	85.54	10100.0
2014-01-30 07:00:00	QQQ	ETF	85.58	85.63	85.54	85.61	77800.0
2014-01-30 08:00:00	QQQ	ETF	85.6	85.81	85.52	85.79	459632.0
2014-01-30 09:00:00	QQQ	ETF	85.8	86.22	85.79	85.98	7229149.0
2014-01-30 10:00:00	QQQ	ETF	85.98	86.32	85.88	86.2399	4809292.0
2014-01-30 11:00:00	QQQ	ETF	86.235	86.73	86.12	86.65	5061719.0
2014-01-30 12:00:00	QQQ	ETF	86.65	86.8	86.59	86.725	3183641.0
2014-01-30 13:00:00	QQQ	ETF	86.72	86.735	86.555	86.6	2389323.0
2014-01-30 14:00:00	QQQ	ETF	86.6	86.72	86.44	86.6699	2409459.0
2014-01-30 15:00:00	QQQ	ETF	86.67	86.79	86.47	86.48	6501856.0
2014-01-30 16:00:00	QQQ	ETF	86.47	86.61	84.9244	86.18	5960348.0
2014-01-30 17:00:00	QQQ	ETF	86.14	86.37	86.1	86.33	143429.0
2014-01-30 18:00:00	QQQ	ETF	86.34	86.5	86.32	86.33	1018062.0
2014-01-30 19:00:00	QQQ	ETF	86.3	86.35	86.3	86.35	6605.0
2014-01-30 06:00:00	IWM	ETF	111.96	112.0	111.96	112.0	700.0
2014-01-30 07:00:00	IWM	ETF	111.91	111.94	111.91	111.94	100188.0
2014-01-30 08:00:00	IWM	ETF	111.97	112.27	111.68	112.25	253023.0
2014-01-30 09:00:00	IWM	ETF	112.25	112.512	112.04	112.18	5880065.0
2014-01-30 10:00:00	IWM	ETF	112.18	112.74	112.06	112.64	5327692.0
2014-01-30 11:00:00	IWM	ETF	112.65	113.54	112.62	113.49	6766172.0
2014-01-30 12:00:00	IWM	ETF	113.489	113.65	113.33	113.56	2698318.0
2014-01-30 13:00:00	IWM	ETF	113.56	113.56	113.27	113.35	1992099.0
2014-01-30 14:00:00	IWM	ETF	113.355	113.379	112.99	113.23	3367927.0
2014-01-30 15:00:00	IWM	ETF	113.24	113.48	112.94	112.96	7019538.0
2014-01-30 16:00:00	IWM	ETF	112.97	113.001	111.4047	112.62	3603863.0
2014-01-30 17:00:00	IWM	ETF	112.65	112.67	112.52	112.52	39700.0
2014-01-30 18:00:00	IWM	ETF	112.57	112.72	112.57	112.71	5600.0
2014-01-30 19:00:00	IWM	ETF	112.72	112.76	112.67	112.72	5750.0
2014-01-30 05:00:00	DIA	ETF	157.28	157.28	157.28	157.28	100.0
2014-01-30 08:00:00	DIA	ETF	157.88	158.0	157.7	158.0	4043.0
2014-01-30 09:00:00	DIA	ETF	158.1	158.38	157.41	157.58	1540856.0
2014-01-30 10:00:00	DIA	ETF	157.58	158.0	157.37	157.95	1390696.0

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

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