PREVIEW / etf_1hour / 2019-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-04.parquet
  size:    314 KB
  rows:    10,533

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-04-04 04:00:00	SPY	ETF	286.58	286.58	286.35	286.35	2871.0
2019-04-04 05:00:00	SPY	ETF	286.46	286.59	286.46	286.59	6605.0
2019-04-04 06:00:00	SPY	ETF	286.79	286.92	286.6	286.87	8994.0
2019-04-04 07:00:00	SPY	ETF	286.85	286.86	286.58	286.58	91463.0
2019-04-04 08:00:00	SPY	ETF	286.7	286.91	286.58	286.78	160557.0
2019-04-04 09:00:00	SPY	ETF	286.81	287.459	286.72	287.32	5898489.0
2019-04-04 10:00:00	SPY	ETF	287.325	287.44	286.39	287.01	7863119.0
2019-04-04 11:00:00	SPY	ETF	287.02	287.1709	286.29	286.54	5537173.0
2019-04-04 12:00:00	SPY	ETF	286.53	286.78	286.01	286.44	5531554.0
2019-04-04 13:00:00	SPY	ETF	286.44	286.79	286.315	286.65	3813729.0
2019-04-04 14:00:00	SPY	ETF	286.66	287.18	286.55	287.11	5059869.0
2019-04-04 15:00:00	SPY	ETF	287.1	287.35	286.82	287.22	10618856.0
2019-04-04 16:00:00	SPY	ETF	287.21	287.34	287.13	287.22	3274514.0
2019-04-04 17:00:00	SPY	ETF	287.25	287.25	287.17	287.17	79751.0
2019-04-04 18:00:00	SPY	ETF	287.18	287.18	287.04	287.04	69054.0
2019-04-04 19:00:00	SPY	ETF	287.05	287.2	287.01	287.07	33898.0
2019-04-04 04:00:00	QQQ	ETF	183.8	183.89	183.59	183.72	17312.0
2019-04-04 05:00:00	QQQ	ETF	183.71	183.92	183.71	183.92	23883.0
2019-04-04 06:00:00	QQQ	ETF	183.93	184.12	183.91	184.06	25108.0
2019-04-04 07:00:00	QQQ	ETF	184.04	184.04	183.7	183.73	71165.0
2019-04-04 08:00:00	QQQ	ETF	184.05	184.05	183.65	183.83	97486.0
2019-04-04 09:00:00	QQQ	ETF	183.83	184.5	183.75	184.33	2682955.0
2019-04-04 10:00:00	QQQ	ETF	184.35	184.41	183.05	183.69	4340250.0
2019-04-04 11:00:00	QQQ	ETF	183.7	183.755	183.07	183.281	3648023.0
2019-04-04 12:00:00	QQQ	ETF	183.29	183.49	182.65	183.11	4514392.0
2019-04-04 13:00:00	QQQ	ETF	183.105	183.38	183.04	183.29	2741399.0
2019-04-04 14:00:00	QQQ	ETF	183.29	183.86	183.21	183.86	2713882.0
2019-04-04 15:00:00	QQQ	ETF	183.86	183.89	183.47	183.725	3954089.0
2019-04-04 16:00:00	QQQ	ETF	183.72	183.79	183.59	183.67	954495.0
2019-04-04 17:00:00	QQQ	ETF	183.71	183.71	183.62	183.69	12802.0
2019-04-04 18:00:00	QQQ	ETF	183.63	183.65	183.55	183.56	17436.0
2019-04-04 19:00:00	QQQ	ETF	183.56	183.63	183.51	183.53	27367.0
2019-04-04 05:00:00	IWM	ETF	155.15	155.15	155.15	155.15	1500.0
2019-04-04 06:00:00	IWM	ETF	155.26	155.34	155.2	155.34	1800.0
2019-04-04 07:00:00	IWM	ETF	155.2	155.31	155.11	155.11	11100.0
2019-04-04 08:00:00	IWM	ETF	155.16	155.34	155.16	155.25	5247.0
2019-04-04 09:00:00	IWM	ETF	155.3	155.85	155.24	155.84	1478894.0
2019-04-04 10:00:00	IWM	ETF	155.85	155.97	155.05	155.81	2463641.0
2019-04-04 11:00:00	IWM	ETF	155.81	156.01	155.115	155.34	1698804.0
2019-04-04 12:00:00	IWM	ETF	155.33	155.48	154.84	155.25	1579334.0
2019-04-04 13:00:00	IWM	ETF	155.26	155.55	155.22	155.3	1389713.0
2019-04-04 14:00:00	IWM	ETF	155.3	155.71	155.25	155.65	1179079.0
2019-04-04 15:00:00	IWM	ETF	155.65	155.95	155.5	155.91	3289754.0
2019-04-04 16:00:00	IWM	ETF	155.92	156.04	155.8	155.84	1035148.0
2019-04-04 17:00:00	IWM	ETF	155.94	155.94	155.85	155.9	3623.0
2019-04-04 18:00:00	IWM	ETF	155.83	155.83	155.79	155.79	16841.0
2019-04-04 19:00:00	IWM	ETF	155.79	155.84	155.73	155.73	6400.0
2019-04-04 06:00:00	DIA	ETF	262.25	262.25	262.25	262.25	100.0
2019-04-04 07:00:00	DIA	ETF	262.25	262.25	262.18	262.18	3100.0
2019-04-04 08:00:00	DIA	ETF	262.25	262.41	262.17	262.31	7050.0

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

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