PREVIEW / etf_1hour / 2014-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-10-08.parquet
  size:    232 KB
  rows:    7,307

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-08 04:00:00	SPY	ETF	193.5	193.69	193.26	193.26	4463.0
2014-10-08 05:00:00	SPY	ETF	193.21	193.35	193.15	193.23	13892.0
2014-10-08 06:00:00	SPY	ETF	193.29	193.66	193.29	193.63	109873.0
2014-10-08 07:00:00	SPY	ETF	193.7	193.93	193.62	193.77	314386.0
2014-10-08 08:00:00	SPY	ETF	193.85	193.88	193.35	193.43	859651.0
2014-10-08 09:00:00	SPY	ETF	193.44	193.92	193.13	193.22	18997325.0
2014-10-08 10:00:00	SPY	ETF	193.21	193.73	192.54	192.582	26382856.0
2014-10-08 11:00:00	SPY	ETF	192.58	193.56	192.36	193.49	21230144.0
2014-10-08 12:00:00	SPY	ETF	193.5	193.77	193.24	193.42	9910931.0
2014-10-08 13:00:00	SPY	ETF	193.43	194.29	193.4	194.2123	11019323.0
2014-10-08 14:00:00	SPY	ETF	194.22	196.07	194.18	195.62	42358273.0
2014-10-08 15:00:00	SPY	ETF	195.62	196.92	195.61	196.64	40002141.0
2014-10-08 16:00:00	SPY	ETF	196.65	196.88	196.56	196.82	12423207.0
2014-10-08 17:00:00	SPY	ETF	196.8	196.8	196.65	196.65	209848.0
2014-10-08 18:00:00	SPY	ETF	196.69	196.69	196.54	196.65	231232.0
2014-10-08 19:00:00	SPY	ETF	196.63	196.67	196.51	196.51	153854.0
2014-10-08 04:00:00	QQQ	ETF	96.61	96.61	96.61	96.61	200.0
2014-10-08 05:00:00	QQQ	ETF	96.63	96.63	96.54	96.54	1700.0
2014-10-08 06:00:00	QQQ	ETF	96.61	96.84	96.61	96.84	36830.0
2014-10-08 07:00:00	QQQ	ETF	96.84	98.5736	96.78	96.87	72779.0
2014-10-08 08:00:00	QQQ	ETF	96.86	96.9	96.57	96.69	256330.0
2014-10-08 09:00:00	QQQ	ETF	96.68	96.91	96.43	96.4625	6320707.0
2014-10-08 10:00:00	QQQ	ETF	96.46	96.809	96.16	96.19	8682314.0
2014-10-08 11:00:00	QQQ	ETF	96.19	96.83	96.06	96.8	6893372.0
2014-10-08 12:00:00	QQQ	ETF	96.8	96.93	96.7	96.82	3728804.0
2014-10-08 13:00:00	QQQ	ETF	96.83	97.24	96.781	97.22	4236265.0
2014-10-08 14:00:00	QQQ	ETF	97.22	98.25	97.21	98.145	14998098.0
2014-10-08 15:00:00	QQQ	ETF	98.145	98.76	98.14	98.5	13632077.0
2014-10-08 16:00:00	QQQ	ETF	98.49	98.5955	96.5601	98.57	2880724.0
2014-10-08 17:00:00	QQQ	ETF	98.56	98.57	98.48	98.53	10967.0
2014-10-08 18:00:00	QQQ	ETF	98.5	98.5	98.41	98.49	44825.0
2014-10-08 19:00:00	QQQ	ETF	98.49	98.49	98.42	98.42	17975.0
2014-10-08 04:00:00	IWM	ETF	106.92	106.92	106.92	106.92	200.0
2014-10-08 05:00:00	IWM	ETF	106.7	106.7	106.69	106.69	4782.0
2014-10-08 06:00:00	IWM	ETF	106.73	106.78	106.73	106.78	35000.0
2014-10-08 07:00:00	IWM	ETF	106.78	106.92	106.75	106.83	130065.0
2014-10-08 08:00:00	IWM	ETF	106.88	106.91	106.53	106.56	253383.0
2014-10-08 09:00:00	IWM	ETF	106.56	107.19	106.52	106.65	4874180.0
2014-10-08 10:00:00	IWM	ETF	106.65	106.93	105.93	105.94	7031021.0
2014-10-08 11:00:00	IWM	ETF	105.93	106.53	105.76	106.44	6507022.0
2014-10-08 12:00:00	IWM	ETF	106.44	106.62	106.2628	106.37	2986442.0
2014-10-08 13:00:00	IWM	ETF	106.38	107.0	106.32	106.98	3715725.0
2014-10-08 14:00:00	IWM	ETF	106.98	108.76	106.95	108.38	11277761.0
2014-10-08 15:00:00	IWM	ETF	108.37	109.04	108.35	108.95	10230821.0
2014-10-08 16:00:00	IWM	ETF	108.94	109.09	108.81	109.04	2140007.0
2014-10-08 17:00:00	IWM	ETF	108.98	109.02	108.81	108.81	17747.0
2014-10-08 18:00:00	IWM	ETF	108.82	108.82	108.78	108.81	2647.0
2014-10-08 19:00:00	IWM	ETF	108.8	108.9	108.79	108.9	5350.0
2014-10-08 20:00:00	IWM	ETF	108.9549	108.9549	108.9549	108.9549	93000.0
2014-10-08 08:00:00	DIA	ETF	167.22	167.22	166.83	166.83	102545.0

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

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