PREVIEW / etf_1hour / 2021-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-01.parquet
  size:    455 KB
  rows:    16,527

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-12-01 04:00:00	SPY	ETF	460.0	462.12	460.0	461.77	66999.0
2021-12-01 05:00:00	SPY	ETF	461.77	461.83	461.28	461.74	36900.0
2021-12-01 06:00:00	SPY	ETF	461.77	462.02	461.11	461.95	136780.0
2021-12-01 07:00:00	SPY	ETF	461.96	462.45	461.63	462.05	385470.0
2021-12-01 08:00:00	SPY	ETF	461.67	462.42	455.901	461.75	604027.0
2021-12-01 09:00:00	SPY	ETF	461.75	462.0	460.24	461.45	6915030.0
2021-12-01 10:00:00	SPY	ETF	461.48	463.54	461.23	463.46	10451486.0
2021-12-01 11:00:00	SPY	ETF	463.45	464.67	462.24	462.67	9514891.0
2021-12-01 12:00:00	SPY	ETF	462.68	463.81	460.27	460.46	7604721.0
2021-12-01 13:00:00	SPY	ETF	460.49	461.18	457.38	459.12	14328799.0
2021-12-01 14:00:00	SPY	ETF	459.11	459.38	456.85	457.5	10492383.0
2021-12-01 15:00:00	SPY	ETF	457.48	457.83	450.29	450.51	33037890.0
2021-12-01 16:00:00	SPY	ETF	450.53	462.7558	449.5	450.47	10412072.0
2021-12-01 17:00:00	SPY	ETF	450.47	451.05	450.42	451.0	264845.0
2021-12-01 18:00:00	SPY	ETF	451.05	452.49	450.5	452.35	364189.0
2021-12-01 19:00:00	SPY	ETF	452.4	452.9	451.46	451.98	250068.0
2021-12-01 04:00:00	QQQ	ETF	397.4	399.29	397.4	399.28	112773.0
2021-12-01 05:00:00	QQQ	ETF	399.26	399.26	398.83	398.98	32873.0
2021-12-01 06:00:00	QQQ	ETF	399.05	399.49	398.65	399.43	56378.0
2021-12-01 07:00:00	QQQ	ETF	399.43	399.75	399.19	399.25	171379.0
2021-12-01 08:00:00	QQQ	ETF	399.39	399.6501	394.115	398.45	348084.0
2021-12-01 09:00:00	QQQ	ETF	398.43	398.94	396.6305	398.09	5864163.0
2021-12-01 10:00:00	QQQ	ETF	398.11	399.25	396.79	399.1	6861424.0
2021-12-01 11:00:00	QQQ	ETF	399.1	400.48	397.98	398.29	5426451.0
2021-12-01 12:00:00	QQQ	ETF	398.29	399.22	395.79	395.99	4548850.0
2021-12-01 13:00:00	QQQ	ETF	396.01	396.92	393.45	395.3101	9957148.0
2021-12-01 14:00:00	QQQ	ETF	395.29	395.49	392.79	393.29	8114185.0
2021-12-01 15:00:00	QQQ	ETF	393.29	393.6	386.64	387.05	18308554.0
2021-12-01 16:00:00	QQQ	ETF	387.08	395.253	385.93	386.74	4347924.0
2021-12-01 17:00:00	QQQ	ETF	386.75	387.78	386.75	387.78	137869.0
2021-12-01 18:00:00	QQQ	ETF	387.67	388.98	386.96	388.83	456226.0
2021-12-01 19:00:00	QQQ	ETF	388.99	389.21	387.87	388.35	228488.0
2021-12-01 04:00:00	IWM	ETF	221.05	223.57	221.05	223.19	83819.0
2021-12-01 05:00:00	IWM	ETF	223.3	223.3	222.75	223.23	18400.0
2021-12-01 06:00:00	IWM	ETF	222.9	223.16	222.55	223.05	129011.0
2021-12-01 07:00:00	IWM	ETF	223.04	223.27	222.48	222.71	194492.0
2021-12-01 08:00:00	IWM	ETF	222.62	224.19	218.17	224.09	564134.0
2021-12-01 09:00:00	IWM	ETF	224.01	224.1	221.75	222.76	5563642.0
2021-12-01 10:00:00	IWM	ETF	222.77	223.86	221.79	223.54	6028434.0
2021-12-01 11:00:00	IWM	ETF	223.55	224.21	220.82	221.26	4879383.0
2021-12-01 12:00:00	IWM	ETF	221.26	222.7	219.47	219.59	6146293.0
2021-12-01 13:00:00	IWM	ETF	219.6	219.92	216.48	218.03	10360478.0
2021-12-01 14:00:00	IWM	ETF	218.0	218.36	216.07	216.77	5771421.0
2021-12-01 15:00:00	IWM	ETF	216.76	217.03	213.19	213.28	12364691.0
2021-12-01 16:00:00	IWM	ETF	213.28	214.3	212.45	212.91	2704953.0
2021-12-01 17:00:00	IWM	ETF	213.09	213.44	212.79	213.4	130714.0
2021-12-01 18:00:00	IWM	ETF	213.4	214.34	213.1	214.28	158714.0
2021-12-01 19:00:00	IWM	ETF	214.25	214.74	213.58	213.95	54372.0
2021-12-01 04:00:00	DIA	ETF	347.44	348.59	347.43	348.21	4504.0
2021-12-01 05:00:00	DIA	ETF	347.93	348.03	347.93	348.03	800.0

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

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