PREVIEW / etf_1hour / 2022-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-19.parquet
  size:    442 KB
  rows:    15,944

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-08-19 04:00:00	SPY	ETF	426.49	426.49	424.1	424.55	78702.0
2022-08-19 05:00:00	SPY	ETF	424.48	424.94	424.31	424.4	44002.0
2022-08-19 06:00:00	SPY	ETF	424.39	424.56	423.22	423.44	120793.0
2022-08-19 07:00:00	SPY	ETF	423.51	424.06	423.31	424.06	389923.0
2022-08-19 08:00:00	SPY	ETF	423.5501	427.15	423.2496	424.1	597110.0
2022-08-19 09:00:00	SPY	ETF	424.05	425.26	422.82	423.17	7534854.0
2022-08-19 10:00:00	SPY	ETF	423.17	423.55	422.44	422.5	7786970.0
2022-08-19 11:00:00	SPY	ETF	422.4901	423.1	421.71	422.5099	5962586.0
2022-08-19 12:00:00	SPY	ETF	422.5	423.7	422.16	423.3	4349577.0
2022-08-19 13:00:00	SPY	ETF	423.31	423.65	422.03	422.845	4126041.0
2022-08-19 14:00:00	SPY	ETF	422.86	422.94	421.56	421.8	4402688.0
2022-08-19 15:00:00	SPY	ETF	421.8	422.78	421.22	422.15	11392193.0
2022-08-19 16:00:00	SPY	ETF	422.14	422.3	421.9	421.93	3393562.0
2022-08-19 17:00:00	SPY	ETF	421.99	422.1	421.79	421.8	118810.0
2022-08-19 18:00:00	SPY	ETF	421.79	421.79	421.56	421.66	12765.0
2022-08-19 19:00:00	SPY	ETF	421.61	422.0	421.25	421.4	48661.0
2022-08-19 04:00:00	QQQ	ETF	327.98	328.62	325.55	326.07	112712.0
2022-08-19 05:00:00	QQQ	ETF	326.12	326.72	326.0	326.06	111834.0
2022-08-19 06:00:00	QQQ	ETF	326.1	326.34	325.22	325.57	74104.0
2022-08-19 07:00:00	QQQ	ETF	325.59	326.0	325.35	326.0	252588.0
2022-08-19 08:00:00	QQQ	ETF	325.8	329.526	325.31	325.79	482537.0
2022-08-19 09:00:00	QQQ	ETF	325.77	326.84	323.845	324.0298	5643871.0
2022-08-19 10:00:00	QQQ	ETF	324.03	324.47	322.92	322.955	6384190.0
2022-08-19 11:00:00	QQQ	ETF	322.959	323.78	322.53	323.035	4993364.0
2022-08-19 12:00:00	QQQ	ETF	323.02	324.08	322.735	323.72	2786013.0
2022-08-19 13:00:00	QQQ	ETF	323.73	324.0393	322.1224	323.215	3116094.0
2022-08-19 14:00:00	QQQ	ETF	323.18	323.26	322.42	322.6091	2201452.0
2022-08-19 15:00:00	QQQ	ETF	322.61	323.4798	322.08	322.87	7795221.0
2022-08-19 16:00:00	QQQ	ETF	322.875	322.95	322.52	322.6	2755019.0
2022-08-19 17:00:00	QQQ	ETF	322.63	322.86	322.41	322.41	271759.0
2022-08-19 18:00:00	QQQ	ETF	322.4	322.4	321.82	321.85	38701.0
2022-08-19 19:00:00	QQQ	ETF	321.92	322.86	321.59	321.6	450070.0
2022-08-19 04:00:00	IWM	ETF	197.79	197.87	196.86	197.11	24924.0
2022-08-19 05:00:00	IWM	ETF	197.07	197.34	196.95	196.98	7198.0
2022-08-19 06:00:00	IWM	ETF	196.9	197.09	196.32	196.52	10668.0
2022-08-19 07:00:00	IWM	ETF	196.52	196.72	196.42	196.68	171612.0
2022-08-19 08:00:00	IWM	ETF	196.68	198.47	196.33	196.72	87874.0
2022-08-19 09:00:00	IWM	ETF	196.79	197.11	195.07	195.23	2435293.0
2022-08-19 10:00:00	IWM	ETF	195.22	195.61	194.79	194.795	3058011.0
2022-08-19 11:00:00	IWM	ETF	194.8	195.12	194.0707	194.96	2199947.0
2022-08-19 12:00:00	IWM	ETF	194.955	195.36	194.49	195.21	1236239.0
2022-08-19 13:00:00	IWM	ETF	195.22	195.33	194.4	194.91	835594.0
2022-08-19 14:00:00	IWM	ETF	194.91	194.97	194.385	194.47	1042196.0
2022-08-19 15:00:00	IWM	ETF	194.47	195.0	194.095	194.63	4056701.0
2022-08-19 16:00:00	IWM	ETF	194.65	194.88	194.6	194.66	1793170.0
2022-08-19 17:00:00	IWM	ETF	194.68	194.73	194.44	194.44	229198.0
2022-08-19 18:00:00	IWM	ETF	194.46	194.59	194.01	194.01	14248.0
2022-08-19 19:00:00	IWM	ETF	194.04	194.35	194.02	194.2	13503.0
2022-08-19 05:00:00	DIA	ETF	337.95	338.33	337.83	338.0	3798.0
2022-08-19 06:00:00	DIA	ETF	337.8	337.99	337.1	337.1	6134.0

> showing 50 of 15,944 rows — these rows as CSV

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