PREVIEW / etf_1hour / 2021-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-09.parquet
  size:    427 KB
  rows:    15,166

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-09 04:00:00	SPY	ETF	468.58	468.77	468.29	468.7	25994.0
2021-12-09 05:00:00	SPY	ETF	468.62	468.62	467.7	468.14	20989.0
2021-12-09 06:00:00	SPY	ETF	468.27	468.31	467.5	467.93	41327.0
2021-12-09 07:00:00	SPY	ETF	468.0	468.51	467.95	468.21	150793.0
2021-12-09 08:00:00	SPY	ETF	468.25	469.872	467.45	467.92	442660.0
2021-12-09 09:00:00	SPY	ETF	467.96	469.07	467.82	468.26	5455926.0
2021-12-09 10:00:00	SPY	ETF	468.26	468.815	467.06	468.21	5987113.0
2021-12-09 11:00:00	SPY	ETF	468.22	468.86	467.58	467.96	3812660.0
2021-12-09 12:00:00	SPY	ETF	467.95	469.0	467.66	468.945	3258031.0
2021-12-09 13:00:00	SPY	ETF	468.94	469.11	467.91	468.45	4050311.0
2021-12-09 14:00:00	SPY	ETF	468.44	468.71	467.17	467.45	4756240.0
2021-12-09 15:00:00	SPY	ETF	467.45	468.01	466.14	466.33	14375333.0
2021-12-09 16:00:00	SPY	ETF	466.32	466.7	465.9	466.51	2874920.0
2021-12-09 17:00:00	SPY	ETF	466.5	466.85	466.45	466.68	109832.0
2021-12-09 18:00:00	SPY	ETF	466.66	467.18	466.35	466.97	38187.0
2021-12-09 19:00:00	SPY	ETF	467.04	467.1	466.46	466.53	42820.0
2021-12-09 04:00:00	QQQ	ETF	399.33	399.33	398.61	398.8	20670.0
2021-12-09 05:00:00	QQQ	ETF	398.7	398.7	397.9	398.18	21973.0
2021-12-09 06:00:00	QQQ	ETF	398.05	398.33	397.59	397.94	41238.0
2021-12-09 07:00:00	QQQ	ETF	397.91	398.49	397.84	398.35	122764.0
2021-12-09 08:00:00	QQQ	ETF	398.0501	399.909	397.7	398.02	246976.0
2021-12-09 09:00:00	QQQ	ETF	398.1	400.2	397.96	398.558	5926217.0
2021-12-09 10:00:00	QQQ	ETF	398.58	399.02	396.32	397.51	7097909.0
2021-12-09 11:00:00	QQQ	ETF	397.55	398.5086	396.962	397.15	4598336.0
2021-12-09 12:00:00	QQQ	ETF	397.1473	397.663	396.555	397.4912	2706363.0
2021-12-09 13:00:00	QQQ	ETF	397.49	397.515	395.14	396.06	4259354.0
2021-12-09 14:00:00	QQQ	ETF	396.06	396.4767	394.82	395.12	4173605.0
2021-12-09 15:00:00	QQQ	ETF	395.13	395.86	393.5299	393.74	8699594.0
2021-12-09 16:00:00	QQQ	ETF	393.73	393.96	393.07	393.93	1582284.0
2021-12-09 17:00:00	QQQ	ETF	393.75	394.04	393.67	394.04	108231.0
2021-12-09 18:00:00	QQQ	ETF	393.99	394.62	393.86	394.42	81087.0
2021-12-09 19:00:00	QQQ	ETF	394.4	394.47	394.0	394.0	49576.0
2021-12-09 04:00:00	IWM	ETF	224.82	224.96	224.5	224.79	17965.0
2021-12-09 05:00:00	IWM	ETF	224.66	224.71	224.11	224.67	20082.0
2021-12-09 06:00:00	IWM	ETF	224.66	224.72	224.1	224.21	19273.0
2021-12-09 07:00:00	IWM	ETF	224.2	224.74	224.02	224.33	88480.0
2021-12-09 08:00:00	IWM	ETF	224.15	225.01	223.57	224.08	239178.0
2021-12-09 09:00:00	IWM	ETF	224.13	225.81	223.27	223.79	3582139.0
2021-12-09 10:00:00	IWM	ETF	223.79	224.74	222.64	223.12	3727688.0
2021-12-09 11:00:00	IWM	ETF	223.13	223.51	222.52	222.71	1997453.0
2021-12-09 12:00:00	IWM	ETF	222.71	223.32	222.31	223.3	1678657.0
2021-12-09 13:00:00	IWM	ETF	223.29	223.29	221.93	222.45	1896995.0
2021-12-09 14:00:00	IWM	ETF	222.47	222.73	221.325	221.445	2232124.0
2021-12-09 15:00:00	IWM	ETF	221.46	221.91	220.48	220.52	5789836.0
2021-12-09 16:00:00	IWM	ETF	220.52	220.77	220.14	220.62	3650068.0
2021-12-09 17:00:00	IWM	ETF	220.62	220.79	220.52	220.6	67700.0
2021-12-09 18:00:00	IWM	ETF	220.59	221.0	220.5	220.67	54959.0
2021-12-09 19:00:00	IWM	ETF	220.6	220.8	220.35	220.38	51282.0
2021-12-09 04:00:00	DIA	ETF	357.15	357.15	357.14	357.14	926.0
2021-12-09 05:00:00	DIA	ETF	356.62	357.02	356.58	357.02	15260.0

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

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