PREVIEW / etf_1hour / 2015-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-14.parquet
  size:    239 KB
  rows:    7,621

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
2015-05-14 04:00:00	SPY	ETF	210.65	211.12	210.65	210.97	97095.0
2015-05-14 05:00:00	SPY	ETF	211.0	211.0	210.86	210.86	43912.0
2015-05-14 06:00:00	SPY	ETF	210.87	211.01	210.82	211.0	27804.0
2015-05-14 07:00:00	SPY	ETF	210.97	211.33	210.82	211.27	424260.0
2015-05-14 08:00:00	SPY	ETF	211.25	211.33	210.91	211.22	772641.0
2015-05-14 09:00:00	SPY	ETF	211.25	211.48	210.91	211.08	11776033.0
2015-05-14 10:00:00	SPY	ETF	211.08	211.65	210.94	211.51	10777428.0
2015-05-14 11:00:00	SPY	ETF	211.51	211.62	211.33	211.565	8241083.0
2015-05-14 12:00:00	SPY	ETF	211.57	211.925	211.46	211.9	8216854.0
2015-05-14 13:00:00	SPY	ETF	211.905	212.19	211.86	212.06	8847462.0
2015-05-14 14:00:00	SPY	ETF	212.05	212.2	212.0	212.15	11172278.0
2015-05-14 15:00:00	SPY	ETF	212.14	212.32	212.06	212.21	23775845.0
2015-05-14 16:00:00	SPY	ETF	212.22	212.4	212.19	212.3	10091730.0
2015-05-14 17:00:00	SPY	ETF	212.32	212.33	212.27	212.33	17356.0
2015-05-14 18:00:00	SPY	ETF	212.27	212.28	212.22	212.28	49541.0
2015-05-14 19:00:00	SPY	ETF	212.25	212.27	212.21	212.27	51643.0
2015-05-14 04:00:00	QQQ	ETF	108.42	108.6	108.42	108.6	79695.0
2015-05-14 05:00:00	QQQ	ETF	108.45	108.45	108.45	108.45	200.0
2015-05-14 06:00:00	QQQ	ETF	108.53	108.65	108.48	108.57	34850.0
2015-05-14 07:00:00	QQQ	ETF	108.59	108.77	108.5	108.75	94596.0
2015-05-14 08:00:00	QQQ	ETF	108.74	108.8	108.67	108.8	145343.0
2015-05-14 09:00:00	QQQ	ETF	108.8	108.96	108.48	108.6544	3584269.0
2015-05-14 10:00:00	QQQ	ETF	108.65	109.09	108.57	109.055	3277977.0
2015-05-14 11:00:00	QQQ	ETF	109.055	109.23	109.015	109.2	2258600.0
2015-05-14 12:00:00	QQQ	ETF	109.2	109.37	109.12	109.36	2178081.0
2015-05-14 13:00:00	QQQ	ETF	109.36	109.52	109.35	109.4432	1507593.0
2015-05-14 14:00:00	QQQ	ETF	109.445	109.57	109.41	109.5001	1356223.0
2015-05-14 15:00:00	QQQ	ETF	109.51	109.67	109.4732	109.58	7785184.0
2015-05-14 16:00:00	QQQ	ETF	109.57	109.68	109.55	109.61	672437.0
2015-05-14 17:00:00	QQQ	ETF	109.6	109.61	109.59	109.59	1602.0
2015-05-14 18:00:00	QQQ	ETF	109.58	109.59	109.57	109.59	14243.0
2015-05-14 19:00:00	QQQ	ETF	109.59	109.61	109.59	109.61	6210.0
2015-05-14 04:00:00	IWM	ETF	122.82	122.95	122.82	122.95	2100.0
2015-05-14 05:00:00	IWM	ETF	123.08	123.08	123.08	123.08	300.0
2015-05-14 06:00:00	IWM	ETF	123.0	123.08	123.0	123.08	1400.0
2015-05-14 07:00:00	IWM	ETF	123.11	123.22	123.1	123.19	20850.0
2015-05-14 08:00:00	IWM	ETF	123.19	123.23	123.03	123.03	141285.0
2015-05-14 09:00:00	IWM	ETF	123.03	123.19	122.45	122.67	3297752.0
2015-05-14 10:00:00	IWM	ETF	122.67	123.43	122.55	123.24	3199475.0
2015-05-14 11:00:00	IWM	ETF	123.24	123.37	123.055	123.22	1258160.0
2015-05-14 12:00:00	IWM	ETF	123.225	123.86	123.2	123.7529	3796223.0
2015-05-14 13:00:00	IWM	ETF	123.75	123.83	123.615	123.69	1555511.0
2015-05-14 14:00:00	IWM	ETF	123.69	123.76	123.57	123.69	1117615.0
2015-05-14 15:00:00	IWM	ETF	123.7	123.84	123.57	123.75	4039051.0
2015-05-14 16:00:00	IWM	ETF	123.75	124.0	122.6692	123.68	1405724.0
2015-05-14 17:00:00	IWM	ETF	123.65	123.79	123.62	123.62	11304.0
2015-05-14 18:00:00	IWM	ETF	123.65	123.79	123.65	123.71	900.0
2015-05-14 08:00:00	DIA	ETF	181.74	181.76	181.63	181.74	11311.0
2015-05-14 09:00:00	DIA	ETF	181.75	182.18	181.729	181.94	933513.0
2015-05-14 10:00:00	DIA	ETF	181.94	182.36	181.81	182.21	602819.0

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

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