PREVIEW / etf_1hour / 2022-12-19

all etf 1-hour files

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

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-19 04:00:00	SPY	ETF	383.27	385.25	383.27	384.49	93588.0
2022-12-19 05:00:00	SPY	ETF	384.49	385.39	384.43	384.91	51408.0
2022-12-19 06:00:00	SPY	ETF	384.88	384.94	384.19	384.5	94379.0
2022-12-19 07:00:00	SPY	ETF	384.48	384.8	383.6	384.55	277427.0
2022-12-19 08:00:00	SPY	ETF	384.5	384.92	383.27	383.43	421425.0
2022-12-19 09:00:00	SPY	ETF	383.46	383.87	381.89	382.42	4977415.0
2022-12-19 10:00:00	SPY	ETF	382.43	383.67	381.66	381.73	6690098.0
2022-12-19 11:00:00	SPY	ETF	381.74	381.9499	380.41	380.9799	5950102.0
2022-12-19 12:00:00	SPY	ETF	380.97	381.78	380.76	381.41	4042369.0
2022-12-19 13:00:00	SPY	ETF	381.41	381.73	379.8001	379.9	4860969.0
2022-12-19 14:00:00	SPY	ETF	379.9	379.97	378.31	378.745	10068541.0
2022-12-19 15:00:00	SPY	ETF	378.73	380.41	378.28	379.98	15028532.0
2022-12-19 16:00:00	SPY	ETF	379.98	380.12	379.52	379.75	4772907.0
2022-12-19 17:00:00	SPY	ETF	379.76	380.02	379.7	379.75	206818.0
2022-12-19 18:00:00	SPY	ETF	379.75	380.78	379.75	380.6	159630.0
2022-12-19 19:00:00	SPY	ETF	380.52	381.2	380.36	380.7	64989.0
2022-12-19 04:00:00	QQQ	ETF	274.57	275.5	274.26	274.4	69549.0
2022-12-19 05:00:00	QQQ	ETF	274.56	275.2	274.43	275.0	38830.0
2022-12-19 06:00:00	QQQ	ETF	274.95	275.04	274.4	274.66	59183.0
2022-12-19 07:00:00	QQQ	ETF	274.72	274.91	274.42	274.69	157673.0
2022-12-19 08:00:00	QQQ	ETF	274.55	274.92	273.75	273.92	281019.0
2022-12-19 09:00:00	QQQ	ETF	273.93	274.3	271.42	271.7929	3906072.0
2022-12-19 10:00:00	QQQ	ETF	271.79	272.77	270.86	270.99	4816694.0
2022-12-19 11:00:00	QQQ	ETF	270.985	271.07	269.66	270.3	3728613.0
2022-12-19 12:00:00	QQQ	ETF	270.31	271.28	270.28	270.88	2396940.0
2022-12-19 13:00:00	QQQ	ETF	270.89	271.46	269.88	269.9301	2687951.0
2022-12-19 14:00:00	QQQ	ETF	269.92	269.97	268.945	269.22	4286711.0
2022-12-19 15:00:00	QQQ	ETF	269.23	270.22	268.49	269.84	7439501.0
2022-12-19 16:00:00	QQQ	ETF	269.85	270.04	269.62	269.77	1460731.0
2022-12-19 17:00:00	QQQ	ETF	269.74	269.82	269.5601	269.72	583622.0
2022-12-19 18:00:00	QQQ	ETF	269.75	270.6	269.73	270.46	78830.0
2022-12-19 19:00:00	QQQ	ETF	270.4	270.6	270.3	270.57	58409.0
2022-12-19 04:00:00	IWM	ETF	174.56	175.33	174.37	174.97	31431.0
2022-12-19 05:00:00	IWM	ETF	174.95	175.32	174.87	175.05	4876.0
2022-12-19 06:00:00	IWM	ETF	174.97	175.07	174.68	174.76	173101.0
2022-12-19 07:00:00	IWM	ETF	174.8	175.17	174.76	175.01	36718.0
2022-12-19 08:00:00	IWM	ETF	174.94	175.09	174.42	174.52	108706.0
2022-12-19 09:00:00	IWM	ETF	174.5299	175.0529	172.79	173.25	2498035.0
2022-12-19 10:00:00	IWM	ETF	173.25	174.2	173.07	173.13	1841552.0
2022-12-19 11:00:00	IWM	ETF	173.16	173.43	172.55	172.7	1524787.0
2022-12-19 12:00:00	IWM	ETF	172.7	173.12	172.42	172.8401	1209166.0
2022-12-19 13:00:00	IWM	ETF	172.845	172.97	172.0	172.015	1076267.0
2022-12-19 14:00:00	IWM	ETF	172.0	172.26	171.7	171.8675	1711077.0
2022-12-19 15:00:00	IWM	ETF	171.88	172.305	171.47	172.03	3388007.0
2022-12-19 16:00:00	IWM	ETF	172.03	172.15	171.86	172.01	2699676.0
2022-12-19 17:00:00	IWM	ETF	171.88	172.06	171.81	171.93	228525.0
2022-12-19 18:00:00	IWM	ETF	172.0	172.52	172.0	172.42	19416.0
2022-12-19 19:00:00	IWM	ETF	172.39	172.56	172.29	172.56	22813.0
2022-12-19 04:00:00	DIA	ETF	330.11	330.41	330.11	330.25	1108.0
2022-12-19 05:00:00	DIA	ETF	329.81	330.25	329.76	330.25	2226.0

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

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