PREVIEW / etf_1hour / 2017-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-24.parquet
  size:    177 KB
  rows:    5,528

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-11-24 04:00:00	SPY	ETF	259.8	259.97	259.8	259.9	3800.0
2017-11-24 05:00:00	SPY	ETF	259.9	260.1	259.9	260.1	9188.0
2017-11-24 06:00:00	SPY	ETF	260.06	260.4	260.06	260.33	50069.0
2017-11-24 07:00:00	SPY	ETF	260.29	260.4	260.25	260.35	154074.0
2017-11-24 08:00:00	SPY	ETF	260.27	260.42	260.25	260.3	714044.0
2017-11-24 09:00:00	SPY	ETF	260.31	260.33	260.17	260.273	4499794.0
2017-11-24 10:00:00	SPY	ETF	260.28	260.36	260.16	260.3289	5260067.0
2017-11-24 11:00:00	SPY	ETF	260.32	260.48	260.32	260.38	3151661.0
2017-11-24 12:00:00	SPY	ETF	260.38	260.48	260.26	260.34	7311710.0
2017-11-24 13:00:00	SPY	ETF	260.35	260.45	260.01	260.01	2514867.0
2017-11-24 14:00:00	SPY	ETF	260.01	260.14	259.8	260.14	406906.0
2017-11-24 15:00:00	SPY	ETF	260.15	260.16	260.09	260.12	10747.0
2017-11-24 16:00:00	SPY	ETF	260.15	260.2	259.83	259.85	112690.0
2017-11-24 04:00:00	QQQ	ETF	155.74	155.8	155.74	155.8	21936.0
2017-11-24 05:00:00	QQQ	ETF	155.8	155.8	155.8	155.8	500.0
2017-11-24 06:00:00	QQQ	ETF	155.86	155.92	155.86	155.88	17355.0
2017-11-24 07:00:00	QQQ	ETF	155.87	155.91	155.84	155.91	35668.0
2017-11-24 08:00:00	QQQ	ETF	155.86	156.0	155.86	155.91	119244.0
2017-11-24 09:00:00	QQQ	ETF	155.69	156.0	155.69	155.96	1344669.0
2017-11-24 10:00:00	QQQ	ETF	155.96	156.135	155.83	156.1	1023496.0
2017-11-24 11:00:00	QQQ	ETF	156.0985	156.31	156.0985	156.2	1339887.0
2017-11-24 12:00:00	QQQ	ETF	156.2	156.2993	156.19	156.25	2257215.0
2017-11-24 13:00:00	QQQ	ETF	156.25	156.33	156.09	156.1	444110.0
2017-11-24 14:00:00	QQQ	ETF	156.11	156.19	156.01	156.1437	19699.0
2017-11-24 15:00:00	QQQ	ETF	156.15	156.16	156.1	156.14	7123.0
2017-11-24 16:00:00	QQQ	ETF	156.11	156.11	155.99	156.05	20235.0
2017-11-24 04:00:00	IWM	ETF	150.89	151.35	150.89	151.22	39091.0
2017-11-24 05:00:00	IWM	ETF	151.28	151.28	151.28	151.28	100.0
2017-11-24 06:00:00	IWM	ETF	151.35	151.53	151.35	151.47	6506.0
2017-11-24 07:00:00	IWM	ETF	151.48	151.59	151.3	151.35	66937.0
2017-11-24 08:00:00	IWM	ETF	151.4	151.4	151.25	151.26	44177.0
2017-11-24 09:00:00	IWM	ETF	151.28	151.3	150.89	151.17	948413.0
2017-11-24 10:00:00	IWM	ETF	151.17	151.37	150.83	151.0	1052216.0
2017-11-24 11:00:00	IWM	ETF	151.0	151.15	150.84	150.92	684370.0
2017-11-24 12:00:00	IWM	ETF	150.92	151.1363	150.77	150.97	1215326.0
2017-11-24 13:00:00	IWM	ETF	150.94	151.26	150.87	150.95	548677.0
2017-11-24 14:00:00	IWM	ETF	150.95	151.0	150.9	150.9	1600.0
2017-11-24 15:00:00	IWM	ETF	150.9136	151.15	150.9136	151.08	651.0
2017-11-24 16:00:00	IWM	ETF	150.88	150.88	150.81	150.81	1900.0
2017-11-24 05:00:00	DIA	ETF	235.25	235.25	235.25	235.25	1103.0
2017-11-24 07:00:00	DIA	ETF	235.65	235.75	235.65	235.73	707.0
2017-11-24 08:00:00	DIA	ETF	235.48	235.65	235.48	235.6	3200.0
2017-11-24 09:00:00	DIA	ETF	235.44	235.615	235.42	235.55	263547.0
2017-11-24 10:00:00	DIA	ETF	235.54	235.69	235.47	235.6756	354432.0
2017-11-24 11:00:00	DIA	ETF	235.67	235.87	235.63	235.67	313413.0
2017-11-24 12:00:00	DIA	ETF	235.67	235.7438	235.41	235.49	357238.0
2017-11-24 13:00:00	DIA	ETF	235.48	235.48	235.25	235.34	44554.0
2017-11-24 14:00:00	DIA	ETF	235.34	235.34	235.22	235.3	13660.0
2017-11-24 15:00:00	DIA	ETF	235.3	235.47	235.24	235.27	1743.0
2017-11-24 16:00:00	DIA	ETF	235.18	235.28	235.06	235.06	6327.0

> showing 50 of 5,528 rows — these rows as CSV

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