PREVIEW / etf_1hour / 2021-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-01.parquet
  size:    438 KB
  rows:    15,489

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-01 04:00:00	SPY	ETF	459.92	460.92	459.92	460.89	33472.0
2021-11-01 05:00:00	SPY	ETF	460.88	461.29	460.88	461.02	16841.0
2021-11-01 06:00:00	SPY	ETF	461.07	461.34	461.04	461.33	91503.0
2021-11-01 07:00:00	SPY	ETF	461.28	461.42	461.0	461.07	74742.0
2021-11-01 08:00:00	SPY	ETF	461.3299	461.4	459.71	460.41	122850.0
2021-11-01 09:00:00	SPY	ETF	460.41	460.7021	459.14	459.27	6791771.0
2021-11-01 10:00:00	SPY	ETF	459.28	459.4	458.2	458.59	6256955.0
2021-11-01 11:00:00	SPY	ETF	458.58	459.52	458.52	459.4701	3224568.0
2021-11-01 12:00:00	SPY	ETF	459.49	460.0	459.37	459.9675	2568083.0
2021-11-01 13:00:00	SPY	ETF	459.97	460.02	458.675	458.83	2670237.0
2021-11-01 14:00:00	SPY	ETF	458.81	459.32	458.22	459.2	3142636.0
2021-11-01 15:00:00	SPY	ETF	459.2	460.23	458.96	460.1	7680071.0
2021-11-01 16:00:00	SPY	ETF	460.09	460.12	459.77	460.09	2669578.0
2021-11-01 17:00:00	SPY	ETF	460.04	460.06	459.91	460.02	71252.0
2021-11-01 18:00:00	SPY	ETF	460.04	460.29	459.8	460.25	75696.0
2021-11-01 19:00:00	SPY	ETF	460.25	460.25	459.84	459.84	43202.0
2021-11-01 04:00:00	QQQ	ETF	387.0	387.61	386.99	387.61	60258.0
2021-11-01 05:00:00	QQQ	ETF	387.64	387.87	387.43	387.56	88482.0
2021-11-01 06:00:00	QQQ	ETF	387.5	387.73	387.4	387.73	20473.0
2021-11-01 07:00:00	QQQ	ETF	387.73	387.92	387.52	387.55	92170.0
2021-11-01 08:00:00	QQQ	ETF	387.55	387.87	386.399	386.8	250975.0
2021-11-01 09:00:00	QQQ	ETF	386.78	386.83	385.13	385.29	4778013.0
2021-11-01 10:00:00	QQQ	ETF	385.29	385.86	384.42	385.35	5013842.0
2021-11-01 11:00:00	QQQ	ETF	385.331	386.66	385.3	386.65	2070666.0
2021-11-01 12:00:00	QQQ	ETF	386.65	386.77	386.35	386.63	1136307.0
2021-11-01 13:00:00	QQQ	ETF	386.63	386.91	385.35	385.65	1962598.0
2021-11-01 14:00:00	QQQ	ETF	385.64	385.89	384.915	385.79	1719193.0
2021-11-01 15:00:00	QQQ	ETF	385.78	387.56	385.69	387.43	3178920.0
2021-11-01 16:00:00	QQQ	ETF	387.43	387.535	386.77	387.32	788690.0
2021-11-01 17:00:00	QQQ	ETF	387.37	387.39	387.21	387.21	29624.0
2021-11-01 18:00:00	QQQ	ETF	387.28	387.43	387.0	387.399	76999.0
2021-11-01 19:00:00	QQQ	ETF	387.28	387.31	387.05	387.05	53310.0
2021-11-01 04:00:00	IWM	ETF	228.91	229.66	228.81	229.6	8205.0
2021-11-01 05:00:00	IWM	ETF	229.55	229.67	229.55	229.55	5201.0
2021-11-01 06:00:00	IWM	ETF	229.45	229.65	229.4	229.49	58126.0
2021-11-01 07:00:00	IWM	ETF	229.52	229.56	229.28	229.28	18518.0
2021-11-01 08:00:00	IWM	ETF	229.6096	229.61	228.88	228.97	51552.0
2021-11-01 09:00:00	IWM	ETF	228.94	231.198	228.66	230.88	3863118.0
2021-11-01 10:00:00	IWM	ETF	230.9	232.5	230.03	232.26	5824942.0
2021-11-01 11:00:00	IWM	ETF	232.27	233.05	232.19	233.02	3038270.0
2021-11-01 12:00:00	IWM	ETF	233.03	234.14	233.01	233.96	2229402.0
2021-11-01 13:00:00	IWM	ETF	233.97	234.03	233.21	233.5	1966286.0
2021-11-01 14:00:00	IWM	ETF	233.49	233.68	232.71	233.25	2983302.0
2021-11-01 15:00:00	IWM	ETF	233.26	234.18	233.065	233.95	4789791.0
2021-11-01 16:00:00	IWM	ETF	233.96	234.14	233.93	234.1	1769525.0
2021-11-01 17:00:00	IWM	ETF	234.15	234.15	233.92	234.09	19662.0
2021-11-01 18:00:00	IWM	ETF	234.09	234.36	233.96	234.34	38303.0
2021-11-01 19:00:00	IWM	ETF	234.33	234.33	234.07	234.08	24187.0
2021-11-01 04:00:00	DIA	ETF	359.0	359.59	359.0	359.59	2261.0
2021-11-01 05:00:00	DIA	ETF	359.72	359.82	359.7	359.73	1775.0

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

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