PREVIEW / etf_1hour / 2014-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-08.parquet
  size:    218 KB
  rows:    6,886

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-08 04:00:00	SPY	ETF	184.63	184.65	184.44	184.45	16334.0
2014-04-08 05:00:00	SPY	ETF	184.45	184.53	184.25	184.25	67571.0
2014-04-08 06:00:00	SPY	ETF	184.3	184.33	183.97	184.06	82903.0
2014-04-08 07:00:00	SPY	ETF	184.03	184.19	183.86	183.98	337335.0
2014-04-08 08:00:00	SPY	ETF	184.1	184.52	184.0	184.4	2105512.0
2014-04-08 09:00:00	SPY	ETF	184.39	184.76	184.06	184.2	16371746.0
2014-04-08 10:00:00	SPY	ETF	184.2	184.68	183.59	184.54	24905900.0
2014-04-08 11:00:00	SPY	ETF	184.55	185.2	184.55	185.02	17215207.0
2014-04-08 12:00:00	SPY	ETF	185.01	185.17	184.77	184.79	8081279.0
2014-04-08 13:00:00	SPY	ETF	184.781	185.4	184.78	185.29	8952289.0
2014-04-08 14:00:00	SPY	ETF	185.28	185.32	184.62	184.91	11508947.0
2014-04-08 15:00:00	SPY	ETF	184.9	185.28	184.69	185.11	16319655.0
2014-04-08 16:00:00	SPY	ETF	185.11	185.205	184.3764	185.02	4800496.0
2014-04-08 17:00:00	SPY	ETF	185.02	185.07	184.3764	185.04	1099795.0
2014-04-08 18:00:00	SPY	ETF	185.04	185.09	185.02	185.06	35954.0
2014-04-08 19:00:00	SPY	ETF	185.04	185.11	185.04	185.1	37309.0
2014-04-08 04:00:00	QQQ	ETF	85.74	85.78	85.67	85.67	7550.0
2014-04-08 05:00:00	QQQ	ETF	85.68	85.75	85.58	85.6	18497.0
2014-04-08 06:00:00	QQQ	ETF	85.63	85.65	85.48	85.48	20235.0
2014-04-08 07:00:00	QQQ	ETF	85.46	85.6	85.42	85.47	124112.0
2014-04-08 08:00:00	QQQ	ETF	85.51	85.83	85.44	85.73	439850.0
2014-04-08 09:00:00	QQQ	ETF	85.72	86.08	85.42	85.67	10257661.0
2014-04-08 10:00:00	QQQ	ETF	85.66	86.25	85.35	86.13	11850267.0
2014-04-08 11:00:00	QQQ	ETF	86.13	86.46	86.02	86.21	9885000.0
2014-04-08 12:00:00	QQQ	ETF	86.22	86.431	86.12	86.2356	3365487.0
2014-04-08 13:00:00	QQQ	ETF	86.24	86.42	86.17	86.3796	3070945.0
2014-04-08 14:00:00	QQQ	ETF	86.37	86.4	86.01	86.225	4352992.0
2014-04-08 15:00:00	QQQ	ETF	86.22	86.45	86.135	86.34	6689994.0
2014-04-08 16:00:00	QQQ	ETF	86.34	86.36	85.9662	86.29	928724.0
2014-04-08 17:00:00	QQQ	ETF	86.31	86.33	86.27	86.31	27735.0
2014-04-08 18:00:00	QQQ	ETF	86.29	86.3	86.28	86.29	12643.0
2014-04-08 19:00:00	QQQ	ETF	86.28	86.33	86.28	86.33	9800.0
2014-04-08 06:00:00	IWM	ETF	112.6	112.6	112.51	112.51	3700.0
2014-04-08 07:00:00	IWM	ETF	112.33	112.7	112.32	112.48	167500.0
2014-04-08 08:00:00	IWM	ETF	112.61	113.06	112.54	113.01	436079.0
2014-04-08 09:00:00	IWM	ETF	112.98	113.73	112.64	112.6501	9597848.0
2014-04-08 10:00:00	IWM	ETF	112.67	113.275	112.2	113.1599	12679846.0
2014-04-08 11:00:00	IWM	ETF	113.16	113.94	113.15	113.48	7771842.0
2014-04-08 12:00:00	IWM	ETF	113.48	113.89	113.28	113.5604	4832445.0
2014-04-08 13:00:00	IWM	ETF	113.565	114.2	113.46	113.97	4001108.0
2014-04-08 14:00:00	IWM	ETF	113.96	114.02	113.18	113.48	4456286.0
2014-04-08 15:00:00	IWM	ETF	113.47	113.85	113.335	113.59	6518302.0
2014-04-08 16:00:00	IWM	ETF	113.59	113.64	113.45	113.52	2594951.0
2014-04-08 17:00:00	IWM	ETF	113.5	113.52	113.48	113.52	1320.0
2014-04-08 18:00:00	IWM	ETF	113.5	113.5	113.5	113.5	200.0
2014-04-08 07:00:00	DIA	ETF	162.0	162.0	162.0	162.0	100.0
2014-04-08 08:00:00	DIA	ETF	162.0	162.33	162.0	162.3	3330.0
2014-04-08 09:00:00	DIA	ETF	162.25	162.33	161.7	161.87	1093077.0
2014-04-08 10:00:00	DIA	ETF	161.87	162.33	161.55	162.19	1260193.0
2014-04-08 11:00:00	DIA	ETF	162.2	162.69	162.2	162.6	668924.0

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

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