PREVIEW / etf_1hour / 2021-11-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-26.parquet
  size:    312 KB
  rows:    11,007

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-26 04:00:00	SPY	ETF	465.0	465.0	459.75	460.63	270865.0
2021-11-26 05:00:00	SPY	ETF	460.95	461.8	460.12	461.16	156678.0
2021-11-26 06:00:00	SPY	ETF	460.94	461.98	460.74	461.16	234354.0
2021-11-26 07:00:00	SPY	ETF	461.07	462.41	461.02	461.59	1063624.0
2021-11-26 08:00:00	SPY	ETF	461.6199	465.39	459.6	461.58	1288518.0
2021-11-26 09:00:00	SPY	ETF	461.6	463.9	460.62	461.49	13709448.0
2021-11-26 10:00:00	SPY	ETF	461.48	461.51	459.0416	460.23	17880603.0
2021-11-26 11:00:00	SPY	ETF	460.22	460.22	458.135	458.93	14182991.0
2021-11-26 12:00:00	SPY	ETF	458.94	461.5	457.77	459.03	26001594.0
2021-11-26 13:00:00	SPY	ETF	459.04	459.68	457.0	457.55	5589419.0
2021-11-26 14:00:00	SPY	ETF	457.59	458.97	456.94	457.08	239620.0
2021-11-26 15:00:00	SPY	ETF	457.16	457.16	456.88	456.93	103775.0
2021-11-26 16:00:00	SPY	ETF	456.93	457.2	456.86	457.1	66680.0
2021-11-26 04:00:00	QQQ	ETF	395.08	395.32	393.19	393.9	267463.0
2021-11-26 05:00:00	QQQ	ETF	393.84	394.69	393.83	394.37	125200.0
2021-11-26 06:00:00	QQQ	ETF	394.33	395.48	394.31	394.75	233511.0
2021-11-26 07:00:00	QQQ	ETF	394.8	396.23	394.64	394.86	536490.0
2021-11-26 08:00:00	QQQ	ETF	394.9	397.0	393.34	394.76	914475.0
2021-11-26 09:00:00	QQQ	ETF	394.76	398.76	394.15	395.65	8443564.0
2021-11-26 10:00:00	QQQ	ETF	395.64	395.85	392.51	393.0288	8896939.0
2021-11-26 11:00:00	QQQ	ETF	393.02	393.02	390.76	391.95	7127816.0
2021-11-26 12:00:00	QQQ	ETF	391.96	393.41	389.77	390.99	11237475.0
2021-11-26 13:00:00	QQQ	ETF	391.0	391.68	390.75	391.24	1900512.0
2021-11-26 14:00:00	QQQ	ETF	391.2	391.37	390.72	390.86	37002.0
2021-11-26 15:00:00	QQQ	ETF	391.01	391.01	390.36	390.65	32277.0
2021-11-26 16:00:00	QQQ	ETF	390.68	391.1	390.59	390.88	34403.0
2021-11-26 04:00:00	IWM	ETF	230.53	230.53	220.86	221.35	229824.0
2021-11-26 05:00:00	IWM	ETF	221.75	223.24	221.51	222.17	126433.0
2021-11-26 06:00:00	IWM	ETF	222.14	223.39	222.1	222.78	338585.0
2021-11-26 07:00:00	IWM	ETF	222.84	224.32	222.75	223.57	632107.0
2021-11-26 08:00:00	IWM	ETF	223.25	226.3	220.16	224.56	888825.0
2021-11-26 09:00:00	IWM	ETF	224.54	226.17	223.28	223.55	11251066.0
2021-11-26 10:00:00	IWM	ETF	223.56	223.57	220.79	221.4	10449567.0
2021-11-26 11:00:00	IWM	ETF	221.38	221.54	219.64	220.8	8024972.0
2021-11-26 12:00:00	IWM	ETF	220.8	223.99	220.8	223.0	11831274.0
2021-11-26 13:00:00	IWM	ETF	223.0	223.19	220.89	221.16	3359020.0
2021-11-26 14:00:00	IWM	ETF	221.1601	221.39	220.7	221.0	32944.0
2021-11-26 15:00:00	IWM	ETF	221.0	222.85	220.81	221.05	32977.0
2021-11-26 16:00:00	IWM	ETF	221.05	221.75	221.0	221.75	16719.0
2021-11-26 04:00:00	DIA	ETF	350.65	351.02	349.36	349.91	46606.0
2021-11-26 05:00:00	DIA	ETF	349.8	350.61	349.59	350.0	27352.0
2021-11-26 06:00:00	DIA	ETF	350.48	350.48	349.67	349.76	15066.0
2021-11-26 07:00:00	DIA	ETF	349.77	350.61	349.77	350.33	163849.0
2021-11-26 08:00:00	DIA	ETF	350.3699	353.68	349.1	350.0	92510.0
2021-11-26 09:00:00	DIA	ETF	349.94	351.46	348.62	349.21	1522642.0
2021-11-26 10:00:00	DIA	ETF	349.18	349.79	347.95	348.87	1476530.0
2021-11-26 11:00:00	DIA	ETF	348.85	348.96	347.36	348.15	1030817.0
2021-11-26 12:00:00	DIA	ETF	348.18	350.69	348.12	349.08	1389527.0
2021-11-26 13:00:00	DIA	ETF	349.09	349.37	347.0	347.78	201747.0
2021-11-26 14:00:00	DIA	ETF	347.8	347.85	347.55	347.6	6936.0

> showing 50 of 11,007 rows — these rows as CSV

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