PREVIEW / etf_1hour / 2022-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-20.parquet
  size:    450 KB
  rows:    16,528

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-10-20 04:00:00	SPY	ETF	367.49	367.49	366.13	366.7	33959.0
2022-10-20 05:00:00	SPY	ETF	366.71	367.99	366.7	367.59	79193.0
2022-10-20 06:00:00	SPY	ETF	367.55	370.07	367.27	369.54	188442.0
2022-10-20 07:00:00	SPY	ETF	369.54	370.45	368.77	369.44	354957.0
2022-10-20 08:00:00	SPY	ETF	369.7598	370.89	366.18	367.53	1705887.0
2022-10-20 09:00:00	SPY	ETF	367.53	369.82	367.0	369.1	7024183.0
2022-10-20 10:00:00	SPY	ETF	369.11	372.67	368.975	371.96	9945191.0
2022-10-20 11:00:00	SPY	ETF	371.97	372.16	369.85	370.2201	7052048.0
2022-10-20 12:00:00	SPY	ETF	370.2499	370.3786	367.19	367.939	8711408.0
2022-10-20 13:00:00	SPY	ETF	367.9219	368.05	365.3764	366.11	8113814.0
2022-10-20 14:00:00	SPY	ETF	366.09	366.23	364.66	365.61	8045282.0
2022-10-20 15:00:00	SPY	ETF	365.6015	366.6199	364.61	365.43	13482391.0
2022-10-20 16:00:00	SPY	ETF	365.43	366.26	365.25	365.6	4036570.0
2022-10-20 17:00:00	SPY	ETF	365.53	365.8	365.49	365.59	109102.0
2022-10-20 18:00:00	SPY	ETF	365.64	365.68	364.05	364.25	159709.0
2022-10-20 19:00:00	SPY	ETF	364.25	364.35	363.63	364.13	93000.0
2022-10-20 04:00:00	QQQ	ETF	267.93	268.7	267.73	268.2	74339.0
2022-10-20 05:00:00	QQQ	ETF	268.31	269.32	268.27	269.0	40049.0
2022-10-20 06:00:00	QQQ	ETF	269.01	271.2	268.67	270.8	312323.0
2022-10-20 07:00:00	QQQ	ETF	270.8	271.42	269.94	270.74	506633.0
2022-10-20 08:00:00	QQQ	ETF	271.25	272.21	267.64	268.95	1386920.0
2022-10-20 09:00:00	QQQ	ETF	269.0	272.46	268.91	271.79	5943339.0
2022-10-20 10:00:00	QQQ	ETF	271.82	274.84	271.6	274.59	7719181.0
2022-10-20 11:00:00	QQQ	ETF	274.6	274.75	272.85	273.44	4356634.0
2022-10-20 12:00:00	QQQ	ETF	273.462	273.53	270.401	271.14	5739446.0
2022-10-20 13:00:00	QQQ	ETF	271.1401	271.32	268.68	269.239	5491285.0
2022-10-20 14:00:00	QQQ	ETF	269.22	269.41	267.92	268.9463	4869341.0
2022-10-20 15:00:00	QQQ	ETF	268.9392	269.81	268.282	269.02	6767530.0
2022-10-20 16:00:00	QQQ	ETF	269.03	270.0	268.05	268.36	2349233.0
2022-10-20 17:00:00	QQQ	ETF	268.47	269.11	268.25	268.3	505817.0
2022-10-20 18:00:00	QQQ	ETF	268.34	268.38	267.17	267.31	240441.0
2022-10-20 19:00:00	QQQ	ETF	267.34	267.47	266.84	267.42	145632.0
2022-10-20 04:00:00	IWM	ETF	170.3	170.82	170.3	170.58	12694.0
2022-10-20 05:00:00	IWM	ETF	170.7	171.27	170.7	171.05	57363.0
2022-10-20 06:00:00	IWM	ETF	171.1	172.26	170.97	171.94	74253.0
2022-10-20 07:00:00	IWM	ETF	171.94	172.33	171.57	171.85	67577.0
2022-10-20 08:00:00	IWM	ETF	172.14	172.6	170.95	170.96	222563.0
2022-10-20 09:00:00	IWM	ETF	170.88	172.4	170.75	171.59	2894252.0
2022-10-20 10:00:00	IWM	ETF	171.57	173.55	171.52	172.9	2713426.0
2022-10-20 11:00:00	IWM	ETF	172.92	173.21	172.08	172.08	2028764.0
2022-10-20 12:00:00	IWM	ETF	172.09	172.16	169.9	170.2	2256088.0
2022-10-20 13:00:00	IWM	ETF	170.19	170.37	168.83	169.1781	2739158.0
2022-10-20 14:00:00	IWM	ETF	169.17	169.3	168.4693	169.01	2185545.0
2022-10-20 15:00:00	IWM	ETF	169.015	169.56	168.47	169.02	3734705.0
2022-10-20 16:00:00	IWM	ETF	169.03	169.59	168.95	169.45	854676.0
2022-10-20 17:00:00	IWM	ETF	169.5	169.5	169.03	169.22	314883.0
2022-10-20 18:00:00	IWM	ETF	169.37	169.4	168.54	168.61	35088.0
2022-10-20 19:00:00	IWM	ETF	168.58	168.68	168.25	168.55	29350.0
2022-10-20 04:00:00	DIA	ETF	304.11	304.11	303.61	303.84	1300.0
2022-10-20 05:00:00	DIA	ETF	303.89	304.68	303.89	304.68	1700.0

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

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