PREVIEW / etf_1hour / 2019-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-24.parquet
  size:    329 KB
  rows:    10,919

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-24 04:00:00	SPY	ETF	292.71	292.73	292.43	292.72	10310.0
2019-04-24 05:00:00	SPY	ETF	292.7	293.02	292.7	292.95	5641.0
2019-04-24 06:00:00	SPY	ETF	293.01	293.1	292.94	292.98	8165.0
2019-04-24 07:00:00	SPY	ETF	292.97	293.03	292.84	292.95	110816.0
2019-04-24 08:00:00	SPY	ETF	293.0	293.11	292.56	292.95	369705.0
2019-04-24 09:00:00	SPY	ETF	292.92	292.92	292.31	292.675	5313696.0
2019-04-24 10:00:00	SPY	ETF	292.67	293.08	292.53	293.07	5977249.0
2019-04-24 11:00:00	SPY	ETF	293.07	293.16	292.6	292.68	4547705.0
2019-04-24 12:00:00	SPY	ETF	292.67	292.78	292.36	292.41	3877541.0
2019-04-24 13:00:00	SPY	ETF	292.4	292.58	292.07	292.425	3696883.0
2019-04-24 14:00:00	SPY	ETF	292.425	292.81	292.35	292.745	3454892.0
2019-04-24 15:00:00	SPY	ETF	292.75	292.89	292.17	292.23	11921103.0
2019-04-24 16:00:00	SPY	ETF	292.22	292.57	292.0	292.05	8167365.0
2019-04-24 17:00:00	SPY	ETF	292.06	292.38	292.05	292.28	1484196.0
2019-04-24 18:00:00	SPY	ETF	292.27	292.48	292.18	292.39	142490.0
2019-04-24 19:00:00	SPY	ETF	292.39	292.47	292.39	292.46	28330.0
2019-04-24 04:00:00	QQQ	ETF	190.08	190.22	190.07	190.22	10510.0
2019-04-24 05:00:00	QQQ	ETF	190.26	190.48	190.26	190.48	9609.0
2019-04-24 06:00:00	QQQ	ETF	190.54	190.6	190.47	190.54	22067.0
2019-04-24 07:00:00	QQQ	ETF	190.55	190.57	190.42	190.54	73997.0
2019-04-24 08:00:00	QQQ	ETF	190.5299	190.72	190.4599	190.57	85014.0
2019-04-24 09:00:00	QQQ	ETF	190.48	190.64	189.89	190.19	3070529.0
2019-04-24 10:00:00	QQQ	ETF	190.19	190.63	190.025	190.62	3155724.0
2019-04-24 11:00:00	QQQ	ETF	190.62	190.71	190.1899	190.2	1395362.0
2019-04-24 12:00:00	QQQ	ETF	190.21	190.26	189.795	189.84	1277201.0
2019-04-24 13:00:00	QQQ	ETF	189.84	190.17	189.76	190.02	1543567.0
2019-04-24 14:00:00	QQQ	ETF	190.01	190.255	189.95	190.2	1092700.0
2019-04-24 15:00:00	QQQ	ETF	190.21	190.2675	189.65	189.69	3505596.0
2019-04-24 16:00:00	QQQ	ETF	189.69	190.95	189.66	190.56	1763027.0
2019-04-24 17:00:00	QQQ	ETF	190.5	191.1	190.5	191.04	308990.0
2019-04-24 18:00:00	QQQ	ETF	191.04	191.11	190.88	191.01	184403.0
2019-04-24 19:00:00	QQQ	ETF	191.0	191.1	190.94	191.09	28132.0
2019-04-24 04:00:00	IWM	ETF	157.41	157.42	157.41	157.42	500.0
2019-04-24 06:00:00	IWM	ETF	157.75	157.75	157.72	157.72	1500.0
2019-04-24 07:00:00	IWM	ETF	157.72	157.76	157.59	157.62	25104.0
2019-04-24 08:00:00	IWM	ETF	157.62	157.9401	157.58	157.64	29597.0
2019-04-24 09:00:00	IWM	ETF	157.66	157.95	157.37	157.84	1763876.0
2019-04-24 10:00:00	IWM	ETF	157.84	158.6	157.68	158.595	2543428.0
2019-04-24 11:00:00	IWM	ETF	158.6	158.69	158.09	158.155	2130370.0
2019-04-24 12:00:00	IWM	ETF	158.15	158.48	157.79	157.82	1974901.0
2019-04-24 13:00:00	IWM	ETF	157.82	158.19	157.57	158.07	1740964.0
2019-04-24 14:00:00	IWM	ETF	158.06	158.36	158.01	158.3543	799104.0
2019-04-24 15:00:00	IWM	ETF	158.36	158.58	157.97	158.06	2730564.0
2019-04-24 16:00:00	IWM	ETF	158.05	158.12	157.59	157.59	1421243.0
2019-04-24 17:00:00	IWM	ETF	157.6	157.99	157.6	157.76	21980.0
2019-04-24 18:00:00	IWM	ETF	157.71	157.81	157.64	157.78	20321.0
2019-04-24 19:00:00	IWM	ETF	157.85	157.85	157.79	157.79	6975.0
2019-04-24 07:00:00	DIA	ETF	266.69	266.69	266.31	266.68	1448.0
2019-04-24 08:00:00	DIA	ETF	266.28	266.86	266.28	266.4501	22372.0
2019-04-24 09:00:00	DIA	ETF	266.5	266.6	265.91	266.27	322436.0

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

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