PREVIEW / etf_1hour / 2014-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-01.parquet
  size:    235 KB
  rows:    7,384

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-10-01 04:00:00	SPY	ETF	196.75	197.09	196.75	197.02	65744.0
2014-10-01 05:00:00	SPY	ETF	197.06	197.09	196.77	196.82	47708.0
2014-10-01 06:00:00	SPY	ETF	196.85	196.92	196.8	196.86	117847.0
2014-10-01 07:00:00	SPY	ETF	196.83	196.94	196.54	196.65	428055.0
2014-10-01 08:00:00	SPY	ETF	196.79	196.79	196.26	196.59	1995886.0
2014-10-01 09:00:00	SPY	ETF	196.58	196.85	195.42	195.78	24103505.0
2014-10-01 10:00:00	SPY	ETF	195.78	195.95	195.16	195.91	26548211.0
2014-10-01 11:00:00	SPY	ETF	195.8999	196.23	195.41	195.61	16557681.0
2014-10-01 12:00:00	SPY	ETF	195.62	195.68	194.95	195.07	16306142.0
2014-10-01 13:00:00	SPY	ETF	195.075	195.18	194.3	194.355	20989324.0
2014-10-01 14:00:00	SPY	ETF	194.36	195.45	194.18	194.22	16787163.0
2014-10-01 15:00:00	SPY	ETF	194.23	194.91	193.91	194.34	42800159.0
2014-10-01 16:00:00	SPY	ETF	194.33	194.72	194.2	194.67	7673059.0
2014-10-01 17:00:00	SPY	ETF	194.68	194.69	194.54	194.63	324311.0
2014-10-01 18:00:00	SPY	ETF	194.65	194.72	194.62	194.63	74978.0
2014-10-01 19:00:00	SPY	ETF	194.64	194.7	194.6	194.64	108113.0
2014-10-01 06:00:00	QQQ	ETF	98.66	98.71	98.65	98.71	12300.0
2014-10-01 07:00:00	QQQ	ETF	98.62	98.69	98.5	98.55	51150.0
2014-10-01 08:00:00	QQQ	ETF	98.68	98.68	98.41	98.54	425549.0
2014-10-01 09:00:00	QQQ	ETF	98.53	98.64	97.89	97.96	7831483.0
2014-10-01 10:00:00	QQQ	ETF	97.96	98.019	97.54	97.857	11666383.0
2014-10-01 11:00:00	QQQ	ETF	97.86	98.08	97.67	97.8	5200561.0
2014-10-01 12:00:00	QQQ	ETF	97.79	97.8	97.4	97.47	4762887.0
2014-10-01 13:00:00	QQQ	ETF	97.47	97.54	97.05	97.09	5679733.0
2014-10-01 14:00:00	QQQ	ETF	97.1	97.42	97.03	97.06	5616495.0
2014-10-01 15:00:00	QQQ	ETF	97.055	97.41	96.9	97.22	10462175.0
2014-10-01 16:00:00	QQQ	ETF	97.21	97.8578	97.21	97.34	1403313.0
2014-10-01 17:00:00	QQQ	ETF	97.33	98.776	97.27	97.32	3037614.0
2014-10-01 18:00:00	QQQ	ETF	97.35	97.39	97.32	97.32	49552.0
2014-10-01 19:00:00	QQQ	ETF	97.33	97.35	97.28	97.3	16651.0
2014-10-01 04:00:00	IWM	ETF	109.35	109.35	109.35	109.35	400.0
2014-10-01 07:00:00	IWM	ETF	109.35	109.35	109.07	109.08	10248.0
2014-10-01 08:00:00	IWM	ETF	109.11	109.38	108.99	109.35	615835.0
2014-10-01 09:00:00	IWM	ETF	109.35	109.43	108.27	108.51	8860211.0
2014-10-01 10:00:00	IWM	ETF	108.5	109.07	108.12	109.03	12288013.0
2014-10-01 11:00:00	IWM	ETF	109.03	109.34	108.56	108.72	7778473.0
2014-10-01 12:00:00	IWM	ETF	108.72	108.72	107.92	108.16	4635337.0
2014-10-01 13:00:00	IWM	ETF	108.17	108.24	107.65	107.71	6118469.0
2014-10-01 14:00:00	IWM	ETF	107.71	108.11	107.62	107.73	6447599.0
2014-10-01 15:00:00	IWM	ETF	107.735	108.02	107.43	107.81	13297210.0
2014-10-01 16:00:00	IWM	ETF	107.8	109.39	107.6986	107.99	6974891.0
2014-10-01 17:00:00	IWM	ETF	108.0	108.02	107.75	107.8	276404.0
2014-10-01 18:00:00	IWM	ETF	107.9	107.93	107.86	107.88	2590.0
2014-10-01 19:00:00	IWM	ETF	107.87	107.92	107.86	107.89	1800.0
2014-10-01 04:00:00	DIA	ETF	169.89	169.89	169.89	169.89	299.0
2014-10-01 07:00:00	DIA	ETF	169.86	169.86	169.86	169.86	500.0
2014-10-01 08:00:00	DIA	ETF	169.9	169.9	169.49	169.9	11015.0
2014-10-01 09:00:00	DIA	ETF	169.85	170.04	168.72	168.94	1737033.0
2014-10-01 10:00:00	DIA	ETF	168.9	168.99	168.26	168.69	1800641.0
2014-10-01 11:00:00	DIA	ETF	168.69	168.91	168.23	168.36	1090775.0

> showing 50 of 7,384 rows — these rows as CSV

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