PREVIEW / etf_1hour / 2019-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-01.parquet
  size:    344 KB
  rows:    11,257

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-10-01 04:00:00	SPY	ETF	297.78	298.2	297.58	297.78	18724.0
2019-10-01 05:00:00	SPY	ETF	297.68	297.8	297.43	297.7	16686.0
2019-10-01 06:00:00	SPY	ETF	297.6	297.82	297.42	297.5	27217.0
2019-10-01 07:00:00	SPY	ETF	297.5	297.64	297.4	297.53	49603.0
2019-10-01 08:00:00	SPY	ETF	297.55	298.43	296.77	297.75	330608.0
2019-10-01 09:00:00	SPY	ETF	297.75	298.455	297.58	298.19	7603783.0
2019-10-01 10:00:00	SPY	ETF	298.14	298.19	295.34	295.41	14312674.0
2019-10-01 11:00:00	SPY	ETF	295.39	295.63	294.56	294.73	8225502.0
2019-10-01 12:00:00	SPY	ETF	294.73	294.75	293.84	294.05	7513903.0
2019-10-01 13:00:00	SPY	ETF	294.055	296.8354	293.06	293.24	9165490.0
2019-10-01 14:00:00	SPY	ETF	293.24	296.8354	293.0	293.8499	11892021.0
2019-10-01 15:00:00	SPY	ETF	293.84	294.18	293.09	293.21	23312184.0
2019-10-01 16:00:00	SPY	ETF	293.22	296.8354	292.84	293.36	5332789.0
2019-10-01 17:00:00	SPY	ETF	293.31	293.44	293.24	293.35	1006094.0
2019-10-01 18:00:00	SPY	ETF	293.34	293.65	292.93	293.56	428295.0
2019-10-01 19:00:00	SPY	ETF	293.6	293.73	293.43	293.73	38685.0
2019-10-01 04:00:00	QQQ	ETF	189.64	189.92	189.43	189.92	17734.0
2019-10-01 05:00:00	QQQ	ETF	189.54	189.6	189.29	189.5	15198.0
2019-10-01 06:00:00	QQQ	ETF	189.41	189.62	189.36	189.44	20055.0
2019-10-01 07:00:00	QQQ	ETF	189.38	189.49	189.24	189.39	44101.0
2019-10-01 08:00:00	QQQ	ETF	189.2902	189.88	189.27	189.51	155704.0
2019-10-01 09:00:00	QQQ	ETF	189.47	190.5898	189.44	190.41	3452528.0
2019-10-01 10:00:00	QQQ	ETF	190.4	190.4	188.23	188.3	7496021.0
2019-10-01 11:00:00	QQQ	ETF	188.3	188.6368	187.8	187.99	3359747.0
2019-10-01 12:00:00	QQQ	ETF	187.98	188.01	187.41	187.6882	2917181.0
2019-10-01 13:00:00	QQQ	ETF	187.67	187.73	186.955	187.13	2600194.0
2019-10-01 14:00:00	QQQ	ETF	187.115	187.95	187.03	187.74	2446591.0
2019-10-01 15:00:00	QQQ	ETF	187.73	187.99	187.11	187.21	6110230.0
2019-10-01 16:00:00	QQQ	ETF	187.21	187.41	187.02	187.41	893273.0
2019-10-01 17:00:00	QQQ	ETF	187.45	187.45	187.27	187.39	99146.0
2019-10-01 18:00:00	QQQ	ETF	187.42	187.67	187.24	187.59	45654.0
2019-10-01 19:00:00	QQQ	ETF	187.67	187.7	187.48	187.69	58922.0
2019-10-01 04:00:00	IWM	ETF	151.85	151.96	151.85	151.96	9000.0
2019-10-01 05:00:00	IWM	ETF	151.85	151.85	151.78	151.82	15122.0
2019-10-01 06:00:00	IWM	ETF	151.85	151.85	151.85	151.85	3000.0
2019-10-01 07:00:00	IWM	ETF	151.74	151.75	151.7	151.7	19000.0
2019-10-01 08:00:00	IWM	ETF	151.74	152.17	151.7	152.06	48286.0
2019-10-01 09:00:00	IWM	ETF	152.02	153.35	151.96	153.04	2474489.0
2019-10-01 10:00:00	IWM	ETF	153.0	153.02	151.06	151.16	6209213.0
2019-10-01 11:00:00	IWM	ETF	151.14	151.485	150.51	150.73	3668094.0
2019-10-01 12:00:00	IWM	ETF	150.715	150.715	149.73	149.74	3273597.0
2019-10-01 13:00:00	IWM	ETF	149.72	149.75	148.35	148.35	5137603.0
2019-10-01 14:00:00	IWM	ETF	148.34	148.87	148.05	148.69	2945465.0
2019-10-01 15:00:00	IWM	ETF	148.685	148.83	148.25	148.41	5689366.0
2019-10-01 16:00:00	IWM	ETF	148.42	148.5	148.2	148.43	1052597.0
2019-10-01 17:00:00	IWM	ETF	148.38	148.45	148.37	148.45	27525.0
2019-10-01 18:00:00	IWM	ETF	148.46	148.53	148.29	148.53	350111.0
2019-10-01 19:00:00	IWM	ETF	148.7	148.73	148.55	148.68	7130.0
2019-10-01 07:00:00	DIA	ETF	269.7	269.7	269.68	269.68	1200.0
2019-10-01 08:00:00	DIA	ETF	269.78	270.08	269.6	270.0	14535.0

> showing 50 of 11,257 rows — these rows as CSV

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