PREVIEW / etf_1hour / 2017-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-12-12.parquet
  size:    286 KB
  rows:    9,415

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
2017-12-12 04:00:00	SPY	ETF	266.62	266.75	266.49	266.53	29282.0
2017-12-12 05:00:00	SPY	ETF	266.58	266.6	266.44	266.44	3520.0
2017-12-12 06:00:00	SPY	ETF	266.51	266.59	266.51	266.57	15944.0
2017-12-12 07:00:00	SPY	ETF	266.56	266.79	266.56	266.68	111913.0
2017-12-12 08:00:00	SPY	ETF	266.76	266.76	266.31	266.75	422565.0
2017-12-12 09:00:00	SPY	ETF	266.75	266.77	266.345	266.61	5662348.0
2017-12-12 10:00:00	SPY	ETF	266.615	266.9	266.53	266.79	5844018.0
2017-12-12 11:00:00	SPY	ETF	266.8	267.24	266.71	267.145	7407979.0
2017-12-12 12:00:00	SPY	ETF	267.15	267.32	266.88	267.1534	8831802.0
2017-12-12 13:00:00	SPY	ETF	267.16	267.2766	266.93	266.96	14669931.0
2017-12-12 14:00:00	SPY	ETF	266.96	267.28	266.87	267.22	9021762.0
2017-12-12 15:00:00	SPY	ETF	267.22	267.22	266.69	266.79	18360875.0
2017-12-12 16:00:00	SPY	ETF	266.78	266.92	266.7342	266.86	11980249.0
2017-12-12 17:00:00	SPY	ETF	266.82	266.85	266.8	266.8	1218855.0
2017-12-12 18:00:00	SPY	ETF	266.83	266.85	266.51	266.52	664935.0
2017-12-12 19:00:00	SPY	ETF	266.52	266.7441	266.44	266.56	48926.0
2017-12-12 04:00:00	QQQ	ETF	156.05	156.07	156.03	156.03	6900.0
2017-12-12 05:00:00	QQQ	ETF	155.99	155.99	155.9	155.9	2200.0
2017-12-12 06:00:00	QQQ	ETF	156.0	156.0	155.91	155.91	8000.0
2017-12-12 07:00:00	QQQ	ETF	155.95	156.04	155.95	155.97	41600.0
2017-12-12 08:00:00	QQQ	ETF	155.97	156.0	155.81	155.94	274709.0
2017-12-12 09:00:00	QQQ	ETF	155.93	155.95	155.36	155.8399	2767084.0
2017-12-12 10:00:00	QQQ	ETF	155.83	155.93	155.54	155.84	2198070.0
2017-12-12 11:00:00	QQQ	ETF	155.84	156.14	155.81	156.07	1485246.0
2017-12-12 12:00:00	QQQ	ETF	156.06	156.15	155.81	155.86	1568895.0
2017-12-12 13:00:00	QQQ	ETF	155.86	155.91	155.4	155.51	2061866.0
2017-12-12 14:00:00	QQQ	ETF	155.51	155.93	155.41	155.8748	1820243.0
2017-12-12 15:00:00	QQQ	ETF	155.88	155.89	155.56	155.69	3734301.0
2017-12-12 16:00:00	QQQ	ETF	155.69	155.72	155.61	155.67	961922.0
2017-12-12 17:00:00	QQQ	ETF	155.61	155.65	155.61	155.63	5712.0
2017-12-12 18:00:00	QQQ	ETF	155.65	155.7	155.5	155.5	8673.0
2017-12-12 19:00:00	QQQ	ETF	155.53	155.59	155.47	155.55	7794.0
2017-12-12 04:00:00	IWM	ETF	151.65	151.76	151.64	151.76	13906.0
2017-12-12 05:00:00	IWM	ETF	151.55	151.55	151.51	151.51	1742.0
2017-12-12 06:00:00	IWM	ETF	151.59	151.7	151.59	151.7	6103.0
2017-12-12 07:00:00	IWM	ETF	151.71	151.82	151.71	151.78	17007.0
2017-12-12 08:00:00	IWM	ETF	151.78	151.81	151.65	151.77	47687.0
2017-12-12 09:00:00	IWM	ETF	151.78	151.78	151.3775	151.52	1636633.0
2017-12-12 10:00:00	IWM	ETF	151.52	151.86	151.45	151.655	1782522.0
2017-12-12 11:00:00	IWM	ETF	151.67	151.93	151.52	151.6	2126303.0
2017-12-12 12:00:00	IWM	ETF	151.6	151.67	151.23	151.58	1451321.0
2017-12-12 13:00:00	IWM	ETF	151.58	151.61	151.32	151.34	947807.0
2017-12-12 14:00:00	IWM	ETF	151.34	151.64	151.19	151.3123	2625881.0
2017-12-12 15:00:00	IWM	ETF	151.32	151.33	150.82	150.89	4353674.0
2017-12-12 16:00:00	IWM	ETF	150.88	151.57	150.81	151.02	6993048.0
2017-12-12 17:00:00	IWM	ETF	150.9	151.04	150.9	151.03	6274.0
2017-12-12 18:00:00	IWM	ETF	150.93	151.03	150.77	150.77	5645.0
2017-12-12 19:00:00	IWM	ETF	150.77	150.81	150.71	150.73	3148.0
2017-12-12 04:00:00	DIA	ETF	244.53	244.53	244.53	244.53	229.0
2017-12-12 05:00:00	DIA	ETF	244.36	244.36	244.36	244.36	300.0

> showing 50 of 9,415 rows — these rows as CSV

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