PREVIEW / etf_1hour / 2020-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-08.parquet
  size:    391 KB
  rows:    13,546

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
2020-09-08 04:00:00	SPY	ETF	343.44	343.58	340.27	340.44	70568.0
2020-09-08 05:00:00	SPY	ETF	340.33	341.14	339.58	339.78	110965.0
2020-09-08 06:00:00	SPY	ETF	339.68	340.16	338.72	339.47	351220.0
2020-09-08 07:00:00	SPY	ETF	339.55	340.2	337.42	338.34	459822.0
2020-09-08 08:00:00	SPY	ETF	339.7101	344.49	336.42	337.36	853594.0
2020-09-08 09:00:00	SPY	ETF	337.33	337.54	333.86	336.7	14409905.0
2020-09-08 10:00:00	SPY	ETF	336.72	338.06	334.8	335.85	14797308.0
2020-09-08 11:00:00	SPY	ETF	335.9	337.3599	334.43	335.49	9860420.0
2020-09-08 12:00:00	SPY	ETF	335.475	336.99	335.29	336.77	8340782.0
2020-09-08 13:00:00	SPY	ETF	336.75	337.74	336.02	337.1701	7283643.0
2020-09-08 14:00:00	SPY	ETF	337.2	342.64	333.03	334.5	12840572.0
2020-09-08 15:00:00	SPY	ETF	334.49	335.51	332.88	333.26	31213772.0
2020-09-08 16:00:00	SPY	ETF	333.26	342.64	333.14	333.69	8472957.0
2020-09-08 17:00:00	SPY	ETF	333.58	333.7	329.65	330.89	1198248.0
2020-09-08 18:00:00	SPY	ETF	330.89	332.19	329.75	331.7	1103236.0
2020-09-08 19:00:00	SPY	ETF	331.82	332.57	331.21	332.3	186390.0
2020-09-08 04:00:00	QQQ	ETF	281.06	281.17	276.69	277.23	153687.0
2020-09-08 05:00:00	QQQ	ETF	277.13	277.92	274.9	275.29	204122.0
2020-09-08 06:00:00	QQQ	ETF	275.13	276.2	274.35	276.2	594867.0
2020-09-08 07:00:00	QQQ	ETF	276.35	276.87	273.4	273.78	1000730.0
2020-09-08 08:00:00	QQQ	ETF	273.79	282.05	272.06	273.76	1812842.0
2020-09-08 09:00:00	QQQ	ETF	273.61	275.71	271.25	275.55	12019931.0
2020-09-08 10:00:00	QQQ	ETF	275.55	278.22	274.21	275.57	12394514.0
2020-09-08 11:00:00	QQQ	ETF	275.61	276.684	272.88	274.26	7220289.0
2020-09-08 12:00:00	QQQ	ETF	274.25	275.34	273.5701	275.13	4744093.0
2020-09-08 13:00:00	QQQ	ETF	275.115	275.54	273.56	274.84	4686923.0
2020-09-08 14:00:00	QQQ	ETF	274.84	275.28	270.36	271.9305	10972503.0
2020-09-08 15:00:00	QQQ	ETF	271.95	272.63	269.66	270.01	18484922.0
2020-09-08 16:00:00	QQQ	ETF	270.02	270.49	269.4	269.44	2068097.0
2020-09-08 17:00:00	QQQ	ETF	269.52	269.95	266.35	267.46	573290.0
2020-09-08 18:00:00	QQQ	ETF	267.46	269.87	266.82	268.82	1135535.0
2020-09-08 19:00:00	QQQ	ETF	268.86	269.64	268.38	269.32	308600.0
2020-09-08 04:00:00	IWM	ETF	154.37	154.37	153.38	153.44	19376.0
2020-09-08 05:00:00	IWM	ETF	153.81	153.97	153.59	153.59	11020.0
2020-09-08 06:00:00	IWM	ETF	153.58	153.72	152.74	153.09	123615.0
2020-09-08 07:00:00	IWM	ETF	153.1	153.24	151.72	152.23	262266.0
2020-09-08 08:00:00	IWM	ETF	152.0501	154.1	151.29	151.87	132623.0
2020-09-08 09:00:00	IWM	ETF	151.87	151.95	149.0	150.75	3768634.0
2020-09-08 10:00:00	IWM	ETF	150.8	151.27	149.72	150.19	3831144.0
2020-09-08 11:00:00	IWM	ETF	150.19	151.28	149.9	150.45	2190133.0
2020-09-08 12:00:00	IWM	ETF	150.45	151.5	150.39	151.375	1601032.0
2020-09-08 13:00:00	IWM	ETF	151.37	152.48	151.22	152.29	2491197.0
2020-09-08 14:00:00	IWM	ETF	152.3	152.47	150.28	151.03	2820135.0
2020-09-08 15:00:00	IWM	ETF	151.02	151.28	149.745	149.88	4119785.0
2020-09-08 16:00:00	IWM	ETF	149.86	150.45	149.84	150.26	930039.0
2020-09-08 17:00:00	IWM	ETF	150.09	150.2	148.01	148.46	99463.0
2020-09-08 18:00:00	IWM	ETF	149.0	149.86	147.5	148.42	251451.0
2020-09-08 19:00:00	IWM	ETF	148.37	149.03	148.21	148.98	20892.0
2020-09-08 04:00:00	DIA	ETF	283.0	283.23	281.37	281.41	3459.0
2020-09-08 05:00:00	DIA	ETF	281.86	281.86	281.24	281.35	7500.0

> showing 50 of 13,546 rows — these rows as CSV

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