PREVIEW / etf_1hour / 2021-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-07.parquet
  size:    446 KB
  rows:    15,830

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-07 04:00:00	SPY	ETF	460.11	464.32	459.75	463.88	218835.0
2021-12-07 05:00:00	SPY	ETF	463.91	465.23	463.89	464.85	65957.0
2021-12-07 06:00:00	SPY	ETF	464.83	465.02	464.5	464.8	82700.0
2021-12-07 07:00:00	SPY	ETF	464.8	464.92	464.23	464.64	375052.0
2021-12-07 08:00:00	SPY	ETF	464.6401	465.0	460.5	464.31	677902.0
2021-12-07 09:00:00	SPY	ETF	464.34	467.26	463.89	467.24	9579000.0
2021-12-07 10:00:00	SPY	ETF	467.24	468.77	466.9632	468.466	13076701.0
2021-12-07 11:00:00	SPY	ETF	468.46	468.88	468.02	468.12	7047424.0
2021-12-07 12:00:00	SPY	ETF	468.12	468.6417	467.93	468.6168	4084580.0
2021-12-07 13:00:00	SPY	ETF	468.61	468.79	467.78	468.46	3881598.0
2021-12-07 14:00:00	SPY	ETF	468.47	468.53	467.82	468.18	4192812.0
2021-12-07 15:00:00	SPY	ETF	468.17	468.53	466.24	468.24	22483647.0
2021-12-07 16:00:00	SPY	ETF	468.24	469.31	467.489	469.14	8396226.0
2021-12-07 17:00:00	SPY	ETF	469.18	469.39	468.28	469.22	187906.0
2021-12-07 18:00:00	SPY	ETF	469.22	469.25	468.28	468.55	718473.0
2021-12-07 19:00:00	SPY	ETF	468.59	469.63	468.02	469.58	252164.0
2021-12-07 04:00:00	QQQ	ETF	390.0	393.33	390.0	392.75	127566.0
2021-12-07 05:00:00	QQQ	ETF	392.73	394.13	392.67	393.66	55765.0
2021-12-07 06:00:00	QQQ	ETF	393.6	393.7	392.94	393.39	77841.0
2021-12-07 07:00:00	QQQ	ETF	393.36	393.53	392.82	393.29	280157.0
2021-12-07 08:00:00	QQQ	ETF	392.8799	393.8004	386.489	393.01	373257.0
2021-12-07 09:00:00	QQQ	ETF	393.0	395.67	392.48	395.65	7906698.0
2021-12-07 10:00:00	QQQ	ETF	395.66	397.48	395.27	396.71	7696703.0
2021-12-07 11:00:00	QQQ	ETF	396.71	397.74	396.515	397.24	4869890.0
2021-12-07 12:00:00	QQQ	ETF	397.26	398.28	397.15	398.1481	3418088.0
2021-12-07 13:00:00	QQQ	ETF	398.14	398.46	397.28	398.29	3070330.0
2021-12-07 14:00:00	QQQ	ETF	398.29	398.3	397.025	397.32	3232930.0
2021-12-07 15:00:00	QQQ	ETF	397.32	398.01	395.98	397.95	9994131.0
2021-12-07 16:00:00	QQQ	ETF	397.95	399.21	396.646	399.0	1937058.0
2021-12-07 17:00:00	QQQ	ETF	398.95	399.2	397.83	399.17	68091.0
2021-12-07 18:00:00	QQQ	ETF	399.09	399.09	398.2	398.43	133763.0
2021-12-07 19:00:00	QQQ	ETF	398.37	399.51	398.07	399.51	120740.0
2021-12-07 04:00:00	IWM	ETF	222.23	222.59	221.95	222.13	31840.0
2021-12-07 05:00:00	IWM	ETF	222.3	223.18	222.25	222.78	17237.0
2021-12-07 06:00:00	IWM	ETF	222.79	223.0	222.52	222.81	118320.0
2021-12-07 07:00:00	IWM	ETF	222.78	222.78	222.32	222.63	125363.0
2021-12-07 08:00:00	IWM	ETF	222.5801	223.01	220.29	222.49	184154.0
2021-12-07 09:00:00	IWM	ETF	222.46	224.8063	221.98	224.57	5810632.0
2021-12-07 10:00:00	IWM	ETF	224.57	225.74	224.3	225.68	4592760.0
2021-12-07 11:00:00	IWM	ETF	225.68	226.04	224.905	225.0	3491854.0
2021-12-07 12:00:00	IWM	ETF	224.98	225.5959	224.911	225.55	2273803.0
2021-12-07 13:00:00	IWM	ETF	225.54	225.65	224.67	225.41	2199073.0
2021-12-07 14:00:00	IWM	ETF	225.41	225.8	225.29	225.56	1616363.0
2021-12-07 15:00:00	IWM	ETF	225.555	225.75	222.9601	224.05	8676786.0
2021-12-07 16:00:00	IWM	ETF	224.1	224.97	223.0	224.78	3168051.0
2021-12-07 17:00:00	IWM	ETF	224.66	224.96	224.1	224.75	155960.0
2021-12-07 18:00:00	IWM	ETF	224.89	224.89	224.22	224.31	39865.0
2021-12-07 19:00:00	IWM	ETF	224.22	224.93	223.72	224.9	115794.0
2021-12-07 04:00:00	DIA	ETF	355.69	355.69	355.69	355.69	300.0
2021-12-07 05:00:00	DIA	ETF	356.0	356.71	356.0	356.66	7741.0

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

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