PREVIEW / etf_1hour / 2021-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-08.parquet
  size:    434 KB
  rows:    15,172

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-08 04:00:00	SPY	ETF	388.63	388.88	388.31	388.75	53878.0
2021-02-08 05:00:00	SPY	ETF	388.76	388.79	388.48	388.59	25480.0
2021-02-08 06:00:00	SPY	ETF	388.61	389.08	388.5	389.04	57509.0
2021-02-08 07:00:00	SPY	ETF	388.98	389.06	388.73	389.05	66411.0
2021-02-08 08:00:00	SPY	ETF	388.8699	389.5	388.56	389.2	123289.0
2021-02-08 09:00:00	SPY	ETF	389.23	389.82	389.1	389.63	3823354.0
2021-02-08 10:00:00	SPY	ETF	389.6399	389.95	389.24	389.55	3899323.0
2021-02-08 11:00:00	SPY	ETF	389.55	389.6399	388.35	388.891	3935048.0
2021-02-08 12:00:00	SPY	ETF	388.91	389.38	388.91	389.03	2286497.0
2021-02-08 13:00:00	SPY	ETF	389.03	389.31	388.59	388.8	2911447.0
2021-02-08 14:00:00	SPY	ETF	388.805	389.35	388.77	389.33	2185345.0
2021-02-08 15:00:00	SPY	ETF	389.32	390.54	389.24	390.53	6423844.0
2021-02-08 16:00:00	SPY	ETF	390.545	390.75	390.29	390.65	2269542.0
2021-02-08 17:00:00	SPY	ETF	390.65	390.75	390.55	390.66	111862.0
2021-02-08 18:00:00	SPY	ETF	390.69	390.9	390.35	390.59	204324.0
2021-02-08 19:00:00	SPY	ETF	390.51	390.69	390.09	390.5	256198.0
2021-02-08 04:00:00	QQQ	ETF	332.53	332.77	332.22	332.67	33882.0
2021-02-08 05:00:00	QQQ	ETF	332.63	332.78	332.43	332.54	14168.0
2021-02-08 06:00:00	QQQ	ETF	332.51	333.01	332.46	332.8	36844.0
2021-02-08 07:00:00	QQQ	ETF	332.79	332.81	332.21	332.62	97748.0
2021-02-08 08:00:00	QQQ	ETF	332.81	333.4	331.36	332.91	157025.0
2021-02-08 09:00:00	QQQ	ETF	332.9	333.28	332.3	333.05	2742251.0
2021-02-08 10:00:00	QQQ	ETF	333.02	333.74	332.42	333.27	2720170.0
2021-02-08 11:00:00	QQQ	ETF	333.28	333.35	331.41	332.24	2123211.0
2021-02-08 12:00:00	QQQ	ETF	332.28	332.74	332.17	332.361	1344020.0
2021-02-08 13:00:00	QQQ	ETF	332.37	332.739	331.92	332.1	1638304.0
2021-02-08 14:00:00	QQQ	ETF	332.11	332.51	332.01	332.47	1209114.0
2021-02-08 15:00:00	QQQ	ETF	332.471	333.6	332.43	333.59	2467918.0
2021-02-08 16:00:00	QQQ	ETF	333.57	333.75	333.26	333.57	1012725.0
2021-02-08 17:00:00	QQQ	ETF	333.61	333.62	333.24	333.43	141874.0
2021-02-08 18:00:00	QQQ	ETF	333.45	333.83	333.33	333.45	71374.0
2021-02-08 19:00:00	QQQ	ETF	333.42	333.42	332.9099	333.23	59652.0
2021-02-08 04:00:00	IWM	ETF	222.35	222.4	221.86	222.36	26213.0
2021-02-08 05:00:00	IWM	ETF	222.33	222.4	222.08	222.21	21781.0
2021-02-08 06:00:00	IWM	ETF	222.21	222.86	222.17	222.86	34995.0
2021-02-08 07:00:00	IWM	ETF	222.85	223.03	222.78	223.02	31396.0
2021-02-08 08:00:00	IWM	ETF	222.75	223.76	222.2	223.68	95575.0
2021-02-08 09:00:00	IWM	ETF	223.7395	225.44	223.4019	225.3762	2335629.0
2021-02-08 10:00:00	IWM	ETF	225.37	225.9	225.0	225.63	2911893.0
2021-02-08 11:00:00	IWM	ETF	225.64	226.45	225.0607	225.56	1926146.0
2021-02-08 12:00:00	IWM	ETF	225.58	226.17	225.46	225.9238	1431654.0
2021-02-08 13:00:00	IWM	ETF	225.92	226.06	225.51	225.8475	955030.0
2021-02-08 14:00:00	IWM	ETF	225.84	226.41	225.84	226.3	1214493.0
2021-02-08 15:00:00	IWM	ETF	226.3	227.33	226.03	227.27	4352458.0
2021-02-08 16:00:00	IWM	ETF	227.31	227.7	225.8191	227.65	1498783.0
2021-02-08 17:00:00	IWM	ETF	227.84	227.84	227.31	227.78	54309.0
2021-02-08 18:00:00	IWM	ETF	227.79	227.79	227.26	227.53	29240.0
2021-02-08 19:00:00	IWM	ETF	227.56	227.56	227.13	227.37	31999.0
2021-02-08 04:00:00	DIA	ETF	312.25	312.5	312.25	312.33	600.0
2021-02-08 05:00:00	DIA	ETF	312.64	312.64	312.55	312.55	500.0

> showing 50 of 15,172 rows — these rows as CSV

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