PREVIEW / etf_1hour / 2017-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-11-21.parquet
  size:    291 KB
  rows:    9,571

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-21 04:00:00	SPY	ETF	258.27	258.4	258.2	258.4	2100.0
2017-11-21 05:00:00	SPY	ETF	258.5	258.88	258.5	258.87	6715.0
2017-11-21 06:00:00	SPY	ETF	258.9	259.05	258.85	259.04	75659.0
2017-11-21 07:00:00	SPY	ETF	259.05	259.18	258.97	259.1	388292.0
2017-11-21 08:00:00	SPY	ETF	259.1	259.37	259.0	259.29	586366.0
2017-11-21 09:00:00	SPY	ETF	259.29	259.76	259.09	259.665	6053082.0
2017-11-21 10:00:00	SPY	ETF	259.665	260.02	259.62	259.99	7969970.0
2017-11-21 11:00:00	SPY	ETF	259.99	260.06	259.86	260.0	6441285.0
2017-11-21 12:00:00	SPY	ETF	260.01	260.04	259.9	259.97	4255318.0
2017-11-21 13:00:00	SPY	ETF	259.97	260.2	259.94	259.98	4641386.0
2017-11-21 14:00:00	SPY	ETF	259.98	260.05	259.9	260.04	7230377.0
2017-11-21 15:00:00	SPY	ETF	260.04	260.06	259.81	259.96	17662047.0
2017-11-21 16:00:00	SPY	ETF	259.96	259.99	259.74	259.77	8720212.0
2017-11-21 17:00:00	SPY	ETF	259.75	259.77	259.68	259.73	175787.0
2017-11-21 18:00:00	SPY	ETF	259.73	259.84	259.7	259.81	97560.0
2017-11-21 19:00:00	SPY	ETF	259.79	259.8	259.64	259.69	92210.0
2017-11-21 05:00:00	QQQ	ETF	154.04	154.35	154.04	154.3	18350.0
2017-11-21 06:00:00	QQQ	ETF	154.36	154.36	154.31	154.32	5682.0
2017-11-21 07:00:00	QQQ	ETF	154.37	154.57	154.35	154.54	51828.0
2017-11-21 08:00:00	QQQ	ETF	154.54	154.66	154.53	154.64	177995.0
2017-11-21 09:00:00	QQQ	ETF	154.63	155.32	154.485	155.275	3156733.0
2017-11-21 10:00:00	QQQ	ETF	155.28	155.47	155.18	155.425	3281606.0
2017-11-21 11:00:00	QQQ	ETF	155.4242	155.555	155.37	155.5	1873474.0
2017-11-21 12:00:00	QQQ	ETF	155.5	155.54	155.36	155.4	1396275.0
2017-11-21 13:00:00	QQQ	ETF	155.41	155.57	155.37	155.45	959812.0
2017-11-21 14:00:00	QQQ	ETF	155.46	155.49	155.37	155.485	1279320.0
2017-11-21 15:00:00	QQQ	ETF	155.4899	155.5	155.33	155.49	3087934.0
2017-11-21 16:00:00	QQQ	ETF	155.48	155.5	155.27	155.41	953496.0
2017-11-21 17:00:00	QQQ	ETF	155.4	155.51	155.4	155.42	8860.0
2017-11-21 18:00:00	QQQ	ETF	155.41	155.52	155.41	155.52	11748.0
2017-11-21 19:00:00	QQQ	ETF	155.48	155.48	155.4	155.47	8607.0
2017-11-21 05:00:00	IWM	ETF	149.65	149.97	149.65	149.97	5700.0
2017-11-21 06:00:00	IWM	ETF	149.97	150.03	149.97	150.03	17684.0
2017-11-21 07:00:00	IWM	ETF	150.03	150.25	150.03	150.25	52543.0
2017-11-21 08:00:00	IWM	ETF	150.26	150.4	150.12	150.34	130286.0
2017-11-21 09:00:00	IWM	ETF	150.32	150.68	150.06	150.635	2903496.0
2017-11-21 10:00:00	IWM	ETF	150.63	151.29	150.55	151.01	4257745.0
2017-11-21 11:00:00	IWM	ETF	151.01	151.03	150.6801	150.83	2768120.0
2017-11-21 12:00:00	IWM	ETF	150.84	150.9	150.51	150.77	1331784.0
2017-11-21 13:00:00	IWM	ETF	150.765	150.92	150.74	150.74	1017401.0
2017-11-21 14:00:00	IWM	ETF	150.74	150.93	150.69	150.93	1212998.0
2017-11-21 15:00:00	IWM	ETF	150.93	151.11	150.72	151.09	3883965.0
2017-11-21 16:00:00	IWM	ETF	151.1	151.14	150.8278	150.99	4309418.0
2017-11-21 17:00:00	IWM	ETF	151.03	151.03	151.02	151.02	1274.0
2017-11-21 18:00:00	IWM	ETF	150.93	151.09	150.93	150.98	402771.0
2017-11-21 19:00:00	IWM	ETF	150.96	151.0531	150.83	150.83	459507.0
2017-11-21 07:00:00	DIA	ETF	234.8	235.0	234.8	235.0	669.0
2017-11-21 08:00:00	DIA	ETF	235.01	235.26	235.01	235.26	4666.0
2017-11-21 09:00:00	DIA	ETF	235.07	235.61	235.07	235.49	359411.0
2017-11-21 10:00:00	DIA	ETF	235.5	235.78	235.4252	235.7635	458622.0

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

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