PREVIEW / etf_1hour / 2021-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-30.parquet
  size:    457 KB
  rows:    16,647

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-11-30 04:00:00	SPY	ETF	460.2	460.2	458.56	460.0	123707.0
2021-11-30 05:00:00	SPY	ETF	460.0	460.3	459.17	460.22	64023.0
2021-11-30 06:00:00	SPY	ETF	460.19	460.58	459.36	460.1	147938.0
2021-11-30 07:00:00	SPY	ETF	460.0	461.6	459.99	460.71	882681.0
2021-11-30 08:00:00	SPY	ETF	460.74	465.03	458.33	462.15	1240997.0
2021-11-30 09:00:00	SPY	ETF	462.15	463.0	461.11	462.44	9290291.0
2021-11-30 10:00:00	SPY	ETF	462.44	464.03	457.98	458.035	15844262.0
2021-11-30 11:00:00	SPY	ETF	458.03	459.89	456.21	457.29	16335687.0
2021-11-30 12:00:00	SPY	ETF	457.28	458.05	455.8237	457.12	9673079.0
2021-11-30 13:00:00	SPY	ETF	457.13	458.96	456.4	458.91	8398837.0
2021-11-30 14:00:00	SPY	ETF	458.9	459.32	456.9	457.35	8937789.0
2021-11-30 15:00:00	SPY	ETF	457.34	457.6699	455.3	455.84	30327373.0
2021-11-30 16:00:00	SPY	ETF	455.87	458.15	455.56	458.13	8659735.0
2021-11-30 17:00:00	SPY	ETF	458.13	458.14	457.95	458.14	75096.0
2021-11-30 18:00:00	SPY	ETF	458.2	459.1	455.56	457.96	276767.0
2021-11-30 19:00:00	SPY	ETF	458.06	458.72	456.77	457.4	180044.0
2021-11-30 04:00:00	QQQ	ETF	398.05	398.05	396.57	397.87	89111.0
2021-11-30 05:00:00	QQQ	ETF	397.88	397.95	397.15	397.72	38099.0
2021-11-30 06:00:00	QQQ	ETF	397.72	397.92	396.93	397.19	107010.0
2021-11-30 07:00:00	QQQ	ETF	397.15	398.21	397.11	397.76	400998.0
2021-11-30 08:00:00	QQQ	ETF	397.8	399.989	396.0	398.81	504358.0
2021-11-30 09:00:00	QQQ	ETF	398.7	400.25	397.85	399.98	6301857.0
2021-11-30 10:00:00	QQQ	ETF	399.99	401.19	393.52	393.5801	13092544.0
2021-11-30 11:00:00	QQQ	ETF	393.59	395.42	392.01	393.09	13673908.0
2021-11-30 12:00:00	QQQ	ETF	393.08	393.95	391.75	393.06	7981708.0
2021-11-30 13:00:00	QQQ	ETF	393.07	395.21	392.565	395.1984	4592069.0
2021-11-30 14:00:00	QQQ	ETF	395.18	395.55	393.2	393.77	5919636.0
2021-11-30 15:00:00	QQQ	ETF	393.74	394.22	392.73	393.66	10588517.0
2021-11-30 16:00:00	QQQ	ETF	393.7	395.83	393.4668	395.82	2251529.0
2021-11-30 17:00:00	QQQ	ETF	395.8	395.8896	395.61	395.77	34391.0
2021-11-30 18:00:00	QQQ	ETF	395.86	396.45	393.82	395.48	196229.0
2021-11-30 19:00:00	QQQ	ETF	395.49	396.17	394.53	394.85	176101.0
2021-11-30 04:00:00	IWM	ETF	221.0	221.0	217.75	218.77	97009.0
2021-11-30 05:00:00	IWM	ETF	218.7	219.0	218.11	218.9	68561.0
2021-11-30 06:00:00	IWM	ETF	219.0	219.35	218.42	218.97	76447.0
2021-11-30 07:00:00	IWM	ETF	219.04	220.49	218.94	219.57	279601.0
2021-11-30 08:00:00	IWM	ETF	219.57	223.95	218.41	220.48	485135.0
2021-11-30 09:00:00	IWM	ETF	220.52	221.86	219.9	220.62	4898552.0
2021-11-30 10:00:00	IWM	ETF	220.61	221.81	218.07	218.12	7194778.0
2021-11-30 11:00:00	IWM	ETF	218.11	219.67	216.7	217.79	7789842.0
2021-11-30 12:00:00	IWM	ETF	217.78	217.78	215.88	216.95	5950203.0
2021-11-30 13:00:00	IWM	ETF	216.97	218.485	216.26	218.43	4535436.0
2021-11-30 14:00:00	IWM	ETF	218.41	218.89	217.66	218.14	5711885.0
2021-11-30 15:00:00	IWM	ETF	218.155	219.97	217.97	218.22	9491885.0
2021-11-30 16:00:00	IWM	ETF	218.17	220.04	218.17	219.96	2672017.0
2021-11-30 17:00:00	IWM	ETF	219.9	219.9	219.7	219.9	16682.0
2021-11-30 18:00:00	IWM	ETF	219.97	220.76	218.17	220.16	220253.0
2021-11-30 19:00:00	IWM	ETF	220.3	220.68	219.05	219.62	118753.0
2021-11-30 04:00:00	DIA	ETF	346.67	346.72	345.82	346.72	6573.0
2021-11-30 05:00:00	DIA	ETF	346.8	346.94	346.23	346.93	9266.0

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

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