PREVIEW / etf_1hour / 2022-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-10.parquet
  size:    458 KB
  rows:    16,468

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
2022-03-10 04:00:00	SPY	ETF	424.49	426.75	424.2	424.66	147443.0
2022-03-10 05:00:00	SPY	ETF	424.64	425.14	423.82	423.9	76355.0
2022-03-10 06:00:00	SPY	ETF	423.81	424.33	422.8	423.31	194146.0
2022-03-10 07:00:00	SPY	ETF	423.28	424.0	422.35	422.39	437718.0
2022-03-10 08:00:00	SPY	ETF	423.2999	426.87	421.75	422.0	1589399.0
2022-03-10 09:00:00	SPY	ETF	421.99	425.0	421.75	424.535	10219935.0
2022-03-10 10:00:00	SPY	ETF	424.55	425.29	421.52	421.78	11270288.0
2022-03-10 11:00:00	SPY	ETF	421.77	422.02	420.44	421.92	7581730.0
2022-03-10 12:00:00	SPY	ETF	421.91	423.19	421.16	421.49	5027435.0
2022-03-10 13:00:00	SPY	ETF	421.49	423.87	421.1	423.4799	6195336.0
2022-03-10 14:00:00	SPY	ETF	423.48	426.09	423.35	425.64	8526503.0
2022-03-10 15:00:00	SPY	ETF	425.66	426.43	424.08	425.48	16031052.0
2022-03-10 16:00:00	SPY	ETF	425.5	425.96	425.08	425.42	4027361.0
2022-03-10 17:00:00	SPY	ETF	425.4	425.67	425.0	425.18	148804.0
2022-03-10 18:00:00	SPY	ETF	425.34	426.56	425.18	426.14	160936.0
2022-03-10 19:00:00	SPY	ETF	426.239	426.239	424.94	425.05	175779.0
2022-03-10 04:00:00	QQQ	ETF	332.8	334.14	332.0	332.3	126920.0
2022-03-10 05:00:00	QQQ	ETF	332.1	332.65	331.23	331.23	76073.0
2022-03-10 06:00:00	QQQ	ETF	331.23	331.75	329.92	330.42	308484.0
2022-03-10 07:00:00	QQQ	ETF	330.4	331.15	329.56	329.65	640308.0
2022-03-10 08:00:00	QQQ	ETF	330.5499	335.241	329.5	329.75	1845635.0
2022-03-10 09:00:00	QQQ	ETF	329.73	331.51	328.92	331.17	7974109.0
2022-03-10 10:00:00	QQQ	ETF	331.1358	331.98	327.58	327.88	9762292.0
2022-03-10 11:00:00	QQQ	ETF	327.87	328.44	326.71	328.33	5984953.0
2022-03-10 12:00:00	QQQ	ETF	328.32	329.43	327.4	327.57	4974402.0
2022-03-10 13:00:00	QQQ	ETF	327.58	330.26	327.3	329.885	5116363.0
2022-03-10 14:00:00	QQQ	ETF	329.88	332.51	329.6935	332.0919	6303994.0
2022-03-10 15:00:00	QQQ	ETF	332.16	332.4	330.47	331.415	7881975.0
2022-03-10 16:00:00	QQQ	ETF	331.43	331.44	330.67	330.98	2776452.0
2022-03-10 17:00:00	QQQ	ETF	331.01	331.01	330.61	330.9	65956.0
2022-03-10 18:00:00	QQQ	ETF	330.98	332.0	330.73	331.54	192493.0
2022-03-10 19:00:00	QQQ	ETF	331.58	331.65	330.64	330.72	173004.0
2022-03-10 04:00:00	IWM	ETF	198.88	199.33	197.9	198.17	55589.0
2022-03-10 05:00:00	IWM	ETF	198.13	198.52	197.86	198.0	14934.0
2022-03-10 06:00:00	IWM	ETF	197.91	198.09	197.5	197.5	22265.0
2022-03-10 07:00:00	IWM	ETF	197.68	197.94	197.21	197.21	142379.0
2022-03-10 08:00:00	IWM	ETF	197.75	198.5996	196.95	197.57	244778.0
2022-03-10 09:00:00	IWM	ETF	197.44	199.1	196.89	198.91	3192031.0
2022-03-10 10:00:00	IWM	ETF	198.91	199.27	196.92	197.07	2580648.0
2022-03-10 11:00:00	IWM	ETF	197.06	197.54	196.56	197.49	1911964.0
2022-03-10 12:00:00	IWM	ETF	197.48	198.29	197.13	197.36	1037175.0
2022-03-10 13:00:00	IWM	ETF	197.34	198.2	197.01	198.0	751054.0
2022-03-10 14:00:00	IWM	ETF	198.01	199.6	197.9701	199.38	1786469.0
2022-03-10 15:00:00	IWM	ETF	199.39	200.04	198.54	199.9	3178305.0
2022-03-10 16:00:00	IWM	ETF	199.9	200.01	199.2	199.76	4719367.0
2022-03-10 17:00:00	IWM	ETF	199.87	199.89	199.1	199.63	36438.0
2022-03-10 18:00:00	IWM	ETF	199.63	200.51	199.5	200.05	69876.0
2022-03-10 19:00:00	IWM	ETF	200.18	200.18	199.35	199.57	54398.0
2022-03-10 04:00:00	DIA	ETF	331.9	332.0	330.85	331.72	3725.0
2022-03-10 05:00:00	DIA	ETF	331.2	331.2	330.69	330.69	1700.0

> showing 50 of 16,468 rows — these rows as CSV

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