PREVIEW / etf_1hour / 2021-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-13.parquet
  size:    402 KB
  rows:    14,042

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-08-13 04:00:00	SPY	ETF	445.37	445.43	445.26	445.41	3900.0
2021-08-13 05:00:00	SPY	ETF	445.59	445.59	445.38	445.43	3050.0
2021-08-13 06:00:00	SPY	ETF	445.47	445.48	445.32	445.32	61925.0
2021-08-13 07:00:00	SPY	ETF	445.33	445.36	445.22	445.22	85339.0
2021-08-13 08:00:00	SPY	ETF	445.35	445.53	445.22	445.53	78120.0
2021-08-13 09:00:00	SPY	ETF	445.54	445.85	445.14	445.505	3437086.0
2021-08-13 10:00:00	SPY	ETF	445.5	445.82	445.07	445.4454	4892410.0
2021-08-13 11:00:00	SPY	ETF	445.45	445.689	445.35	445.5199	2151274.0
2021-08-13 12:00:00	SPY	ETF	445.5199	445.62	445.36	445.5499	1820505.0
2021-08-13 13:00:00	SPY	ETF	445.545	445.8	445.4	445.725	1913463.0
2021-08-13 14:00:00	SPY	ETF	445.725	445.76	445.2	445.4273	2544306.0
2021-08-13 15:00:00	SPY	ETF	445.435	445.93	445.33	445.9	8522045.0
2021-08-13 16:00:00	SPY	ETF	445.89	445.95	445.62	445.62	2246442.0
2021-08-13 17:00:00	SPY	ETF	445.51	445.7	445.5	445.5	56893.0
2021-08-13 18:00:00	SPY	ETF	445.58	445.58	445.34	445.35	15926.0
2021-08-13 19:00:00	SPY	ETF	445.38	445.45	445.31	445.45	53456.0
2021-08-13 04:00:00	QQQ	ETF	367.92	367.99	367.79	367.92	9623.0
2021-08-13 05:00:00	QQQ	ETF	367.97	368.01	367.65	367.73	17917.0
2021-08-13 06:00:00	QQQ	ETF	367.73	367.82	367.64	367.66	63766.0
2021-08-13 07:00:00	QQQ	ETF	367.7	367.71	367.12	367.2	162274.0
2021-08-13 08:00:00	QQQ	ETF	367.7404	367.805	367.08	367.61	95613.0
2021-08-13 09:00:00	QQQ	ETF	367.65	368.34	367.38	368.12	3006203.0
2021-08-13 10:00:00	QQQ	ETF	368.13	369.16	367.72	368.5	3493579.0
2021-08-13 11:00:00	QQQ	ETF	368.51	368.8075	368.011	368.17	1573718.0
2021-08-13 12:00:00	QQQ	ETF	368.165	368.63	367.9609	368.5676	1450911.0
2021-08-13 13:00:00	QQQ	ETF	368.56	368.61	368.3	368.5301	899599.0
2021-08-13 14:00:00	QQQ	ETF	368.52	368.57	368.02	368.35	1017308.0
2021-08-13 15:00:00	QQQ	ETF	368.34	368.87	368.23	368.82	3110991.0
2021-08-13 16:00:00	QQQ	ETF	368.82	368.89	368.65	368.65	822168.0
2021-08-13 17:00:00	QQQ	ETF	368.57	368.82	368.5	368.82	100377.0
2021-08-13 18:00:00	QQQ	ETF	368.645	368.645	368.6	368.6	1362.0
2021-08-13 19:00:00	QQQ	ETF	368.53	368.6	368.45	368.6	10617.0
2021-08-13 04:00:00	IWM	ETF	222.81	222.81	222.5	222.75	6817.0
2021-08-13 05:00:00	IWM	ETF	222.85	222.89	222.85	222.85	2600.0
2021-08-13 06:00:00	IWM	ETF	222.84	222.93	222.84	222.89	11975.0
2021-08-13 07:00:00	IWM	ETF	222.77	222.86	222.73	222.86	12702.0
2021-08-13 08:00:00	IWM	ETF	222.8301	223.18	222.76	223.14	50914.0
2021-08-13 09:00:00	IWM	ETF	223.15	223.3	221.64	221.84	2488719.0
2021-08-13 10:00:00	IWM	ETF	221.84	222.04	221.0987	221.92	3347045.0
2021-08-13 11:00:00	IWM	ETF	221.92	222.14	221.67	221.94	1306154.0
2021-08-13 12:00:00	IWM	ETF	221.94	222.15	221.6	221.76	1180972.0
2021-08-13 13:00:00	IWM	ETF	221.765	221.95	221.5963	221.83	887080.0
2021-08-13 14:00:00	IWM	ETF	221.84	221.91	220.81	221.14	1859207.0
2021-08-13 15:00:00	IWM	ETF	221.15	221.75	220.7	221.08	3501326.0
2021-08-13 16:00:00	IWM	ETF	221.0798	221.17	220.8	220.81	1273783.0
2021-08-13 17:00:00	IWM	ETF	220.99	221.17	220.81	220.85	102110.0
2021-08-13 18:00:00	IWM	ETF	220.82	220.83	220.81	220.82	756.0
2021-08-13 19:00:00	IWM	ETF	220.84	220.85	220.5	220.85	4379.0
2021-08-13 04:00:00	DIA	ETF	355.51	355.64	355.5	355.63	6006.0
2021-08-13 05:00:00	DIA	ETF	355.79	355.83	355.68	355.79	6647.0

> showing 50 of 14,042 rows — these rows as CSV

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