PREVIEW / etf_1hour / 2019-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-04.parquet
  size:    331 KB
  rows:    10,968

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-04 04:00:00	SPY	ETF	246.5	247.59	246.28	247.1	76410.0
2019-01-04 05:00:00	SPY	ETF	247.12	247.69	246.95	247.62	39218.0
2019-01-04 06:00:00	SPY	ETF	247.59	247.93	247.24	247.55	285410.0
2019-01-04 07:00:00	SPY	ETF	247.52	247.68	247.0	247.14	433026.0
2019-01-04 08:00:00	SPY	ETF	247.15	247.66	245.3	247.15	2072812.0
2019-01-04 09:00:00	SPY	ETF	247.14	249.16	246.82	249.115	14015553.0
2019-01-04 10:00:00	SPY	ETF	249.125	251.35	248.02	251.03	26934025.0
2019-01-04 11:00:00	SPY	ETF	251.03	251.86	250.25	251.2	13788463.0
2019-01-04 12:00:00	SPY	ETF	251.18	252.72	250.61	252.42	12234520.0
2019-01-04 13:00:00	SPY	ETF	252.43	253.11	251.75	252.16	17100307.0
2019-01-04 14:00:00	SPY	ETF	252.16	252.79	251.5	251.65	12849300.0
2019-01-04 15:00:00	SPY	ETF	251.655	252.65	251.47	252.47	28616423.0
2019-01-04 16:00:00	SPY	ETF	252.46	253.05	252.0	252.2	9349721.0
2019-01-04 17:00:00	SPY	ETF	252.2	252.39	252.2	252.39	2214093.0
2019-01-04 18:00:00	SPY	ETF	252.33	253.04	252.33	252.56	124807.0
2019-01-04 19:00:00	SPY	ETF	252.56	252.82	252.54	252.64	47770.0
2019-01-04 04:00:00	QQQ	ETF	151.68	152.57	151.6	152.14	258966.0
2019-01-04 05:00:00	QQQ	ETF	152.14	152.6	152.06	152.55	49284.0
2019-01-04 06:00:00	QQQ	ETF	152.55	152.81	152.26	152.55	89898.0
2019-01-04 07:00:00	QQQ	ETF	152.53	152.57	151.89	151.99	238770.0
2019-01-04 08:00:00	QQQ	ETF	152.5199	152.52	150.79	151.92	934590.0
2019-01-04 09:00:00	QQQ	ETF	151.9	153.41	151.74	153.33	7303475.0
2019-01-04 10:00:00	QQQ	ETF	153.33	155.21	152.67	155.2	12191893.0
2019-01-04 11:00:00	QQQ	ETF	155.19	155.9085	154.99	155.62	8302592.0
2019-01-04 12:00:00	QQQ	ETF	155.61	156.49	155.35	156.285	5449209.0
2019-01-04 13:00:00	QQQ	ETF	156.29	157.0	156.19	156.44	7719986.0
2019-01-04 14:00:00	QQQ	ETF	156.44	156.8099	155.87	155.89	5710858.0
2019-01-04 15:00:00	QQQ	ETF	155.89	156.46	155.695	156.39	11611268.0
2019-01-04 16:00:00	QQQ	ETF	156.39	156.53	156.11	156.36	3694682.0
2019-01-04 17:00:00	QQQ	ETF	156.36	156.36	156.1	156.24	151209.0
2019-01-04 18:00:00	QQQ	ETF	156.25	156.4	156.24	156.4	10207.0
2019-01-04 19:00:00	QQQ	ETF	156.36	156.55	156.35	156.53	21971.0
2019-01-04 04:00:00	IWM	ETF	132.79	134.01	132.79	134.01	885.0
2019-01-04 05:00:00	IWM	ETF	133.85	133.9	133.85	133.88	4170.0
2019-01-04 06:00:00	IWM	ETF	133.95	134.15	133.85	134.15	11900.0
2019-01-04 07:00:00	IWM	ETF	134.14	134.15	133.78	133.79	64758.0
2019-01-04 08:00:00	IWM	ETF	133.86	134.1	132.83	133.92	63824.0
2019-01-04 09:00:00	IWM	ETF	133.81	135.45	133.71	135.19	4435441.0
2019-01-04 10:00:00	IWM	ETF	135.19	137.01	135.19	136.7199	9003098.0
2019-01-04 11:00:00	IWM	ETF	136.71	137.265	135.86	136.635	3651629.0
2019-01-04 12:00:00	IWM	ETF	136.63	137.19	136.22	137.04	2065425.0
2019-01-04 13:00:00	IWM	ETF	137.05	137.57	136.82	137.18	3029001.0
2019-01-04 14:00:00	IWM	ETF	137.18	137.6	136.85	136.92	2457086.0
2019-01-04 15:00:00	IWM	ETF	136.91	137.38	136.87	137.22	4856124.0
2019-01-04 16:00:00	IWM	ETF	137.22	137.22	136.9	137.09	1728045.0
2019-01-04 17:00:00	IWM	ETF	137.19	137.23	137.03	137.06	102394.0
2019-01-04 18:00:00	IWM	ETF	137.14	137.29	137.14	137.29	1575.0
2019-01-04 19:00:00	IWM	ETF	137.3	137.32	137.3	137.3	3495.0
2019-01-04 04:00:00	DIA	ETF	229.46	229.76	229.46	229.76	300.0
2019-01-04 05:00:00	DIA	ETF	229.4	229.84	229.4	229.84	600.0

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

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