PREVIEW / etf_1hour / 2022-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-16.parquet
  size:    474 KB
  rows:    17,208

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
2022-12-16 04:00:00	SPY	ETF	383.94	387.85	383.2	383.99	120004.0
2022-12-16 05:00:00	SPY	ETF	383.76	384.05	382.5	382.98	162284.0
2022-12-16 06:00:00	SPY	ETF	382.76	384.1	382.64	383.68	113431.0
2022-12-16 07:00:00	SPY	ETF	383.7	385.05	383.42	385.05	432341.0
2022-12-16 08:00:00	SPY	ETF	384.2387	387.9	382.6	384.2	669443.0
2022-12-16 09:00:00	SPY	ETF	384.19	386.575	383.3	385.87	7759504.0
2022-12-16 10:00:00	SPY	ETF	385.87	385.88	381.85	383.07	12011360.0
2022-12-16 11:00:00	SPY	ETF	383.05	383.5289	381.36	381.54	6643147.0
2022-12-16 12:00:00	SPY	ETF	381.56	382.889	381.04	381.175	5853371.0
2022-12-16 13:00:00	SPY	ETF	381.17	382.06	381.07	381.725	5437064.0
2022-12-16 14:00:00	SPY	ETF	381.7	383.27	381.2	382.93	7739968.0
2022-12-16 15:00:00	SPY	ETF	382.93	384.96	382.375	383.3	23331974.0
2022-12-16 16:00:00	SPY	ETF	383.29	384.26	382.42	382.73	6760808.0
2022-12-16 17:00:00	SPY	ETF	382.74	382.9	382.4	382.64	217287.0
2022-12-16 18:00:00	SPY	ETF	383.27	383.27	382.4	382.61	850211.0
2022-12-16 19:00:00	SPY	ETF	382.57	382.57	382.2	382.5	49776.0
2022-12-16 04:00:00	QQQ	ETF	273.85	276.23	273.39	274.27	114242.0
2022-12-16 05:00:00	QQQ	ETF	274.2	274.54	273.69	274.13	77868.0
2022-12-16 06:00:00	QQQ	ETF	274.19	275.1	273.93	274.75	104698.0
2022-12-16 07:00:00	QQQ	ETF	274.81	276.0	274.72	276.0	322561.0
2022-12-16 08:00:00	QQQ	ETF	275.13	277.097	273.6696	275.47	565577.0
2022-12-16 09:00:00	QQQ	ETF	275.48	277.77	274.68	276.9001	5647481.0
2022-12-16 10:00:00	QQQ	ETF	276.9	276.9	273.46	274.51	7501957.0
2022-12-16 11:00:00	QQQ	ETF	274.5111	274.6395	273.05	273.2299	4839779.0
2022-12-16 12:00:00	QQQ	ETF	273.235	274.435	272.84	272.9805	3724955.0
2022-12-16 13:00:00	QQQ	ETF	272.98	273.56	272.77	273.185	3067820.0
2022-12-16 14:00:00	QQQ	ETF	273.185	274.22	272.61	273.92	4207405.0
2022-12-16 15:00:00	QQQ	ETF	273.905	275.4712	273.485	274.22	9625034.0
2022-12-16 16:00:00	QQQ	ETF	274.21	274.35	273.4	273.6901	6486039.0
2022-12-16 17:00:00	QQQ	ETF	273.7	274.54	273.64	274.25	680722.0
2022-12-16 18:00:00	QQQ	ETF	274.25	274.29	274.1	274.16	218341.0
2022-12-16 19:00:00	QQQ	ETF	274.1501	274.16	273.76	274.1	22849.0
2022-12-16 04:00:00	IWM	ETF	173.77	173.79	173.26	173.58	34237.0
2022-12-16 05:00:00	IWM	ETF	173.49	173.57	172.78	173.01	27254.0
2022-12-16 06:00:00	IWM	ETF	172.84	173.62	172.84	173.25	29140.0
2022-12-16 07:00:00	IWM	ETF	173.35	174.0	173.28	174.0	54065.0
2022-12-16 08:00:00	IWM	ETF	174.03	174.06	173.42	174.01	89172.0
2022-12-16 09:00:00	IWM	ETF	173.96	175.11	173.65	174.65	2848987.0
2022-12-16 10:00:00	IWM	ETF	174.64	174.6409	172.99	173.6189	3936906.0
2022-12-16 11:00:00	IWM	ETF	173.63	174.05	172.9	172.965	2030304.0
2022-12-16 12:00:00	IWM	ETF	172.97	173.65	172.67	172.74	1705946.0
2022-12-16 13:00:00	IWM	ETF	172.75	173.48	172.7	173.271	882586.0
2022-12-16 14:00:00	IWM	ETF	173.27	173.99	173.13	173.825	1382688.0
2022-12-16 15:00:00	IWM	ETF	173.81	174.835	173.5	174.35	4499042.0
2022-12-16 16:00:00	IWM	ETF	174.37	174.5395	173.85	174.15	4146837.0
2022-12-16 17:00:00	IWM	ETF	174.13	174.37	173.91	174.25	1428276.0
2022-12-16 18:00:00	IWM	ETF	174.24	174.37	174.03	174.03	102382.0
2022-12-16 19:00:00	IWM	ETF	174.02	174.11	173.71	173.95	4536.0
2022-12-16 04:00:00	DIA	ETF	329.16	329.16	328.51	328.63	2483.0
2022-12-16 05:00:00	DIA	ETF	328.8	329.06	327.81	327.83	6395.0

> showing 50 of 17,208 rows — these rows as CSV

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