PREVIEW / etf_1hour / 2014-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-01-07.parquet
  size:    216 KB
  rows:    6,808

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-07 04:00:00	SPY	ETF	182.83	182.9	182.82	182.9	9096.0
2014-01-07 05:00:00	SPY	ETF	182.9	183.14	182.9	183.12	35260.0
2014-01-07 06:00:00	SPY	ETF	183.1	183.14	182.95	182.95	90783.0
2014-01-07 07:00:00	SPY	ETF	182.96	183.18	182.92	183.03	323610.0
2014-01-07 08:00:00	SPY	ETF	183.02	183.13	182.94	183.1	423470.0
2014-01-07 09:00:00	SPY	ETF	183.08	183.51	182.95	183.49	14675678.0
2014-01-07 10:00:00	SPY	ETF	183.49	183.79	183.44	183.625	12496495.0
2014-01-07 11:00:00	SPY	ETF	183.625	183.66	183.36	183.4001	8835173.0
2014-01-07 12:00:00	SPY	ETF	183.405	183.6	183.32	183.5899	5339938.0
2014-01-07 13:00:00	SPY	ETF	183.585	183.65	183.33	183.355	4802474.0
2014-01-07 14:00:00	SPY	ETF	183.351	183.555	183.14	183.486	9390164.0
2014-01-07 15:00:00	SPY	ETF	183.485	183.73	183.44	183.44	19387681.0
2014-01-07 16:00:00	SPY	ETF	183.44	183.524	182.4242	183.35	7726127.0
2014-01-07 17:00:00	SPY	ETF	183.37	183.42	182.4243	183.39	1094127.0
2014-01-07 18:00:00	SPY	ETF	183.39	183.42	183.37	183.39	13032.0
2014-01-07 19:00:00	SPY	ETF	183.38	183.38	183.28	183.29	90629.0
2014-01-07 05:00:00	QQQ	ETF	86.55	86.66	86.55	86.66	2320.0
2014-01-07 06:00:00	QQQ	ETF	86.6	86.62	86.6	86.62	1000.0
2014-01-07 07:00:00	QQQ	ETF	86.63	86.7	86.63	86.65	9200.0
2014-01-07 08:00:00	QQQ	ETF	86.67	86.72	86.32	86.69	125037.0
2014-01-07 09:00:00	QQQ	ETF	86.68	86.95	86.56	86.9401	3772223.0
2014-01-07 10:00:00	QQQ	ETF	86.949	87.11	86.93	87.07	3500608.0
2014-01-07 11:00:00	QQQ	ETF	87.07	87.1	86.91	86.9493	2143725.0
2014-01-07 12:00:00	QQQ	ETF	86.9499	87.09	86.89	87.06	1832854.0
2014-01-07 13:00:00	QQQ	ETF	87.06	87.14	86.975	86.99	1044624.0
2014-01-07 14:00:00	QQQ	ETF	86.98	87.105	86.841	87.09	2806710.0
2014-01-07 15:00:00	QQQ	ETF	87.1	87.25	87.08	87.09	4913039.0
2014-01-07 16:00:00	QQQ	ETF	87.09	87.12	86.776	87.06	743831.0
2014-01-07 17:00:00	QQQ	ETF	87.06	87.06	87.0	87.01	27850.0
2014-01-07 18:00:00	QQQ	ETF	87.02	87.03	87.02	87.02	37593.0
2014-01-07 19:00:00	QQQ	ETF	87.02	87.02	86.98	87.0	14700.0
2014-01-07 05:00:00	IWM	ETF	114.26	114.27	114.26	114.26	2000.0
2014-01-07 07:00:00	IWM	ETF	114.06	114.24	114.06	114.13	70559.0
2014-01-07 08:00:00	IWM	ETF	114.13	114.26	114.13	114.24	132590.0
2014-01-07 09:00:00	IWM	ETF	114.25	114.79	114.11	114.75	3627577.0
2014-01-07 10:00:00	IWM	ETF	114.76	115.16	114.752	115.095	3771603.0
2014-01-07 11:00:00	IWM	ETF	115.1	115.13	114.96	115.04	2284164.0
2014-01-07 12:00:00	IWM	ETF	115.02	115.03	114.81	114.89	1295831.0
2014-01-07 13:00:00	IWM	ETF	114.89	114.925	114.55	114.56	1866419.0
2014-01-07 14:00:00	IWM	ETF	114.56	114.8	114.36	114.78	3485634.0
2014-01-07 15:00:00	IWM	ETF	114.7799	114.98	114.69	114.69	6177931.0
2014-01-07 16:00:00	IWM	ETF	114.7	114.74	113.8057	114.61	1806870.0
2014-01-07 17:00:00	IWM	ETF	114.62	114.62	114.62	114.62	1000.0
2014-01-07 18:00:00	IWM	ETF	114.64	114.64	114.64	114.64	400.0
2014-01-07 19:00:00	IWM	ETF	114.65	114.65	114.63	114.63	1210.0
2014-01-07 07:00:00	DIA	ETF	164.63	164.63	164.63	164.63	100.0
2014-01-07 08:00:00	DIA	ETF	164.7	164.7	164.6	164.63	4360.0
2014-01-07 09:00:00	DIA	ETF	164.65	165.09	164.52	165.07	1241079.0
2014-01-07 10:00:00	DIA	ETF	165.08	165.29	164.98	165.1632	892107.0
2014-01-07 11:00:00	DIA	ETF	165.17	165.19	164.97	165.0046	399488.0

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

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