PREVIEW / etf_1hour / 2017-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-10-30.parquet
  size:    285 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-10-30 04:00:00	SPY	ETF	257.25	257.3	257.16	257.21	13233.0
2017-10-30 05:00:00	SPY	ETF	257.27	257.34	257.2	257.24	17077.0
2017-10-30 06:00:00	SPY	ETF	257.21	257.24	257.05	257.05	40647.0
2017-10-30 07:00:00	SPY	ETF	257.03	257.19	257.02	257.19	163815.0
2017-10-30 08:00:00	SPY	ETF	257.09	257.21	257.06	257.11	179349.0
2017-10-30 09:00:00	SPY	ETF	257.11	257.4	256.99	257.27	4858995.0
2017-10-30 10:00:00	SPY	ETF	257.2799	257.6	257.21	257.47	4334181.0
2017-10-30 11:00:00	SPY	ETF	257.47	257.505	256.64	256.89	7337183.0
2017-10-30 12:00:00	SPY	ETF	256.88	256.9	256.41	256.81	7615142.0
2017-10-30 13:00:00	SPY	ETF	256.8	257.01	256.65	256.7	4602014.0
2017-10-30 14:00:00	SPY	ETF	256.71	256.98	256.65	256.87	3949749.0
2017-10-30 15:00:00	SPY	ETF	256.87	257.06	256.555	256.8	10611970.0
2017-10-30 16:00:00	SPY	ETF	256.81	256.9	256.63	256.68	8683498.0
2017-10-30 17:00:00	SPY	ETF	256.66	256.69	256.65	256.68	16600.0
2017-10-30 18:00:00	SPY	ETF	256.65	256.72	256.6	256.64	46628.0
2017-10-30 19:00:00	SPY	ETF	256.63	256.71	256.56	256.58	12999.0
2017-10-30 04:00:00	QQQ	ETF	151.33	151.33	151.21	151.22	14400.0
2017-10-30 05:00:00	QQQ	ETF	151.27	151.32	151.26	151.32	2300.0
2017-10-30 06:00:00	QQQ	ETF	151.33	151.35	151.2	151.2	6100.0
2017-10-30 07:00:00	QQQ	ETF	151.18	151.27	151.16	151.24	54797.0
2017-10-30 08:00:00	QQQ	ETF	151.18	151.34	151.17	151.26	80934.0
2017-10-30 09:00:00	QQQ	ETF	151.24	151.78	151.07	151.74	3286843.0
2017-10-30 10:00:00	QQQ	ETF	151.73	152.19	151.67	151.955	4197987.0
2017-10-30 11:00:00	QQQ	ETF	151.95	151.975	151.29	151.56	4332203.0
2017-10-30 12:00:00	QQQ	ETF	151.54	151.559	150.9899	151.449	4381206.0
2017-10-30 13:00:00	QQQ	ETF	151.44	151.5758	151.22	151.27	2000852.0
2017-10-30 14:00:00	QQQ	ETF	151.265	151.56	151.26	151.49	1595651.0
2017-10-30 15:00:00	QQQ	ETF	151.5	151.73	151.21	151.58	3702006.0
2017-10-30 16:00:00	QQQ	ETF	151.58	151.66	151.45	151.48	838225.0
2017-10-30 17:00:00	QQQ	ETF	151.47	151.54	151.47	151.5	36212.0
2017-10-30 18:00:00	QQQ	ETF	151.49	151.51	151.42	151.44	10840.0
2017-10-30 19:00:00	QQQ	ETF	151.5	151.52	151.45	151.45	12200.0
2017-10-30 04:00:00	IWM	ETF	149.49	149.49	149.43	149.43	2100.0
2017-10-30 05:00:00	IWM	ETF	149.33	149.33	149.33	149.33	235.0
2017-10-30 06:00:00	IWM	ETF	149.4	149.42	149.24	149.24	6515.0
2017-10-30 07:00:00	IWM	ETF	149.24	149.34	149.23	149.33	21488.0
2017-10-30 08:00:00	IWM	ETF	149.34	149.36	149.22	149.3	105748.0
2017-10-30 09:00:00	IWM	ETF	149.3	149.43	148.88	148.94	2654371.0
2017-10-30 10:00:00	IWM	ETF	148.93	149.45	148.85	148.98	2655632.0
2017-10-30 11:00:00	IWM	ETF	148.98	149.23	148.23	148.47	4526593.0
2017-10-30 12:00:00	IWM	ETF	148.47	148.51	148.03	148.13	2617577.0
2017-10-30 13:00:00	IWM	ETF	148.13	148.3	147.46	147.5	3877931.0
2017-10-30 14:00:00	IWM	ETF	147.5	148.195	147.385	148.0068	3211678.0
2017-10-30 15:00:00	IWM	ETF	148.0	148.26	147.6775	148.19	5270961.0
2017-10-30 16:00:00	IWM	ETF	148.21	148.39	148.1521	148.18	3044825.0
2017-10-30 17:00:00	IWM	ETF	148.15	148.18	147.978	147.978	690300.0
2017-10-30 18:00:00	IWM	ETF	148.15	148.19	148.15	148.17	1395.0
2017-10-30 19:00:00	IWM	ETF	148.11	148.19	148.11	148.15	35769.0
2017-10-30 06:00:00	DIA	ETF	233.8	233.8	233.76	233.76	700.0
2017-10-30 07:00:00	DIA	ETF	233.76	233.76	233.57	233.69	4850.0

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

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