PREVIEW / etf_1hour / 2018-08-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-07.parquet
  size:    300 KB
  rows:    9,865

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
2018-08-07 04:00:00	SPY	ETF	285.2	285.5	285.17	285.38	34950.0
2018-08-07 05:00:00	SPY	ETF	285.38	285.45	285.25	285.28	22702.0
2018-08-07 06:00:00	SPY	ETF	285.28	285.36	285.18	285.35	70596.0
2018-08-07 07:00:00	SPY	ETF	285.31	285.35	285.17	285.17	73199.0
2018-08-07 08:00:00	SPY	ETF	285.31	285.32	284.99	285.27	176003.0
2018-08-07 09:00:00	SPY	ETF	285.28	285.69	285.24	285.62	5762316.0
2018-08-07 10:00:00	SPY	ETF	285.63	286.01	285.51	285.7	8087769.0
2018-08-07 11:00:00	SPY	ETF	285.7	285.894	285.46	285.716	3901266.0
2018-08-07 12:00:00	SPY	ETF	285.72	285.9642	285.685	285.87	3634150.0
2018-08-07 13:00:00	SPY	ETF	285.87	285.96	285.57	285.845	5493387.0
2018-08-07 14:00:00	SPY	ETF	285.84	285.94	285.69	285.84	3121374.0
2018-08-07 15:00:00	SPY	ETF	285.84	285.88	285.41	285.54	8071759.0
2018-08-07 16:00:00	SPY	ETF	285.54	285.83	285.4418	285.72	2945618.0
2018-08-07 17:00:00	SPY	ETF	285.75	285.75	285.36	285.6	214233.0
2018-08-07 18:00:00	SPY	ETF	285.62	285.68	285.49	285.54	90701.0
2018-08-07 19:00:00	SPY	ETF	285.52	285.6	285.5	285.56	24666.0
2018-08-07 04:00:00	QQQ	ETF	181.55	181.78	181.55	181.73	5790.0
2018-08-07 05:00:00	QQQ	ETF	181.7	181.73	181.64	181.66	11137.0
2018-08-07 06:00:00	QQQ	ETF	181.66	181.71	181.56	181.64	22457.0
2018-08-07 07:00:00	QQQ	ETF	181.62	181.69	181.54	181.54	68366.0
2018-08-07 08:00:00	QQQ	ETF	181.5799	181.63	181.39	181.61	219617.0
2018-08-07 09:00:00	QQQ	ETF	181.61	182.14	181.33	181.78	5528890.0
2018-08-07 10:00:00	QQQ	ETF	181.77	182.1	181.35	181.45	5367885.0
2018-08-07 11:00:00	QQQ	ETF	181.45	181.7199	181.26	181.61	3026136.0
2018-08-07 12:00:00	QQQ	ETF	181.62	182.04	181.57	181.95	1668672.0
2018-08-07 13:00:00	QQQ	ETF	181.96	181.98	181.63	181.96	2115912.0
2018-08-07 14:00:00	QQQ	ETF	181.96	182.06	181.74	181.87	1803154.0
2018-08-07 15:00:00	QQQ	ETF	181.88	181.95	181.65	181.76	3476290.0
2018-08-07 16:00:00	QQQ	ETF	181.74	181.96	181.1645	181.95	2870282.0
2018-08-07 17:00:00	QQQ	ETF	181.8	181.95	181.75	181.8	140772.0
2018-08-07 18:00:00	QQQ	ETF	181.86	181.91	181.76	181.76	101991.0
2018-08-07 19:00:00	QQQ	ETF	181.8	181.87	181.75	181.82	20230.0
2018-08-07 04:00:00	IWM	ETF	167.66	167.8	167.66	167.79	2405.0
2018-08-07 05:00:00	IWM	ETF	167.85	167.85	167.85	167.85	300.0
2018-08-07 06:00:00	IWM	ETF	167.68	167.75	167.65	167.75	2800.0
2018-08-07 07:00:00	IWM	ETF	167.72	167.8	167.7	167.74	20800.0
2018-08-07 08:00:00	IWM	ETF	167.83	167.83	167.73	167.73	41456.0
2018-08-07 09:00:00	IWM	ETF	167.78	168.333	167.78	168.09	1813261.0
2018-08-07 10:00:00	IWM	ETF	168.1	168.35	167.93	168.14	1795430.0
2018-08-07 11:00:00	IWM	ETF	168.15	168.4933	167.955	168.07	1442375.0
2018-08-07 12:00:00	IWM	ETF	168.055	168.17	167.72	168.02	1565585.0
2018-08-07 13:00:00	IWM	ETF	168.02	168.03	167.6	167.8	1417838.0
2018-08-07 14:00:00	IWM	ETF	167.79	167.99	167.66	167.92	976036.0
2018-08-07 15:00:00	IWM	ETF	167.92	168.02	167.62	167.71	2518317.0
2018-08-07 16:00:00	IWM	ETF	167.7	168.05	167.3471	168.01	655520.0
2018-08-07 17:00:00	IWM	ETF	167.95	167.95	167.8	167.85	31325.0
2018-08-07 18:00:00	IWM	ETF	167.9	167.9	167.72	167.85	8184.0
2018-08-07 19:00:00	IWM	ETF	167.86	167.88	167.81	167.87	9172.0
2018-08-07 04:00:00	DIA	ETF	255.01	255.01	255.01	255.01	100.0
2018-08-07 06:00:00	DIA	ETF	255.69	255.69	255.69	255.69	120.0

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

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