PREVIEW / etf_1hour / 2014-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-07.parquet
  size:    223 KB
  rows:    6,992

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-04-07 04:00:00	SPY	ETF	185.99	185.99	185.66	185.71	56222.0
2014-04-07 05:00:00	SPY	ETF	185.75	186.04	185.74	185.83	53750.0
2014-04-07 06:00:00	SPY	ETF	185.83	185.96	185.74	185.84	104931.0
2014-04-07 07:00:00	SPY	ETF	185.86	185.91	185.55	185.76	415538.0
2014-04-07 08:00:00	SPY	ETF	185.75	186.05	185.57	185.94	1410033.0
2014-04-07 09:00:00	SPY	ETF	185.96	186.05	185.22	186.0	17615979.0
2014-04-07 10:00:00	SPY	ETF	186.0	186.26	185.17	185.33	19165434.0
2014-04-07 11:00:00	SPY	ETF	185.33	185.95	184.78	184.79	15308484.0
2014-04-07 12:00:00	SPY	ETF	184.79	184.94	184.38	184.76	16954976.0
2014-04-07 13:00:00	SPY	ETF	184.75	185.2814	184.14	184.215	15567424.0
2014-04-07 14:00:00	SPY	ETF	184.22	184.86	183.96	184.69	18247573.0
2014-04-07 15:00:00	SPY	ETF	184.69	185.11	184.3	184.31	25047884.0
2014-04-07 16:00:00	SPY	ETF	184.31	186.3177	184.26	184.41	6572109.0
2014-04-07 17:00:00	SPY	ETF	184.41	184.48	184.41	184.48	144286.0
2014-04-07 18:00:00	SPY	ETF	184.49	184.61	184.48	184.6	80438.0
2014-04-07 19:00:00	SPY	ETF	184.61	184.63	184.59	184.59	57113.0
2014-04-07 04:00:00	QQQ	ETF	85.97	85.97	85.8	85.84	34884.0
2014-04-07 05:00:00	QQQ	ETF	86.02	86.02	85.85	85.85	8650.0
2014-04-07 06:00:00	QQQ	ETF	85.85	85.91	85.81	85.9	35570.0
2014-04-07 07:00:00	QQQ	ETF	85.9	85.9	85.71	85.8	347717.0
2014-04-07 08:00:00	QQQ	ETF	85.79	85.93	85.55	85.83	3260150.0
2014-04-07 09:00:00	QQQ	ETF	85.85	86.34	85.55	86.34	14823265.0
2014-04-07 10:00:00	QQQ	ETF	86.335	86.63	85.82	86.0	16545572.0
2014-04-07 11:00:00	QQQ	ETF	86.0	86.25	85.61	85.63	5777612.0
2014-04-07 12:00:00	QQQ	ETF	85.62	85.791	85.33	85.62	6422481.0
2014-04-07 13:00:00	QQQ	ETF	85.615	85.6599	85.18	85.23	5127685.0
2014-04-07 14:00:00	QQQ	ETF	85.22	85.73	84.951	85.59	10188413.0
2014-04-07 15:00:00	QQQ	ETF	85.59	86.09	85.515	85.56	12491959.0
2014-04-07 16:00:00	QQQ	ETF	85.56	85.61	85.51	85.57	2052806.0
2014-04-07 17:00:00	QQQ	ETF	85.59	85.64	85.59	85.62	13930.0
2014-04-07 18:00:00	QQQ	ETF	85.64	85.67	85.62	85.67	24676.0
2014-04-07 19:00:00	QQQ	ETF	85.68	85.69	85.67	85.69	11802.0
2014-04-07 04:00:00	IWM	ETF	113.87	113.87	113.87	113.87	100.0
2014-04-07 06:00:00	IWM	ETF	113.91	113.91	113.88	113.88	200.0
2014-04-07 07:00:00	IWM	ETF	113.81	113.91	113.64	113.77	194637.0
2014-04-07 08:00:00	IWM	ETF	113.77	114.06	113.76	113.97	258191.0
2014-04-07 09:00:00	IWM	ETF	114.0	114.14	112.98	114.09	9812924.0
2014-04-07 10:00:00	IWM	ETF	114.1	114.24	113.23	113.42	10738064.0
2014-04-07 11:00:00	IWM	ETF	113.42	113.61	112.6099	112.64	8178893.0
2014-04-07 12:00:00	IWM	ETF	112.64	113.08	112.35	112.95	7086261.0
2014-04-07 13:00:00	IWM	ETF	112.95	112.98	112.26	112.44	6471841.0
2014-04-07 14:00:00	IWM	ETF	112.44	112.94	112.08	112.81	6016920.0
2014-04-07 15:00:00	IWM	ETF	112.82	113.31	112.58	112.79	10366679.0
2014-04-07 16:00:00	IWM	ETF	112.79	114.4913	112.7	112.87	2907853.0
2014-04-07 17:00:00	IWM	ETF	112.87	112.97	112.83	112.9	10847.0
2014-04-07 18:00:00	IWM	ETF	112.92	112.97	112.92	112.94	2600.0
2014-04-07 19:00:00	IWM	ETF	113.0	113.0	112.95	112.97	1000.0
2014-04-07 07:00:00	DIA	ETF	163.19	163.48	163.19	163.48	300.0
2014-04-07 08:00:00	DIA	ETF	163.5	163.7	163.35	163.62	4571.0
2014-04-07 09:00:00	DIA	ETF	163.58	163.93	163.06	163.508	1238519.0

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

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