PREVIEW / etf_1hour / 2015-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-05.parquet
  size:    240 KB
  rows:    7,614

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-06-05 04:00:00	SPY	ETF	210.57	210.77	210.4	210.41	35226.0
2015-06-05 05:00:00	SPY	ETF	210.41	210.55	210.35	210.35	12155.0
2015-06-05 06:00:00	SPY	ETF	210.32	210.35	209.77	209.95	498397.0
2015-06-05 07:00:00	SPY	ETF	209.98	210.32	209.85	210.2	284213.0
2015-06-05 08:00:00	SPY	ETF	210.2	210.36	209.28	209.91	5355198.0
2015-06-05 09:00:00	SPY	ETF	209.89	210.17	208.98	209.6801	20065970.0
2015-06-05 10:00:00	SPY	ETF	209.7	210.58	209.66	209.955	22543578.0
2015-06-05 11:00:00	SPY	ETF	209.955	210.22	209.79	209.97	10700614.0
2015-06-05 12:00:00	SPY	ETF	209.96	210.07	209.47	210.01	10871828.0
2015-06-05 13:00:00	SPY	ETF	210.005	210.15	209.81	209.87	7928098.0
2015-06-05 14:00:00	SPY	ETF	209.88	210.17	209.8	209.95	7259271.0
2015-06-05 15:00:00	SPY	ETF	209.94	210.085	209.56	209.79	18910282.0
2015-06-05 16:00:00	SPY	ETF	209.78	209.89	209.65	209.83	15545317.0
2015-06-05 17:00:00	SPY	ETF	209.83	209.83	209.72	209.75	350838.0
2015-06-05 18:00:00	SPY	ETF	209.76	209.81	209.76	209.77	13989.0
2015-06-05 19:00:00	SPY	ETF	209.79	209.82	209.77	209.82	7955.0
2015-06-05 06:00:00	QQQ	ETF	109.47	109.51	109.39	109.49	30398.0
2015-06-05 07:00:00	QQQ	ETF	109.48	109.66	109.45	109.64	30300.0
2015-06-05 08:00:00	QQQ	ETF	109.61	109.65	109.09	109.39	488058.0
2015-06-05 09:00:00	QQQ	ETF	109.38	109.61	108.63	109.04	5735696.0
2015-06-05 10:00:00	QQQ	ETF	109.06	109.69	109.04	109.36	4685764.0
2015-06-05 11:00:00	QQQ	ETF	109.36	109.6	109.295	109.45	1532245.0
2015-06-05 12:00:00	QQQ	ETF	109.45	109.46	109.15	109.41	1548333.0
2015-06-05 13:00:00	QQQ	ETF	109.41	109.515	109.32	109.38	1178005.0
2015-06-05 14:00:00	QQQ	ETF	109.38	109.57	109.36	109.44	1732083.0
2015-06-05 15:00:00	QQQ	ETF	109.44	109.5	109.23	109.31	3228663.0
2015-06-05 16:00:00	QQQ	ETF	109.31	109.44	109.26	109.4	316776.0
2015-06-05 17:00:00	QQQ	ETF	109.3	109.43	109.3	109.43	414369.0
2015-06-05 18:00:00	QQQ	ETF	109.34	109.4	109.34	109.4	650.0
2015-06-05 19:00:00	QQQ	ETF	109.37	109.4	109.36	109.36	500.0
2015-06-05 05:00:00	IWM	ETF	124.63	124.63	124.63	124.63	300.0
2015-06-05 06:00:00	IWM	ETF	124.44	124.44	124.24	124.24	300.0
2015-06-05 07:00:00	IWM	ETF	124.34	124.34	124.34	124.34	1000.0
2015-06-05 08:00:00	IWM	ETF	124.39	124.6	124.04	124.4	646208.0
2015-06-05 09:00:00	IWM	ETF	124.42	124.43	123.32	124.25	4741895.0
2015-06-05 10:00:00	IWM	ETF	124.25	124.79	123.94	124.35	4122935.0
2015-06-05 11:00:00	IWM	ETF	124.35	124.58	124.285	124.555	1206104.0
2015-06-05 12:00:00	IWM	ETF	124.54	124.72	124.37	124.7001	3598493.0
2015-06-05 13:00:00	IWM	ETF	124.71	124.92	124.69	124.86	2226367.0
2015-06-05 14:00:00	IWM	ETF	124.865	125.49	124.86	125.465	3641163.0
2015-06-05 15:00:00	IWM	ETF	125.47	125.52	125.17	125.39	5650687.0
2015-06-05 16:00:00	IWM	ETF	125.39	125.51	124.4794	125.45	1624744.0
2015-06-05 17:00:00	IWM	ETF	125.43	125.43	125.37	125.41	161724.0
2015-06-05 19:00:00	IWM	ETF	125.39	125.39	125.39	125.39	100.0
2015-06-05 07:00:00	DIA	ETF	179.21	179.21	179.16	179.16	400.0
2015-06-05 08:00:00	DIA	ETF	179.07	179.1	178.5	178.9	80800.0
2015-06-05 09:00:00	DIA	ETF	178.77	179.32	178.25	178.68	1125796.0
2015-06-05 10:00:00	DIA	ETF	178.6899	179.46	178.68	178.87	980365.0
2015-06-05 11:00:00	DIA	ETF	178.89	179.11	178.67	178.799	368202.0
2015-06-05 12:00:00	DIA	ETF	178.78	178.8832	178.41	178.82	372673.0

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

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