PREVIEW / etf_1hour / 2022-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-03.parquet
  size:    467 KB
  rows:    16,667

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-01-03 04:00:00	SPY	ETF	476.38	477.25	476.38	477.25	49910.0
2022-01-03 05:00:00	SPY	ETF	477.24	477.76	477.15	477.76	30855.0
2022-01-03 06:00:00	SPY	ETF	477.76	478.09	477.76	478.0	67577.0
2022-01-03 07:00:00	SPY	ETF	478.02	478.06	477.33	477.41	140363.0
2022-01-03 08:00:00	SPY	ETF	477.9504	477.99	476.53	476.56	487197.0
2022-01-03 09:00:00	SPY	ETF	476.53	477.72	473.85	474.9266	8831058.0
2022-01-03 10:00:00	SPY	ETF	474.94	476.78	474.77	476.17	6606795.0
2022-01-03 11:00:00	SPY	ETF	476.16	476.25	474.45	475.36	4956196.0
2022-01-03 12:00:00	SPY	ETF	475.32	475.995	475.03	475.6	3107557.0
2022-01-03 13:00:00	SPY	ETF	475.6	476.77	475.335	476.74	3508626.0
2022-01-03 14:00:00	SPY	ETF	476.73	477.68	476.6	477.228	4752088.0
2022-01-03 15:00:00	SPY	ETF	477.22	477.85	476.65	477.76	12640184.0
2022-01-03 16:00:00	SPY	ETF	477.75	477.87	476.4299	477.56	4416116.0
2022-01-03 17:00:00	SPY	ETF	477.71	477.71	477.52	477.52	18668.0
2022-01-03 18:00:00	SPY	ETF	477.68	477.77	477.35	477.35	90747.0
2022-01-03 19:00:00	SPY	ETF	477.31	477.68	477.25	477.6	54730.0
2022-01-03 04:00:00	QQQ	ETF	399.04	399.76	399.04	399.76	64633.0
2022-01-03 05:00:00	QQQ	ETF	399.74	400.13	399.68	400.07	54704.0
2022-01-03 06:00:00	QQQ	ETF	400.15	400.74	400.15	400.66	36132.0
2022-01-03 07:00:00	QQQ	ETF	400.6	400.65	400.14	400.15	93472.0
2022-01-03 08:00:00	QQQ	ETF	400.45	400.5996	399.11	399.1496	378011.0
2022-01-03 09:00:00	QQQ	ETF	399.12	401.53	396.88	397.48	7120717.0
2022-01-03 10:00:00	QQQ	ETF	397.49	400.55	397.21	400.41	5974406.0
2022-01-03 11:00:00	QQQ	ETF	400.41	400.6	398.91	399.33	3577223.0
2022-01-03 12:00:00	QQQ	ETF	399.3214	400.29	398.9	400.03	2414960.0
2022-01-03 13:00:00	QQQ	ETF	400.06	401.165	399.66	401.0	2250567.0
2022-01-03 14:00:00	QQQ	ETF	400.995	401.94	400.77	401.3411	2494203.0
2022-01-03 15:00:00	QQQ	ETF	401.3665	401.8999	400.79	401.78	4961859.0
2022-01-03 16:00:00	QQQ	ETF	401.77	402.1801	400.0319	401.85	1068579.0
2022-01-03 17:00:00	QQQ	ETF	401.84	402.08	401.68	402.08	48099.0
2022-01-03 18:00:00	QQQ	ETF	402.02	402.23	401.54	401.6	156194.0
2022-01-03 19:00:00	QQQ	ETF	401.63	401.89	401.51	401.87	59704.0
2022-01-03 04:00:00	IWM	ETF	223.55	223.8	223.3	223.72	37997.0
2022-01-03 05:00:00	IWM	ETF	223.8	224.4	223.71	224.4	16460.0
2022-01-03 06:00:00	IWM	ETF	224.44	224.8	224.42	224.7	39096.0
2022-01-03 07:00:00	IWM	ETF	224.7	224.7	224.01	224.04	103578.0
2022-01-03 08:00:00	IWM	ETF	224.06	224.6504	223.68	223.69	90349.0
2022-01-03 09:00:00	IWM	ETF	223.65	225.05	222.73	224.49	4869325.0
2022-01-03 10:00:00	IWM	ETF	224.5	226.69	224.47	224.9086	6935803.0
2022-01-03 11:00:00	IWM	ETF	224.92	225.39	223.47	223.79	2697090.0
2022-01-03 12:00:00	IWM	ETF	223.78	224.235	223.51	224.01	1449815.0
2022-01-03 13:00:00	IWM	ETF	224.02	224.2	223.5614	224.185	1054269.0
2022-01-03 14:00:00	IWM	ETF	224.18	224.72	224.03	224.71	944869.0
2022-01-03 15:00:00	IWM	ETF	224.72	225.37	224.39	225.34	3324247.0
2022-01-03 16:00:00	IWM	ETF	225.32	225.39	224.75	225.16	1592307.0
2022-01-03 17:00:00	IWM	ETF	225.3	225.32	225.1201	225.31	6515.0
2022-01-03 18:00:00	IWM	ETF	225.25	225.32	225.05	225.12	14974.0
2022-01-03 19:00:00	IWM	ETF	225.1	225.37	225.02	225.3396	20555.0
2022-01-03 04:00:00	DIA	ETF	364.53	364.53	364.1	364.36	896.0
2022-01-03 06:00:00	DIA	ETF	365.23	365.27	365.22	365.27	1010.0

> showing 50 of 16,667 rows — these rows as CSV

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