PREVIEW / etf_1hour / 2022-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-21.parquet
  size:    470 KB
  rows:    17,226

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-21 04:00:00	SPY	ETF	382.41	383.22	382.41	383.17	25935.0
2022-12-21 05:00:00	SPY	ETF	383.2	383.21	382.35	382.51	39635.0
2022-12-21 06:00:00	SPY	ETF	382.44	382.87	382.25	382.82	54525.0
2022-12-21 07:00:00	SPY	ETF	382.77	383.09	381.88	383.04	236171.0
2022-12-21 08:00:00	SPY	ETF	382.4673	383.96	381.65	383.65	393982.0
2022-12-21 09:00:00	SPY	ETF	383.67	383.98	382.69	383.16	5022705.0
2022-12-21 10:00:00	SPY	ETF	383.17	386.63	382.88	386.58	9852258.0
2022-12-21 11:00:00	SPY	ETF	386.58	387.3	385.6	385.94	6767414.0
2022-12-21 12:00:00	SPY	ETF	385.953	386.44	385.41	386.3899	3884732.0
2022-12-21 13:00:00	SPY	ETF	386.4082	386.82	385.63	386.38	4040645.0
2022-12-21 14:00:00	SPY	ETF	386.39	387.41	385.73	386.09	5769155.0
2022-12-21 15:00:00	SPY	ETF	386.11	386.47	385.24	386.23	10336078.0
2022-12-21 16:00:00	SPY	ETF	386.22	387.01	386.08	386.88	7167918.0
2022-12-21 17:00:00	SPY	ETF	386.94	387.11	386.83	386.9	66274.0
2022-12-21 18:00:00	SPY	ETF	386.94	387.06	386.23	386.65	65852.0
2022-12-21 19:00:00	SPY	ETF	386.61	386.93	386.35	386.89	91970.0
2022-12-21 04:00:00	QQQ	ETF	271.09	271.55	271.0	271.4	39944.0
2022-12-21 05:00:00	QQQ	ETF	271.41	271.41	270.61	270.71	93071.0
2022-12-21 06:00:00	QQQ	ETF	270.66	270.87	270.3	270.68	69211.0
2022-12-21 07:00:00	QQQ	ETF	270.69	271.0	269.93	270.9	326799.0
2022-12-21 08:00:00	QQQ	ETF	270.77	271.4496	269.742	271.07	514754.0
2022-12-21 09:00:00	QQQ	ETF	271.09	271.98	269.74	270.86	5168868.0
2022-12-21 10:00:00	QQQ	ETF	270.9	273.8583	270.66	273.83	5933291.0
2022-12-21 11:00:00	QQQ	ETF	273.85	274.48	272.9	273.3101	4081296.0
2022-12-21 12:00:00	QQQ	ETF	273.36	273.97	272.7	273.92	2856717.0
2022-12-21 13:00:00	QQQ	ETF	273.94	274.36	273.27	273.84	2545283.0
2022-12-21 14:00:00	QQQ	ETF	273.85	274.78	273.29	273.6	3060095.0
2022-12-21 15:00:00	QQQ	ETF	273.62	273.865	272.8	273.5	5150851.0
2022-12-21 16:00:00	QQQ	ETF	273.51	274.08	273.37	273.89	2084447.0
2022-12-21 17:00:00	QQQ	ETF	273.9	274.1	273.81	273.91	54674.0
2022-12-21 18:00:00	QQQ	ETF	273.98	274.05	273.45	273.85	488718.0
2022-12-21 19:00:00	QQQ	ETF	273.81	273.99	273.58	273.98	55486.0
2022-12-21 04:00:00	IWM	ETF	173.94	174.22	173.82	174.18	37637.0
2022-12-21 05:00:00	IWM	ETF	174.1	174.31	174.03	174.1	6433.0
2022-12-21 06:00:00	IWM	ETF	174.13	174.42	174.03	174.37	21862.0
2022-12-21 07:00:00	IWM	ETF	174.34	174.56	173.97	174.51	32451.0
2022-12-21 08:00:00	IWM	ETF	174.51	174.85	174.0	174.68	81767.0
2022-12-21 09:00:00	IWM	ETF	174.68	174.83	174.2	174.46	2482566.0
2022-12-21 10:00:00	IWM	ETF	174.48	176.53	174.31	176.45	2577590.0
2022-12-21 11:00:00	IWM	ETF	176.46	176.8	176.1101	176.295	1479490.0
2022-12-21 12:00:00	IWM	ETF	176.3	176.37	176.01	176.27	883432.0
2022-12-21 13:00:00	IWM	ETF	176.27	176.47	176.04	176.3	608929.0
2022-12-21 14:00:00	IWM	ETF	176.329	176.64	175.73	175.82	1280165.0
2022-12-21 15:00:00	IWM	ETF	175.82	175.95	175.42	175.82	3261698.0
2022-12-21 16:00:00	IWM	ETF	175.9	176.27	175.79	176.24	2059453.0
2022-12-21 17:00:00	IWM	ETF	176.34	176.34	176.07	176.11	3865.0
2022-12-21 18:00:00	IWM	ETF	176.28	176.31	175.9	176.15	160059.0
2022-12-21 19:00:00	IWM	ETF	176.04	176.31	175.94	176.31	26808.0
2022-12-21 04:00:00	DIA	ETF	330.97	330.97	330.85	330.85	700.0
2022-12-21 05:00:00	DIA	ETF	331.01	331.01	330.53	330.53	200.0

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

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