PREVIEW / etf_1hour / 2021-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-10.parquet
  size:    422 KB
  rows:    14,674

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
2021-02-10 04:00:00	SPY	ETF	391.5	391.7	391.45	391.45	12702.0
2021-02-10 05:00:00	SPY	ETF	391.56	391.6	391.35	391.58	12340.0
2021-02-10 06:00:00	SPY	ETF	391.62	391.9	391.45	391.45	50231.0
2021-02-10 07:00:00	SPY	ETF	391.45	391.58	391.29	391.53	141962.0
2021-02-10 08:00:00	SPY	ETF	391.49	392.46	391.36	392.12	372276.0
2021-02-10 09:00:00	SPY	ETF	392.12	392.28	391.37	391.54	3661432.0
2021-02-10 10:00:00	SPY	ETF	391.55	391.93	387.5	389.699	14412449.0
2021-02-10 11:00:00	SPY	ETF	389.69	390.12	388.85	389.5081	4962883.0
2021-02-10 12:00:00	SPY	ETF	389.49	389.81	388.66	389.55	3806562.0
2021-02-10 13:00:00	SPY	ETF	389.55	390.1	389.39	389.645	2347916.0
2021-02-10 14:00:00	SPY	ETF	389.65	390.85	389.45	390.79	4786168.0
2021-02-10 15:00:00	SPY	ETF	390.7911	391.07	389.37	390.1	8522921.0
2021-02-10 16:00:00	SPY	ETF	390.09	390.6	390.07	390.42	2391889.0
2021-02-10 17:00:00	SPY	ETF	390.43	390.57	390.3	390.36	60002.0
2021-02-10 18:00:00	SPY	ETF	390.43	390.45	390.08	390.21	347763.0
2021-02-10 19:00:00	SPY	ETF	390.21	390.21	389.15	389.23	108714.0
2021-02-10 04:00:00	QQQ	ETF	335.27	335.28	334.9	335.05	32417.0
2021-02-10 05:00:00	QQQ	ETF	335.0	335.06	334.82	334.98	14692.0
2021-02-10 06:00:00	QQQ	ETF	334.98	335.05	334.52	334.58	17732.0
2021-02-10 07:00:00	QQQ	ETF	334.51	334.67	334.41	334.57	107277.0
2021-02-10 08:00:00	QQQ	ETF	334.49	335.43	333.51	335.05	169987.0
2021-02-10 09:00:00	QQQ	ETF	335.01	335.46	334.33	334.845	1913659.0
2021-02-10 10:00:00	QQQ	ETF	334.865	335.24	329.5	331.7099	8024645.0
2021-02-10 11:00:00	QQQ	ETF	331.675	332.54	330.7	331.885	3086874.0
2021-02-10 12:00:00	QQQ	ETF	331.89	332.4	331.115	332.19	1700940.0
2021-02-10 13:00:00	QQQ	ETF	332.14	332.58	331.76	332.09	838209.0
2021-02-10 14:00:00	QQQ	ETF	332.06	333.67	331.97	333.4907	2452130.0
2021-02-10 15:00:00	QQQ	ETF	333.538	333.82	331.94	332.73	3307113.0
2021-02-10 16:00:00	QQQ	ETF	332.72	333.22	332.6666	333.06	827616.0
2021-02-10 17:00:00	QQQ	ETF	332.9	333.01	332.75	332.94	67089.0
2021-02-10 18:00:00	QQQ	ETF	332.99	333.09	332.68	332.8	60514.0
2021-02-10 19:00:00	QQQ	ETF	332.77	332.79	331.85	331.92	96335.0
2021-02-10 04:00:00	IWM	ETF	228.91	228.96	228.81	228.9	4100.0
2021-02-10 05:00:00	IWM	ETF	228.74	229.09	228.74	229.09	5299.0
2021-02-10 06:00:00	IWM	ETF	229.13	229.62	229.12	229.33	35960.0
2021-02-10 07:00:00	IWM	ETF	229.31	229.38	229.19	229.27	18754.0
2021-02-10 08:00:00	IWM	ETF	229.19	230.29	228.96	229.85	212044.0
2021-02-10 09:00:00	IWM	ETF	229.85	230.315	229.26	229.97	2422265.0
2021-02-10 10:00:00	IWM	ETF	229.98	230.2	224.945	227.23	6750985.0
2021-02-10 11:00:00	IWM	ETF	227.24	228.41	226.69	227.65	3899122.0
2021-02-10 12:00:00	IWM	ETF	227.65	227.99	225.96	227.74	2462062.0
2021-02-10 13:00:00	IWM	ETF	227.73	228.49	227.48	227.83	1419498.0
2021-02-10 14:00:00	IWM	ETF	227.83	228.71	227.38	228.51	1719181.0
2021-02-10 15:00:00	IWM	ETF	228.51	228.64	226.2112	226.88	2920662.0
2021-02-10 16:00:00	IWM	ETF	226.88	227.1	226.51	226.91	1005995.0
2021-02-10 17:00:00	IWM	ETF	226.91	227.02	226.89	226.99	1500.0
2021-02-10 18:00:00	IWM	ETF	226.99	226.99	226.64	226.84	39672.0
2021-02-10 19:00:00	IWM	ETF	226.76	226.77	225.57	225.74	44446.0
2021-02-10 04:00:00	DIA	ETF	314.7	314.7	314.69	314.69	1000.0
2021-02-10 05:00:00	DIA	ETF	314.72	314.72	314.68	314.68	400.0

> showing 50 of 14,674 rows — these rows as CSV

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