PREVIEW / etf_1hour / 2018-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-28.parquet
  size:    305 KB
  rows:    10,011

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-02-28 04:00:00	SPY	ETF	275.32	275.42	275.09	275.3	7697.0
2018-02-28 05:00:00	SPY	ETF	275.44	275.46	274.84	274.94	11428.0
2018-02-28 06:00:00	SPY	ETF	275.05	275.2	274.65	274.75	61062.0
2018-02-28 07:00:00	SPY	ETF	274.72	275.02	274.58	274.99	207238.0
2018-02-28 08:00:00	SPY	ETF	274.98	275.46	274.5	275.19	679981.0
2018-02-28 09:00:00	SPY	ETF	275.27	276.17	274.97	276.17	7429086.0
2018-02-28 10:00:00	SPY	ETF	276.17	276.19	274.4	274.82	9504639.0
2018-02-28 11:00:00	SPY	ETF	274.83	274.96	273.78	274.605	11478288.0
2018-02-28 12:00:00	SPY	ETF	274.58	275.42	274.2	275.16	7763308.0
2018-02-28 13:00:00	SPY	ETF	275.15	275.58	274.74	275.57	6924939.0
2018-02-28 14:00:00	SPY	ETF	275.57	275.85	273.79	273.9	10953600.0
2018-02-28 15:00:00	SPY	ETF	273.92	274.08	271.31	271.33	36949241.0
2018-02-28 16:00:00	SPY	ETF	271.34	274.5281	271.25	271.96	19918885.0
2018-02-28 17:00:00	SPY	ETF	271.95	274.4201	271.65	271.84	851764.0
2018-02-28 18:00:00	SPY	ETF	271.86	272.12	271.48	271.95	309387.0
2018-02-28 19:00:00	SPY	ETF	271.93	272.19	271.74	271.96	71530.0
2018-02-28 04:00:00	QQQ	ETF	168.67	168.82	168.67	168.82	19916.0
2018-02-28 05:00:00	QQQ	ETF	168.79	168.83	168.53	168.57	36700.0
2018-02-28 06:00:00	QQQ	ETF	168.67	168.76	168.46	168.57	68937.0
2018-02-28 07:00:00	QQQ	ETF	168.54	168.79	168.48	168.79	46640.0
2018-02-28 08:00:00	QQQ	ETF	168.79	169.2	168.32	169.05	367688.0
2018-02-28 09:00:00	QQQ	ETF	169.12	169.52	168.74	169.52	2746244.0
2018-02-28 10:00:00	QQQ	ETF	169.52	169.64	168.4	168.69	4060843.0
2018-02-28 11:00:00	QQQ	ETF	168.7	168.88	167.92	168.537	4823179.0
2018-02-28 12:00:00	QQQ	ETF	168.53	169.2293	168.3	169.12	2710283.0
2018-02-28 13:00:00	QQQ	ETF	169.1	169.63	168.94	169.61	3462204.0
2018-02-28 14:00:00	QQQ	ETF	169.6	169.8	168.54	168.63	4443085.0
2018-02-28 15:00:00	QQQ	ETF	168.63	168.74	167.1	167.1	11336426.0
2018-02-28 16:00:00	QQQ	ETF	167.13	167.69	167.08	167.53	3092201.0
2018-02-28 17:00:00	QQQ	ETF	167.64	167.69	167.21	167.64	946387.0
2018-02-28 18:00:00	QQQ	ETF	167.66	167.76	167.38	167.67	31017.0
2018-02-28 19:00:00	QQQ	ETF	167.63	167.63	167.44	167.54	50902.0
2018-02-28 04:00:00	IWM	ETF	153.01	153.17	153.01	153.12	2200.0
2018-02-28 05:00:00	IWM	ETF	153.02	153.06	152.85	152.85	1902.0
2018-02-28 06:00:00	IWM	ETF	153.01	153.02	152.71	152.72	5500.0
2018-02-28 07:00:00	IWM	ETF	152.73	152.92	152.72	152.92	34928.0
2018-02-28 08:00:00	IWM	ETF	152.72	153.05	152.72	152.98	100024.0
2018-02-28 09:00:00	IWM	ETF	153.19	153.6	152.8	153.24	1486198.0
2018-02-28 10:00:00	IWM	ETF	153.24	153.35	152.0	152.3299	2533950.0
2018-02-28 11:00:00	IWM	ETF	152.34	152.56	151.79	152.34	2462886.0
2018-02-28 12:00:00	IWM	ETF	152.34	153.18	152.289	152.95	968809.0
2018-02-28 13:00:00	IWM	ETF	152.92	153.02	152.39	152.75	1531797.0
2018-02-28 14:00:00	IWM	ETF	152.76	153.02	151.54	151.58	3266671.0
2018-02-28 15:00:00	IWM	ETF	151.59	151.68	150.31	150.39	8341723.0
2018-02-28 16:00:00	IWM	ETF	150.36	150.57	150.05	150.5	2289860.0
2018-02-28 17:00:00	IWM	ETF	150.5	150.5	150.35	150.43	162022.0
2018-02-28 18:00:00	IWM	ETF	150.4	150.6	150.26	150.58	38245.0
2018-02-28 19:00:00	IWM	ETF	150.57	150.69	150.48	150.63	12433.0
2018-02-28 04:00:00	DIA	ETF	255.0	255.0	255.0	255.0	100.0
2018-02-28 06:00:00	DIA	ETF	254.52	254.52	254.52	254.52	200.0

> showing 50 of 10,011 rows — these rows as CSV

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