PREVIEW / etf_1hour / 2019-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-22.parquet
  size:    314 KB
  rows:    10,517

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-05-22 04:00:00	SPY	ETF	285.73	286.06	285.63	286.06	1805.0
2019-05-22 05:00:00	SPY	ETF	285.99	286.44	285.99	286.31	13501.0
2019-05-22 06:00:00	SPY	ETF	286.4	286.53	286.07	286.07	30304.0
2019-05-22 07:00:00	SPY	ETF	286.13	286.13	285.2	285.22	429984.0
2019-05-22 08:00:00	SPY	ETF	285.9899	286.68	284.75	285.42	1388748.0
2019-05-22 09:00:00	SPY	ETF	285.4	286.02	285.26	285.99	5919529.0
2019-05-22 10:00:00	SPY	ETF	286.0	286.69	285.38	285.64	9305591.0
2019-05-22 11:00:00	SPY	ETF	285.63	286.29	285.26	285.8933	7743265.0
2019-05-22 12:00:00	SPY	ETF	285.88	286.04	285.325	285.46	3891871.0
2019-05-22 13:00:00	SPY	ETF	285.45	285.99	285.1	285.88	4823976.0
2019-05-22 14:00:00	SPY	ETF	285.88	286.35	285.54	286.17	4364128.0
2019-05-22 15:00:00	SPY	ETF	286.1751	286.29	285.62	285.62	7836550.0
2019-05-22 16:00:00	SPY	ETF	285.65	285.8344	285.45	285.6	2950398.0
2019-05-22 17:00:00	SPY	ETF	285.56	285.71	285.55	285.67	129852.0
2019-05-22 18:00:00	SPY	ETF	285.67	285.73	285.6	285.6	33712.0
2019-05-22 19:00:00	SPY	ETF	285.6	285.6	285.24	285.37	56687.0
2019-05-22 04:00:00	QQQ	ETF	181.06	181.35	181.06	181.25	9065.0
2019-05-22 05:00:00	QQQ	ETF	181.33	181.81	181.33	181.55	42660.0
2019-05-22 06:00:00	QQQ	ETF	181.58	181.71	181.29	181.31	31166.0
2019-05-22 07:00:00	QQQ	ETF	181.33	181.33	180.46	180.6	524066.0
2019-05-22 08:00:00	QQQ	ETF	181.18	181.83	180.09	180.68	748846.0
2019-05-22 09:00:00	QQQ	ETF	180.63	181.57	180.58	181.5	2955228.0
2019-05-22 10:00:00	QQQ	ETF	181.5	182.07	180.96	181.16	4171588.0
2019-05-22 11:00:00	QQQ	ETF	181.15	181.71	180.84	181.37	2355919.0
2019-05-22 12:00:00	QQQ	ETF	181.36	181.46	180.9	181.1089	1413745.0
2019-05-22 13:00:00	QQQ	ETF	181.08	181.52	180.75	181.4	2761085.0
2019-05-22 14:00:00	QQQ	ETF	181.4	181.85	181.13	181.6301	2402384.0
2019-05-22 15:00:00	QQQ	ETF	181.64	181.72	181.03	181.04	3361083.0
2019-05-22 16:00:00	QQQ	ETF	181.04	181.1	180.83	180.91	610528.0
2019-05-22 17:00:00	QQQ	ETF	180.83	180.94	180.83	180.94	9604.0
2019-05-22 18:00:00	QQQ	ETF	180.95	181.09	180.95	180.98	21300.0
2019-05-22 19:00:00	QQQ	ETF	180.9	180.9	180.65	180.72	57285.0
2019-05-22 04:00:00	IWM	ETF	153.39	153.47	153.39	153.44	3200.0
2019-05-22 05:00:00	IWM	ETF	153.63	153.72	153.63	153.72	6500.0
2019-05-22 06:00:00	IWM	ETF	153.76	153.9	153.7	153.7	6470.0
2019-05-22 07:00:00	IWM	ETF	153.54	153.54	153.26	153.26	3500.0
2019-05-22 08:00:00	IWM	ETF	153.5	153.5	152.9	153.25	280992.0
2019-05-22 09:00:00	IWM	ETF	153.26	153.59	153.16	153.55	1556038.0
2019-05-22 10:00:00	IWM	ETF	153.55	153.59	152.65	152.72	3133149.0
2019-05-22 11:00:00	IWM	ETF	152.71	153.015	152.375	152.725	1718521.0
2019-05-22 12:00:00	IWM	ETF	152.72	152.78	152.22	152.22	1080777.0
2019-05-22 13:00:00	IWM	ETF	152.21	152.75	152.0	152.62	1230719.0
2019-05-22 14:00:00	IWM	ETF	152.61	152.86	152.48	152.72	738249.0
2019-05-22 15:00:00	IWM	ETF	152.72	152.8	152.46	152.48	2459566.0
2019-05-22 16:00:00	IWM	ETF	152.53	152.63	152.41	152.49	451879.0
2019-05-22 17:00:00	IWM	ETF	152.5	152.53	152.42	152.53	5723.0
2019-05-22 18:00:00	IWM	ETF	152.57	152.57	152.53	152.53	6281.0
2019-05-22 19:00:00	IWM	ETF	152.37	152.37	152.37	152.37	300.0
2019-05-22 04:00:00	DIA	ETF	258.14	258.34	258.14	258.34	998.0
2019-05-22 05:00:00	DIA	ETF	258.5	258.5	258.5	258.5	665.0

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

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