PREVIEW / etf_1hour / 2019-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-03.parquet
  size:    327 KB
  rows:    10,943

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-03 04:00:00	SPY	ETF	246.82	247.12	246.25	246.32	62301.0
2019-01-03 05:00:00	SPY	ETF	246.27	246.55	245.97	246.09	54670.0
2019-01-03 06:00:00	SPY	ETF	246.11	246.99	245.89	246.47	159794.0
2019-01-03 07:00:00	SPY	ETF	246.39	247.3	246.39	247.25	464546.0
2019-01-03 08:00:00	SPY	ETF	246.7301	248.26	245.7	248.1	1275842.0
2019-01-03 09:00:00	SPY	ETF	248.12	248.57	246.78	247.25	11777539.0
2019-01-03 10:00:00	SPY	ETF	247.18	247.235	244.03	245.35	25128131.0
2019-01-03 11:00:00	SPY	ETF	245.36	248.18	245.04	247.12	20278164.0
2019-01-03 12:00:00	SPY	ETF	247.1115	247.34	246.03	247.04	10534619.0
2019-01-03 13:00:00	SPY	ETF	247.03	247.05	244.79	245.21	12005884.0
2019-01-03 14:00:00	SPY	ETF	245.2	246.65	244.54	244.9	10671962.0
2019-01-03 15:00:00	SPY	ETF	244.9	245.43	243.67	244.13	28867863.0
2019-01-03 16:00:00	SPY	ETF	244.11	244.79	243.96	244.46	17916560.0
2019-01-03 17:00:00	SPY	ETF	244.39	244.43	244.19	244.33	2933181.0
2019-01-03 18:00:00	SPY	ETF	244.33	244.84	244.1	244.21	148377.0
2019-01-03 19:00:00	SPY	ETF	244.21	244.39	243.19	243.54	218955.0
2019-01-03 04:00:00	QQQ	ETF	150.88	151.1	150.68	150.73	49659.0
2019-01-03 05:00:00	QQQ	ETF	150.67	151.01	150.44	150.63	90515.0
2019-01-03 06:00:00	QQQ	ETF	150.68	150.93	150.57	150.92	83323.0
2019-01-03 07:00:00	QQQ	ETF	150.92	151.84	150.89	151.81	360117.0
2019-01-03 08:00:00	QQQ	ETF	151.2	152.49	150.51	152.39	734179.0
2019-01-03 09:00:00	QQQ	ETF	152.4	153.26	151.65	152.01	8214952.0
2019-01-03 10:00:00	QQQ	ETF	151.99	152.01	150.0	151.0015	13050482.0
2019-01-03 11:00:00	QQQ	ETF	151.02	152.75	150.9	152.03	10211630.0
2019-01-03 12:00:00	QQQ	ETF	152.04	152.28	151.17	151.86	5248786.0
2019-01-03 13:00:00	QQQ	ETF	151.84	151.86	150.24	150.405	5732140.0
2019-01-03 14:00:00	QQQ	ETF	150.39	151.51	150.05	150.22	5826032.0
2019-01-03 15:00:00	QQQ	ETF	150.23	150.76	149.49	149.7	13487122.0
2019-01-03 16:00:00	QQQ	ETF	149.71	150.5833	149.26	150.02	2687711.0
2019-01-03 17:00:00	QQQ	ETF	150.1	150.1	149.72	149.89	380338.0
2019-01-03 18:00:00	QQQ	ETF	149.9	150.27	149.85	149.95	84810.0
2019-01-03 19:00:00	QQQ	ETF	149.9	149.9	149.21	149.45	129761.0
2019-01-03 05:00:00	IWM	ETF	132.83	132.91	132.83	132.91	300.0
2019-01-03 06:00:00	IWM	ETF	132.67	132.99	132.67	132.67	1350.0
2019-01-03 07:00:00	IWM	ETF	132.99	133.32	132.99	133.31	41800.0
2019-01-03 08:00:00	IWM	ETF	133.09	133.72	133.09	133.72	86785.0
2019-01-03 09:00:00	IWM	ETF	133.77	134.15	132.59	133.12	3061070.0
2019-01-03 10:00:00	IWM	ETF	133.09	133.115	131.65	132.8178	5392928.0
2019-01-03 11:00:00	IWM	ETF	132.82	134.64	132.705	134.29	4199862.0
2019-01-03 12:00:00	IWM	ETF	134.29	134.39	133.54	134.02	2718457.0
2019-01-03 13:00:00	IWM	ETF	134.01	134.03	132.8	133.08	1978019.0
2019-01-03 14:00:00	IWM	ETF	133.065	133.58	132.5	132.84	2123887.0
2019-01-03 15:00:00	IWM	ETF	132.84	133.03	132.16	132.22	5040755.0
2019-01-03 16:00:00	IWM	ETF	132.22	132.46	131.97	132.25	1087735.0
2019-01-03 17:00:00	IWM	ETF	132.29	132.29	132.1	132.22	33168.0
2019-01-03 18:00:00	IWM	ETF	132.22	132.47	132.09	132.2	64788.0
2019-01-03 19:00:00	IWM	ETF	132.2	132.2	131.6	131.69	11520.0
2019-01-03 04:00:00	DIA	ETF	230.0	230.0	230.0	230.0	100.0
2019-01-03 05:00:00	DIA	ETF	229.85	229.85	229.85	229.85	200.0
2019-01-03 06:00:00	DIA	ETF	230.0	230.36	230.0	230.36	600.0

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

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