PREVIEW / etf_1hour / 2015-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-10.parquet
  size:    243 KB
  rows:    7,724

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-10 04:00:00	SPY	ETF	208.98	209.22	208.98	209.22	104066.0
2015-06-10 05:00:00	SPY	ETF	209.12	209.55	209.1	209.5	67139.0
2015-06-10 06:00:00	SPY	ETF	209.45	209.55	209.35	209.4	54800.0
2015-06-10 07:00:00	SPY	ETF	209.38	209.45	209.25	209.39	212494.0
2015-06-10 08:00:00	SPY	ETF	209.38	209.44	209.16	209.25	351237.0
2015-06-10 09:00:00	SPY	ETF	209.25	210.1	209.2	209.9	14430196.0
2015-06-10 10:00:00	SPY	ETF	209.905	210.6	209.905	210.55	17961484.0
2015-06-10 11:00:00	SPY	ETF	210.56	211.41	210.47	211.065	26060520.0
2015-06-10 12:00:00	SPY	ETF	211.065	211.26	211.02	211.19	11285920.0
2015-06-10 13:00:00	SPY	ETF	211.19	211.25	210.92	211.08	7196915.0
2015-06-10 14:00:00	SPY	ETF	211.075	211.39	211.07	211.3499	16760881.0
2015-06-10 15:00:00	SPY	ETF	211.35	211.35	210.94	210.95	28755938.0
2015-06-10 16:00:00	SPY	ETF	210.95	211.37	210.94	211.28	8828479.0
2015-06-10 17:00:00	SPY	ETF	211.27	211.3	210.95	211.24	188187.0
2015-06-10 18:00:00	SPY	ETF	211.19	211.19	210.99	211.01	225465.0
2015-06-10 19:00:00	SPY	ETF	211.04	211.11	211.0	211.06	518653.0
2015-06-10 04:00:00	QQQ	ETF	108.41	108.41	108.41	108.41	20000.0
2015-06-10 05:00:00	QQQ	ETF	108.44	108.55	108.44	108.55	2000.0
2015-06-10 06:00:00	QQQ	ETF	108.69	108.69	108.57	108.57	15200.0
2015-06-10 07:00:00	QQQ	ETF	108.6	108.61	108.51	108.6	52512.0
2015-06-10 08:00:00	QQQ	ETF	108.57	108.59	108.38	108.41	91126.0
2015-06-10 09:00:00	QQQ	ETF	108.41	108.76	108.26	108.65	3160053.0
2015-06-10 10:00:00	QQQ	ETF	108.66	109.25	108.65	109.24	4411620.0
2015-06-10 11:00:00	QQQ	ETF	109.24	109.69	109.16	109.55	4597849.0
2015-06-10 12:00:00	QQQ	ETF	109.54	109.66	109.49	109.64	1935345.0
2015-06-10 13:00:00	QQQ	ETF	109.645	109.69	109.49	109.615	1277566.0
2015-06-10 14:00:00	QQQ	ETF	109.62	109.81	109.62	109.79	2037350.0
2015-06-10 15:00:00	QQQ	ETF	109.79	109.8	109.44	109.44	5236153.0
2015-06-10 16:00:00	QQQ	ETF	109.46	109.62	108.0888	109.55	1786813.0
2015-06-10 17:00:00	QQQ	ETF	109.58	109.6	109.58	109.6	653.0
2015-06-10 18:00:00	QQQ	ETF	109.57	109.57	109.43	109.43	26560.0
2015-06-10 19:00:00	QQQ	ETF	109.46	109.48	109.45	109.48	7760.0
2015-06-10 04:00:00	IWM	ETF	124.82	124.82	124.82	124.82	100.0
2015-06-10 05:00:00	IWM	ETF	125.0	125.0	125.0	125.0	100.0
2015-06-10 06:00:00	IWM	ETF	125.07	125.07	125.07	125.07	400.0
2015-06-10 07:00:00	IWM	ETF	125.02	125.02	124.93	125.02	15200.0
2015-06-10 08:00:00	IWM	ETF	125.02	125.05	124.9	124.92	100731.0
2015-06-10 09:00:00	IWM	ETF	124.95	125.59	124.85	125.43	3502612.0
2015-06-10 10:00:00	IWM	ETF	125.43	126.0801	125.42	126.0801	4155310.0
2015-06-10 11:00:00	IWM	ETF	126.08	126.48	126.04	126.26	4699696.0
2015-06-10 12:00:00	IWM	ETF	126.26	126.47	126.18	126.27	2472847.0
2015-06-10 13:00:00	IWM	ETF	126.28	126.35	125.96	126.15	2079089.0
2015-06-10 14:00:00	IWM	ETF	126.15	126.27	126.07	126.24	2657228.0
2015-06-10 15:00:00	IWM	ETF	126.2399	126.3	125.96	125.97	5011399.0
2015-06-10 16:00:00	IWM	ETF	125.97	126.24	125.93	126.12	2196352.0
2015-06-10 17:00:00	IWM	ETF	126.08	126.13	125.9901	126.089	11246.0
2015-06-10 18:00:00	IWM	ETF	126.12	126.12	125.98	125.98	5400.0
2015-06-10 19:00:00	IWM	ETF	125.98	125.98	125.94	125.94	1459.0
2015-06-10 07:00:00	DIA	ETF	178.3	178.3	178.3	178.3	500.0
2015-06-10 08:00:00	DIA	ETF	178.48	178.48	178.24	178.24	700.0

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

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