PREVIEW / etf_1hour / 2022-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-17.parquet
  size:    447 KB
  rows:    16,376

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-17 04:00:00	SPY	ETF	428.76	428.85	428.06	428.08	29804.0
2022-08-17 05:00:00	SPY	ETF	428.07	428.35	427.39	427.58	37486.0
2022-08-17 06:00:00	SPY	ETF	427.44	427.51	426.57	426.92	117767.0
2022-08-17 07:00:00	SPY	ETF	426.97	427.1	426.03	426.35	277245.0
2022-08-17 08:00:00	SPY	ETF	427.1416	429.8654	425.61	426.01	1324119.0
2022-08-17 09:00:00	SPY	ETF	425.99	427.41	425.71	426.975	6158715.0
2022-08-17 10:00:00	SPY	ETF	426.975	427.53	425.38	425.51	6387661.0
2022-08-17 11:00:00	SPY	ETF	425.52	426.53	424.54	424.8911	5418467.0
2022-08-17 12:00:00	SPY	ETF	424.9	426.85	424.87	426.5099	4223992.0
2022-08-17 13:00:00	SPY	ETF	426.51	427.14	426.04	426.7	2756887.0
2022-08-17 14:00:00	SPY	ETF	426.69	429.5	426.34	427.7699	9666420.0
2022-08-17 15:00:00	SPY	ETF	427.7666	428.5437	426.161	426.67	8365336.0
2022-08-17 16:00:00	SPY	ETF	426.66	427.16	426.59	427.06	2148325.0
2022-08-17 17:00:00	SPY	ETF	427.1	427.1	426.82	426.85	53362.0
2022-08-17 18:00:00	SPY	ETF	426.87	426.9	426.13	426.22	68426.0
2022-08-17 19:00:00	SPY	ETF	426.22	426.23	425.71	425.93	48423.0
2022-08-17 04:00:00	QQQ	ETF	331.28	331.28	330.5	330.75	37891.0
2022-08-17 05:00:00	QQQ	ETF	330.64	331.01	330.07	330.1	41693.0
2022-08-17 06:00:00	QQQ	ETF	330.24	330.24	329.53	329.92	86231.0
2022-08-17 07:00:00	QQQ	ETF	329.93	330.09	329.0	329.28	355434.0
2022-08-17 08:00:00	QQQ	ETF	329.84	332.529	328.78	329.18	508451.0
2022-08-17 09:00:00	QQQ	ETF	329.15	330.22	328.25	329.46	4492991.0
2022-08-17 10:00:00	QQQ	ETF	329.46	330.03	326.775	326.94	5251332.0
2022-08-17 11:00:00	QQQ	ETF	326.92	328.14	326.36	326.79	4131790.0
2022-08-17 12:00:00	QQQ	ETF	326.8	328.48	326.79	328.0899	2825085.0
2022-08-17 13:00:00	QQQ	ETF	328.08	328.845	327.57	328.27	2790718.0
2022-08-17 14:00:00	QQQ	ETF	328.27	331.43	327.96	329.7499	7743308.0
2022-08-17 15:00:00	QQQ	ETF	329.74	330.56	328.01	328.48	7016647.0
2022-08-17 16:00:00	QQQ	ETF	328.49	328.88	328.33	328.88	1081053.0
2022-08-17 17:00:00	QQQ	ETF	328.87	328.98	328.4	328.48	39074.0
2022-08-17 18:00:00	QQQ	ETF	328.5	328.59	327.83	327.87	78916.0
2022-08-17 19:00:00	QQQ	ETF	327.9	327.9	327.39	327.46	127410.0
2022-08-17 04:00:00	IWM	ETF	200.51	200.67	200.23	200.24	14669.0
2022-08-17 05:00:00	IWM	ETF	200.34	200.4	199.9	199.98	10307.0
2022-08-17 06:00:00	IWM	ETF	199.86	199.91	199.45	199.64	50739.0
2022-08-17 07:00:00	IWM	ETF	199.65	199.7	199.06	199.24	58054.0
2022-08-17 08:00:00	IWM	ETF	199.26	199.53	198.84	198.96	182272.0
2022-08-17 09:00:00	IWM	ETF	198.95	199.18	197.55	198.25	2022998.0
2022-08-17 10:00:00	IWM	ETF	198.23	198.5	197.02	197.08	2432675.0
2022-08-17 11:00:00	IWM	ETF	197.09	197.52	196.38	196.64	1745249.0
2022-08-17 12:00:00	IWM	ETF	196.64	197.855	196.58	197.545	1227542.0
2022-08-17 13:00:00	IWM	ETF	197.55	197.97	197.33	197.8267	1044403.0
2022-08-17 14:00:00	IWM	ETF	197.8	199.33	197.74	198.21	2737376.0
2022-08-17 15:00:00	IWM	ETF	198.2	198.62	197.455	197.6	3186987.0
2022-08-17 16:00:00	IWM	ETF	197.61	197.96	197.58	197.94	1150404.0
2022-08-17 17:00:00	IWM	ETF	197.93	198.01	197.55	197.66	151856.0
2022-08-17 18:00:00	IWM	ETF	197.7	197.74	197.41	197.46	57813.0
2022-08-17 19:00:00	IWM	ETF	197.43	197.46	197.27	197.38	35738.0
2022-08-17 04:00:00	DIA	ETF	341.33	341.33	341.04	341.04	730.0
2022-08-17 05:00:00	DIA	ETF	340.93	340.93	340.54	340.54	1489.0

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

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