PREVIEW / etf_1hour / 2021-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-26.parquet
  size:    411 KB
  rows:    14,437

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-03-26 04:00:00	SPY	ETF	390.74	391.37	390.74	390.85	58130.0
2021-03-26 05:00:00	SPY	ETF	390.84	390.84	390.5	390.81	12800.0
2021-03-26 06:00:00	SPY	ETF	390.69	390.9	390.26	390.58	13954.0
2021-03-26 07:00:00	SPY	ETF	390.55	391.03	390.08	390.61	279876.0
2021-03-26 08:00:00	SPY	ETF	390.5999	391.5	390.01	390.65	446138.0
2021-03-26 09:00:00	SPY	ETF	390.61	391.39	390.46	391.28	6138258.0
2021-03-26 10:00:00	SPY	ETF	391.27	392.35	391.06	391.51	9568645.0
2021-03-26 11:00:00	SPY	ETF	391.52	391.93	390.58	391.8719	7955367.0
2021-03-26 12:00:00	SPY	ETF	391.88	392.9411	391.52	392.4808	5288931.0
2021-03-26 13:00:00	SPY	ETF	392.4896	392.99	391.36	391.98	5873092.0
2021-03-26 14:00:00	SPY	ETF	391.97	392.29	390.29	392.25	12129722.0
2021-03-26 15:00:00	SPY	ETF	392.24	396.41	391.83	395.94	27029382.0
2021-03-26 16:00:00	SPY	ETF	395.94	396.25	390.9	395.85	8952387.0
2021-03-26 17:00:00	SPY	ETF	395.89	395.98	395.51	395.59	203113.0
2021-03-26 18:00:00	SPY	ETF	395.56	403.9	395.41	395.5	1300876.0
2021-03-26 19:00:00	SPY	ETF	395.5	395.72	395.41	395.63	57425.0
2021-03-26 04:00:00	QQQ	ETF	312.57	312.8	312.09	312.17	52191.0
2021-03-26 05:00:00	QQQ	ETF	312.25	312.41	311.75	312.37	48932.0
2021-03-26 06:00:00	QQQ	ETF	312.4	312.66	311.44	311.44	74592.0
2021-03-26 07:00:00	QQQ	ETF	311.44	311.69	309.89	310.5	483316.0
2021-03-26 08:00:00	QQQ	ETF	312.58	313.89	309.02	310.65	620950.0
2021-03-26 09:00:00	QQQ	ETF	310.6	312.74	310.53	312.23	5629241.0
2021-03-26 10:00:00	QQQ	ETF	312.24	313.58	311.47	312.38	6627692.0
2021-03-26 11:00:00	QQQ	ETF	312.42	312.96	311.0	312.96	6076726.0
2021-03-26 12:00:00	QQQ	ETF	312.96	313.54	312.15	312.71	4197610.0
2021-03-26 13:00:00	QQQ	ETF	312.71	313.78	311.58	312.02	4689284.0
2021-03-26 14:00:00	QQQ	ETF	312.01	312.33	309.67	311.855	9421769.0
2021-03-26 15:00:00	QQQ	ETF	311.84	316.33	311.64	316.01	9917323.0
2021-03-26 16:00:00	QQQ	ETF	316.04	316.63	315.31	315.97	2149903.0
2021-03-26 17:00:00	QQQ	ETF	315.96	316.0	315.69	315.77	187668.0
2021-03-26 18:00:00	QQQ	ETF	315.8	315.93	315.69	315.87	12514.0
2021-03-26 19:00:00	QQQ	ETF	315.72	315.86	315.4	315.85	18317.0
2021-03-26 04:00:00	IWM	ETF	218.4	218.52	218.1	218.1	32018.0
2021-03-26 05:00:00	IWM	ETF	218.26	218.31	217.66	217.73	19300.0
2021-03-26 06:00:00	IWM	ETF	217.79	218.17	217.79	218.08	9399.0
2021-03-26 07:00:00	IWM	ETF	218.16	218.47	217.47	218.17	241367.0
2021-03-26 08:00:00	IWM	ETF	218.0799	218.63	217.49	218.32	277812.0
2021-03-26 09:00:00	IWM	ETF	218.32	219.28	217.59	218.86	3844415.0
2021-03-26 10:00:00	IWM	ETF	218.94	220.68	218.9	219.0	4603142.0
2021-03-26 11:00:00	IWM	ETF	219.0	219.7	217.77	218.98	3012773.0
2021-03-26 12:00:00	IWM	ETF	218.99	220.2899	218.55	218.63	2204224.0
2021-03-26 13:00:00	IWM	ETF	218.615	219.25	216.86	217.49	2436113.0
2021-03-26 14:00:00	IWM	ETF	217.4999	218.048	215.96	218.0	3583304.0
2021-03-26 15:00:00	IWM	ETF	217.965	220.66	217.21	220.62	5478559.0
2021-03-26 16:00:00	IWM	ETF	220.61	220.97	220.18	220.71	2071371.0
2021-03-26 17:00:00	IWM	ETF	220.78	220.84	220.55	220.67	95703.0
2021-03-26 18:00:00	IWM	ETF	220.53	220.53	220.4701	220.48	6363.0
2021-03-26 19:00:00	IWM	ETF	220.42	220.61	220.4	220.61	19097.0
2021-03-26 04:00:00	DIA	ETF	327.41	327.54	327.27	327.27	900.0
2021-03-26 05:00:00	DIA	ETF	327.12	327.12	326.97	327.05	838.0

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

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