PREVIEW / etf_1hour / 2021-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-03.parquet
  size:    430 KB
  rows:    15,264

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-03 04:00:00	SPY	ETF	461.4	461.81	461.4	461.71	4635.0
2021-11-03 05:00:00	SPY	ETF	461.68	461.91	461.61	461.71	7316.0
2021-11-03 06:00:00	SPY	ETF	461.7	461.71	461.42	461.42	15621.0
2021-11-03 07:00:00	SPY	ETF	461.56	461.66	461.33	461.59	47346.0
2021-11-03 08:00:00	SPY	ETF	461.4	461.72	461.16	461.21	168892.0
2021-11-03 09:00:00	SPY	ETF	461.21	461.58	460.8338	461.39	3574482.0
2021-11-03 10:00:00	SPY	ETF	461.47	461.67	460.83	461.45	3595938.0
2021-11-03 11:00:00	SPY	ETF	461.45	461.5	461.04	461.4201	2045387.0
2021-11-03 12:00:00	SPY	ETF	461.426	461.53	461.2	461.31	1575757.0
2021-11-03 13:00:00	SPY	ETF	461.305	461.4196	460.96	461.135	2148737.0
2021-11-03 14:00:00	SPY	ETF	461.13	464.23	460.86	463.94	10328636.0
2021-11-03 15:00:00	SPY	ETF	463.92	465.15	463.72	464.74	12950575.0
2021-11-03 16:00:00	SPY	ETF	464.74	464.75	464.41	464.7	3669714.0
2021-11-03 17:00:00	SPY	ETF	464.71	464.82	464.66	464.72	303000.0
2021-11-03 18:00:00	SPY	ETF	464.72	465.12	464.71	465.07	98444.0
2021-11-03 19:00:00	SPY	ETF	465.07	465.5	465.07	465.46	64509.0
2021-11-03 04:00:00	QQQ	ETF	389.06	389.43	389.06	389.33	30643.0
2021-11-03 05:00:00	QQQ	ETF	389.32	389.7	389.32	389.5	21982.0
2021-11-03 06:00:00	QQQ	ETF	389.51	389.64	389.08	389.29	199976.0
2021-11-03 07:00:00	QQQ	ETF	389.27	389.67	389.17	389.54	154677.0
2021-11-03 08:00:00	QQQ	ETF	389.39	389.7	388.95	389.48	117481.0
2021-11-03 09:00:00	QQQ	ETF	389.46	389.95	388.65	389.29	3427513.0
2021-11-03 10:00:00	QQQ	ETF	389.32	389.43	388.48	389.0401	3061189.0
2021-11-03 11:00:00	QQQ	ETF	389.05	389.64	388.62	389.61	1484401.0
2021-11-03 12:00:00	QQQ	ETF	389.6	389.71	389.24	389.46	1281718.0
2021-11-03 13:00:00	QQQ	ETF	389.45	389.78	389.18	389.3	1230192.0
2021-11-03 14:00:00	QQQ	ETF	389.29	392.21	389.02	392.051	7550167.0
2021-11-03 15:00:00	QQQ	ETF	392.06	393.61	391.79	393.235	6868318.0
2021-11-03 16:00:00	QQQ	ETF	393.235	393.29	393.06	393.26	1004247.0
2021-11-03 17:00:00	QQQ	ETF	393.18	393.39	393.14	393.34	109781.0
2021-11-03 18:00:00	QQQ	ETF	393.31	393.9	393.25	393.85	95380.0
2021-11-03 19:00:00	QQQ	ETF	393.87	394.57	393.87	394.57	143098.0
2021-11-03 04:00:00	IWM	ETF	234.49	234.82	234.49	234.76	4978.0
2021-11-03 05:00:00	IWM	ETF	234.69	234.8	234.61	234.71	2900.0
2021-11-03 06:00:00	IWM	ETF	234.8	234.82	234.48	234.58	16786.0
2021-11-03 07:00:00	IWM	ETF	234.57	234.66	234.36	234.52	29198.0
2021-11-03 08:00:00	IWM	ETF	234.51	234.6496	234.0	234.1	73711.0
2021-11-03 09:00:00	IWM	ETF	234.13	236.05	233.92	235.8072	3592296.0
2021-11-03 10:00:00	IWM	ETF	235.83	238.24	235.77	237.69	6071729.0
2021-11-03 11:00:00	IWM	ETF	237.68	238.15	237.08	237.25	4044754.0
2021-11-03 12:00:00	IWM	ETF	237.24	237.67	236.73	236.77	2204203.0
2021-11-03 13:00:00	IWM	ETF	236.77	236.87	236.18	236.56	1656144.0
2021-11-03 14:00:00	IWM	ETF	236.56	239.81	236.45	239.11	6987711.0
2021-11-03 15:00:00	IWM	ETF	239.11	239.43	238.45	238.62	5695837.0
2021-11-03 16:00:00	IWM	ETF	238.64	238.8	236.3923	238.73	3655720.0
2021-11-03 17:00:00	IWM	ETF	238.85	238.94	238.67	238.81	9151.0
2021-11-03 18:00:00	IWM	ETF	238.81	239.02	238.64	238.95	72987.0
2021-11-03 19:00:00	IWM	ETF	238.91	239.35	238.91	239.17	29740.0
2021-11-03 04:00:00	DIA	ETF	360.47	360.47	360.47	360.47	227.0
2021-11-03 05:00:00	DIA	ETF	360.4	360.4	360.4	360.4	100.0

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

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