PREVIEW / etf_1hour / 2019-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-02.parquet
  size:    333 KB
  rows:    11,259

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
2019-01-02 04:00:00	SPY	ETF	248.0	248.0	244.96	246.13	121694.0
2019-01-02 05:00:00	SPY	ETF	246.06	246.41	245.67	245.87	48739.0
2019-01-02 06:00:00	SPY	ETF	245.71	246.44	245.66	246.2	91938.0
2019-01-02 07:00:00	SPY	ETF	246.23	247.06	246.09	246.09	467969.0
2019-01-02 08:00:00	SPY	ETF	246.05	249.92	244.7	245.73	904141.0
2019-01-02 09:00:00	SPY	ETF	245.73	247.4	245.73	247.18	11941732.0
2019-01-02 10:00:00	SPY	ETF	247.18	249.17	246.615	248.86	15886086.0
2019-01-02 11:00:00	SPY	ETF	248.87	250.46	248.59	248.89	16141767.0
2019-01-02 12:00:00	SPY	ETF	248.9	250.33	248.68	250.16	12904796.0
2019-01-02 13:00:00	SPY	ETF	250.15	251.21	250.15	251.16	8908266.0
2019-01-02 14:00:00	SPY	ETF	251.16	251.17	249.71	249.84	10873764.0
2019-01-02 15:00:00	SPY	ETF	249.84	250.48	248.72	250.26	27115853.0
2019-01-02 16:00:00	SPY	ETF	250.25	250.4	248.0	248.1	16406518.0
2019-01-02 17:00:00	SPY	ETF	248.11	250.18	247.35	247.36	625394.0
2019-01-02 18:00:00	SPY	ETF	247.37	250.18	246.3	246.65	548565.0
2019-01-02 19:00:00	SPY	ETF	246.65	247.19	246.65	246.7	106062.0
2019-01-02 04:00:00	QQQ	ETF	150.24	150.72	150.0	150.57	89650.0
2019-01-02 05:00:00	QQQ	ETF	150.57	151.02	150.26	150.37	44341.0
2019-01-02 06:00:00	QQQ	ETF	150.35	150.78	150.29	150.53	71896.0
2019-01-02 07:00:00	QQQ	ETF	150.66	151.35	150.61	150.69	546854.0
2019-01-02 08:00:00	QQQ	ETF	150.65	154.26	149.95	150.55	392618.0
2019-01-02 09:00:00	QQQ	ETF	150.56	152.43	150.55	152.2599	6157439.0
2019-01-02 10:00:00	QQQ	ETF	152.24	154.02	151.76	153.77	8524090.0
2019-01-02 11:00:00	QQQ	ETF	153.77	154.8	153.57	153.695	7518033.0
2019-01-02 12:00:00	QQQ	ETF	153.7	155.02	153.57	154.89	5343082.0
2019-01-02 13:00:00	QQQ	ETF	154.88	155.75	154.88	155.71	4846877.0
2019-01-02 14:00:00	QQQ	ETF	155.7199	155.725	154.77	154.8647	4059950.0
2019-01-02 15:00:00	QQQ	ETF	154.86	155.1	153.86	154.89	9044457.0
2019-01-02 16:00:00	QQQ	ETF	154.88	155.01	151.95	152.17	4775753.0
2019-01-02 17:00:00	QQQ	ETF	152.22	154.88	151.51	151.61	549022.0
2019-01-02 18:00:00	QQQ	ETF	151.55	151.66	150.88	151.08	350038.0
2019-01-02 19:00:00	QQQ	ETF	151.08	151.5	151.08	151.27	209806.0
2019-01-02 04:00:00	IWM	ETF	131.68	132.16	131.68	132.15	8500.0
2019-01-02 05:00:00	IWM	ETF	132.18	132.28	132.0	132.28	2107.0
2019-01-02 06:00:00	IWM	ETF	132.27	132.41	132.08	132.13	9700.0
2019-01-02 07:00:00	IWM	ETF	132.2	132.57	132.2	132.25	55633.0
2019-01-02 08:00:00	IWM	ETF	132.2	133.9	131.51	132.0	98383.0
2019-01-02 09:00:00	IWM	ETF	132.14	132.59	131.54	132.54	3261258.0
2019-01-02 10:00:00	IWM	ETF	132.53	134.36	132.22	134.14	4308392.0
2019-01-02 11:00:00	IWM	ETF	134.14	135.17	133.93	133.99	3923592.0
2019-01-02 12:00:00	IWM	ETF	134.0	134.38	133.2449	134.2667	2728407.0
2019-01-02 13:00:00	IWM	ETF	134.26	134.93	134.26	134.91	2105275.0
2019-01-02 14:00:00	IWM	ETF	134.92	134.92	134.19	134.34	1891598.0
2019-01-02 15:00:00	IWM	ETF	134.34	134.71	133.62	134.7	4447392.0
2019-01-02 16:00:00	IWM	ETF	134.7	134.81	133.51	133.76	1876158.0
2019-01-02 17:00:00	IWM	ETF	133.73	133.73	133.05	133.05	39033.0
2019-01-02 18:00:00	IWM	ETF	133.18	134.66	132.87	132.89	309635.0
2019-01-02 19:00:00	IWM	ETF	132.84	133.04	132.84	132.95	6308.0
2019-01-02 04:00:00	DIA	ETF	228.62	229.4	228.6	229.4	9265.0
2019-01-02 05:00:00	DIA	ETF	229.56	229.56	229.1	229.1	3300.0

> showing 50 of 11,259 rows — these rows as CSV

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